private void button2_Click(object sender, EventArgs e)
{
frmSelectDataDialog frmselect = new frmSelectDataDialog("Emp", "");
frmselect.frmSeorderPlanEdit = this; //将新创建的窗体对象设置为同一个窗体类的实例（对象）
frmselect.frmName = "frmSeorderPlanEdit"; //用于识别 是那一个窗体调用的select窗口的
frmselect.ShowDialog();
}
private void txtFEmpNumber_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
if (this.FCustID == null)
{
ds = k3db.GetDataSet(" SELECT FItemID, FNumber 代码,FName 名称,FAddress 地址 FROM dbo.t_emp WHERE FDeleted=0 and fnumber like '%" + this.txtFEmpNumber.Text + "%' ", "tab");
if (ds.Tables[0].Rows.Count == 1)
{
this.FEmpID = ds.Tables[0].Rows[0][0].ToString();
this.txtFEmpNumber.Text = ds.Tables[0].Rows[0][2].ToString();
}
else
{
frmSelectDataDialog frmselect = new frmSelectDataDialog("Emp", this.txtFEmpNumber.Text);
frmselect.frmSeorderPlanEdit = this; //将新创建的窗体对象设置为同一个窗体类的实例（对象）
frmselect.frmName = "frmSeorderPlanEdit"; //用于识别 是那一个窗体调用的select窗口的
frmselect.ShowDialog();
}
}
}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{//双击
if (e.ColumnIndex == 1)
{
// MessageBox.Show("1111"); .Value
string fnumber;
if (dataGridView1["ColumnFitemNnmber", e.RowIndex].Value == null)
{
fnumber = "";
}
else
{
fnumber = dataGridView1["ColumnFitemNnmber", e.RowIndex].Value.ToString();
}
frmSelectDataDialog frmselect = new frmSelectDataDialog("Icitem", fnumber);
frmselect.frmSeorderPlanEdit = this; //将新创建的窗体对象设置为同一个窗体类的实例（对象）
frmselect.frmName = "frmSeorderPlanEdit"; //用于识别 是那一个窗体调用的select窗口的
frmselect.M_int_CurrentRow = e.RowIndex;
frmselect.ShowDialog();
this.dataGridView1.CurrentCell = dataGridView1["ColumnFSFQty", e.RowIndex]; //设置辅助重量单元格获得焦点
dataGridView1.BeginEdit(true);
}
}
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{//
if (e.ColumnIndex == 1 && e.RowIndex >= 0 && this.dataGridView1["ColumnFitemID", e.RowIndex].Value == null)
{
//产品代码单元格变化
{
// this.dataGridView1.AllowUserToAddRows = false;
string fnumber;
int row;
row = this.dataGridView1.CurrentCell.RowIndex;//行
if (this.dataGridView1["ColumnFitemNnmber", row].Value == null)
{
fnumber = "";
}
else
{
fnumber = this.dataGridView1["ColumnFitemNnmber", row].Value.ToString();
}
ds = db.GetDataSet(" SELECT FItemID ,fnumber 代码,FName 名称,fmodel 规格型号,FUnitID FKUnitID,funitname k3单位,FSecUnitname 辅助单位,FSecCoefficient 换算率 FROM dbo.rysp_icitem where Fdelete=0 and fnumber like '%" + fnumber + "%' ", "tab");
if (ds.Tables[0].Rows.Count == 1)
{ //如果输入的代码只有一个产品直接赋值
this.dataGridView1["ColumnFitemID", row].Value = ds.Tables[0].Rows[0][0].ToString();; // finterid
this.dataGridView1["ColumnFitemNnmber", row].Value = ds.Tables[0].Rows[0][1].ToString();; //fnumber
this.dataGridView1["ColumnFitemName", row].Value = ds.Tables[0].Rows[0][2].ToString();; //fname
this.dataGridView1["ColumnFmodel", row].Value = ds.Tables[0].Rows[0][3].ToString();; //fmodel
this.dataGridView1["ColumnFKUnitID", row].Value = ds.Tables[0].Rows[0][4].ToString();; //FKUnitID
this.dataGridView1["ColumnFKUnitName", row].Value = ds.Tables[0].Rows[0][5].ToString();; //funitname
this.dataGridView1["ColumnFFUnitName", row].Value = ds.Tables[0].Rows[0][6].ToString(); //FSecUnitname
this.dataGridView1["ColumnFSecCoefficient", row].Value = ds.Tables[0].Rows[0][7].ToString(); //FSecCoefficient
this.dataGridView1.CurrentCell = dataGridView1["ColumnFSFQty", e.RowIndex]; //设置辅助重量单元格获得焦点
dataGridView1.BeginEdit(true);
}
else
{//否则弹出查询窗体
frmSelectDataDialog frmselect = new frmSelectDataDialog("Icitem", fnumber);
frmselect.frmSeorderPlanEdit = this; //将新创建的窗体对象设置为同一个窗体类的实例（对象）
frmselect.frmName = "frmSeorderPlanEdit"; //用于识别 是那一个窗体调用的select窗口的
frmselect.M_int_CurrentRow = this.dataGridView1.CurrentCell.RowIndex;
frmselect.ShowDialog();
//this.dataGridView1.CurrentCell = dataGridView1["ColumnFSFQty", e.RowIndex]; //设置辅助重量单元格获得焦点
//dataGridView1.BeginEdit(true);
}
}
}
if (e.ColumnIndex == 0 && e.RowIndex >= 0)
{//取得产品内码时 通过内码去获取单价
if (this.dataGridView1["ColumnFitemID", e.RowIndex].Value != null)
{
SqlParameter param1 = new SqlParameter("@ItemID", SqlDbType.Int);
param1.Value = int.Parse(this.dataGridView1["ColumnFitemID", e.RowIndex].Value.ToString());
SqlParameter param2 = new SqlParameter("@fcurid", SqlDbType.Int);
param2.Value = int.Parse(this.FCustID);
//创建泛型
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(param1);
parameters.Add(param2);
//把泛型中的元素复制到数组中
SqlParameter[] inputParameters = parameters.ToArray();
DataTable dt = db.GetDataTable("sp_getPrice", inputParameters);
if (dt.Rows.Count == 0)
{
MessageBox.Show("未能获得K3中的单价，请先到K3主控台维护单价！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.dataGridView1["ColumnFPrice", e.RowIndex].Value = "";
}
else
{
this.dataGridView1["ColumnFPrice", e.RowIndex].Value = dt.Rows[0][0].ToString();
}
}
}
if (e.ColumnIndex == 9 && e.RowIndex >= 0)
{//更改k3重量
try
{
this.dataGridView1["ColumnFSFQty", e.RowIndex].Value =
(Convert.ToSingle(this.dataGridView1["ColumnFSkQty", e.RowIndex].Value.ToString()) /
Convert.ToSingle(this.dataGridView1["ColumnFSecCoefficient", e.RowIndex].Value.ToString())).ToString();
}
catch {
MessageBox.Show("重量录入非法字符！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
//计算当前行金额
this.dataGridView1["ColumnFSAmount", e.RowIndex].Value = Convert.ToSingle
((Convert.ToSingle(this.dataGridView1["ColumnFSkQty", e.RowIndex].Value.ToString()) *
Convert.ToSingle(this.dataGridView1["ColumnFPrice", e.RowIndex].Value.ToString()))).ToString();
//计算合计金额
try
{
float Sumfamout = 0;
for (int i = 0; i <= dataGridView1.RowCount; i++)
{
Sumfamout = Sumfamout + Convert.ToSingle(dataGridView1["ColumnFSAmount", i].Value.ToString());
this.txtSumFamout.Text = Sumfamout.ToString();
}
}
catch { }
//添加一行
this.dataGridView1.Rows.Add();
}
catch
{
MessageBox.Show("重量或单价错误！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (e.ColumnIndex == 10 && e.RowIndex >= 0)
{//更改辅助重量
try
{
this.dataGridView1["ColumnFSkQty", e.RowIndex].Value =
(Convert.ToSingle(this.dataGridView1["ColumnFSFQty", e.RowIndex].Value.ToString()) *
Convert.ToSingle(this.dataGridView1["ColumnFSecCoefficient", e.RowIndex].Value.ToString())).ToString();
}
catch
{
MessageBox.Show("重量录入非法字符！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
