//删除 protected void ASPxGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { MS_MODIFY_OVER_MAT sp = new MS_MODIFY_OVER_MAT() { FUNC1 = "DELETE", MATERIALCODE1 = e.Values["MATERIAL_CODE"].ToString(), LINESIDENUM1 = e.Values["MATERIAL_NUM"].ToString(), GZDD1 = e.Values["GZDD"].ToString(), YHDM1 = theUserCode, QADSITE1 = e.Values["QADSITE"].ToString() }; Rmes.DA.Base.Procedure.run(sp); setCondition(); e.Cancel = true; }
//差异调整 public void ASPxGridView1_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e) { string s = e.Parameters; string[] s1 = s.Split('|'); string type1 = s1[0]; //按钮 int rowIndex = int.Parse(s1[1]); //index ASPxGridView atl1 = (ASPxGridView)sender; //选中的行数是什么 int count1 = atl1.Selection.Count; if (type1 == "Adjust") { for (int i = 0; i < count1 && rowIndex < rowIndex + count1; i++, rowIndex++) { string strMaterialnum = ASPxGridView1.GetRowValues(rowIndex, "MATERIAL_NUM").ToString(); string gzdd = ASPxGridView1.GetRowValues(rowIndex, "GZDD").ToString(); string qadsite = ASPxGridView1.GetRowValues(rowIndex, "QADSITE").ToString(); string materialcode = ASPxGridView1.GetRowValues(rowIndex, "MATERIAL_CODE").ToString(); int Materialnum = Convert.ToInt32(strMaterialnum); //插入到日志表 try { string Sql3 = "INSERT INTO ATPUFSB_LOG (bill_code,material_code,material_num,gzdd,create_time,flag,yhmc,handle_time,qadsite,gys_code,rmes_id,user_code,flag_log,rqsj)" + " SELECT bill_code,material_code,material_num,gzdd,create_time,flag,yhmc,handle_time,qadsite,gys_code,rmes_id,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM atpufsb WHERE gzdd='" + gzdd + "' and qadsite='" + qadsite + "' and material_code='" + materialcode + "' " + "and create_time>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd') and create_time <=to_date('" + ASPxDateEdit2.Text.Trim() + "','yyyy-mm-dd')"; dc.ExeSql(Sql3); } catch { } string Sql = "update atpufsb set flag='Y',handle_time=sysdate,yhmc='" + theUserName + "' where gzdd='" + gzdd + "' and qadsite='" + qadsite + "' and material_code='" + materialcode + "' " + "and create_time>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd') and create_time <=to_date('" + ASPxDateEdit2.Text.Trim() + "','yyyy-mm-dd')"; dc.ExeSql(Sql); //插入到日志表 try { string Sql3 = "INSERT INTO ATPUFSB_LOG (bill_code,material_code,material_num,gzdd,create_time,flag,yhmc,handle_time,qadsite,gys_code,rmes_id,user_code,flag,rqsj)" + " SELECT bill_code,material_code,material_num,gzdd,create_time,flag,yhmc,handle_time,qadsite,gys_code,rmes_id,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM atpufsb WHERE gzdd='" + gzdd + "' and qadsite='" + qadsite + "' and material_code='" + materialcode + "' " + "and create_time>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd') and create_time <=to_date('" + ASPxDateEdit2.Text.Trim() + "','yyyy-mm-dd')"; dc.ExeSql(Sql3); } catch { return; } string Sql2 = "select material_num from ms_over_mat where material_code='" + materialcode + "' and gzdd='" + gzdd + "' and qadsite='" + qadsite + "'"; DataTable dt2 = dc.GetTable(Sql2); if (dt2.Rows.Count > 0) { string strmn = dt2.Rows[0][0].ToString(); int mn = Convert.ToInt32(strmn); Materialnum = mn - Materialnum; } else { Materialnum = 0 - Materialnum; } strMaterialnum = Convert.ToString(Materialnum); MS_MODIFY_OVER_MAT sp = new MS_MODIFY_OVER_MAT() { FUNC1 = "UPDATE", MATERIALCODE1 = materialcode, LINESIDENUM1 = strMaterialnum, GZDD1 = gzdd, YHDM1 = theUserCode, QADSITE1 = qadsite }; Rmes.DA.Base.Procedure.run(sp); } e.Result = "OK,回冲池数量已调整!"; } else { e.Result = "Fail,调整失败!"; } }