protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Request.Params["functionNo"] != null && Request.Params["functionNo"].Trim() != "") { this.FunctionNo = Request.Params["functionNo"]; } } if (this.SET_SQL.Value != "") { this.SET_SQL.Value = this.SET_SQL.Value.Substring(0, this.SET_SQL.Value.Length - 1); SCommBB commBB = new SCommBB(); try { string[] updateSqls = this.SET_SQL.Value.Split(';'); foreach (string updateSql in updateSqls) { commBB.ExecuteSql(updateSql); } } finally { commBB.Dispose(); } this.SET_SQL.Value = ""; } this.ShowPullInfo(this.FunctionNo); }
/// <summary> /// 获取SAP数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnData_Click(object sender, EventArgs e) { SCommBB commBB = new SCommBB(); try { //获取SAP到货单、销售订单 commBB.ExecuteSql("exec up_SAP_GetNewData"); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('同步SAP到货\\拣货数据成功!');", true); } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { commBB.Dispose(); } }
/// <summary> /// 修改关联的托盘号 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnChangeBox_Click(object sender, EventArgs e) { if (txtBoxNo.Text.ToString() == "") { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"箱号不能为空!\");", true); return; } if (txtPalletNewNo.Text.ToString()=="") { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"托盘号不能为空!\");", true); return; } if (txtBoxNo.Text.ToString().ToUpper().Substring(0, 1) != "X" || txtPalletNewNo.Text.ToString().ToUpper().Substring(0,1)!="T") { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"箱号或是托盘号不正确!\");", true); return; } SCommBB comm = new SCommBB(); try { comm.ExecuteSql("Update BarrangeBillBox set PalletNo = '" + txtPalletNewNo.Text.Trim().ToUpper() + "' where boxNo = '" + txtBoxNo.Text.Trim().ToUpper() + "'"); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"更新托盘号成功 箱号 " + txtBoxNo.Text.Trim().ToUpper() + " 更新后的托盘是" + txtPalletNewNo.Text.Trim().ToUpper() + "!\");", true); } catch (Exception ee) { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"更新托盘号失败 " + ee.Message + "!\");", true); } finally { txtBoxNo.Text = ""; txtPalletNewNo.Text = ""; comm.Dispose(); } }
public bool UpdateLBoxNo(int BoxQty, string MaterialNo) { SCommBB commBB = new SCommBB(); bool ret = false; string command = @"update LMaterial set U_BoxQty =" + BoxQty + " where materialNo ='" + MaterialNo + "'"; try { commBB.ExecuteSql(command); ret = true; } catch { ret = false; } finally { commBB.Dispose(); } return ret; }
public bool UpdateTHBill(string backBillNo) { bool ret = false; string command = "Update BBackBill set instantState = '05' where backBillNo ='" + backBillNo + "' "; SCommBB commBB = new SCommBB(); try { commBB.ExecuteSql(command); ret = true; } catch { ret = false; } commBB.Dispose(); return ret; }
protected void Button2_Click(object sender, EventArgs e) { foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { //string str = "update BArriveBill set instantState='06' where id ='" + this.grid.DataKeys[gvrow.RowIndex]["chkId"].ToString() + "'"; // this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"" + this.grid.DataKeys[gvrow.RowIndex]["id"].ToString() + "\");", true); string str = "update BArriveBill set instantState='06' where id ='" + this.grid.DataKeys[gvrow.RowIndex]["id"].ToString() + "'"; SCommBB commBB = new SCommBB(); commBB.ExecuteSql(str); } } this.BindGrid(); }
public string SAPConverMaterialOutInStock(string strStockUpBillNo, string MarkText) { SapOnlineService.SapOnlineService sapService = new SapOnlineService.SapOnlineService(); CSaleDetailBB saleDetailBB = new CSaleDetailBB(); SCommBB commBB = new SCommBB(); try { SapOnlineService.WebFaHuoModel2[] faHuoList = null; SapOnlineService.WebShouHuoModel2[] shouHuoList = null; SapOnlineService.IGE1_Return IGEReturn = null; SapOnlineService.IGN1_Return IGNReturn = null; SapOnlineService.IGE1[] IGEArray = null; StringBuilder struFaHuo = new StringBuilder(); StringBuilder struShouHuo = new StringBuilder(); DataTable dtPickOutPlan = new DataTable(); string strResult = "", strError = ""; //获取所有需要收发货的拣货计划 dtPickOutPlan = commBB.Query("exec Proc_GetSAPKCSFH '" + strStockUpBillNo + "'").Tables[0]; if (dtPickOutPlan.Rows.Count == 0) { strResult = "0&当前拣货单没有需要收发货物料!"; return strResult; } #region 库存发货 foreach (DataRow rowPickOutPlan in dtPickOutPlan.Rows) { double num = 0; string strAbsEntry = "", strDocEntry = "", strMaterialNo_FH = "", strMaterialNo_SH = ""; strAbsEntry = rowPickOutPlan["absEntry"].ToString();//提货单ID strDocEntry = rowPickOutPlan["docEntry"].ToString();//销售订单ID strMaterialNo_FH = rowPickOutPlan["materialNo_FH"].ToString();//库存发货物料 strMaterialNo_SH = rowPickOutPlan["materialNo_SH"].ToString();//库存收货物料 num = Convert.ToDouble(rowPickOutPlan["num"]);//剩余未SAP库存收发货数量 //库存发货 if (Convert.ToBoolean(rowPickOutPlan["isSAPOutStock"]) == false) { struFaHuo.Append(strMaterialNo_FH + "," + num + ",01," + strDocEntry + "," + strAbsEntry + "," + strMaterialNo_SH + ",GHBZ-WMS;"); } } if (struFaHuo.ToString() != "") { string[] array_FaHuo = struFaHuo.ToString().Trim(';').Split(';'); faHuoList = new SapOnlineService.WebFaHuoModel2[array_FaHuo.Length]; //发货 for (int i = 0; i < array_FaHuo.Length; i++) { string[] array_FaHuoDetail = array_FaHuo[i].Split(','); SapOnlineService.WebFaHuoModel2 faHuo = new SapOnlineService.WebFaHuoModel2(); faHuo.ItemCode = array_FaHuoDetail[0];//ItemCode faHuo.Quantity = Convert.ToDouble(array_FaHuoDetail[1]);//Quantity faHuo.WhsCode = array_FaHuoDetail[2];//WhsCode faHuo.U_ORDR = array_FaHuoDetail[3];//U_ORDR faHuo.U_PKL = array_FaHuoDetail[4];//U_PKL faHuo.U_ItemCode = array_FaHuoDetail[5];//U_ItemCode faHuo.U_YongT = "GHBZ-WMS";//U_YongT faHuoList[i] = faHuo; } //库存发货 IGEReturn = sapService.IGE1_Web_Add_ForCangKu(System.DateTime.Now, "由WMS提交-" + MarkText, faHuoList); strResult = IGEReturn.ResultSucess; strError = IGEReturn.ErrMesg; if (strResult == "1") { IGEArray = IGEReturn.ListIGE1; for (int i = 0; i < IGEArray.Length; i++) { //更改发货状态 commBB.ExecuteSql("update dbo.CPickOutPlan set isSAPOutStock=1,sapStockPrice=" + IGEArray[i].StockPrice + " where absEntry='" + IGEArray[i].U_PKL + "' and docEntry='" + IGEArray[i].U_ORDR + "' and materialNo='" + IGEArray[i].ItemCode + "'"); } } else { return "0&" + strError; } } #endregion 库存发货 #region 库存收货 //获取所有需要收货的拣货计划 dtPickOutPlan = commBB.Query("exec Proc_GetSAPKCSFH '" + strStockUpBillNo + "'").Tables[0]; foreach (DataRow rowPickOutPlan in dtPickOutPlan.Rows) { double num = 0, price = 0; string strAbsEntry = "", strDocEntry = "", strMaterialNo_FH = "", strMaterialNo_SH = ""; strAbsEntry = rowPickOutPlan["absEntry"].ToString();//提货单ID strDocEntry = rowPickOutPlan["docEntry"].ToString();//销售订单ID strMaterialNo_FH = rowPickOutPlan["materialNo_FH"].ToString();//库存发货物料 strMaterialNo_SH = rowPickOutPlan["materialNo_SH"].ToString();//库存收货物料 num = Convert.ToDouble(rowPickOutPlan["num"]);//剩余未SAP库存收发货数量 price = Convert.ToDouble(rowPickOutPlan["sapStockPrice"]);//价格 //库存收货 if (Convert.ToBoolean(rowPickOutPlan["isSAPInStock"]) == false) { struShouHuo.Append(strMaterialNo_SH + "," + num + ",01," + strDocEntry + "," + strAbsEntry + "," + strMaterialNo_FH + ",GHBZ-WMS," + price.ToString() + ";"); } } //组织库存收发货数据 if (struShouHuo.ToString() != "") { string[] array_ShouHuo = struShouHuo.ToString().Trim(';').Split(';'); shouHuoList = new SapOnlineService.WebShouHuoModel2[array_ShouHuo.Length]; //收货 for (int i = 0; i < array_ShouHuo.Length; i++) { string[] array_ShouHuoDetail = array_ShouHuo[i].Split(','); SapOnlineService.WebShouHuoModel2 shouHuo = new SapOnlineService.WebShouHuoModel2(); shouHuo.ItemCode = array_ShouHuoDetail[0];//ItemCode shouHuo.Quantity = Convert.ToDouble(array_ShouHuoDetail[1]);//Quantity shouHuo.WhsCode = array_ShouHuoDetail[2];//WhsCode shouHuo.U_ORDR = array_ShouHuoDetail[3];//U_ORDR shouHuo.U_PKL = array_ShouHuoDetail[4];//U_PKL shouHuo.U_ItemCode = array_ShouHuoDetail[5];//U_ItemCode shouHuo.U_YongT = "GHBZ-WMS";//U_YongT shouHuo.Price = Convert.ToDouble(array_ShouHuoDetail[7]);//Price shouHuoList[i] = shouHuo; } //库存收货 IGNReturn = sapService.IGN1_Web_Add_ForCangKu(System.DateTime.Now, "由WMS提交-库存收货", shouHuoList); strResult = IGNReturn.ResultSucess; strError = IGNReturn.ErrMesg; //更改收货状态 if (IGNReturn.ResultSucess == "1") { foreach (SapOnlineService.WebShouHuoModel2 shouHuo in shouHuoList) { commBB.ExecuteSql("update dbo.CPickOutPlan set isSAPInStock=1 where absEntry='" + shouHuo.U_PKL + "' and docEntry='" + shouHuo.U_ORDR + "' and materialNo='" + shouHuo.U_ItemCode + "'"); } } else { return "0&" + strError; } } #endregion 库存收货 return strResult; } finally { sapService.Dispose(); saleDetailBB.Dispose(); commBB.Dispose(); } }
/// <summary> /// 提交SAP /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnCommit_Click(object sender, EventArgs e) { DMWJEXECUTE services = new DMWJEXECUTE(); IList<string> messList = new List<string>(); messList.Clear(); try { bool isChecked = false; //获取选中的数据Id foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { int financeBillId = 0, financeBillLineNum = 0; string strMaterialNo = "", custNo = "", custNm = ""; DateTime stockDt, arriveDt; double num = 0; financeBillId = Convert.ToInt32(this.grid.DataKeys[gvrow.RowIndex]["financeBillId"]); financeBillLineNum = Convert.ToInt32(this.grid.DataKeys[gvrow.RowIndex]["financeBillLineNum"]); strMaterialNo = this.grid.DataKeys[gvrow.RowIndex]["materialNo"].ToString(); num = Convert.ToDouble(this.grid.DataKeys[gvrow.RowIndex]["num"]); stockDt = Convert.ToDateTime(this.grid.DataKeys[gvrow.RowIndex]["stockDt"]); arriveDt = Convert.ToDateTime(this.grid.DataKeys[gvrow.RowIndex]["arriveDt"]); custNo = this.grid.DataKeys[gvrow.RowIndex]["custNo"].ToString(); custNm = this.grid.DataKeys[gvrow.RowIndex]["custNm"].ToString(); string mess = Convert.ToInt32(chkId.ValidationGroup).ToString() + ";" + financeBillId.ToString() + ";" + financeBillLineNum.ToString() + ";" + strMaterialNo + ";" + num.ToString() + ";" + stockDt + ";" + arriveDt + ";" + custNo + ";" + custNm; messList.Add(mess); //strResult = services.SAPInStock(Convert.ToInt32(chkId.ValidationGroup), financeBillId, // financeBillLineNum, strMaterialNo, num, stockDt, arriveDt, custNo, custNm); //if (strResult.Split('&')[0] == "1") //{ // isChecked = true; //} //else if (strResult.Split('&')[0] == "0") //{ // this.BindGrid(); // this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"" + strResult.Split('&')[1] + "\");", true); // return; //} } } if (messList.Count > 0) { SapOnlineService.SapOnlineService sapService = new SapOnlineService.SapOnlineService(); SapOnlineService.POR1[] list = new SapOnlineService.POR1[messList.Count]; for (int i = 0; i < messList.Count; i++) { SapOnlineService.POR1 por1 = new SapOnlineService.POR1(); por1.DocEntry = Convert.ToInt32(messList[i].Split(';')[1].ToString()); por1.LineNum = Convert.ToInt32(messList[i].Split(';')[2].ToString()); por1.ItemCode = messList[i].Split(';')[3].ToString(); por1.Quantity = Convert.ToDouble(messList[i].Split(';')[4].ToString());//数量 list[i] = por1; } string strResult = sapService.Web_AddPDN_For_POR1(messList[0].Split(';')[7].ToString(), messList[0].Split(';')[8].ToString(), Convert.ToDateTime(messList[0].Split(';')[5].ToString()), "由WMS同步", Convert.ToDateTime(messList[0].Split(';')[5].ToString()), "由WMS同步", Convert.ToDateTime(messList[0].Split(';')[6].ToString()), list); if (strResult.Split('&')[0] == "1") { for (int i = 0; i < messList.Count; i++) { BArriveDetailData arriveDetailModel = new BArriveDetailData(); BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); SCommBB commBB = new SCommBB(); arriveDetailModel = arriveDetailBB.GetModel(Convert.ToInt32(messList[i].Split(';')[0])); arriveDetailModel.isSapInStock = true;//是否已提交SAP入库 arriveDetailBB.ModifyRecord(arriveDetailModel); //更改物料箱的“是否已提交SAP入库”状态 commBB.ExecuteSql(@"update dbo.BArrangeBillBox set isSapInStock=1 where isSapInStock=0 and inStockDt is not null and arriveBillNo='" + arriveDetailModel.arriveBillNo + "' and financeBillId='" + messList[i].Split(';')[1].ToString() + "' and financeBillLineNum='" + messList[i].Split(';')[2].ToString() + "' and materialNo='" + messList[i].Split(';')[3].ToString() + "'" +" or oldMaterialNo ='"+ messList[i].Split(';')[3].ToString() + "'" +" and isSapInStock=0 and inStockDt is not null and arriveBillNo='" + arriveDetailModel.arriveBillNo + "' and financeBillId='" + messList[i].Split(';')[1].ToString() + "' and financeBillLineNum='" + messList[i].Split(';')[2].ToString()+"'"); } isChecked = true; } else if (strResult.Split('&')[0] == "0") { this.BindGrid(); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"" + strResult.Split('&')[1] + "\");", true); return; } } if (isChecked) { this.BindGrid(); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"SAP入库成功!\");", true); } } catch (Exception error) { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"" + error.Message + "\");", true); } finally { services.Dispose(); } }
/// <summary> /// 排托单列表行事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { SCommBB commBB = new SCommBB(); try { GridViewRow gvRow = (e.CommandSource as LinkButton).NamingContainer as GridViewRow; string strArriveBillNo, strPalletIndex = ""; strArriveBillNo = this.GridView1.DataKeys[gvRow.RowIndex]["arriveBillNo"].ToString();//到货单号 strPalletIndex = this.GridView1.DataKeys[gvRow.RowIndex]["palletIndex"].ToString();//托盘序号 #region 重新排托 if (e.CommandName == "arrange") { //更改排托收货单状态为“01 收货中” commBB.ExecuteSql("update dbo.BArrangeBillFact set instantState='01' where arriveBillNo='" + strArriveBillNo + "' and palletIndex='" + strPalletIndex + "'"); //更改排托单明细状态为“02 排托中” commBB.ExecuteSql("update dbo.BArrangeBillDetail set instantState='02' where arriveBillNo='" + strArriveBillNo + "' and palletIndex='" + strPalletIndex + "'"); //更改排托单状态为“03 排托中” commBB.ExecuteSql("update dbo.BArrangeBill set instantState='03' where arriveBillNo='" + strArriveBillNo + "'"); //更改到货单状态为“04 排托中” commBB.ExecuteSql("update dbo.BArriveBill set instantState='04' where billNo='" + strArriveBillNo + "'"); return; } #endregion 重新排托 } finally { commBB.Dispose(); } }
public void updateBForkliftTask(string palletNo) { string str = "update BForkliftTask set isDeal='1' where palletNo ='" + palletNo + "'and isDeal='0'"; SCommBB commBB = new SCommBB(); commBB.ExecuteSql(str); commBB.Dispose(); }
/// <summary> /// 确认发货 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnConfirmSend_Click(object sender, EventArgs e) { bool isChecked = false; //获取选中的数据Id foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { isChecked = true; string id = this.grid.DataKeys[gvrow.RowIndex].Values["id"].ToString(); string stockUpbillNo = this.grid.DataKeys[gvrow.RowIndex].Values["stockUpBillNo"].ToString(); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"选择的备货单号是" + stockUpbillNo + "!\");", true); string command = "select distinct palletNo,wareNo,wareLocatorNo from BArrangeBillBox where stockUpBillNo = '" + stockUpbillNo + "' and isnull(palletNo,'')<>''";//获取订单下的托盘号码 2015-06-25增加限制条件 排除生成空托盘的时候的bug SCommBB bb = new SCommBB(); DataTable dt = bb.Query(command).Tables[0]; bb.Dispose(); BForkliftTaskBC bforkTaskBC = new BForkliftTaskBC(); for (int i = 0; i < dt.Rows.Count; i++) { bforkTaskBC.SaveForkliftTask(dt.Rows[i][0].ToString(), "CKQ", "CKQ01", "20", this.currentUser.empId); } SCommBB commBB = new SCommBB(); string strSql = "update dbo.CStockUpDetail set instantState='04' where stockUpBillNO='" + stockUpbillNo + "'"; commBB.ExecuteSql(strSql); //将备货单属性改为09出库中 strSql = @"update dbo.CStockUpBill set instantState='09' where stockUpBillNo = '" + stockUpbillNo + "'"; commBB.ExecuteSql(strSql); //实时获取订单状态 //using (CStockUpBillBB billBB = new CStockUpBillBB()) //{ // CStockUpBillData data = billBB.GetModel(Convert.ToInt32(id)); // data.instantState = "11";//状态更改为“确认发货” // billBB.ModifyRecord(data); //} } } if (isChecked) { this.BindGrid(); return; } this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条记录!\");", true); return; }
public bool UpdateBarrangeBillBox(string boxNO, string palletNo) { SCommBB commBB = new SCommBB(); try { commBB.ExecuteSql("Update BarrangeBillBox set palletNo = '" + palletNo + "' where boxNo = '" + boxNO + "'"); return true; } catch { return false; } finally { commBB.Dispose(); } }
public void updateBArrangeBillDetail(string financeBillNo, string arriveBillNo, string palletIndex) { string sql = "update BArrangeBillDetail set instantState='05' where financeBillNo='" + financeBillNo + "' AND arriveBillNo ='" + arriveBillNo + "' and palletIndex='" + palletIndex + "'"; SCommBB commBB = new SCommBB(); commBB.ExecuteSql(sql); commBB.Dispose(); }
public void SaveTSArriveBox(int arriveDetailId, string strArriveBillNo, string strFinanceBillNo, string strMaterialNo, string strBoxNo, string strPalletNo, int factNum, int isrtEmpId, string strWareLocatorNo) { TSBarriveDetailBB arriveDetailBB = new TSBarriveDetailBB(); BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(); SCommBB commBB = new SCommBB(); try { TSBarriveDetailData arriveDetailModel = new TSBarriveDetailData(); BArrangeBillBoxData arrangeBillBoxModel = new BArrangeBillBoxData(); DataTable dtWareLocator = new DataTable(); //获取某库位信息 dtWareLocator = this.GetWareLocatorInfo(strWareLocatorNo); //获取到货单明细实例 arriveDetailModel = arriveDetailBB.GetModel(arriveDetailId); arrangeBillBoxModel.arriveBillNo = strArriveBillNo;//到货单号 arrangeBillBoxModel.financeBillNo = strFinanceBillNo;//采购单号 //arrangeBillBoxModel.financeBillId = arriveDetailModel.financeBillId;//采购订单ID //arrangeBillBoxModel.financeBillLineNum = arriveDetailModel.financeBillLineNum;//采购订单行号 arrangeBillBoxModel.materialNo = strMaterialNo;//物料号 arrangeBillBoxModel.boxNo = strBoxNo;//箱号 arrangeBillBoxModel.palletNo = strPalletNo;//托盘号 arrangeBillBoxModel.wareNo = dtWareLocator.Rows[0]["wareNo"].ToString();//库区 arrangeBillBoxModel.wareLocatorNo = strWareLocatorNo;//库位 arrangeBillBoxModel.isBoxArrange = false;//箱子是否已经排托 arrangeBillBoxModel.isPalletUsing = false;//托盘是否占用 arrangeBillBoxModel.acceptEmpId = isrtEmpId;//收货人 arrangeBillBoxModel.acceptDt = System.DateTime.Now.ToString();//收货时间 arrangeBillBoxModel.factNum = factNum;//收货数量 arrangeBillBoxBB.AddRecord(arrangeBillBoxModel); //锁定库位 commBB.ExecuteSql("update dbo.LWareLocator set isUsing=1 where wareLocatorNo='" + strWareLocatorNo + "'"); } finally { arriveDetailBB.Dispose(); arrangeBillBoxBB.Dispose(); commBB.Dispose(); } }
public void FinishTSArriveDetail(int arriveDetailId) { BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); SCommBB commBB = new SCommBB(); try { BArriveDetailData arriveDetailModel = new BArriveDetailData(); object obj = null; string strArriveBillNo = "", strFinanceBillNo = "", strMaterialNo = ""; arriveDetailModel = arriveDetailBB.GetModel(arriveDetailId); arriveDetailModel.isFinishReceive = true;//收货完成 arriveDetailBB.ModifyRecord(arriveDetailModel); //更改到货单明细的排托数量 strArriveBillNo = arriveDetailModel.arriveBillNo; strFinanceBillNo = arriveDetailModel.financeBillNo; strMaterialNo = arriveDetailModel.materialNo; obj = commBB.ExecuteScalar("select count(1) from dbo.BArrangeBillBox where arriveBillNo='" + strArriveBillNo + "' and financeBillNo='" + strFinanceBillNo + "' and materialNo='" + strMaterialNo + "'"); if (obj != null) { commBB.ExecuteSql("update dbo.BarriveDetail set boxNum=" + obj.ToString() + " where id=" + arriveDetailId.ToString()); } } finally { arriveDetailBB.Dispose(); commBB.Dispose(); } }
public string SAPInStock(int arriveDetailId, int financeBillId, int financeBillLineNum, string strMaterialNo, double num, DateTime stockDt, DateTime arriveDt, string custNo, string custNm) { SapOnlineService.SapOnlineService sapService = new SapOnlineService.SapOnlineService(); SCommBB commBB = new SCommBB(); BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); try { SapOnlineService.POR1[] list = null; SapOnlineService.POR1 por1 = new SapOnlineService.POR1(); BArriveDetailData arriveDetailModel = new BArriveDetailData(); string strResult = ""; //SAP入库 //需要传递:采购订单号、行号、物料号、数量 list = new SapOnlineService.POR1[1]; por1.DocEntry = financeBillId;//采购订单号 por1.LineNum = financeBillLineNum;//采购订单行号 por1.ItemCode = strMaterialNo;//物料编号 por1.Quantity = num;//数量 list[0] = por1; strResult = sapService.Web_AddPDN_For_POR1(custNo, custNm, stockDt, "由WMS同步", stockDt, "由WMS同步", stockDt, list); // strResult = sapService.Web_AddPDN_For_POR1(por1.DocEntry, stockDt, "从仓库系统生成", arriveDt, list); if (strResult.Split('&')[0] == "1") { //更改到货中间表数据 arriveDetailModel = arriveDetailBB.GetModel(arriveDetailId); arriveDetailModel.isSapInStock = true;//是否已提交SAP入库 arriveDetailBB.ModifyRecord(arriveDetailModel); //更改物料箱的“是否已提交SAP入库”状态 commBB.ExecuteSql(@"update dbo.BArrangeBillBox set isSapInStock=1 where isSapInStock=0 and inStockDt is not null and arriveBillNo='" + arriveDetailModel.arriveBillNo + "' and financeBillId='" + financeBillId + "' and financeBillLineNum='" + financeBillLineNum + "' and materialNo='" + strMaterialNo + "'"); } return strResult; } finally { sapService.Dispose(); arriveDetailBB.Dispose(); commBB.Dispose(); } }
public bool InsertBoxNameInfo(string FinanceBillNo, string ArriveBillNo, string MaterialNo, string BoxQty, string materialNm_CH, string InsertEmpId) { //insert into InsertBoxQty(FinanceBillNo,ArriveBillNo,MaterialNo,BoxQty,materialNm_CH,InsertEmpId,InsertDt) //VALUES('123','22','DDD','100',‘#20A内盒’,'1',GETDATE()) string command = "insert into InsertBoxQty(FinanceBillNo,ArriveBillNo,MaterialNo,BoxQty,materialNm_CH,InsertEmpId,InsertDt) VALUES('" + FinanceBillNo + "','" + ArriveBillNo + "','" + MaterialNo + "','" + BoxQty + "','" + materialNm_CH + "','" + InsertEmpId + "',GETDATE())"; bool ret = false; SCommBB commBB = new SCommBB(); try { commBB.ExecuteSql(command); ret = true; } catch { ret = false; } finally { commBB.Dispose(); } return ret; }
public bool UpdateBoxInfo(string BBbackBillNo) { bool ret = false; string command = @"Update BArrangeBillBox set wareLocatorNo = '',wareNo = '',preWareLocatorNo = 'N01.01',preWareNo = 'YCQ',oldPalletNo = palletNo,palletNo = '' where boxNo in (select boxNo from BBackDetail where backBillNo = '" + BBbackBillNo + "')"; SCommBB commBB = new SCommBB(); try { commBB.ExecuteSql(command); ret = true; } catch { ret = false; } commBB.Dispose(); return ret; }
/// <summary> /// 提交按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnCommit_Click(object sender, EventArgs e) { DMWJEXECUTE services = new DMWJEXECUTE(); IList<string> messList = new List<string>(); messList.Clear(); try { bool isChecked = false; //获取选中的数据Id foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { int financeBillId = 0, financeBillLineNum = 0; string strMaterialNo = "", custNo = "", custNm = ""; string financeBillNo = ""; DateTime stockDt, arriveDt; double num = 0; string SAPDocEntry = ""; string arrivebillNO = ""; //financeBillId = Convert.ToInt32(this.grid.DataKeys[gvrow.RowIndex]["financeBillId"]); financeBillLineNum = Convert.ToInt32(this.grid.DataKeys[gvrow.RowIndex]["financeBillLineNum"]); arrivebillNO = this.grid.DataKeys[gvrow.RowIndex]["arriveBillNo"].ToString(); financeBillNo = this.grid.DataKeys[gvrow.RowIndex]["financeBillNo"].ToString(); SAPDocEntry = arrivebillNO.Remove(0, 2); strMaterialNo = this.grid.DataKeys[gvrow.RowIndex]["materialNo"].ToString(); num = Convert.ToDouble(this.grid.DataKeys[gvrow.RowIndex]["num"]); stockDt = Convert.ToDateTime(this.grid.DataKeys[gvrow.RowIndex]["stockDt"]); arriveDt = Convert.ToDateTime(this.grid.DataKeys[gvrow.RowIndex]["arriveDt"]); custNo = this.grid.DataKeys[gvrow.RowIndex]["custNo"].ToString(); custNm = this.grid.DataKeys[gvrow.RowIndex]["custNm"].ToString(); SapOnlineService.SapOnlineService sapService = new SapOnlineService.SapOnlineService(); string strResult = sapService.IGN1_Web_Add_From_WMS(Convert.ToDateTime(stockDt), financeBillNo, int.Parse(SAPDocEntry), strMaterialNo, num, "01"); int id = Convert.ToInt32(chkId.ValidationGroup); if (strResult.Split('&')[0] == "1") { BArriveDetailData arriveDetailModel = new BArriveDetailData(); BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); SCommBB commBB = new SCommBB(); arriveDetailModel = arriveDetailBB.GetModel(id); arriveDetailModel.isSapInStock = true;//是否已提交SAP入库 arriveDetailBB.ModifyRecord(arriveDetailModel); //更改物料箱的“是否已提交SAP入库”状态 commBB.ExecuteSql(@"update dbo.BArrangeBillBox set isSapInStock=1 where isSapInStock=0 and inStockDt is not null and arriveBillNo='" + arriveDetailModel.arriveBillNo + "' and financeBillLineNum='" + financeBillLineNum + "' and materialNo='" +strMaterialNo + "'" + " or oldMaterialNo ='" +strMaterialNo+ "'" + " and isSapInStock=0 and inStockDt is not null and arriveBillNo='" + arriveDetailModel.arriveBillNo + "'and financeBillLineNum='" + financeBillLineNum + "'"); isChecked = true; } else if (strResult.Split('&')[0] == "0") { this.BindGrid(); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"" + strResult.Split('&')[1] + "\");", true); return; } } if (isChecked) { this.BindGrid(); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"SAP入库成功!\");", true); } } } catch (Exception error) { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"" + error.Message + "\");", true); } finally { services.Dispose(); } }
public bool UpdateCheck(string checkNo) { SCommBB commBB = new SCommBB(); bool ret = false; try { commBB.ExecuteSql(@"exec [dbo].[pro_UpdateCheck] '" + checkNo + "'"); ret = true; } catch { ret = false; } finally { commBB.Dispose(); } return ret; }
protected void btnSave_Click(object sender, EventArgs e) { PRolePermissionsData rolePermissionsData = new PRolePermissionsData(); SCommBB commBB = new SCommBB(); PRolePermissionsBB rolePermissionsBB = new PRolePermissionsBB(); try { //删除当前角色所有权限 rolePermissionsBB.DeleteRecordByRole(this.RoleId, 2); //保存权限 string strPermissions = ""; CheckBox checkBox = new CheckBox(); foreach (DataListItem item in this.DataList1.Items) { //获取ItemoNo Label label = (Label)item.FindControl("itemNo"); string itemNo = label.Text; if (itemNo.IndexOf('-') >= 0) { itemNo = itemNo.Substring(itemNo.LastIndexOf('-') + 1); } foreach (System.Web.UI.Control control in item.Controls) { if (control.GetType() == checkBox.GetType()) { if (((CheckBox)control).Checked == true) { strPermissions += itemNo + "," + ((CheckBox)control).ToolTip + ",0|"; } } } } //保存权限 commBB.ExecuteSql("exec sys_BatchSavePermissions " + this.RoleId.ToString() + ",'" + strPermissions.Remove(strPermissions.Length - 1) + "'"); } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { commBB.Dispose(); rolePermissionsBB.Dispose(); } this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('保存成功!');", true); }
public bool UpdateCheckBil(int checkBillId, int empId, string instantState, string checkResult, string checkmark, string checkDt, string arriveBillNo, string materialNo, string finaceBillNO) { //第一步 更新BcheckBill BCheckBillBB checkBillBB = new BCheckBillBB(); SCommBB commBB = new SCommBB(); HS.Model.BCheckBillData data = checkBillBB.GetModel(Convert.ToInt32(checkBillId)); try { if (data.instantState == "04") { data.instantState = instantState;//05是合格 06是不合格 data.checkMark = checkmark; data.checkDt = DateTime.Now.ToString(); data.checkEmpId = empId; data.checkResult = checkResult;//直接是合格或是不合格 if (checkBillBB.ModifyRecord(data)) { bool checkResultNew; if (checkResult == "合格") checkResultNew = true; else checkResultNew = false; //第二步 更新BarrangeBillBox //更改所有箱的判定结果 commBB.ExecuteSql("update dbo.BArrangeBillBox set checkResult='" + checkResultNew + "',checkResultDt='" + System.DateTime.Now.ToString() + "',checkResultEmpId='" + empId + "' where arriveBillNo='" + arriveBillNo + "' and financeBillNo='" + finaceBillNO + "' and materialNo='" + materialNo + "'"); } } return true; } catch { return false; } finally { checkBillBB.Dispose(); commBB.Dispose(); } }
protected void Button2_Click(object sender, EventArgs e) { foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { string str = "update BArriveBill set instantState='06' where id ='" + this.grid.DataKeys[gvrow.RowIndex]["id"].ToString() + "'"; SCommBB commBB = new SCommBB(); commBB.ExecuteSql(str); } } this.BindGrid(); }
/// <summary> /// 取消检测判定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUnSubmit_Click(object sender, EventArgs e) { SCommBB commBB = new SCommBB(); BCheckBillBB checkBillBB = new BCheckBillBB(); try { bool isChecked = false; foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { string strArriveBillNo = "", strFinanceBillNo = "", strMaterialNo = ""; strArriveBillNo = this.grid.DataKeys[gvrow.RowIndex]["arriveBillNo"].ToString(); strFinanceBillNo = this.grid.DataKeys[gvrow.RowIndex]["financeBillNo"].ToString(); strMaterialNo = this.grid.DataKeys[gvrow.RowIndex]["materialNo"].ToString(); //更改检测单 BCheckBillData checkBillModel = checkBillBB.GetModel(Convert.ToInt32(chkId.ValidationGroup)); if (checkBillModel.instantState != "05" && checkBillModel.instantState != "06") { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前检测单未检测判定!\");", true); return; } isChecked = true; commBB.ExecuteSql("update dbo.BCheckBill set checkResult=null,checkEmpId=0,checkDt=null,instantState='04' where id=" + chkId.ValidationGroup); //更改箱检测结果 commBB.ExecuteSql("update dbo.BArrangeBillBox set checkResult=0,checkResultDt=null,checkResultEmpId=0 where arriveBillNo='" + strArriveBillNo + "' and financeBillNo='" + strFinanceBillNo + "' and materialNo='" + strMaterialNo + "'"); } } if (isChecked) { this.BindGrid(); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条记录!\");", true); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { commBB.Dispose(); checkBillBB.Dispose(); } }
/// <summary> /// 保存判断结果 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveRet_click(object sender, EventArgs e) { BCheckBillBB checkBillBB = new BCheckBillBB(); SCommBB commBB = new SCommBB(); try { HS.Model.BCheckBillData data = checkBillBB.GetModel(Convert.ToInt32(this.IdValue)); if (data.instantState == "04") { data.instantState = this.rdopass.Checked ? "05" : "06";//05 合格 06不合格 data.checkMark = this.txtMark.Text; data.checkDt = DateTime.Now.ToString(); data.checkEmpId = this.currentUser.empId; data.checkResult = this.rdopass.Checked ? "合格" : "不合格"; if (checkBillBB.ModifyRecord(data)) { bool checkResult = rdopass.Checked ? true : false; //更改所有箱的判定结果 commBB.ExecuteSql("update dbo.BArrangeBillBox set checkResult='" + checkResult + "',checkResultDt='" + System.DateTime.Now.ToString() + "',checkResultEmpId='" + this.currentUser.empId + "' where arriveBillNo='" + Request.QueryString["ano"] + "' and financeBillNo='" + Request.QueryString["fno"] + "' and materialNo='" + Request.QueryString["mno"] + "'"); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"检测单判定录入成功!\");location.replace('BCheckBillListResult.aspx?itemNo=0402&pTypeNo=main');", true); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"检测单判定录入失败!\");", true); } } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前检测单已经判定完成!\");", true); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { checkBillBB.Dispose(); commBB.Dispose(); } }
public string GetSuggestWareLocator_ForkliftTask(int forkliftTaskId) { string strSuggestWareLocator = ""; BForkliftTaskBB forkliftTaskBB = new BForkliftTaskBB(); LWareLocatorBB wareLocatorBB = new LWareLocatorBB(); SCommBB commBB = new SCommBB(); LWareLocatorRelationBB wareLocatorRelation = new LWareLocatorRelationBB(); try { vBForkliftTaskData vForkliftTaskModel = new vBForkliftTaskData(); BForkliftTaskData forkliftTaskModel = new BForkliftTaskData(); DataTable dtWareLocator = new DataTable(); //获取叉车任务实例 forkliftTaskModel = forkliftTaskBB.GetModel(forkliftTaskId); vForkliftTaskModel = forkliftTaskBB.GetVModel(forkliftTaskId); if (forkliftTaskModel.taskType == "01" || forkliftTaskModel.taskType == "04" || forkliftTaskModel.taskType == "10") { #region 01 从排托区到质检区、04 从理货区返回质检区、10 从收货区到质检区 //获取没有使用的质检区的所有库位 //2015-08-04 修改增加相应的对应关系 与表LwareLocator之间产生关系 if (!string.IsNullOrEmpty(forkliftTaskModel.nextLocatorNo))//已有目的库位 { strSuggestWareLocator = vForkliftTaskModel.nextWareNo + "," + vForkliftTaskModel.nextWareNm + "," + vForkliftTaskModel.nextLocatorNo + "," + vForkliftTaskModel.nextWareLocatorNm; } else//没有目的库位 { //只有原来的库区是在收货区的时候 才进行处理 //if (vForkliftTaskModel.preWareNo == "SHQ") //{ // //首先是查找出所有的可以进行入库的库位 // DataTable dtNew = new DataTable(); // if (vForkliftTaskModel.preLocatorNo.Contains("SH")) // dtNew = wareLocatorRelation.GetList("wareLocatorStartPrefix = 'SH' and isdel = 0").Tables[0]; // else // dtNew = wareLocatorRelation.GetList("wareLocatorStartPrefix = 'S' and isdel = 0").Tables[0]; // for (int i = 0; i < dtNew.Rows.Count; i++) // { // //2015-08-04 数据库实现后发现只能通过程序来进行实现 // dtWareLocator = wareLocatorBB.GetVList("wareType='01' and isUsing=0 and isDel=0 and wareLocatorNo like '" + dtNew.Rows[i]["wareLocatorEndPrefix"] + "%'").Tables[0]; // if(dtWareLocator.Rows.Count>0) // { // break;//如果大于0的话则进行退出操作 // } // } // // dtWareLocator = wareLocatorBB.GetVList("wareType='01' and isUsing=0 and isDel=0").Tables[0]; //} //else //{ //首先要通过叉车能够获取获取托盘上此时有的信息 string palletNO = vForkliftTaskModel.palletNo; DataTable dtPallet = GetBoxByPalletNo(palletNO); string checkMaterial = ""; if (dtPallet != null) { if (dtPallet.Rows.Count > 0 && dtPallet.Rows[0]["materialNO"] != "") { checkMaterial = dtPallet.Rows[0]["materialNO"].ToString(); } } //dtWareLocator = wareLocatorBB.GetVList("wareType='01' and isUsing=0 and isDel=0").Tables[0]; dtWareLocator = wareLocatorBB.GetVListJoey(checkMaterial).Tables[0]; //} if (dtWareLocator.Rows.Count > 0) { //获取推荐库位信息 strSuggestWareLocator = dtWareLocator.Rows[0]["wareNo"].ToString() + "," + dtWareLocator.Rows[0]["wareNm"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNm"].ToString(); //更改叉车任务的目的库位信息 forkliftTaskModel.nextWareNo = dtWareLocator.Rows[0]["wareNo"].ToString();//目的库区 forkliftTaskModel.nextLocatorNo = dtWareLocator.Rows[0]["wareLocatorNo"].ToString();//目的库位 forkliftTaskBB.ModifyRecord(forkliftTaskModel); //更改目的库位的使用状态 commBB.ExecuteSql("update dbo.LWareLocator set isUsing=1 where wareLocatorNo='" + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "'"); } } #endregion 01 从排托区到质检区、04 从理货区返回质检区、10 从收货区到质检区 } else if (forkliftTaskModel.taskType == "08" || forkliftTaskModel.taskType == "02" || forkliftTaskModel.taskType == "03" || forkliftTaskModel.taskType == "05" || forkliftTaskModel.taskType == "06" || forkliftTaskModel.taskType == "11" || forkliftTaskModel.taskType == "12") { #region 08 从收货区到收货排托区,02 从质检区到理货区,03 从理货区到正式库区,05 从正式库区到拣货区,06 从拣货区返回正式库区,11 从质检区到正式区,12 托盘移库 strSuggestWareLocator = vForkliftTaskModel.nextWareNo + "," + vForkliftTaskModel.nextWareNm + "," + vForkliftTaskModel.nextLocatorNo + "," + vForkliftTaskModel.nextWareLocatorNm; #endregion 08 从收货区到收货排托区,02 从质检区到理货区,03 从理货区到正式库区,05 从正式库区到拣货区,06 从拣货区返回正式库区,11 从质检区到正式区,12 托盘移库 } else if (forkliftTaskModel.taskType == "07") { #region 07 拣货区发货 strSuggestWareLocator = ",发货区,,发货区"; #endregion 07 拣货区发货 } else if (forkliftTaskModel.taskType == "09") { #region 09 从收货排托区返回收货区 if (!string.IsNullOrEmpty(forkliftTaskModel.nextLocatorNo))//已有目的库位 { strSuggestWareLocator = vForkliftTaskModel.nextWareNo + "," + vForkliftTaskModel.nextWareNm + "," + vForkliftTaskModel.nextLocatorNo + "," + vForkliftTaskModel.nextWareLocatorNm; } else { //获取收货区的所有库位 dtWareLocator = wareLocatorBB.GetVList("wareType='05' and isUsing=0").Tables[0]; if (dtWareLocator.Rows.Count > 0) { strSuggestWareLocator = dtWareLocator.Rows[0]["wareNo"].ToString() + "," + dtWareLocator.Rows[0]["wareNm"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNm"].ToString(); //更改叉车任务的目的库位信息 forkliftTaskModel.nextWareNo = dtWareLocator.Rows[0]["wareNo"].ToString();//目的库区 forkliftTaskModel.nextLocatorNo = dtWareLocator.Rows[0]["wareLocatorNo"].ToString();//目的库位 forkliftTaskBB.ModifyRecord(forkliftTaskModel); //更改目的库位的使用状态 commBB.ExecuteSql("update dbo.LWareLocator set isUsing=1 where wareLocatorNo='" + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "'"); } } #endregion 09 从收货排托区返回收货区 } else if (forkliftTaskModel.taskType == "13" || forkliftTaskModel.taskType == "30") { #region 13 从理货区到异常区 //获取没有使用的异常区的所有库位 //if (!string.IsNullOrEmpty(forkliftTaskModel.nextLocatorNo))//已有目的库位 //{ // strSuggestWareLocator = vForkliftTaskModel.nextWareNo // + "," + vForkliftTaskModel.nextWareNm // + "," + vForkliftTaskModel.nextLocatorNo // + "," + vForkliftTaskModel.nextWareLocatorNm; //} //else //{ //} //dtWareLocator = wareLocatorBB.GetVList("wareType='09' and isUsing=0 and isDel=0").Tables[0]; dtWareLocator = wareLocatorBB.GetVList("wareType='09' and isDel=0").Tables[0];//临时不限制是否正在使用 if (dtWareLocator.Rows.Count > 0) { //获取推荐库位信息 strSuggestWareLocator = dtWareLocator.Rows[0]["wareNo"].ToString() + "," + dtWareLocator.Rows[0]["wareNm"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNm"].ToString(); //更改叉车任务的目的库位信息 forkliftTaskModel.nextWareNo = dtWareLocator.Rows[0]["wareNo"].ToString();//目的库区 forkliftTaskModel.nextLocatorNo = dtWareLocator.Rows[0]["wareLocatorNo"].ToString();//目的库位 forkliftTaskBB.ModifyRecord(forkliftTaskModel); ////更改目的库位的使用状态 //commBB.ExecuteSql("update dbo.LWareLocator set isUsing=1 where wareLocatorNo='" // + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "'"); } #endregion 13 从理货区到异常区 } else if (forkliftTaskModel.taskType == "14") { #region 14 从拣货区到打托区 if (!string.IsNullOrEmpty(forkliftTaskModel.nextLocatorNo))//已有目的库位 { strSuggestWareLocator = vForkliftTaskModel.nextWareNo + "," + vForkliftTaskModel.nextWareNm + "," + vForkliftTaskModel.nextLocatorNo + "," + vForkliftTaskModel.nextWareLocatorNm; } else { //获取打托区的所有库位 dtWareLocator = wareLocatorBB.GetVList("wareType='10' and isUsing=0 and isDel=0").Tables[0]; if (dtWareLocator.Rows.Count > 0) { strSuggestWareLocator = dtWareLocator.Rows[0]["wareNo"].ToString() + "," + dtWareLocator.Rows[0]["wareNm"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNm"].ToString(); //更改叉车任务的目的库位信息 forkliftTaskModel.nextWareNo = dtWareLocator.Rows[0]["wareNo"].ToString();//目的库区 forkliftTaskModel.nextLocatorNo = dtWareLocator.Rows[0]["wareLocatorNo"].ToString();//目的库位 forkliftTaskBB.ModifyRecord(forkliftTaskModel); //更改目的库位的使用状态 //日期 2014-07-22 将打托区占用取消掉 打托区当中可以有多个被占用 //commBB.ExecuteSql("update dbo.LWareLocator set isUsing=1 where wareLocatorNo='" // + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "'"); } } #endregion 14 从拣货区到打托区 } else if (forkliftTaskModel.taskType == "15") { #region 15 从打托区到发货区 if (!string.IsNullOrEmpty(forkliftTaskModel.nextLocatorNo))//已有目的库位 { strSuggestWareLocator = vForkliftTaskModel.nextWareNo + "," + vForkliftTaskModel.nextWareNm + "," + vForkliftTaskModel.nextLocatorNo + "," + vForkliftTaskModel.nextWareLocatorNm; } else { //获取发货区的所有库位 dtWareLocator = wareLocatorBB.GetVList("wareType='08' and isUsing=0 and isDel=0").Tables[0]; if (dtWareLocator.Rows.Count > 0) { strSuggestWareLocator = dtWareLocator.Rows[0]["wareNo"].ToString() + "," + dtWareLocator.Rows[0]["wareNm"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNm"].ToString(); //更改叉车任务的目的库位信息 forkliftTaskModel.nextWareNo = dtWareLocator.Rows[0]["wareNo"].ToString();//目的库区 forkliftTaskModel.nextLocatorNo = dtWareLocator.Rows[0]["wareLocatorNo"].ToString();//目的库位 forkliftTaskBB.ModifyRecord(forkliftTaskModel); //更改目的库位的使用状态 commBB.ExecuteSql("update dbo.LWareLocator set isUsing=1 where wareLocatorNo='" + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "'"); } } #endregion 15 从打托区到发货区 } else if (forkliftTaskModel.taskType == "20") { #region 20的时候 正式出库 if (!string.IsNullOrEmpty(forkliftTaskModel.nextLocatorNo))//已有目的库位 { strSuggestWareLocator = vForkliftTaskModel.nextWareNo + "," + vForkliftTaskModel.nextWareNm + "," + vForkliftTaskModel.nextLocatorNo + "," + vForkliftTaskModel.nextWareLocatorNm; } else { //获取发货区的所有库位 dtWareLocator = wareLocatorBB.GetVList("wareType='11' and isUsing=0 and isDel=0").Tables[0]; if (dtWareLocator.Rows.Count > 0) { strSuggestWareLocator = dtWareLocator.Rows[0]["wareNo"].ToString() + "," + dtWareLocator.Rows[0]["wareNm"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNm"].ToString(); //更改叉车任务的目的库位信息 forkliftTaskModel.nextWareNo = dtWareLocator.Rows[0]["wareNo"].ToString();//目的库区 forkliftTaskModel.nextLocatorNo = dtWareLocator.Rows[0]["wareLocatorNo"].ToString();//目的库位 forkliftTaskBB.ModifyRecord(forkliftTaskModel); //更改目的库位的使用状态 //commBB.ExecuteSql("update dbo.LWareLocator set isUsing=1 where wareLocatorNo='" // + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "'"); } } #endregion 20 正式库区发货 } else if (forkliftTaskModel.taskType == "30") { //2015-08-07进行修改 #region 退货区生成叉车任务获取相应的库位 dtWareLocator = wareLocatorBB.GetVList("wareType='09' and isUsing=0 and isDel=0 and wareNO = 'YCQ'").Tables[0]; if (dtWareLocator.Rows.Count > 0) { strSuggestWareLocator = dtWareLocator.Rows[0]["wareNo"].ToString() + "," + dtWareLocator.Rows[0]["wareNm"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "," + dtWareLocator.Rows[0]["wareLocatorNm"].ToString(); //更改叉车任务的目的库位信息 forkliftTaskModel.nextWareNo = dtWareLocator.Rows[0]["wareNo"].ToString();//目的库区 forkliftTaskModel.nextLocatorNo = dtWareLocator.Rows[0]["wareLocatorNo"].ToString();//目的库位 forkliftTaskBB.ModifyRecord(forkliftTaskModel); #endregion } } } finally { forkliftTaskBB.Dispose(); wareLocatorBB.Dispose(); commBB.Dispose(); } return strSuggestWareLocator; }
public bool UpdateCheckBillState(string checkBillId) { SCommBB commBB = new SCommBB(); try { commBB.ExecuteSql("Update BCheckBill set instantState = '04' where id = '" + checkBillId + "'"); return true; } catch { return false; } finally { commBB.Dispose(); } }
public bool InsertSAPNOBoxNO(string FinanceBillNo, string ArriveBillNo, string MaterialNo, int BoxQty, int InsertEmpId) { SCommBB commBB = new SCommBB(); bool ret = false; string command = @"insert into InsertBoxQty(FinanceBillNo,ArriveBillNo,MaterialNo,BoxQty,InsertEmpId,InsertDt) VALUES('" + FinanceBillNo + "','" + ArriveBillNo + "','" + MaterialNo + "'," + BoxQty + "," + InsertEmpId + ",GETDATE())"; try { commBB.ExecuteSql(command); ret = true; } catch { ret = false; } finally { commBB.Dispose(); } return ret; }
/// <summary> /// 保存分配线体 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_GZT_Click(object sender, EventArgs e) { SCommBB commBB = new SCommBB(); try { if (this.ddlWareLocator.SelectedValue == "") { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('请首先选择分配线体!');", true); return; } foreach (GridViewRow gvrow in this.gridStockUpDetail.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { string strPalletIndex = this.gridStockUpDetail.DataKeys[gvrow.RowIndex].Values["palletIndex"].ToString(); commBB.ExecuteSql("update dbo.CStockUpDetail set GZT='" + this.ddlWareLocator.SelectedValue + "' where stockUpBillNo='" + this.stockUpBillNo.Text.Trim() + "' and palletIndex='" + strPalletIndex + "'"); } } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { commBB.Dispose(); } }
public bool UpdateCheckDetailMaterial(string checkNo, string wareLocatorNo,string material) { SCommBB commBB = new SCommBB(); bool ret = false; try { commBB.ExecuteSql(@" exec [pro_UpdateCheckDetailMaterial] '" + checkNo + "','" + wareLocatorNo + "','" + material+"'"); ret = true; } catch { ret = false; } finally { commBB.Dispose(); } return ret; }