/// <summary>
/// 根据订单号查询物料信息
/// </summary>
private void getOrderInfo(string sDdh)
{
string[] strTmpArray = { "", "", "", "", "", "" };
strTmpArray = sapClass.getOrdInfo(sDdh);
if (strTmpArray[1] == "")
{
lstHint2.Items.Add("生产订单信息获取失败，从SAP下载！");
sapClass.downOrderInfo(sDdh);
strTmpArray = sapClass.getOrdInfo(sDdh);
}
if (strTmpArray[1] == "")
{
lstHint2.Items.Add("生产订单信息获取失败！");
}
txtScdd.Text = sDdh;
txtHxmh.Text = strTmpArray[0];
txtWlbh.Text = strTmpArray[1];
txtGc.Text = strTmpArray[2];
txtWlmc.Text = sapClass.getMaterialName(strTmpArray[1]);
}
/// <summary>
/// 编辑数据信息
/// </summary>
private void doUpdate(int iFlag)
{
if ((txtScdd.Text == "") || (txtGc.Text == "") || (txtKcd.Text == ""))
{
MessageBox.Show("工厂、生产订单与库存地都不能为空！");
return;
}
string strTmpTable, strTmpField, strTmpWhere;
if (uGridData.Selected.Rows.Count > 0)
{
foreach (UltraGridRow ugr in uGridData.Selected.Rows)
{
strOptNo = uGridData.Rows[ugr.Index].Cells["FS_BATCHNO"].Value.ToString();
if (uGridData.Selected.Rows.Count == 1)
{
p_FS_BATCHNO = (txtLh.Text != "") ? txtLh.Text : uGridData.Rows[ugr.Index].Cells["FS_BATCHNO"].Value.ToString();
}
else
{
p_FS_BATCHNO = uGridData.Rows[ugr.Index].Cells["FS_BATCHNO"].Value.ToString();
}
p_FS_PRODUCTNO = (txtScdd.Text != "") ? txtScdd.Text : uGridData.Rows[ugr.Index].Cells["FS_PRODUCTNO"].Value.ToString();
p_FS_ITEMNO = (txtHxmh.Text != "") ? txtHxmh.Text : "0001";
p_FS_MATERIALNAME = sapClass.getMaterialName(sapClass.getMaterial(p_FS_PRODUCTNO));
p_FS_RECEIVEFACTORY = (txtGc.Text != "") ? txtGc.Text : uGridData.Rows[ugr.Index].Cells["FS_PLANT"].Value.ToString();
p_FS_RECEIVESTORE = (txtKcd.Text != "") ? txtKcd.Text : uGridData.Rows[ugr.Index].Cells["FS_SAPSTORE"].Value.ToString();
p_FS_ACCOUNTDATE = dteJzrq.Value.ToString("yyyy-MM-dd");
strTmpTable = "DT_PLATECONFIRMWEIGHTMAIN";
strTmpField = "";
switch (iFlag)
{
case 0:
strTmpField = "FS_PRODUCTNO='" + txtScdd.Text + "',FS_ITEMNO='0001',FS_SAPSTORE='" + txtKcd.Text + "',"
+ "FS_ACCOUNTDATE='" + dteJzrq.Value.ToString("yyyy-MM-dd") + "',FS_PLANT='1100',FS_HEADER='"
+ cmbHead.Text + "',FS_ISMATCH=1,FS_AUDITOR='" + CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()
+ "'";
break;
case 1:
strTmpField = "FS_ISMATCH=0";
break;
}
strTmpWhere = "FS_BATCHNO='" + strOptNo + "'";
if (sapClass.uptData(strTmpTable, strTmpField, strTmpWhere))
{
lstHint2.Items.Add("数据修改成功！");
}
else
{
MessageBox.Show("数据修改失败！");
}
}
}
else
{
MessageBox.Show("请先选择要修改的数据行！");
}
}