try
... {
object[] m_arr;
this.Cursor = Cursors.WaitCursor;
int iRow = ((CustomDataGridView)sender).CurrentCell.RowIndex;
if (((CustomDataGridView)sender).CurrentRow.Cells[e.ColumnIndex].OwningColumn.Name == "Part_NO")
...{
DataSet ds;
ServicePO.PO poBLL = new ServicePO.PO();
if (poBLL.SelectUnit(dataGridView1.Rows[iRow].Cells["Part_NO"].Value.ToString(), out m_arr, out ds))
...{
dataGridView1.Rows[iRow].Cells["Unit_Code"].Value = m_arr[0].ToString();
dataGridView1.Rows[iRow].Cells["Unit_Name"].Value = m_arr[1].ToString();
((DataGridViewComboBoxCell)dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"]).DataSource = ds.Tables[0];
//设置主键
ds.Tables[0].PrimaryKey = new DataColumn[]...{ds.Tables[0].Columns["Unit_Code"]};
((DataGridViewComboBoxCell)dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"]).DisplayMember = "Unit_Name";
((DataGridViewComboBoxCell)dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"]).ValueMember = "Unit_Code";
}
}
if (((CustomDataGridView)sender).CurrentRow.Cells[e.ColumnIndex].OwningColumn.Name == "FZ_Unit_Qty" || ((CustomDataGridView)sender).CurrentRow.Cells[e.ColumnIndex].OwningColumn.Name == "FZ_Unit_Name")
...{
if (dataGridView1.Rows[iRow].Cells["FZ_Unit_Qty"].Value != System.DBNull.Value)//原料
...{
double dUnitRate, dFZ_Unit_Qty;
string sUnit_Code = dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"].Value.ToString();
//根据主键获取 Unit_Rate p.unit_code,u.unit_name,p.unit_rate
DataRow foundRow=((DataTable)(((DataGridViewComboBoxCell)dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"])).DataSource).Rows.Find (new object[]...{sUnit_Code});
double.TryParse(foundRow["unit_rate"].ToString(), out dUnitRate);
double.TryParse(dataGridView1.Rows[iRow].Cells["FZ_Unit_Qty"].Value.ToString(), out dFZ_Unit_Qty);
dataGridView1["Qty", iRow].Value = dUnitRate * dFZ_Unit_Qty;
}
}
... {
object[] m_arr;
this.Cursor = Cursors.WaitCursor;
int iRow = ((CustomDataGridView)sender).CurrentCell.RowIndex;
if (((CustomDataGridView)sender).CurrentRow.Cells[e.ColumnIndex].OwningColumn.Name == "Part_NO")
...{
DataSet ds;
ServicePO.PO poBLL = new ServicePO.PO();
if (poBLL.SelectUnit(dataGridView1.Rows[iRow].Cells["Part_NO"].Value.ToString(), out m_arr, out ds))
...{
dataGridView1.Rows[iRow].Cells["Unit_Code"].Value = m_arr[0].ToString();
dataGridView1.Rows[iRow].Cells["Unit_Name"].Value = m_arr[1].ToString();
((DataGridViewComboBoxCell)dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"]).DataSource = ds.Tables[0];
//设置主键
ds.Tables[0].PrimaryKey = new DataColumn[]...{ds.Tables[0].Columns["Unit_Code"]};
((DataGridViewComboBoxCell)dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"]).DisplayMember = "Unit_Name";
((DataGridViewComboBoxCell)dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"]).ValueMember = "Unit_Code";
}
}
if (((CustomDataGridView)sender).CurrentRow.Cells[e.ColumnIndex].OwningColumn.Name == "FZ_Unit_Qty" || ((CustomDataGridView)sender).CurrentRow.Cells[e.ColumnIndex].OwningColumn.Name == "FZ_Unit_Name")
...{
if (dataGridView1.Rows[iRow].Cells["FZ_Unit_Qty"].Value != System.DBNull.Value)//原料
...{
double dUnitRate, dFZ_Unit_Qty;
string sUnit_Code = dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"].Value.ToString();
//根据主键获取 Unit_Rate p.unit_code,u.unit_name,p.unit_rate
DataRow foundRow=((DataTable)(((DataGridViewComboBoxCell)dataGridView1.Rows[iRow].Cells["FZ_Unit_Name"])).DataSource).Rows.Find (new object[]...{sUnit_Code});
double.TryParse(foundRow["unit_rate"].ToString(), out dUnitRate);
double.TryParse(dataGridView1.Rows[iRow].Cells["FZ_Unit_Qty"].Value.ToString(), out dFZ_Unit_Qty);
dataGridView1["Qty", iRow].Value = dUnitRate * dFZ_Unit_Qty;
}
}