//删除
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,调整失败！";
}
}
