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