public void SelectPline()
{
Workshop_PlineEntity pline = Workshop_PlineFactory.GetByPline(LoginInfo.StationInfo.PLINE_CODE);
List <ProductLineEntity> listline = ProductLineFactory.GetByWorkShopID(pline.WORKSHOP_CODE);
foreach (ProductLineEntity LineEn in listline)
{
string[] str = new string[] { LineEn.PLINE_NAME, LineEn.PLINE_CODE, LineEn.RMES_ID };
ListViewItem Item = new ListViewItem(str);
ViewPline.Items.Add(Item);
}
}
protected void ASPxGridView1_RowInserting1(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
Workshop_PlineEntity wpe = new Workshop_PlineEntity();
wpe.COMPANY_CODE = theCompanyCode;
wpe.WORKSHOP_CODE = e.NewValues["WORKSHOP_CODE"] as string;
wpe.PLINE_CODE = e.NewValues["PLINE_CODE"] as string;
wpe.TEMP01 = e.NewValues["TEMP01"] as string;
string sql = "insert into REL_WORKSHOP_PLINE(WORKSHOP_CODE,PLINE_CODE,TEMP01) values('" + wpe.WORKSHOP_CODE + "','" + wpe.PLINE_CODE + "','" + wpe.TEMP01 + "')";
db.Insert(wpe);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
Workshop_PlineEntity wpe = new Workshop_PlineEntity();
wpe.COMPANY_CODE = theCompanyCode;
wpe.WORKSHOP_CODE = e.NewValues["WORKSHOP_CODE"] as string;
wpe.PLINE_CODE = e.NewValues["PLINE_CODE"] as string;
wpe.TEMP01 = e.NewValues["TEMP01"] as string;
string sql = "update REL_WORKSHOP_PLINE set WORKSHOP_CODE='" + wpe.WORKSHOP_CODE + "', PLINE_CODE='" + wpe.PLINE_CODE + "',TEMP01='" + wpe.TEMP01
+ "' where WORKSHOP_CODE='" + (string)e.OldValues["WORKSHOP_CODE"] + "' and PLINE_CODE='" + (string)e.OldValues["PLINE_CODE"] + "'";
dc.ExeSql(sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
