Example #1
0
        private void cmbRecordName_SelectedIndexChanged(object sender, EventArgs e)
        {
            MesRecordBLL RecordBLL   = new MesRecordBLL();
            var          Record_rows = RecordBLL.GetData(" where R_Name = '" + cmbRecordName.Text + "'");

            cmbRecord.Text = Record_rows[0].R_Record;
        }
Example #2
0
        private void cmbRecord_SelectedIndexChanged(object sender, EventArgs e)
        {
            Mes_ProceBLL ProceBLL = new Mes_ProceBLL();
            var          row      = ProceBLL.GetList_Proce("where P_RecordCode = '" + cmbRecord.Text + "'");

            for (int i = 0; i < row.Count; i++)
            {
                cmbProce.Items.Add(row[i].P_ProNo);
            }

            MesRecordBLL RecordBLL   = new MesRecordBLL();
            var          Record_rows = RecordBLL.GetData(" where R_Record = '" + cmbRecord.Text + "'");

            txtRecordName.Text = Record_rows[0].R_Name;
        }
Example #3
0
        private void frmOutWorkShopList_Load(object sender, EventArgs e)
        {
            MesProductOrderHeadBLL ProductOrderHeadBLL = new MesProductOrderHeadBLL();
            var row_ProductOrder = ProductOrderHeadBLL.GetListAll();

            for (int i = 0; i < row_ProductOrder.Count; i++)
            {
                //cmb  .Items.Add(row_ProductOrder[i].W_Code);
                comOrderNo.Items.Add(row_ProductOrder[i].P_OrderNo);
            }

            MesWorkShopBLL WorkShopBLL = new MesWorkShopBLL();
            var            rows        = WorkShopBLL.GetList();

            for (int i = 0; i < rows.Count; i++)
            {
                cmbWorkShop.Items.Add(rows[i].W_Code);
                cmbWorkshopName.Items.Add(rows[i].W_Name);
            }

            if (cmbWorkShop.Items.Contains(Globels.strWorkShop))
            {
                cmbWorkShop.Text = Globels.strWorkShop;
            }

            MesStockBLL StockBLL   = new MesStockBLL();
            var         Stock_rows = StockBLL.GetData(" where S_Kind = '4'");

            for (int i = 0; i < Stock_rows.Count; i++)
            {
                cmbStock.Items.Add(Stock_rows[i].S_Code);
                cmbStockName.Items.Add(Stock_rows[i].S_Name);
            }
            if (cmbStock.Items.Contains(Globels.strStockCode))
            {
                cmbStock.Text = Globels.strStockCode;
            }

            MesRecordBLL RecordBLL   = new MesRecordBLL();
            var          Record_rows = RecordBLL.GetList();

            for (int i = 0; i < Record_rows.Count; i++)
            {
                cmbRecord.Items.Add(Record_rows[i].R_Record);
            }
        }
Example #4
0
        private void frmInWorkShop_Load(object sender, EventArgs e)
        {
            MesProductOrderHeadBLL ProductOrderHeadBLL = new MesProductOrderHeadBLL();
            var row_ProductOrder = ProductOrderHeadBLL.GetListAll();

            for (int i = 0; i < row_ProductOrder.Count; i++)
            {
                //cmb  .Items.Add(row_ProductOrder[i].W_Code);
                comOrderNo.Items.Add(row_ProductOrder[i].P_OrderNo);
            }

            MesWorkShopBLL WorkShopBLL = new MesWorkShopBLL();
            var            rows        = WorkShopBLL.GetList();

            for (int i = 0; i < rows.Count; i++)
            {
                cmbWorkShop.Items.Add(rows[i].W_Code);
                cmbWorkshopName.Items.Add(rows[i].W_Name);
            }

            if (cmbWorkShop.Items.Contains(Globels.strWorkShop))
            {
                cmbWorkShop.Text = Globels.strWorkShop;
                //cmbStockName.Text =
            }

            MesStockBLL StockBLL   = new MesStockBLL();
            var         Stock_rows = StockBLL.GetData(" where S_Kind = 4 order by S_Code asc");

            for (int i = 0; i < Stock_rows.Count; i++)
            {
                cmbStock.Items.Add(Stock_rows[i].S_Code);
                cmbStockName.Items.Add(Stock_rows[i].S_Name);
            }
            if (cmbStock.Items.Contains(Globels.strStockCode))
            {
                cmbStock.Text = Globels.strStockCode;
            }

            MesRecordBLL RecordBLL   = new MesRecordBLL();
            var          Record_rows = RecordBLL.GetList();

            for (int i = 0; i < Record_rows.Count; i++)
            {
                cmbRecord.Items.Add(Record_rows[i].R_Record);
            }

            //MesBasketBLL BasketBLL = new MesBasketBLL();
            //var Basket_rows = BasketBLL.GetList();
            //for (int i = 0; i < Basket_rows.Count; i++)
            //{
            //    cmbBasket.Items.Add(Record_rows[i].R_Record);
            //}

            //MesInventoryBLL InventoryBLL = new MesInventoryBLL();
            //var Goods_rows = InventoryBLL.GetList();
            //for (int i = 0; i < Goods_rows.Count; i++)
            //{
            //    cmbStock.Items.Add(Goods_rows[i].G_Code);
            //}
        }
Example #5
0
        private void frmOrgres_Load(object sender, EventArgs e)
        {
            MesProductOrderHeadBLL ProductOrderHeadBLL = new MesProductOrderHeadBLL();
            var row_ProductOrder = ProductOrderHeadBLL.GetListAll();

            for (int i = 0; i < row_ProductOrder.Count; i++)
            {
                //cmb  .Items.Add(row_ProductOrder[i].W_Code);
                comOrderNo.Items.Add(row_ProductOrder[i].P_OrderNo);
            }

            MesWorkShopBLL WorkShopBLL = new MesWorkShopBLL();
            var            rows        = WorkShopBLL.GetList();

            for (int i = 0; i < rows.Count; i++)
            {
                cmbWorkShop.Items.Add(rows[i].W_Code);
                cmbWorkShopName.Items.Add(rows[i].W_Name);
            }

            if (cmbWorkShop.Items.Contains(Globels.strWorkShop))
            {
                cmbWorkShop.Text = Globels.strWorkShop;
            }

            MesRecordBLL RecordBLL   = new MesRecordBLL();
            var          Record_rows = RecordBLL.GetList();

            for (int i = 0; i < Record_rows.Count; i++)
            {
                cmbRecord.Items.Add(Record_rows[i].R_Record);
                cmbRecordName.Items.Add(Record_rows[i].R_Name);
            }


            Mes_ProceBLL ProceBLL = new Mes_ProceBLL();
            var          row      = ProceBLL.GetList_Proce(" where 1 = 1 ");

            for (int i = 0; i < row.Count; i++)
            {
                cmbProce.Items.Add(row[i].P_ProNo);
                cmbProceName.Items.Add(row[i].P_ProName);
            }
            if (cmbProce.Items.Contains(Globels.strProce))
            {
                cmbProce.Text = Globels.strProce;
            }



            Mes_TeamBLL TeamBLL   = new Mes_TeamBLL();
            var         Team_rows = TeamBLL.GetList_Team(" where 1 = 1 ");

            for (int i = 0; i < Team_rows.Count; i++)
            {
                cmbTeam.Items.Add(Team_rows[i].T_Code);
                cmbTeamName.Items.Add(Team_rows[i].T_Name);
            }
            if (cmbTeam.Items.Contains(Globels.strTeam))
            {
                cmbTeam.Text = Globels.strTeam;
            }

            string strSql = "Select distinct W_SecGoodsName from Mes_WorkShopWeight where W_WorkShopCode = '" + cmbWorkShop.Text + "'";
            Mes_WorkShopWeightBLL WorkShopWeightBL = new Mes_WorkShopWeightBLL();
            DataSet ds   = WorkShopWeightBL.GetList_WorkShop(strSql);
            int     nLen = ds.Tables[0].Rows.Count;

            comboBox1.Items.Clear();
            comboBox1.Items.Add("");
            for (int i = 0; i < nLen; i++)
            {
                comboBox1.Items.Add(ds.Tables[0].Rows[i]["W_SecGoodsName"].ToString());
            }
            Search();
        }