public void CaseDetailEditHandler() { DataTable dt = (DataTable)dgCaseDetailList.DataSource; if (dt != null && dt.Rows.Count > 0) { hkCaseDetailMgr.Stop(); CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(dt.Rows[dgCaseDetailList.CurrentRowIndex].ItemArray[1].ToString(), dt.Rows[dgCaseDetailList.CurrentRowIndex].ItemArray[2].ToString(), dt.Rows[dgCaseDetailList.CurrentRowIndex].ItemArray[3].ToString(), dt.Rows[dgCaseDetailList.CurrentRowIndex].ItemArray[4].ToString(), dt.Rows[dgCaseDetailList.CurrentRowIndex].ItemArray[5].ToString(), this.caseNumberID, true); editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate); editFrm.Show(); } }
public void AddUpdateCaseDetail(string barcode) { try { string sql = string.Empty; List <SQLiteParameter> parameters = new List <SQLiteParameter>(); //国际商品码 sql = @"select * from FromERPDetail where BoxBarcode=@BoxBarcode"; parameters = new List <SQLiteParameter>() { new SQLiteParameter("@BoxBarcode", barcode) }; //处理Code128C码奇数位前面补零的问题 sql += " or BoxBarcode=@FormatBoxBarcode "; parameters.Add(new SQLiteParameter("@FormatBoxBarcode", barcode.Substring(1))); DataTable partsDt = db.ExecuteDataTable(sql, parameters.ToArray()); if (partsDt != null && partsDt.Rows.Count > 0) { hkCaseDetailMgr.Stop(); CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(partsDt.Rows[0]["ProdName"].ToString(), partsDt.Rows[0]["Model"].ToString(), partsDt.Rows[0]["Num"].ToString(), partsDt.Rows[0]["NormNum"].ToString(), partsDt.Rows[0]["Barcode"].ToString(), this.caseNumberID, false); editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate); editFrm.Show(); } else { if (barcode.Contains("-")) { //件码-数量 string[] infoArray = barcode.Split(new char[] { '-' }); sql = @"select * from FromERPDetail where Barcode=@Barcode"; parameters = new List <SQLiteParameter>() { new SQLiteParameter("@Barcode", infoArray[0]) }; //处理Code128C码奇数位前面补零的问题 sql += " or Barcode=@FormatBarcode "; parameters.Add(new SQLiteParameter("@FormatBarcode", infoArray[0].Substring(1))); DataTable dtFirst = db.ExecuteDataTable(sql, parameters.ToArray()); if (dtFirst != null && dtFirst.Rows.Count > 0) { hkCaseDetailMgr.Stop(); CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(dtFirst.Rows[0]["ProdName"].ToString(), dtFirst.Rows[0]["Model"].ToString(), dtFirst.Rows[0]["Num"].ToString(), infoArray[1], dtFirst.Rows[0]["Barcode"].ToString(), this.caseNumberID, false); editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate); editFrm.Show(); } else { msg.ShowMessage("该配件不在发货单中", 1); } } else { //自编条码 sql = @"select * from FromERPDetail where Barcode=@Barcode"; parameters = new List <SQLiteParameter>() { new SQLiteParameter("@Barcode", barcode) }; //处理Code128C码奇数位前面补零的问题 sql += " or Barcode=@FormatBarcode "; parameters.Add(new SQLiteParameter("@FormatBarcode", barcode.Substring(1))); DataTable dtSecond = db.ExecuteDataTable(sql, parameters.ToArray()); if (dtSecond != null && dtSecond.Rows.Count > 0) { hkCaseDetailMgr.Stop(); if (dtSecond.Rows[0]["bJianMaInBox"].ToString().Equals("True")) { CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(dtSecond.Rows[0]["ProdName"].ToString(), dtSecond.Rows[0]["Model"].ToString(), dtSecond.Rows[0]["Num"].ToString(), dtSecond.Rows[0]["NormNum"].ToString(), dtSecond.Rows[0]["Barcode"].ToString(), this.caseNumberID, false); editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate); editFrm.Show(); } else { CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(dtSecond.Rows[0]["ProdName"].ToString(), dtSecond.Rows[0]["Model"].ToString(), dtSecond.Rows[0]["Num"].ToString(), "1", dtSecond.Rows[0]["Barcode"].ToString(), this.caseNumberID, false); editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate); editFrm.Show(); } } else { msg.ShowMessage("该配件不在发货单中", 1); } } } } catch (Exception ex) { } }