private void frmStorageAdd_Load(object sender, EventArgs e) { comStock.Items.Clear(); comProductNo.Items.Clear(); MesStockBLL StockBLL = new MesStockBLL(); var row = StockBLL.GetData(" where s_Kind = 1"); int nCount = row.Count; for (int i = 0; i < nCount; i++) { comStock.Items.Add(row[i].S_Code.ToString() + "$" + row[i].S_Name.ToString()); } MesProductOrderHeadBLL ProductOrderHeadBLL = new MesProductOrderHeadBLL(); var Product = ProductOrderHeadBLL.GetList(""); int nCount2 = Product.Count; for (int j = 0; j < nCount2; j++) { comProductNo.Items.Add(Product[j].P_OrderNo.ToString() + "$" + Product[j].P_OrderDate.ToString()); } string strCondit = " where S_EffectTime > '" + DateTime.Now + "'"; MesSupplyBLL SupplyBLL = new MesSupplyBLL(); var Supply = SupplyBLL.GetList(strCondit); int nCount3 = Supply.Count; for (int k = 0; k < nCount3; k++) { cmbSupply.Items.Add(Supply[k].S_Code + "$" + Supply[k].S_Name); } }
private void comOrderNo_SelectedIndexChanged(object sender, EventArgs e) { MesProductOrderHeadBLL ProductOrderHeadBLL = new MesProductOrderHeadBLL(); var row = ProductOrderHeadBLL.GetList(comOrderNo.Text); txtOrderDate.Text = row[0].P_OrderDate.ToString(); }
private void txtOrderNo_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter)//如果输入的是回车键 { MesProductOrderHeadBLL MesProductOrderHeadBLL = new MesProductOrderHeadBLL(); //var rows = MesProductOrderHeadBLL.GetList(txtOrderNo.Text.Trim()); //if (rows == null || rows.Count < 1) //{ // untCommon.InfoMsg("输入的生产订单号错误,请重新输入!"); // txtOrderNo.Focus(); // txtOrderNo.SelectAll(); //} } }
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); } }
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); //} }
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(); }