public PICKForm(string[] xml, string skuid, string errinfo, string[] retried, DataTable dtmaterial, string[][] check)
{
InitializeComponent();
Xml = xml;
Retried = retried;
Skuid = skuid;
dtMaterial = dtmaterial;
Check = check;
dt = DBhelp.XML2Table(Xml[0]);
cm = (CurrencyManager)this.BindingContext[dt];
textEdit1.DataBindings.Add("Text", dt, "AgencyLeaf");
textEdit2.DataBindings.Add("Text", dt, "SysLogID");
textEdit3.DataBindings.Add("Text", dt, "StationID");
textEdit4.DataBindings.Add("Text", dt, "RoleLeaf");
textEdit5.DataBindings.Add("Text", dt, "CommunityID");
textEdit6.DataBindings.Add("Text", dt, "UserCode");
textEdit7.DataBindings.Add("Text", dt, "ExCode");
textEdit8.DataBindings.Add("Text", dt, "UserID");
textEdit9.DataBindings.Add("Text", dt, "PassWord");
textEdit10.DataBindings.Add("Text", dt, "OrderType");
textEdit11.DataBindings.Add("Text", dt, "IssueType");
textEdit12.DataBindings.Add("Text", dt, "OrderNumber");
textEdit13.DataBindings.Add("Text", dt, "LineNumber");
textEdit14.DataBindings.Add("Text", dt, "ComponentLineType");
textEdit15.DataBindings.Add("Text", dt, "PointOfUseID");
textEdit16.DataBindings.Add("Text", dt, "OperationSequenceNumber");
textEdit17.DataBindings.Add("Text", dt, "ItemNumber");
textEdit18.DataBindings.Add("Text", dt, "Stockroom");
textEdit19.DataBindings.Add("Text", dt, "Bin");
textEdit20.DataBindings.Add("Text", dt, "LotNumber");
textEdit21.DataBindings.Add("Text", dt, "IssuedQuantity");
textEdit22.DataBindings.Add("Text", dt, "ResourceComponentPolicy");
textEdit23.DataBindings.Add("Text", dt, "QuantityType");
textEdit24.Text = skuid;
cm.Position = 0; // 如 index = 0;
if (dtmaterial != null)
{
textEdit25.DataBindings.Add("Text", dtmaterial, "LotNumber");
textEdit26.DataBindings.Add("Text", dtmaterial, "RecvBatchNo");
textEdit27.DataBindings.Add("Text", dtmaterial, "MaterialTrackID");
textEdit28.DataBindings.Add("Text", dtmaterial, "QtyInStore");
check[0][1] = check[0][2] = dtmaterial.Rows[0]["RecvBatchNo"].ToString();
check[1][1] = check[1][2] = dtmaterial.Rows[0]["QtyInStore"].ToString();
}
else
{
this.checkEdit2.Enabled = false;
this.checkEdit3.Enabled = false;
}
if (errinfo.Trim() != "")
{
this.textBox1.WordWrap = true;
this.textBox1.Text = errinfo;
}
if (Retried[0] == "True")
{
this.checkEdit1.Checked = true;
this.simpleButton1.Enabled = false;
this.btn_delete.Enabled = false;
}
else
{
this.checkEdit1.Checked = false;
}
}
public IMTRForm(string[] xml, string skuid, string errinfo, string[] retried, DataTable dtmaterial, string[][] check)
{
InitializeComponent();
Xml = xml;
Retried = retried;
Check = check;
dt = DBhelp.XML2Table(Xml[0]);
cm = (CurrencyManager)this.BindingContext[dt];
textEdit1.DataBindings.Add("Text", dt, "AgencyLeaf");
textEdit2.DataBindings.Add("Text", dt, "SysLogID");
textEdit3.DataBindings.Add("Text", dt, "StationID");
textEdit4.DataBindings.Add("Text", dt, "RoleLeaf");
textEdit5.DataBindings.Add("Text", dt, "CommunityID");
textEdit6.DataBindings.Add("Text", dt, "UserCode");
textEdit7.DataBindings.Add("Text", dt, "ExCode");
textEdit8.DataBindings.Add("Text", dt, "UserID");
textEdit9.DataBindings.Add("Text", dt, "PassWord");
textEdit10.DataBindings.Add("Text", dt, "ItemNumber");
textEdit11.DataBindings.Add("Text", dt, "StockroomFrom");
textEdit12.DataBindings.Add("Text", dt, "BinFrom");
textEdit13.DataBindings.Add("Text", dt, "InventoryCategoryFrom");
textEdit14.DataBindings.Add("Text", dt, "LotNumberFrom");
textEdit15.DataBindings.Add("Text", dt, "InventoryQuantity");
textEdit16.DataBindings.Add("Text", dt, "StockroomTo");
textEdit17.DataBindings.Add("Text", dt, "BinTo");
textEdit18.DataBindings.Add("Text", dt, "InventoryCategoryTo");
textEdit19.DataBindings.Add("Text", dt, "LotNumberTo");
textEdit20.DataBindings.Add("Text", dt, "DocumentNumber");
textEdit21.DataBindings.Add("Text", dt, "ItemLotReceiptWindow");
textEdit22.DataBindings.Add("Text", dt, "LotIdentifier");
textEdit23.Text = skuid;
cm.Position = 0;
if (dtmaterial != null)
{
textEdit24.DataBindings.Add("Text", dtmaterial, "LotNumber");
textEdit25.DataBindings.Add("Text", dtmaterial, "RecvBatchNo");
textEdit26.DataBindings.Add("Text", dtmaterial, "MaterialTrackID");
textEdit27.DataBindings.Add("Text", dtmaterial, "QtyInStore");
check[0][1] = check[0][2] = dtmaterial.Rows[0]["RecvBatchNo"].ToString();
check[1][1] = check[1][2] = dtmaterial.Rows[0]["QtyInStore"].ToString();
}
else
{
this.checkEdit2.Enabled = false;
this.checkEdit3.Enabled = false;
}
if (errinfo.Trim() != "")
{
this.textBox1.WordWrap = true;
this.textBox1.Text = errinfo;
}
if (Retried[0] == "True")
{
this.checkEdit1.Checked = true;
this.simpleButton1.Enabled = false;
this.btn_delete.Enabled = false;
}
else
{
this.checkEdit1.Checked = false;
}
}
//卡片显示
private void ShowCard()
{
if (gridView1.DataRowCount > 0)
{
string xml = gridView1.GetDataRow(gridView1.FocusedRowHandle)["ExChangeXML"].ToString();
gridControl2.DataSource = DBhelp.XML2Table(xml);
gridControl2.MainView.PopulateColumns();
//隐藏cardView1无用属性
for (int i = 0; i < 9; i++)
{
cardView1.Columns[i].Visible = false;
}
if (gridView1.GetDataRow(gridView1.FocusedRowHandle)["Properties"].ToString() != "")
{
string xml2 = gridView1.GetDataRow(gridView1.FocusedRowHandle)["Properties"].ToString();
DataTable tempstoredt = DBhelp.XML2Table(xml2);
tempstoredt.Columns.Add("LotNumber");
tempstoredt.Columns.Add("RecvBatchNo");
tempstoredt.Columns.Add("MaterialTrackID");
tempstoredt.Columns.Add("QtyInStore");
string selectsql3 = null;
if (tempstoredt.Columns.Contains("SKUID"))
{
selectsql3 = string.Format("SKUID = '{0}'", tempstoredt.Rows[0]["SKUID"].ToString());
}
DataTable tempdt = materialdt.Clone();
if (selectsql3 != null)
{
DataRow[] drArr = materialdt.Select(selectsql3);
if (drArr.Length > 0)
{
tempdt.ImportRow(drArr[0]);
}
}
if (tempdt.Rows.Count > 0)
{
tempstoredt.Rows[0]["LotNumber"] = tempdt.Rows[0]["LotNumber"];
tempstoredt.Rows[0]["RecvBatchNo"] = tempdt.Rows[0]["RecvBatchNo"];
tempstoredt.Rows[0]["MaterialTrackID"] = tempdt.Rows[0]["MaterialTrackID"];
tempstoredt.Rows[0]["QtyInStore"] = tempdt.Rows[0]["QtyInStore"];
}
else
{
tempstoredt.Rows[0]["LotNumber"] = "无记录";
tempstoredt.Rows[0]["RecvBatchNo"] = "无记录";
tempstoredt.Rows[0]["MaterialTrackID"] = "无记录";
tempstoredt.Rows[0]["QtyInStore"] = "无记录";
}
gridControl3.DataSource = tempstoredt;
gridControl3.MainView.PopulateColumns();
//隐藏cardView2无用属性
if (tempstoredt != null)
{
for (int i = 0; i < 5; i++)
{
cardView2.Columns[i].Visible = false;
}
}
}
//错误信息显示
textBox1.Multiline = true; //多行显示
textBox1.WordWrap = true; //文字断行显示
textBox1.Width = 15; //这里设置显示10个文字的宽度像素
if (gridView1.GetDataRow(gridView1.FocusedRowHandle)["ErrCode"].ToString() != "0" && gridView1.GetDataRow(gridView1.FocusedRowHandle)["ErrCode"] != null)
{
this.panelControl2.Appearance.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(253)))), ((int)(((byte)(244)))), ((int)(((byte)(191)))));
this.textBox1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(253)))), ((int)(((byte)(244)))), ((int)(((byte)(191)))));
this.textBox1.Text = gridView1.GetDataRow(gridView1.FocusedRowHandle)["ErrCode"].ToString() + ":" + gridView1.GetDataRow(gridView1.FocusedRowHandle)["ErrText"].ToString();
}
else
{
this.panelControl2.Appearance.BackColor = System.Drawing.Color.White;
this.textBox1.BackColor = System.Drawing.Color.White;
this.textBox1.Text = "";
}
}
else
{
this.gridControl2.DataSource = null;
this.gridControl3.DataSource = null;
this.panelControl2.Appearance.BackColor = System.Drawing.Color.White;
this.textBox1.BackColor = System.Drawing.Color.White;
this.textBox1.Text = "";
}
cardView1.OptionsBehavior.Editable = false;
cardView1.Appearance.FieldValue.BackColor = Color.Transparent;
cardView1.Appearance.FieldValue.ForeColor = Color.Black;
}
//显示编辑窗口
public void ShowEditForm()
{
string[][] check = new string[3][];
check[0] = new string[] { "False", "False", "False" }; //是否提交
check[1] = new string[] { "", "", "" }; //返回 RecvBatchNo,QtyInStore,QtyLoaded的值
check[2] = new string[] { "", "", "" }; //默认值
string selectsql3 = null;
long LogID = long.Parse(gridView1.GetDataRow(gridView1.FocusedRowHandle)["LogID"].ToString());
long LinkedLogID = long.Parse(gridView1.GetDataRow(gridView1.FocusedRowHandle)["LinkedLogID"].ToString());
string skuid = "";
string[] retried = { gridView1.GetDataRow(gridView1.FocusedRowHandle)["Retried"].ToString(), gridView1.GetDataRow(gridView1.FocusedRowHandle)["Retried"].ToString() };
string[] xml = { gridView1.GetDataRow(gridView1.FocusedRowHandle)["ExChangeXML"].ToString(), gridView1.GetDataRow(gridView1.FocusedRowHandle)["ExChangeXML"].ToString() };
DataTable tempdt = DBhelp.XML2Table(xml[0]);
if (xml[0] != "")
{
XmlDocument xdoc = new XmlDocument();
if (gridView1.GetDataRow(gridView1.FocusedRowHandle)["Properties"].ToString().Trim() != "")
{
xdoc.LoadXml(gridView1.GetDataRow(gridView1.FocusedRowHandle)["Properties"].ToString());
if (xdoc.FirstChild.SelectSingleNode("SKUID") != null)
{
skuid = xdoc.FirstChild.SelectSingleNode("SKUID").InnerText;
selectsql3 = string.Format("SKUID = '{0}'", skuid);
}
}
DialogResult dia = new DialogResult();
DataTable dtNew3 = materialdt.Clone();
string errinfo = gridView1.GetDataRow(gridView1.FocusedRowHandle)["ErrCode"].ToString() + ":" + gridView1.GetDataRow(gridView1.FocusedRowHandle)["ErrText"].ToString();
if (selectsql3 != null)
{
DataRow[] drArr3 = materialdt.Select(selectsql3);
if (drArr3.Length > 0)
{
dtNew3.ImportRow(drArr3[0]);
}
if (dtNew3.Rows.Count <= 0)
{
dtNew3 = null;
}
}
if (gridView1.GetDataRow(gridView1.FocusedRowHandle)["ExCode"].ToString() == "IMTR01")
{
IMTRForm im = null;
im = new IMTRForm(xml, skuid, errinfo, retried, dtNew3, check);
dia = im.ShowDialog();
}
else if (gridView1.GetDataRow(gridView1.FocusedRowHandle)["ExCode"].ToString() == "PORV01")
{
PORVForm po = null;
po = new PORVForm(xml, skuid, errinfo, retried, dtNew3, check);
dia = po.ShowDialog();
}
else if (gridView1.GetDataRow(gridView1.FocusedRowHandle)["ExCode"].ToString() == "PICK08")
{
PICKForm pi = null;
pi = new PICKForm(xml, skuid, errinfo, retried, dtNew3, check);
dia = pi.ShowDialog();
}
if (dia == DialogResult.OK)
{
string sql = "update IRAP..stb_Log_WebServiceShuttling set ExChangeXML = @ExChangeXML where LogID = @LogID and PartitioningKey ='600100000'";
SqlParameter[] paras = new SqlParameter[2];
if (GetLastLogID(LinkedLogID) != null)
{
long LastLogID = (long)GetLastLogID(LinkedLogID);
WriteLog.Instance.WriteBeginSplitter("开始编辑记录LogID =" + LastLogID.ToString() + string.Format(";Retried = {0}", retried[0]));
paras[0] = new SqlParameter("@ExChangeXML", xml[0]);
paras[1] = new SqlParameter("@LogID", LastLogID);
int i = 2;
try
{
i = DBhelp.ExecuteSQL(sql, paras);
}
catch (SqlException err)
{
WriteLog.Instance.Write(err.Message, "更改ExChangeXml失败");
WriteLog.Instance.Write(xml[1], "更改前的ExChangeXml");
WriteLog.Instance.Write(xml[0], "更改后的ExChangeXml");
MessageBox.Show(err.Message);
}
if (i == 0)
{
WriteLog.Instance.Write("未找到记录：", "更改ExChangeXml失败");
WriteLog.Instance.Write(xml[1], "更改前的ExChangeXml");
WriteLog.Instance.Write(xml[0], "更改后的ExChangeXml");
MessageBox.Show("保存失败");
}
else if (i == 1)
{
WriteLog.Instance.Write("成功", "更改ExChangeXml成功");
WriteLog.Instance.Write(xml[1], "更改前的ExChangeXml");
WriteLog.Instance.Write(xml[0], "更改后的ExChangeXml");
string name = "IRAP..ssp_BackgroundJob_WSRetry";
SqlParameter[] paras3 = new SqlParameter[5];
paras3[0] = new SqlParameter("@SysLogID", 1);
paras3[1] = new SqlParameter("@CommunityID", 60010);
paras3[2] = new SqlParameter("@WSSLogID", LastLogID);
paras3[3] = new SqlParameter("@ErrCode", SqlDbType.Int, 4);
paras3[3].Direction = ParameterDirection.Output;
paras3[4] = new SqlParameter("@ErrText", SqlDbType.NVarChar, 400);
paras3[4].Direction = ParameterDirection.Output;
int j = 2;
try
{
j = DBhelp.ExecuteProc(name, paras3);
}
catch (SqlException err)
{
MessageBox.Show(err.Message);
WriteLog.Instance.Write(err.Message, "WSRrtry执行失败");
}
if (j == -1)
{
WriteLog.Instance.Write(string.Format("ErrCode = {0},{1}", paras3[3].Value.ToString(), paras3[4].Value.ToString()), "WSRetry执行成功");
MessageBox.Show(string.Format("ErrCode = {0},{1}", paras3[3].Value.ToString(), paras3[4].Value.ToString()));
// 如果是 PORV01 交易成功，则需要将 utb_MaterialStore 表中的 RecvBatchNo 更新为四班中生成的 RecvBatchNo
// 代码待定
if (check[0][0] == "True")
{
int flag = 2;
string sql2 = "update IRAPRIMCS..utb_MaterialStore set RecvBatchNo = @RecvBatchNo where SKUID =@SKUID";
SqlParameter[] paras2 = new SqlParameter[2];
paras2[0] = new SqlParameter("@RecvBatchNo", check[0][1]);
paras2[1] = new SqlParameter("@SKUID", skuid);
try
{
flag = DBhelp.ExecuteSQL(sql2, paras2);
if (flag == 0)
{
WriteLog.Instance.Write(string.Format("更改RecvbatcNo = {0}为RecvBatchNo = {1}", check[0][2], check[0][1]), "更改RecvBatchNo失败，未找到记录");
}
else if (flag == 1)
{
WriteLog.Instance.Write(string.Format("更改RecvbatcNo = {0}为RecvBatchNo = {1}", check[0][2], check[0][1]), "更改RecvBatchNo成功");
}
}
catch (SqlException err)
{
MessageBox.Show(err.Message);
WriteLog.Instance.Write(string.Format("更改RecvbatcNo = {0}更改RecvbatcNo = {1}", check[0][2], check[0][1]), "更改更改RecvbatcNo失败" + err.Message);
}
}
if (check[1][0] == "True")
{
int flag = 2;
string sql2 = "update IRAPRIMCS..utb_MaterialStore set QtyInStore = @QtyInStore where SKUID =@SKUID";
SqlParameter[] paras2 = new SqlParameter[2];
paras2[0] = new SqlParameter("@QtyInStore", check[1][1]);
paras2[1] = new SqlParameter("@SKUID", skuid);
try
{
flag = DBhelp.ExecuteSQL(sql2, paras2);
if (flag == 0)
{
WriteLog.Instance.Write(string.Format("更改QtyInStore = {0}为QtyInStore = {1}", check[1][2], check[1][1]), "更改QtyInStore失败，未找到记录");
}
else if (flag == 1)
{
WriteLog.Instance.Write(string.Format("更改QtyInStore = {0}为QtyInStore = {1}", check[1][2], check[1][1]), "更改QtyInStore成功");
}
}
catch (SqlException err)
{
MessageBox.Show(err.Message);
WriteLog.Instance.Write(string.Format("更改QtyInStore = {0}更改QtyInStore = {1}", check[1][2], check[1][1]), "更改更改QtyInStore失败" + err.Message);
}
}
if (check[2][1] != check[2][2] && check[2][0] == "True")
{
int flag = 2;
string sql2 = "update IRAPMES..RSFact_PWOMaterialTrack set QtyLoaded = @QtyLoaded where WFInstanceID in (SELECT WFInstanceID from IRAPMES..AuxFact_PWOIssuing where MONumber =@MONumber and MOLineNo =@MOLineNo) and SKUID =@SKUID";
SqlParameter[] paras2 = new SqlParameter[4];
paras2[0] = new SqlParameter("@QtyLoaded", check[2][1]);
paras2[1] = new SqlParameter("@MONumber", tempdt.Rows[0]["OrderNumber"].ToString());
paras2[2] = new SqlParameter("@MOLineNo", tempdt.Rows[0]["LineNumber"].ToString());
paras2[3] = new SqlParameter("@SKUID", skuid);
try
{
flag = DBhelp.ExecuteSQL(sql2, paras2);
if (flag == 0)
{
WriteLog.Instance.Write(string.Format("更改QtyLoaded = {0}为QtyLoaded = {1}", check[2][2], check[2][1]), "更改QtyLoaded失败,未找到记录");
}
else if (flag == 1)
{
WriteLog.Instance.Write(string.Format("更改QtyLoaded = {0}为QtyLoaded = {1}", check[2][2], check[2][1]), "更改QtyLoaded成功");
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
WriteLog.Instance.Write(string.Format("更改QtyLoaded = {0}为QtyLoaded = {1}", check[2][2], check[2][1]), "更改QtyLoaded失败" + err.Message);
}
}
WriteLog.Instance.WriteEndSplitter("结束编辑记录");
RefreshData();
}
}
}
else
{
MessageBox.Show("该LinkedLogID下无Retried=0的记录，请刷新数据");
}
}
else if (dia == DialogResult.Abort)
{
string sql = "update IRAP..stb_Log_WebServiceShuttling set Retried = @Retried where LogID = @LogID";
SqlParameter[] paras = new SqlParameter[2];
if (GetLastLogID(LinkedLogID) != null)
{
long LastLogID = (long)(LogID);
paras[0] = new SqlParameter("@Retried", 1);
paras[1] = new SqlParameter("@LogID", LastLogID);
try
{
if (DBhelp.ExecuteSQL(sql, paras) == 1)
{
MessageBox.Show("删除成功");
WriteLog.Instance.WriteBeginSplitter("开始删除记录LogID =" + LastLogID.ToString() + string.Format(";Retried = {0}", retried[0]));
WriteLog.Instance.Write(xml[1], "删除记录成功");
WriteLog.Instance.WriteEndSplitter("结束删除记录");
RefreshData();
}
}
catch (SqlException err)
{
MessageBox.Show("删除失败:" + err.Message);
WriteLog.Instance.WriteBeginSplitter("开始删除记录LogID =" + LastLogID.ToString() + string.Format(";Retried = {0}", retried[0]));
WriteLog.Instance.Write(err.Message, "删除记录失败");
WriteLog.Instance.Write(xml[1], "删除记录失败");
WriteLog.Instance.WriteEndSplitter("结束删除记录");
}
}
else
{
MessageBox.Show("该LinkedLogID下无Retried=0的记录，请刷新数据");
}
}
}
}
//获取解析的XML数据
private void SetDTRow(long LogID, int mode)
{
DataRow dr = maindt.Rows.Find(LogID);
DataTable tempdt = DBhelp.XML2Table(dr["ExChangeXML"].ToString());
if (dr["Properties"].ToString() != "")
{
DataTable tempdt2 = DBhelp.XML2Table(dr["Properties"].ToString());
if (tempdt2.Columns.Contains("SKUID"))
{
dr["SKUID"] = tempdt2.Rows[0]["SKUID"];
}
}
if (dr["ExCode"].ToString() == "PICK08" || dr["ExCode"].ToString() == "提料")
{
dr["ExCode"] = "PICK08";
dr["ItemNumber"] = tempdt.Rows[0]["ItemNumber"];
dr["LotNumber"] = tempdt.Rows[0]["LotNumber"];
dr["BinFrom"] = tempdt.Rows[0]["Bin"];
dr["Quantity"] = tempdt.Rows[0]["IssuedQuantity"];
dr["OrderNumber"] = tempdt.Rows[0]["OrderNumber"];
dr["OLineNO"] = tempdt.Rows[0]["LineNumber"];
if (mode == 2)
{
gridView1.SetFocusedRowCellValue("ItemNumber", tempdt.Rows[0]["ItemNumber"]);
gridView1.SetFocusedRowCellValue("LotNumber", tempdt.Rows[0]["LotNumber"]);
gridView1.SetFocusedRowCellValue("BinFrom", tempdt.Rows[0]["Bin"]);
gridView1.SetFocusedRowCellValue("Quantity", tempdt.Rows[0]["IssuedQuantity"]);
}
}
else if (dr["ExCode"].ToString() == "IMTR01" || dr["ExCode"].ToString() == "移库")
{
dr["ExCode"] = "IMTR01";
dr["ItemNumber"] = tempdt.Rows[0]["ItemNumber"];
dr["LotNumber"] = tempdt.Rows[0]["LotNumberFrom"];
dr["BinFrom"] = tempdt.Rows[0]["BinFrom"];
dr["BinTo"] = tempdt.Rows[0]["BinTo"];
dr["Quantity"] = tempdt.Rows[0]["InventoryQuantity"];
if (mode == 2)
{
gridView1.SetFocusedRowCellValue("ItemNumber", tempdt.Rows[0]["ItemNumber"]);
gridView1.SetFocusedRowCellValue("LotNumber", tempdt.Rows[0]["LotNumberFrom"]);
gridView1.SetFocusedRowCellValue("BinFrom", tempdt.Rows[0]["BinFrom"]);
gridView1.SetFocusedRowCellValue("BinTo", tempdt.Rows[0]["BinTo"]);
gridView1.SetFocusedRowCellValue("Quantity", tempdt.Rows[0]["InventoryQuantity"]);
}
}
else if (dr["ExCode"].ToString() == "PORV01" || dr["ExCode"].ToString() == "入库")
{
dr["ExCode"] = "PORV01";
dr["ItemNumber"] = tempdt.Rows[0]["ItemNumber"];
dr["LotNumber"] = tempdt.Rows[0]["LotNumberDefault"];
dr["BinTo"] = tempdt.Rows[0]["Bin1"];
dr["Quantity"] = tempdt.Rows[0]["ReceiptQuantityMove1"];
dr["OrderNumber"] = tempdt.Rows[0]["PONumber"];
dr["OLineNO"] = tempdt.Rows[0]["POLineNumber"];
if (mode == 2)
{
gridView1.SetFocusedRowCellValue("ItemNumber", tempdt.Rows[0]["ItemNumber"]);
gridView1.SetFocusedRowCellValue("LotNumber", tempdt.Rows[0]["LotNumberDefault"]);
gridView1.SetFocusedRowCellValue("BinTo", tempdt.Rows[0]["Bin1"]);
gridView1.SetFocusedRowCellValue("Quantity", tempdt.Rows[0]["ReceiptQuantityMove1"]);
}
}
else if (dr["ExCode"].ToString() == "MORV00")
{
dr["ExCode"] = "MORV00";
dr["ItemNumber"] = tempdt.Rows[0]["ItemNumber"];
dr["LotNumber"] = tempdt.Rows[0]["LotNumber"];
dr["BinFrom"] = tempdt.Rows[0]["Bin1"];
dr["Quantity"] = tempdt.Rows[0]["ReceiptQuantity"];
dr["OrderNumber"] = tempdt.Rows[0]["MONumber"];
dr["OLineNO"] = tempdt.Rows[0]["MOLineNumber"];
}
else if (dr["ExCode"].ToString() == "INVA01")
{
dr["ExCode"] = "INVA01";
dr["ItemNumber"] = tempdt.Rows[0]["ItemNumber"];
dr["LotNumber"] = tempdt.Rows[0]["LotNumber"];
dr["BinTo"] = tempdt.Rows[0]["Bin"];
dr["Quantity"] = tempdt.Rows[0]["AdjustQuantity"];
}
tempdt.Clear();
}
//获取并显示数据
private void LoadTask()
{
Task task1 = Task.Factory.StartNew(() =>
{
string sql3 = "Select * from IRAPRIMCS..utb_MaterialStore";
if (materialdt != null)
{
materialdt.Clear();
}
try
{
materialdt = DBhelp.Query(sql3).Tables["ds"];
}
catch (Exception e)
{
MessageBox.Show(e.Message);
WriteLog.Instance.Write(e.Message, "加载材料库存数据失败");
}
});
splashScreenManager1.SetWaitFormDescription("获取数据中...");
if (maindt != null)
{
maindt.Clear();
}
try
{
maindt = DBhelp.Query(mainsql).Tables["ds"];
}
catch (Exception e)
{
MessageBox.Show(e.Message);
WriteLog.Instance.Write(e.Message, "加载主数据失败!");
}
splashScreenManager1.SetWaitFormDescription("显示数据中...");
maindt.PrimaryKey = new DataColumn[] { maindt.Columns["LogID"] };
maindt.Columns.Add("ItemNumber").SetOrdinal(4);
maindt.Columns.Add("LotNumber").SetOrdinal(5);
maindt.Columns.Add("BinFrom").SetOrdinal(6);
maindt.Columns.Add("BinTo").SetOrdinal(7);
maindt.Columns.Add("OrderNumber").SetOrdinal(8);
maindt.Columns.Add("OLineNo");
maindt.Columns.Add("Quantity").SetOrdinal(8);
maindt.Columns.Add("SKUID").SetOrdinal(9);
//更改ExCode并为列赋值
for (int i = 0; i < maindt.Rows.Count; i++)
{
SetDTRow((long)maindt.Rows[i]["LogID"], 1);
}
gridControl1.UseEmbeddedNavigator = true;
gridControl1.EmbeddedNavigator.Enabled = false;
maindv = maindt.DefaultView;
maindv.Sort = "LinkedLogID asc,LogID asc";
gridControl1.DataSource = maindv;
gridControl1.MainView.PopulateColumns();
//隐藏gridView1无用属性
gridView1.Columns["ErrCode"].Visible = false;
gridView1.Columns["Retried"].Visible = false;
gridView1.Columns["LinkedLogID"].Visible = false;
gridView1.Columns["ExChangeXML"].Visible = false;
gridView1.Columns["ErrText"].Visible = false;
gridView1.Columns["Properties"].Visible = false;
gridView1.Columns["SKUID"].GroupIndex = 0;
gridView1.BestFitColumns();
Task.WaitAll(task1);
}
public PORVForm(string[] xml, string skuid, string errinfo, string[] retried, DataTable dtmaterial, string[][] check)
{
InitializeComponent();
Xml = xml;
Retried = retried;
Check = check;
dt = DBhelp.XML2Table(Xml[0]);
cm = (CurrencyManager)this.BindingContext[dt];
textEdit1.DataBindings.Add("Text", dt, "AgencyLeaf");
textEdit2.DataBindings.Add("Text", dt, "SysLogID");
textEdit3.DataBindings.Add("Text", dt, "StationID");
textEdit4.DataBindings.Add("Text", dt, "RoleLeaf");
textEdit5.DataBindings.Add("Text", dt, "CommunityID");
textEdit6.DataBindings.Add("Text", dt, "UserCode");
textEdit7.DataBindings.Add("Text", dt, "ExCode");
textEdit8.DataBindings.Add("Text", dt, "UserID");
textEdit9.DataBindings.Add("Text", dt, "PassWord");
textEdit10.DataBindings.Add("Text", dt, "PONumber");
textEdit11.DataBindings.Add("Text", dt, "POLineNumber");
textEdit12.DataBindings.Add("Text", dt, "POReceiptActionType");
textEdit13.DataBindings.Add("Text", dt, "POLineUM");
textEdit14.DataBindings.Add("Text", dt, "ReceiptQuantityMove1");
textEdit15.DataBindings.Add("Text", dt, "Stockroom1");
textEdit16.DataBindings.Add("Text", dt, "Bin1");
textEdit17.DataBindings.Add("Text", dt, "InventoryCategory1");
textEdit18.DataBindings.Add("Text", dt, "POLineType");
textEdit19.DataBindings.Add("Text", dt, "ItemNumber");
textEdit20.DataBindings.Add("Text", dt, "NewLot");
textEdit21.DataBindings.Add("Text", dt, "LotNumberAssignmentPolicy");
textEdit22.DataBindings.Add("Text", dt, "LotNumberDefault");
if (dt.Columns.Contains("VendorLotNumber"))
{
textEdit23.DataBindings.Add("Text", dt, "VendorLotNumber");
}
else
{
textEdit23.Text = "";
}
if (dt.Columns.Contains("FirstReceiptDate"))
{
textEdit24.DataBindings.Add("Text", dt, "FirstReceiptDate");
}
else
{
textEdit24.Text = "";
}
textEdit25.DataBindings.Add("Text", dt, "PromisedDate");
textEdit26.DataBindings.Add("Text", dt, "POReceiptDate");
textEdit27.Text = skuid;
cm.Position = 0; // 如 index = 0;
if (dtmaterial != null)
{
textEdit28.DataBindings.Add("Text", dtmaterial, "LotNumber");
textEdit29.DataBindings.Add("Text", dtmaterial, "RecvBatchNo");
textEdit30.DataBindings.Add("Text", dtmaterial, "MaterialTrackID");
textEdit31.DataBindings.Add("Text", dtmaterial, "QtyInStore");
check[0][1] = check[0][2] = dtmaterial.Rows[0]["RecvBatchNo"].ToString();
check[1][1] = check[1][2] = dtmaterial.Rows[0]["QtyInStore"].ToString();
}
else
{
this.checkEdit2.Enabled = false;
this.checkEdit3.Enabled = false;
}
if (errinfo.Trim() != "")
{
this.textBox1.WordWrap = true;
this.textBox1.Text = errinfo;
}
if (Retried[0] == "True")
{
this.checkEdit1.Checked = true;
this.simpleButton1.Enabled = false;
this.btn_delete.Enabled = false;
}
else
{
this.checkEdit1.Checked = false;
}
}
