protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { string rmes_id = e.OldValues["RMES_ID"].ToString(); ASPxComboBox plineCode = ASPxGridView1.FindEditFormTemplateControl("plineCode") as ASPxComboBox; ASPxComboBox productSeries = ASPxGridView1.FindEditFormTemplateControl("productSeries") as ASPxComboBox; ASPxComboBox detectDataType = ASPxGridView1.FindEditFormTemplateControl("detectDataType") as ASPxComboBox; DetectDataEntity detEntity = new DetectDataEntity(); detEntity.RMES_ID = rmes_id; detEntity.COMPANY_CODE = theCompanyCode; detEntity.PLINE_CODE = plineCode.SelectedItem.Value.ToString().Trim(); detEntity.PRODUCT_SERIES = productSeries.SelectedItem.Value.ToString().Trim(); detEntity.DETECT_ITEM_CODE = e.NewValues["DETECT_ITEM_CODE"].ToString().Trim(); detEntity.DETECT_ITEM_NAME = e.NewValues["DETECT_ITEM_NAME"].ToString().Trim(); detEntity.DETECT_ITEM_CODE = e.NewValues["DETECT_DATA_CODE"].ToString().Trim(); detEntity.DETECT_ITEM_NAME = e.NewValues["DETECT_DATA_NAME"].ToString().Trim(); detEntity.DETECT_DATA_TYPE = detectDataType.SelectedItem.Value.ToString().Trim(); detEntity.DETECT_DATA_UNIT = e.NewValues["DETECT_DATA_UNIT"].ToString().Trim(); if (e.NewValues["STANDARD_VALUE"] == null || e.NewValues["STANDARD_VALUE"].ToString().Trim() == "") { detEntity.STANDARD_VALUE = 0; } else { detEntity.STANDARD_VALUE = int.Parse(e.NewValues["STANDARD_VALUE"].ToString().Trim()); detEntity.STANDARD_VALUE = int.Parse(e.NewValues["DETECT_DATA_STANDARD"].ToString().Trim()); } if (e.NewValues["MAX_VALUE"] == null || e.NewValues["MAX_VALUE"].ToString().Trim() == "") { detEntity.MAX_VALUE = 0; } else { detEntity.MAX_VALUE = int.Parse(e.NewValues["MAX_VALUE"].ToString().Trim()); detEntity.MAX_VALUE = int.Parse(e.NewValues["DETECT_DATA_UP"].ToString().Trim()); } if (e.NewValues["MIN_VALUE"] == null || e.NewValues["MIN_VALUE"].ToString().Trim() == "") { detEntity.MIN_VALUE = 0; } else { detEntity.MIN_VALUE = int.Parse(e.NewValues["MIN_VALUE"].ToString().Trim()); detEntity.MIN_VALUE = int.Parse(e.NewValues["DETECT_DATA_DOWN"].ToString().Trim()); } db.Update(detEntity); e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
protected void ASPxGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { string rmes_id = e.Values["RMES_ID"].ToString(); DetectDataEntity detEntity = new DetectDataEntity { RMES_ID = rmes_id }; //插入到日志表20161101 try { string Sql2 = "INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,user_code,flag,rqsj)" + " SELECT RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,'" + theUserCode + "' , 'DEL', SYSDATE FROM CODE_DETECT WHERE RMES_ID = '" + rmes_id + "' "; dc.ExeSql(Sql2); } catch { return; } dc.ExeSql("update CODE_DETECT set temp01='N' where RMES_ID = '" + rmes_id + "' "); //db.Delete(detEntity); setCondition(); e.Cancel = true; }
protected void ASPxGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { //判断当前记录是否可以删除 //string strDelCode = e.Values["PLAN_CODE"].ToString(); string rmes_id = e.Values["RMES_ID"].ToString(); DetectDataEntity detEntity = new DetectDataEntity { RMES_ID = rmes_id }; db.Delete(detEntity); setCondition(); e.Cancel = true; }
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { string rmes_id = e.OldValues["RMES_ID"].ToString(); DetectDataEntity detEntity = db.First <DetectDataEntity>("where rmes_id=@0", rmes_id); ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox; //ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("comWorkUnit") as ASPxComboBox; detEntity.PLINE_CODE = pline.SelectedItem.Value.ToString(); //detEntity.WORKUNIT_CODE = e.NewValues["WORKUNIT_CODE"].ToString(); detEntity.DETECT_CODE = e.NewValues["DETECT_CODE"].ToString(); detEntity.DETECT_NAME = e.NewValues["DETECT_NAME"].ToString(); detEntity.DETECT_UNIT = e.NewValues["DETECT_UNIT"].ToString(); detEntity.PRODUCT_SERIES = "";// e.NewValues["PRODUCT_SERIES"].ToString(); detEntity.ASSOCIATION_TYPE = e.NewValues["ASSOCIATION_TYPE"].ToString(); detEntity.INPUT_TIME = DateTime.Now; detEntity.INPUT_PERSON = theUserId; if (detEntity.DETECT_TYPE != "0") { //if (detEntity.DETECT_TYPE == "1") //{ // try // { // detEntity.DETECT_STANDARD = Convert.ToInt32(e.NewValues["DETECT_STANDARD"].ToString().Trim()); // } // catch // { // detEntity.DETECT_STANDARD = 0; // } //} //else //{ // detEntity.DETECT_STANDARD = 0; //} detEntity.DETECT_STANDARD = 0; detEntity.DETECT_MAX = 0; detEntity.DETECT_MIN = 0; } else { detEntity.DETECT_STANDARD = Convert.ToDouble(e.NewValues["DETECT_STANDARD"].ToString()); detEntity.DETECT_MAX = Convert.ToDouble(e.NewValues["DETECT_MAX"].ToString()); detEntity.DETECT_MIN = Convert.ToDouble(e.NewValues["DETECT_MIN"].ToString()); } db.Update(detEntity); //插入到日志表20161101 try { //string Sql2 = "INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,user_code,flag,rqsj)" // + " SELECT RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,'" // + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM CODE_DETECT WHERE RMES_ID = '" + rmes_id + "' "; string Sql2 = " INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,user_code,flag,rqsj)" + " VALUES( '" + rmes_id + "','" + theCompanyCode + "','" + e.OldValues["PLINE_CODE"].ToString() + "','" + e.OldValues["PRODUCT_SERIES"].ToString() + "','" + e.OldValues["DETECT_CODE"].ToString() + "','" + e.OldValues["DETECT_NAME"].ToString() + "','" + e.OldValues["DETECT_TYPE"].ToString() + "','" + e.OldValues["DETECT_STANDARD"].ToString() + "','" + e.OldValues["DETECT_MAX"].ToString() + "','" + e.OldValues["DETECT_MIN"].ToString() + "','" + e.OldValues["DETECT_UNIT"].ToString() + "','" + e.OldValues["ASSOCIATION_TYPE"].ToString() + "','" + theUserCode + "','BEFOREEDIT',SYSDATE) "; dc.ExeSql(Sql2); string Sql3 = " INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,user_code,flag,rqsj)" + " VALUES( '" + rmes_id + "','" + theCompanyCode + "','" + e.NewValues["PLINE_CODE"].ToString() + "','" + e.NewValues["PRODUCT_SERIES"].ToString() + "','" + e.NewValues["DETECT_CODE"].ToString() + "','" + e.NewValues["DETECT_NAME"].ToString() + "','" + e.NewValues["DETECT_TYPE"].ToString() + "','" + e.NewValues["DETECT_STANDARD"].ToString() + "','" + e.NewValues["DETECT_MAX"].ToString() + "','" + e.NewValues["DETECT_MIN"].ToString() + "','" + e.NewValues["DETECT_UNIT"].ToString() + "','" + e.NewValues["ASSOCIATION_TYPE"].ToString() + "','" + theUserCode + "','AFTEREDIT',SYSDATE) "; dc.ExeSql(Sql3); } catch { return; } e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox; //ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("comWorkUnit") as ASPxComboBox; ASPxComboBox detectDataType = ASPxGridView1.FindEditFormTemplateControl("detectDataType") as ASPxComboBox; string sql = "select 'DECT'||TRIM(TO_CHAR(SEQ_USER_ID.NEXTVAL,'000000')) from dual"; dc.setTheSql(sql); string dece_code1 = dc.GetValue(); DetectDataEntity detEntity = new DetectDataEntity(); detEntity.COMPANY_CODE = theCompanyCode; //detEntity.DETECT_CODE = e.NewValues["DETECT_CODE"].ToString(); detEntity.DETECT_CODE = dece_code1; detEntity.DETECT_NAME = e.NewValues["DETECT_NAME"].ToString(); detEntity.DETECT_UNIT = e.NewValues["DETECT_UNIT"].ToString(); detEntity.PRODUCT_SERIES = "";// e.NewValues["PRODUCT_SERIES"].ToString(); detEntity.ASSOCIATION_TYPE = e.NewValues["ASSOCIATION_TYPE"].ToString(); detEntity.PLINE_CODE = pline.SelectedItem.Value.ToString(); detEntity.DETECT_TYPE = detectDataType.SelectedItem.Value.ToString(); detEntity.INPUT_TIME = DateTime.Now; detEntity.INPUT_PERSON = theUserId; if (detEntity.DETECT_TYPE != "0") //非计量型无上下限 记点型限定01 { //if (detEntity.DETECT_TYPE == "1") //{ // try // { // detEntity.DETECT_STANDARD = Convert.ToInt32(e.NewValues["DETECT_STANDARD"].ToString().Trim()); // } // catch // { // detEntity.DETECT_STANDARD = 0; // } //} //else //{ // detEntity.DETECT_STANDARD = 0; //} detEntity.DETECT_STANDARD = 0; detEntity.DETECT_MAX = 0; detEntity.DETECT_MIN = 0; } else //计量型 { if (e.NewValues["DETECT_STANDARD"] == null || e.NewValues["DETECT_STANDARD"].ToString().Trim() == "") { detEntity.DETECT_STANDARD = 0; } else { detEntity.DETECT_STANDARD = Convert.ToDouble(e.NewValues["DETECT_STANDARD"].ToString().Trim()); } if (e.NewValues["DETECT_MAX"] == null || e.NewValues["DETECT_MAX"].ToString().Trim() == "") { detEntity.DETECT_MAX = 0; } else { detEntity.DETECT_MAX = Convert.ToDouble(e.NewValues["DETECT_MAX"].ToString()); } if (e.NewValues["DETECT_MIN"] == null || e.NewValues["DETECT_MIN"].ToString().Trim() == "") { detEntity.DETECT_MIN = 0; } else { detEntity.DETECT_MIN = Convert.ToDouble(e.NewValues["DETECT_MIN"].ToString()); } } db.Insert(detEntity); //插入到日志表20161101 try { string Sql2 = "INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,user_code,flag,rqsj)" + " SELECT RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,'" + theUserCode + "' , 'ADD', SYSDATE FROM CODE_DETECT WHERE DETECT_CODE = '" + dece_code1 + "' AND DETECT_NAME = '" + e.NewValues["DETECT_NAME"].ToString() + "' "; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }