private void cmbProce_SelectedIndexChanged(object sender, EventArgs e)
{
Mes_ProceBLL ProceBLL = new Mes_ProceBLL();
var row = ProceBLL.GetList_Proce("where P_RecordCode = '" + cmbRecord.Text + "' and P_ProNo = '" + cmbProce.Text + "'");
txtProceName.Text = row[0].P_ProName;
}
private void cmbProceName_SelectedIndexChanged(object sender, EventArgs e)
{
Mes_ProceBLL ProceBLL = new Mes_ProceBLL();
var row = ProceBLL.GetList_Proce("where P_ProName = '" + cmbProceName.Text + "'");
cmbProce.Text = row[0].P_ProNo;
}
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 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();
}