Esempio n. 1
0
        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();
        }
Esempio n. 2
0
        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);
        }