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;
}
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;
}
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();
}