public void BindData(DataSet inDataEnv, PdSer inMPdSer, int inParent, string inBranch, string inWHouse, string inWHLoca, string inLot) { //this.pnlWHouse.Visible = this.mbllIsGetWHouse; this.mPdSer = inMPdSer; this.mintParentID = inParent; this.dtsDataEnv = inDataEnv; this.mstrBranch = inBranch; this.mstrWHouse = inWHouse; this.txtLot.Text = inLot; this.txtFrQcWHouse.Tag = inWHouse; string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); pobjSQLUtil.SetPara(new object[1] { inWHouse }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QWHouse", "WHOUSE", "select fcCode, fcName from " + MapTable.Table.WHouse + " where fcSkid = ?", ref strErrorMsg)) { this.txtFrQcWHouse.Text = this.dtsDataEnv.Tables["QWHouse"].Rows[0]["fcCode"].ToString().TrimEnd(); this.txtFrQnWHouse.Text = this.dtsDataEnv.Tables["QWHouse"].Rows[0]["fcName"].ToString().TrimEnd(); } this.pmSetStkBal(); }
private void pmSetBrowView() { WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside); WS.Data.Agents.cDBMSAgent pobjSQLUtil2 = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); DataTable dtrBrowView = new DataTable(); dtrBrowView = PdSer.GetPdSerTable(pobjSQLUtil, pobjSQLUtil2, App.ActiveCorp.RowID, this.mstrBranchID, this.mstrProdID, this.mstrWHouse, ""); if (this.dtsDataEnv.Tables[this.mstrBrowViewAlias] != null) { this.dtsDataEnv.Tables.Remove(this.mstrBrowViewAlias); } this.dtsDataEnv.Tables.Add(dtrBrowView); }