/// <summary> /// 生成排拖单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnPaiFact_Click(object sender, EventArgs e) { //获取选中的数据Id foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { string strBillNo = "", strCustNm = "", strArriveDt = "", strSate = ""; strBillNo = chkId.ValidationGroup; strCustNm = this.grid.DataKeys[gvrow.RowIndex].Values["custNm"].ToString(); strArriveDt = this.grid.DataKeys[gvrow.RowIndex].Values["arriveDt"].ToString(); //实时获取订单状态 using (BArriveBillBB billBB = new BArriveBillBB()) { DataSet ds = billBB.GetVList(" billNo='" + strBillNo + "'"); if (ds.Tables[0].Rows.Count > 0) { strSate = ds.Tables[0].Rows[0]["instantState"].ToString(); } } //判断到货单明细是否全部完成 using (BArriveDetailBB arriveDetailBB = new BArriveDetailBB()) { DataTable dtArriveDetail = arriveDetailBB.GetList("arriveBillNo='" + strBillNo + "'").Tables[0]; foreach (DataRow row in dtArriveDetail.Rows) { if (Convert.ToBoolean(row["isFinishReceive"]) == false) { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前到货单未收货完成!\");", true); return; } } } if (strSate != "03" && strSate != "04" && strSate != "05") { Response.Redirect("../BArriveDetail/BArriveDetailList.aspx?billNo=" + strBillNo + "&custnm=" + Server.UrlEncode(strCustNm) + "&arriveDt=" + Server.UrlEncode(strArriveDt) + "&itemNo=" + this.itemNo + "&pTypeNo=edit", false); return; } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"订单流程已提交或已收货状态,不能修改信息!\");", true); return; } } } this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条记录!\");", true); return; }
/// <summary> /// 绑定到货物料明细表 /// </summary> protected void BindMateriel() { using (BArriveDetailBB arriveDetailBB = new BArriveDetailBB()) { string strWhere = " isFinishReceive=1"; DataSet ds = new DataSet(); //到货单号 if (this.txtA.Text.Trim() != "") { strWhere += " and arriveBillNo like '%" + this.txtA.Text.Replace("'", "''") + "%' "; } //采购单号 if (this.txtB.Text.Trim() != "") { strWhere += " and financeBillNo like '%" + this.txtB.Text.Replace("'", "''") + "%' "; } //物料 if (this.txtC.Text.Trim() != "") { strWhere += " and (materialNo like '%" + this.txtC.Text.Replace("'", "''") + "%' or materialDesc like '%" + this.txtC.Text.Replace("'", "''") + "%')"; } //必须是排托已完成的物料 //strWhere += " and exists (select 1 from dbo.BArriveBill where dbo.BArriveBill.instantState='05' and dbo.BArriveBill.billNo=dbo.vBArriveDetail.arriveBillNo)"; //必须尚未生成检验单的物料 strWhere += @" and not exists(select 1 from BCheckBill where BCheckBill.arriveBillNo=vBArriveDetail.arriveBillNo and BCheckBill.financeBillNo=vBArriveDetail.financeBillNo and BCheckBill.materialNo=vBArriveDetail.materialNo)"; //判定必须有收货并且有放置在质检区信息 strWhere += @" and exists(select 1 from dbo.vBArrangeBillBox as t where t.arriveBillNo=dbo.vBArriveDetail.arriveBillNo and t.financeBillNo=dbo.vBArriveDetail.financeBillNo and t.materialNo=dbo.vBArriveDetail.materialNo and t.wareType='01')"; //到货单物料所在库位类别为质检区 strWhere += @" and not exists(select 1 from dbo.vBArrangeBillBox as t where t.arriveBillNo=dbo.vBArriveDetail.arriveBillNo and t.financeBillNo=dbo.vBArriveDetail.financeBillNo and t.materialNo=dbo.vBArriveDetail.materialNo and t.wareType<>'01')"; ds = arriveDetailBB.GetVList(strWhere); this.grvMateriel.DataSource = ds.Tables[0]; this.grvMateriel.DataBind(); //赋值记录条数、页面总数 this.Label3.Text = ds.Tables[0].Rows.Count.ToString(); this.Label2.Text = this.grvMateriel.PageCount.ToString(); this.currPage.Text = (this.grvMateriel.PageIndex + 1).ToString(); } }
/// <summary> /// 到货单列表行事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grid_RowCommand(object sender, GridViewCommandEventArgs e) { BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); try { GridViewRow gvRow = (e.CommandSource as LinkButton).NamingContainer as GridViewRow; BArriveDetailData arriveDetailModel = new BArriveDetailData(); #region 重新收货 if (e.CommandName == "receive") { int id = Convert.ToInt32(this.grid.DataKeys[gvRow.RowIndex]["id"]); arriveDetailModel = arriveDetailBB.GetModel(id); arriveDetailModel.isFinishReceive = false;//收货未完成 arriveDetailBB.ModifyRecord(arriveDetailModel); return; } #endregion 重新收货 } finally { arriveDetailBB.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.StrWhere = "1=1"; string id= Request.QueryString["id"]; BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); BArriveBillBB arriveBillBB = new BArriveBillBB(); DataSet ds = new DataSet(); try { vBArriveBillData data = arriveBillBB.GetVModel(Convert.ToInt32(id)); this.IdValue = data.billNo; this.StrWhere = " arriveBillNo='" + data.billNo + "'"; txtBillNo.Text = data.billNo; txtSupple.Text = data.custNm; txtarrageBillNo.Text = "PT" + data.billNo; txtarriveDt.Text = Convert.ToDateTime(data.arriveDt).ToString("yyyy-MM-dd"); this.DtDetail = arriveDetailBB.GetVList(this.StrWhere).Tables[0]; } finally { arriveDetailBB.Dispose(); } this.BindGrid(); } InitPageData(); }
/// <summary> /// 初始化数据 /// </summary> private void InitData() { BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); BArrangeBillDetailBB arrangeBillDetailBB = new BArrangeBillDetailBB(); try { #region 生成到货明细数据源 //到货明细 this.DtDetail = arriveDetailBB.GetVList(" arriveBillNo='" + this.ArriveBillNo + "'").Tables[0]; #endregion 生成到货明细数据源 #region 生成排托明细数据源 //排托明细 string strWhere = "arriveBillNo=@arriveBillNo"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@arriveBillNo", this.ArriveBillNo) }; DataSet ds = arrangeBillDetailBB.GetVList(strWhere, param); if (ds != null && ds.Tables.Count > 0) { this.DtResult = ds.Tables[0]; this.DtResult.Columns.Add(new DataColumn("rowId", typeof(string))); this.DtResult.Columns.Add(new DataColumn("isdel", typeof(string))); this.DtResult.Columns.Add(new DataColumn("ischeck", typeof(string))); this.DtResult.Columns.Add(new DataColumn("hideAmount", typeof(string))); foreach (DataRow dr in this.DtResult.Rows) { dr["rowId"] = Guid.NewGuid().ToString(); dr["isdel"] = "0"; dr["ischeck"] = "false"; #region 记录合计行 if (dr["boxNum"] != null && dr["boxNum"] != DBNull.Value) { //初始化时保存amount的原始值 dr["hideAmount"] = dr["boxNum"].ToString() == "" ? "0" : dr["boxNum"].ToString(); } else { dr["hideAmount"] = "0"; } #endregion } } #endregion 生成排托明细数据源 } finally { arriveDetailBB.Dispose(); arrangeBillDetailBB.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> private void BindGrid() { //throw new NotImplementedException(); BArriveDetailBB saleBillBB = new BArriveDetailBB(); DataSet ds = new DataSet(); try { string strwhere = this.StrWhere; //销售订单编号 if (!string.IsNullOrEmpty(this.txtSaleBillNo.Text)) { strwhere += " and billNo like '%" + this.txtSaleBillNo.Text.Trim().Replace("'", "''").Trim() + "%'"; } //客户 if (!string.IsNullOrEmpty(this.txtMaterialNo.Text)) { strwhere += " and (MaterialNo like '%" + this.txtMaterialNo.Text.Replace("'", "''").Trim() + "%')"; } //订单状态 // ds = saleBillBB.GetVListChange(strwhere); ds = saleBillBB.GetVListChange(strwhere); this.grid.DataSource = ds.Tables[0]; this.grid.DataBind(); //赋值记录条数、页面总数 this.Label3.Text = ds.Tables[0].Rows.Count.ToString(); this.Label2.Text = this.grid.PageCount.ToString(); this.currPage.Text = (this.grid.PageIndex + 1).ToString(); } finally { saleBillBB.Dispose(); } }
/// <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 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 bool UpdateArriveDetailWeight(int arriveDetailId, double firstBoxSingleWeight) { BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); try { BArriveDetailData arriveDetailModel = new BArriveDetailData(); arriveDetailModel = arriveDetailBB.GetModel(arriveDetailId); arriveDetailModel.firstBoxSingleWeight = firstBoxSingleWeight; return arriveDetailBB.ModifyRecord(arriveDetailModel); } finally { arriveDetailBB.Dispose(); } }
public void SaveArriveBox(int arriveDetailId, string strArriveBillNo, string strFinanceBillNo, string strMaterialNo, string strBoxNo, string strPalletNo, int factNum, int isrtEmpId, string strWareLocatorNo) { BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(); SCommBB commBB = new SCommBB(); try { BArriveDetailData arriveDetailModel = new BArriveDetailData(); 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 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 DataTable GetArriveDetail(int arriveDetailId) { BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); try { DataTable dt = new DataTable(); dt = arriveDetailBB.GetVList("id=" + arriveDetailId.ToString()).Tables[0]; return dt; } finally { arriveDetailBB.Dispose(); } }
/// <summary> /// 提交排托单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnCommit_Click(object sender, EventArgs e) { BArriveDetailBB bb = new BArriveDetailBB(); try { //获取选中的数据Id foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { string strBillNo = ""; DataSet ds = new DataSet(); strBillNo = chkId.ValidationGroup; if (bb.ModifyRecordSC(strBillNo)) { this.BindGrid();//重新绑定到货单列表 return; } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"更改生产到货单状态失败!\");", true); return; } } } this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条记录!\");", true); return; } finally { bb.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.StrWhere = "1=1"; string id= Request.QueryString["id"]; BArriveDetailBB arriveDetailBB = new BArriveDetailBB(); TSBarrivebillBB arriveBillBB = new TSBarrivebillBB(); DataSet ds = new DataSet(); try { TSBarrivebillData data = arriveBillBB.GetModel(Convert.ToInt32(id)); this.IdValue = data.arriveBillNo; this.StrWhere = " arriveBillNo='" + data.arriveBillNo + "'"; txtBillNo.Text = data.arriveBillNo; this.DtDetail = arriveDetailBB.GetTSVList(this.StrWhere).Tables[0]; } finally { arriveDetailBB.Dispose(); } this.BindGrid(); } InitPageData(); }