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