C# (CSharp) Process.Dal.BillDal Examples

Example #1

File: StockInWorkQueryDialog.cs Project: radtek/HNXC_WCS

        private void StockInWorkQueryDialog_Load(object sender, EventArgs e)
        {
            this.dtpStartBillDate.Value = DateTime.Now;
            this.dtpEndBillDate.Value   = DateTime.Now;

            Process.Dal.BillDal dal = new Process.Dal.BillDal();

            dtBillType = dal.GetBillByType("1");

            cbBillType.DataSource = dtBillType;

            CigaretteFields.Add("CIGARETTE_CODE", "牌号编码");
            CigaretteFields.Add("CIGARETTE_NAME", "牌号名称");
            CigaretteFields.Add("CIGARETTE_MEMO", "牌号描述");

            FormulaFields.Add("FORMULA_CODE", "配方编码");
            FormulaFields.Add("FORMULA_NAME", "配方名称");
            FormulaFields.Add("CIGARETTE_CODE", "牌号编码");
            FormulaFields.Add("CIGARETTE_NAME", "牌号名称");
            FormulaFields.Add("BATCH_WEIGHT", "批次重量");
            FormulaFields.Add("USE_COUNT", "使用次数");

            dtCigarette = dal.GetCigarette();
            dtFormula   = dal.GetFormula();
        }

Example #2

File: StockInWorkQuery.cs Project: katway/HNXC_WCS

        private void dgvMain_CurrentCellChanged(object sender, EventArgs e)
        {
            if (this.dgvMain.CurrentRow != null)
            {
                string TaskID = this.dgvMain.Rows[this.dgvMain.CurrentRow.Index].Cells["colTaskID"].Value.ToString();

                Process.Dal.BillDal dal = new Process.Dal.BillDal();
                DataTable           dt  = dal.GetBillTaskDetail(TaskID);
                this.dgSub.DataSource = dt;
            }
        }

Example #3

File: StockInWorkQuery.cs Project: Guoyingbin/HNXC_WCS

        private void dgvMain_CurrentCellChanged(object sender, EventArgs e)
        {
            if (this.dgvMain.CurrentRow != null)
            {
                string TaskID = this.dgvMain.Rows[this.dgvMain.CurrentRow.Index].Cells["colTaskID"].Value.ToString();

                Process.Dal.BillDal dal = new Process.Dal.BillDal();
                DataTable dt = dal.GetBillTaskDetail(TaskID);
                this.dgSub.DataSource = dt;
            }
        }

Example #4

File: StockInWorkQuery.cs Project: Guoyingbin/HNXC_WCS

        private void btnRefresh_Click(object sender, EventArgs e)
        {
            StockInWorkQueryDialog frm = new StockInWorkQueryDialog();
            if (frm.ShowDialog() == DialogResult.OK)
            {
                string strWhere = frm.strWhere;

                Process.Dal.BillDal dal = new Process.Dal.BillDal();
                DataTable dt = dal.GetBillInTask(strWhere);
                bsMain.DataSource = dt;
            }
        }

Example #5

File: StockInWorkQuery.cs Project: katway/HNXC_WCS

        private void btnRefresh_Click(object sender, EventArgs e)
        {
            StockInWorkQueryDialog frm = new StockInWorkQueryDialog();

            if (frm.ShowDialog() == DialogResult.OK)
            {
                string strWhere = frm.strWhere;

                Process.Dal.BillDal dal = new Process.Dal.BillDal();
                DataTable           dt  = dal.GetBillInTask(strWhere);
                bsMain.DataSource = dt;
            }
        }

Example #6

File: StockOutWorkQueryDialog.cs Project: Guoyingbin/HNXC_WCS

        private void StockInWorkQueryDialog_Load(object sender, EventArgs e)
        {
            this.dtpStartBillDate.Value = DateTime.Now;
            this.dtpEndBillDate.Value = DateTime.Now;

               Process.Dal.BillDal dal=new Process.Dal.BillDal();

            dtBillType=dal.GetBillByType("2,3,4");

            cbBillType.DataSource =dtBillType;

            CigaretteFields.Add("CIGARETTE_CODE", "牌号编码");
            CigaretteFields.Add("CIGARETTE_NAME", "牌号名称");
            CigaretteFields.Add("CIGARETTE_MEMO", "牌号描述");

            FormulaFields.Add("FORMULA_CODE", "配方编码");
            FormulaFields.Add("FORMULA_NAME", "配方名称");
            FormulaFields.Add("CIGARETTE_CODE", "牌号编码");
            FormulaFields.Add("CIGARETTE_NAME", "牌号名称");
            FormulaFields.Add("BATCH_WEIGHT", "批次重量");
            FormulaFields.Add("USE_COUNT", "使用次数");

            dtCigarette = dal.GetCigarette();
            dtFormula = dal.GetFormula();
        }

Example #7

File: frmCraneTaskOption.cs Project: Guoyingbin/HNXC_WCS

 private void btnRefresh_Click(object sender, EventArgs e)
 {
     XC.Process.Dal.BillDal dal = new Process.Dal.BillDal();
     dt= dal.GetCranTaskByCraneNo(this.cmbCrane.Text);
     this.dgvMain.DataSource = dt;
 }

Example #8

 private void btnRefresh_Click(object sender, EventArgs e)
 {
     XC.Process.Dal.BillDal dal = new Process.Dal.BillDal();
     dt = dal.GetCranTaskByCraneNo(this.cmbCrane.Text);
     this.dgvMain.DataSource = dt;
 }