protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridLookup uSO = ASPxGridView2.FindEditFormTemplateControl("txtSO2") as ASPxGridLookup;
ASPxTextBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxTextBox;
ASPxTextBox uPQBAK = ASPxGridView2.FindEditFormTemplateControl("txtPQBAK") as ASPxTextBox;
ASPxTextBox uREMARK = ASPxGridView2.FindEditFormTemplateControl("txtREMARK") as ASPxTextBox;
string strSO = uSO.Value.ToString();
string strJX = uJX.Text.Trim();
string strPQBAK = uPQBAK.Text.Trim();
string strREMARK = uREMARK.Text.Trim();
string Sql = "INSERT INTO PAINT_SO (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,input_person,input_time) "
+ "VALUES( '" + strSO + "','" + strPQBAK + "','" + strPQBAK + "','" + strREMARK + "','" + strJX + "','" + theUserId + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)"
+ " VALUES( '" + strSO + "','" + strPQBAK + "','" + strPQBAK + "','" + strREMARK + "','" + strJX + "','" + theUserCode + "' , 'ADD', SYSDATE) ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox plineCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox ljmc = ASPxGridView2.FindEditFormTemplateControl("txtName") as ASPxTextBox;
ASPxComboBox partNAME_ABC = ASPxGridView2.FindEditFormTemplateControl("comboLJLB_NAME") as ASPxComboBox;
string Sql = "INSERT INTO ATPUSMLJB (PLINE_CODE,ABOM_DESC,PART_ABC,INPUT_PERSON,INPUT_TIME) "
+ "VALUES( '" + plineCode.Value.ToString() + "','" + ljmc.Text.Trim() + "','" + partNAME_ABC.Value.ToString() + "','" + theUserId + "',SYSDATE)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUSMLJB_LOG (PLINE_CODE,ABOM_DESC,PART_ABC,user_code,flag,rqsj)"
+ " SELECT PLINE_CODE,ABOM_DESC,PART_ABC,'" + theUserCode + "' , 'ADD', SYSDATE FROM ATPUSMLJB "
+ "WHERE PLINE_CODE = '" + plineCode.Value.ToString() + "' and ABOM_DESC = '" + ljmc.Text.Trim() + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox plineCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox ljmc = ASPxGridView2.FindEditFormTemplateControl("txtName") as ASPxTextBox;
//取RMES_ID的值
string sql_rmes_id = "SELECT SEQ_RMES_ID.NEXTVAL FROM DUAL ";
dc.setTheSql(sql_rmes_id);
string rmes_id = dc.GetTable().Rows[0][0].ToString();
string Sql = "";
Sql = "INSERT INTO DMZYLJB_NAME (RMES_ID,LJMC,PLINE_CODE,INPUT_PERSON,INPUT_TIME)"
+ "VALUES('" + rmes_id + "', '" + ljmc.Text.Trim() + "','" + plineCode.Value.ToString() + "','"+theUserId+"',SYSDATE)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO DMZYLJB_NAME_LOG (RMES_ID,LJMC,PLINE_CODE,user_code,flag,rqsj)"
+ " SELECT RMES_ID,LJMC,PLINE_CODE,'" + theUserCode + "' , 'ADD', SYSDATE FROM DMZYLJB_NAME WHERE RMES_ID = '" + rmes_id + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
//-----------------------------------------------------------总成零件现场是否显示维护----------------------------------------------------
//修改
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox ljdm = ASPxGridView2.FindEditFormTemplateControl("comboLJDM2") as ASPxComboBox;
ASPxCheckBox chZCXSFlag = ASPxGridView2.FindEditFormTemplateControl("chZCFlag") as ASPxCheckBox;
string xsFlag = "";
if (chZCXSFlag.Checked == true)
{
xsFlag = "1";
}
else
{
xsFlag = "0";
}
string Sql = "UPDATE ATPUBOMKZB SET SFXS='" + xsFlag + "' "
+ " WHERE abom_comp = '" + ljdm.Value.ToString() + "'";
dc.ExeSql(Sql);
//记录操作start
string logSql = "insert into atpubomkzb_log(abom_comp,zdrq,rqbegin,rqend,rqsj,yhmc,czms) "
+ " select abom_comp,zdrq,rqbegin,rqend,sysdate,'" + theUserName + "','修改了该零件的显示属性' "
+ " from atpubomkzb where abom_comp='" + ljdm.Value.ToString() + "' ";
dc.ExeSql(logSql);
//记录操作end
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition2();
}
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox uGxdm = ASPxGridView2.FindEditFormTemplateControl("txtGxdm") as ASPxComboBox;
ASPxTextBox uPath = ASPxGridView2.FindEditFormTemplateControl("txtPath") as ASPxTextBox;
ASPxTextBox uCzts = ASPxGridView2.FindEditFormTemplateControl("txtCzts") as ASPxTextBox;
string gxdm = uGxdm.Text.Trim();
string path = uPath.Text.Trim();
string czts = uCzts.Text.Trim();
string part = ASPxGridView2.GetRowValues(ASPxGridView2.EditingRowVisibleIndex, new string[] { "PART" }).ToString();
//string part = e.NewValues["PART"].ToString();
//修改前数据插入到日志表
string Lsql = "insert into RST_ATPU_ZJTS_LOG(PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT,EDIT_USER,EDIT_FLAG,EDIT_DATE)select PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT, "
+ "'" + theUserName + "','BEFOREDIT',SYSDATE FROM RST_ATPU_ZJTS WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "' ";
dc.ExeSql(Lsql);
string Sql = "UPDATE RST_ATPU_ZJTS SET CZTS='" + czts + "', WJPATH='" + path + "'"
+ " WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "' ";
dc.ExeSql(Sql);
//修改后数据插入到日志表
string Lsql2 = "insert into RST_ATPU_ZJTS_LOG(PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT,EDIT_USER,EDIT_FLAG,EDIT_DATE)select PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT, "
+ "'" + theUserName + "','AFTEREDIT',SYSDATE FROM RST_ATPU_ZJTS WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "'";
dc.ExeSql(Lsql2);
e.Cancel = true;
ASPxGridView2.CancelEdit();
//if (Session["inv9501sql"] as string != "")
//{
// DataTable dt2 = dc.GetTable(Session["inv9501sql"] as string);
// ASPxGridView2.DataSource = dt2;
// ASPxGridView2.DataBind();
//}
SetCondition();
}
protected void ASPxGridView2_RowUpdating(object sender, ASPxDataUpdatingEventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
try
{
var formLayout = ASPxGridView2.FindEditFormTemplateControl("ASPxFormLayout1") as ASPxFormLayout;
if (formLayout != null)
{
var gridLookupVendedor = formLayout.FindControl("GridLookupVendedor") as ASPxGridLookup;
var memoComentarios = formLayout.FindControl("MemoComentarios") as ASPxMemo;
var timeEditHoraVisita = formLayout.FindControl("TimeEditHoraVisita") as ASPxTimeEdit;
var spinPrioridad = formLayout.FindControl("SpinPrioridad") as ASPxSpinEdit;
var customerCode = ASPxGridView2.GetRowValuesByKeyValue(e.Keys[0], "CUSTOMER_CODE");
var customerName = ASPxGridView2.GetRowValuesByKeyValue(e.Keys[0], "CUSTOMER_NAME");
var pResult = "";
_objTask.UpdateInsertPresaleTasks(Session["connectionString"].ToString(),
customerCode.ToString(), customerName.ToString(),
gridLookupVendedor.Text, memoComentarios.Text, timeEditHoraVisita.DateTime,
ASPxCalendar1.SelectedDate, Convert.ToInt32(spinPrioridad.Number), ref pResult);
}
GetTasksByDate(ASPxCalendar1.SelectedDate);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
ASPxGridView2.CancelEdit();
e.Cancel = true;
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uSO = ASPxGridView2.FindEditFormTemplateControl("TextSO") as ASPxTextBox;
string strSO = uSO.Text.Trim();
string Sql = "INSERT INTO NONPPIF_ATPU (SO,input_person,input_time)VALUES( '" + strSO + "','" + theUserId + "',sysdate) ";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO NONPPIF_ATPU_LOG (SO,user_code,flag,rqsj)"
+ " SELECT SO,'" + theUserCode + "' , 'ADD', SYSDATE FROM NONPPIF_ATPU WHERE SO = '" + strSO + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxComboBox;
ASPxComboBox uPD = ASPxGridView2.FindEditFormTemplateControl("txtPD") as ASPxComboBox;
string strJX = uJX.Value.ToString();
string strPD = uPD.Value.ToString();
string Sql = "INSERT INTO JWYF (JXREMARK,PANDUAN,INPUT_PERSON,INPUT_TIME) "
+ "VALUES('" + strJX + "', '" + strPD + "','" + theUserId + "',SYSDATE)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO JWYF_LOG (JXREMARK,PANDUAN,user_code,flag,rqsj)"
+ " VALUES('" + strJX + "', '" + strPD + "','" + theUserCode + "' , 'ADD', SYSDATE) ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
e.NewValues["RowStatus"] = Constant.ROWSTATUS_ACTIVE;
if (e.NewValues["IsDefault"] == null)
{
e.NewValues["IsDefault"] = false;
}
if (Util.isExistXpoObject <AccountingPeriodType>("Name", (string)e.NewValues["Name"]))
{
e.Cancel = true;
throw(new Exception("Trùng tên thể loại chu kì"));
}
if ((bool)e.NewValues["IsDefault"] == true)
{
CriteriaOperator criteria = new BinaryOperator("IsDefault", true, BinaryOperatorType.Equal);
AccountingPeriodType type = session.FindObject <AccountingPeriodType>(criteria);
e.NewValues["RowStatus"] = Constant.ROWSTATUS_ACTIVE;
if (type != null)
{
if (AccountingPeriodTypeBO.IsUsedAccoutingPeriodType(session, type.AccountingPeriodTypeId))
{
ASPxGridView2.CancelEdit();
throw new Exception("Loại chu kì nhỏ nhất " + type.Name + " đang được sử dụng nên không thể thay đổi");
}
type.IsDefault = false;
type.Save();
}
}
}
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
string gwmc = "", gwmc1 = "", gxmc = "", gxmc1 = "", ljdm1 = "", ljdm2 = "";
string sql2 = "", rowid = "";
try
{
rowid = e.NewValues["ROWID"].ToString();
}
catch { }
try
{
ljdm1 = e.NewValues["LJDM1"].ToString();
}
catch { }
try
{
gwmc = e.NewValues["GWMC"].ToString();
}
catch { }
try
{
ljdm2 = e.NewValues["LJDM2"].ToString();
}
catch { }
try
{
gwmc1 = e.NewValues["GWMC1"].ToString();
}
catch { }
try
{
gxmc1 = e.NewValues["GXMC1"].ToString();
}
catch { }
if (ljdm1 == "")
{
sql2 = "update SJBOMSOTHMUTI set gwmc='" + gwmc + "',GWMC1='" + gwmc1
+ "',GXMC1='" + gxmc1 + "' where LJDM2 = '" + ljdm2 + "' and jhdm='" + Request["planCode"].ToString() + "'";
}
else
{
sql2 = "update SJBOMSOTHMUTI set gwmc='" + gwmc + "',GWMC1='" + gwmc1
+ "',GXMC1='" + gxmc1 + "' where LJDM1 = '" + ljdm1 + "' and jhdm='" + Request["planCode"].ToString() + "'";
}
//sql2 = "update SJBOMSOTHMUTI set gwmc='" + e.NewValues["GWMC"].ToString() + "',GWMC1='" + e.NewValues["GWMC1"].ToString()
// + "',GXMC1='" + e.NewValues["GXMC1"].ToString() + "' where LJDM1 = '" + e.Keys["LJDM1"].ToString() + "' and jhdm='" + Request["planCode"].ToString() + "'";
//sql2 = "update SJBOMSOTHMUTI set gwmc='" + gwmc + "',GWMC1='" + gwmc1
// + "',GXMC1='" + gxmc1 + "' where LJDM1 = '" + ljdm1 + "' and jhdm='" + Request["planCode"].ToString() + "'";
//sql2 = "update SJBOMSOTHMUTI set gwmc='" + gwmc + "',GWMC1='" + gwmc1
// + "',GXMC1='" + gxmc1 + "' where rowid = '" + rowid + "' and jhdm='" + Request["planCode"].ToString() + "'";
dc.ExeSql(sql2);
e.Cancel = true;
ASPxGridView2.CancelEdit();
initGrid2();
return;
}
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox aCode = ASPxGridView2.FindEditFormTemplateControl("txtAlineCode") as ASPxTextBox;
ASPxTextBox aName = ASPxGridView2.FindEditFormTemplateControl("txtAlineName") as ASPxTextBox;
ASPxComboBox PlineId = ASPxGridView2.FindEditFormTemplateControl("ASPxComboBox1") as ASPxComboBox;
string plineCode = "";
string plineName = "";
string chSql = "select pline_code,pline_name from code_product_line where rmes_id='" + PlineId.Value.ToString() + "'";
dataConn dc1 = new dataConn(chSql);
DataTable dt1 = dc1.GetTable();
if (dt1.Rows.Count > 0)
{
plineCode = dt1.Rows[0]["pline_code"].ToString();
plineName = dt1.Rows[0]["pline_name"].ToString();
}
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPU_ACROSSLINE_LOG (COMPANY_CODE,ALINE_CODE,ALINE_NAME,PLINE_ID,PLINE_CODE,PLINE_NAME,user_code,flag,rqsj)"
+ " SELECT COMPANY_CODE,ALINE_CODE,ALINE_NAME,PLINE_ID,PLINE_CODE,PLINE_NAME,'"
+ theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM ATPU_ACROSSLINE WHERE COMPANY_CODE='" + theCompanyCode + "' and ALINE_CODE='"
+ aCode.Text.Trim() + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string upSql = "UPDATE ATPU_ACROSSLINE SET ALINE_NAME='" + aName.Text.Trim() + "',input_person='" + theUserId + "',input_time=sysdate "
+ " WHERE COMPANY_CODE = '" + theCompanyCode + "' and ALINE_CODE='" + aCode.Text.Trim() + "' and PLINE_ID='" + PlineId.Value.ToString() + "'";
dc.ExeSql(upSql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPU_ACROSSLINE_LOG (COMPANY_CODE,ALINE_CODE,ALINE_NAME,PLINE_ID,PLINE_CODE,PLINE_NAME,user_code,flag,rqsj)"
+ " SELECT COMPANY_CODE,ALINE_CODE,ALINE_NAME,PLINE_ID,PLINE_CODE,PLINE_NAME,'"
+ theUserCode + "' , 'AFTEREDIT', SYSDATE FROM ATPU_ACROSSLINE WHERE COMPANY_CODE='" + theCompanyCode + "' and ALINE_CODE='"
+ aCode.Text.Trim() + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
queryFunction();
}
//修改
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridLookup uSO = ASPxGridView2.FindEditFormTemplateControl("txtSO2") as ASPxGridLookup;
ASPxTextBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxTextBox;
ASPxTextBox uPQBAK = ASPxGridView2.FindEditFormTemplateControl("txtPQBAK") as ASPxTextBox;
ASPxTextBox uREMARK = ASPxGridView2.FindEditFormTemplateControl("txtREMARK") as ASPxTextBox;
string strSO = uSO.Value.ToString();
string strJX = uJX.Text.Trim();
string strPQBAK = uPQBAK.Text.Trim();
string strREMARK = uREMARK.Text.Trim();
//插入到日志表
try
{
string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)"
+ " SELECT SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM PAINT_SO WHERE SO = '" + strSO + "' and JX= '" + strJX + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string Sql = "UPDATE PAINT_SO SET TYPE_PQ='" + strPQBAK + "',TYPE_PQBAK='" + strPQBAK + "',REMARK='" + strREMARK + "',input_person='" + theUserId + "',input_time=sysdate"
+ " WHERE SO = '" + strSO + "'and JX= '" + strJX + "' ";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)"
+ " SELECT SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM PAINT_SO WHERE SO = '" + strSO + "' and JX= '" + strJX + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
if (Util.isExistXpoObject <AccountingPeriodType>("Name", (string)e.NewValues["Name"]))
{
CriteriaOperator criteria_0 = new BinaryOperator("Name", (string)e.NewValues["Name"], BinaryOperatorType.Equal);
CriteriaOperator criteria_1 = new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator criteria_2 = new BinaryOperator("AccountingPeriodTypeId", e.Keys[0], BinaryOperatorType.NotEqual);
CriteriaOperator criteria = new GroupOperator(GroupOperatorType.And, criteria_0, criteria_1, criteria_2);
AccountingPeriodType type = session.FindObject <AccountingPeriodType>(criteria);
if (type != null)
{
e.Cancel = true;
throw (new Exception("Trùng tên thể loại chu kì"));
}
}
if (e.NewValues["IsDefault"] == null)
{
e.NewValues["IsDefault"] = false;
}
if ((bool)e.NewValues["IsDefault"] == true)
{
CriteriaOperator criteria = new BinaryOperator("IsDefault", true, BinaryOperatorType.Equal);
AccountingPeriodType type = session.FindObject <AccountingPeriodType>(criteria);
if (type != null)
{
if (AccountingPeriodTypeBO.IsUsedAccoutingPeriodType(session, type.AccountingPeriodTypeId))
{
ASPxGridView2.CancelEdit();
throw new Exception("Loại chu kì nhỏ nhất " + type.Name + " đang được sử dụng nên không thể thay đổi");
}
type.IsDefault = false;
type.Save();
}
}
else
{
if (e.OldValues["IsDefault"].ToString() == "True")
{
e.Cancel = true;
ASPxGridView2.CancelEdit();
throw (new Exception("Phải luôn có 1 thể loại chu kì nhỏ nhất"));
}
}
}
//修改
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox uPCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uSN = ASPxGridView2.FindEditFormTemplateControl("txtSN") as ASPxTextBox;
ASPxComboBox uSNflag = ASPxGridView2.FindEditFormTemplateControl("ASPxComboBox3") as ASPxComboBox;
string strPCode = uPCode.Value.ToString();
string strSN = uSN.Text.Trim();
string strSNflag = uSNflag.Value.ToString();
//插入到日志表
try
{
string Sql2 = "INSERT INTO CODE_SN_RESERVE_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,SN,SN_FLAG,user_code,flag,rqsj)"
+ "select RMES_ID,COMPANY_CODE,PLINE_CODE,SN,SN_FLAG,'" + theUserCode + "','DEL',SYSDATE from CODE_SN_RESERVE WHERE COMPANY_CODE = '" + theCompanyCode + "' and SN = '" + strSN + "')";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string Sql = "UPDATE CODE_SN_RESERVE SET PLINE_CODE='" + strPCode + "',SN='" + strSN + "',SN_FLAG='" + strSNflag + "',input_person='" + theUserId + "',input_time=sysdate "
+ " WHERE COMPANY_CODE = '" + theCompanyCode + "' and SN = '" + strSN + "'";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO CODE_SN_RESERVE_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,SN,SN_FLAG,user_code,flag,rqsj)"
+ "select RMES_ID,COMPANY_CODE,PLINE_CODE,SN,SN_FLAG,'" + theUserCode + "','DEL',SYSDATE from CODE_SN_RESERVE WHERE COMPANY_CODE = '" + theCompanyCode + "' and SN = '" + strSN + "')";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
//修改
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxComboBox;
ASPxComboBox uPD = ASPxGridView2.FindEditFormTemplateControl("txtPD") as ASPxComboBox;
string strJX = uJX.Value.ToString();
string strPD = uPD.Value.ToString();
//插入到日志表
try
{
string Sql2 = "INSERT INTO JWYF_LOG (JXREMARK,PANDUAN,user_code,flag,rqsj)"
+ " SELECT JXREMARK,PANDUAN,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM JWYF WHERE PANDUAN = '" + strPD + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string Sql = "UPDATE JWYF SET PANDUAN='" + strPD + "',INPUT_PERSON='" + theUserId + "',INPUT_TIME=SYSDATE"
+ " WHERE JXREMARK='" + strJX + "'";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO JWYF_LOG (JXREMARK,PANDUAN,user_code,flag,rqsj)"
+ " SELECT JXREMARK,PANDUAN,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM JWYF WHERE PANDUAN = '" + strPD + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
//修改
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox uPCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uSN = ASPxGridView2.FindEditFormTemplateControl("txtSN") as ASPxTextBox;
ASPxComboBox uSNflag = ASPxGridView2.FindEditFormTemplateControl("ASPxComboBox3") as ASPxComboBox;
string strPCode = uPCode.Value.ToString();
string strSN = uSN.Text.Trim();
string strSNflag = uSNflag.Value.ToString();
string Sql = "UPDATE CODE_SN_RESERVE SET PLINE_CODE='" + strPCode + "',SN='" + strSN + "',SN_FLAG='" + strSNflag + "' "
+ " WHERE COMPANY_CODE = '" + theCompanyCode + "' and SN = '" + strSN + "'";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox uPCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uSN = ASPxGridView2.FindEditFormTemplateControl("txtSN") as ASPxTextBox;
ASPxComboBox uSNflag = ASPxGridView2.FindEditFormTemplateControl("ASPxComboBox3") as ASPxComboBox;
string strPCode = uPCode.Value.ToString();
string strSN = uSN.Text.Trim();
string strSNflag = uSNflag.Value.ToString();
string Sql = "INSERT INTO CODE_SN_RESERVE (RMES_ID,COMPANY_CODE,PLINE_CODE,SN,SN_FLAG) "
+ "VALUES(SEQ_RMES_ID.NextVal, '" + theCompanyCode + "','" + strPCode + "','" + strSN + "','" + strSNflag + "')";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
//新增
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox zcdm = ASPxGridView2.FindEditFormTemplateControl("txtZCDM") as ASPxTextBox;
ASPxComboBox scxdm = ASPxGridView2.FindEditFormTemplateControl("comboSCXDM") as ASPxComboBox;
ASPxTextBox fdjxl = ASPxGridView2.FindEditFormTemplateControl("txtFDJXL") as ASPxTextBox;
string Sql = "INSERT INTO ATPUFZZCB (ZCDM,SCXDM,FDJXL,INPUT_PERSON,INPUT_TIME) "
+ " VALUES ( UPPER('" + zcdm.Value.ToString() + "'),UPPER('" + scxdm.Value.ToString() + "'),UPPER('" + fdjxl.Value.ToString() + "'),'" + theUserId + "',SYSDATE) ";
dc.ExeSql(Sql);
//插入日志表161103
string sql2 = "insert into ATPUFZZCB_LOG(ZCDM,SCXDM,FDJXL,USER_CODE,FLAG_LOG,RQSJ) "
+ "VALUES(UPPER('" + zcdm.Value.ToString() + "'),UPPER('" + scxdm.Value.ToString() + "'),UPPER('" + fdjxl.Value.ToString() + "'),"
+ "'" + theUserId + "','ADD',SYSDATE)";
dc.ExeSql(sql2);
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition2();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox uGxdm = ASPxGridView2.FindEditFormTemplateControl("txtGxdm") as ASPxComboBox;
ASPxTextBox uPath = ASPxGridView2.FindEditFormTemplateControl("txtPath") as ASPxTextBox;
ASPxTextBox uCzts = ASPxGridView2.FindEditFormTemplateControl("txtCzts") as ASPxTextBox;
string gxdm = uGxdm.Text.Trim();
string path = uPath.Text.Trim();
string czts = uCzts.Text.Trim();
string Gsql = "select plan_so,pline_code from data_plan where plan_code='" + ASPxTextPlanCode.Text.Trim() + "'";
DataTable Gdt = dc.GetTable(Gsql);
string so = "", gzdd = "";
if (Gdt.Rows.Count > 0)
{
so = Gdt.Rows[0][0].ToString();
gzdd = Gdt.Rows[0][1].ToString();
}
//插入到日志表
string Lsql = "insert into RST_ATPU_ZJTS_LOG(PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT,EDIT_USER,EDIT_FLAG,EDIT_DATE) "
+ "VALUES( 'LSCS', '" + czts + "','" + gxdm + "','" + gzdd + "','" + ASPxTextPlanCode.Text.Trim() + "','" + so + "','C',sysdate,'" + path + "','','','" + theUserName + "','ADD',sysdate)";
dc.ExeSql(Lsql);
//到正式表
string Sql = "INSERT INTO RST_ATPU_ZJTS (PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT) "
+ "VALUES( 'LSCS', '" + czts + "','" + gxdm + "','" + gzdd + "','" + ASPxTextPlanCode.Text.Trim() + "','" + so + "','C',sysdate,'" + path + "','','')";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView2.CancelEdit();
//if (Session["inv9501sql"] as string != "")
//{
// DataTable dt2 = dc.GetTable(Session["inv9501sql"] as string);
// ASPxGridView2.DataSource = dt2;
// ASPxGridView2.DataBind();
//}
SetCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox uPCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uSN = ASPxGridView2.FindEditFormTemplateControl("txtSN") as ASPxTextBox;
ASPxComboBox uSNflag = ASPxGridView2.FindEditFormTemplateControl("ASPxComboBox3") as ASPxComboBox;
string strPCode = uPCode.Value.ToString();
string strSN = uSN.Text.Trim();
string strSNflag = uSNflag.Value.ToString();
//取RMES_ID的值
string sql_rmes_id = "SELECT SEQ_RMES_ID.NEXTVAL FROM DUAL ";
dc.setTheSql(sql_rmes_id);
string rmes_id = dc.GetTable().Rows[0][0].ToString();
string Sql = "INSERT INTO CODE_SN_RESERVE (RMES_ID,COMPANY_CODE,PLINE_CODE,SN,SN_FLAG,input_person,input_time) "
+ "VALUES('" + rmes_id + "', '" + theCompanyCode + "','" + strPCode + "','" + strSN + "','" + strSNflag + "','" + theUserId + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO CODE_SN_RESERVE_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,SN,SN_FLAG,user_code,flag,rqsj)"
+ "select RMES_ID,COMPANY_CODE,PLINE_CODE,SN,SN_FLAG,'" + theUserCode + "','ADD',SYSDATE from CODE_SN_RESERVE where rmes_id='" + rmes_id + "')";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox uLJLB = ASPxGridView2.FindEditFormTemplateControl("ComboLJLB") as ASPxComboBox;
ASPxTextBox uLJDM = ASPxGridView2.FindEditFormTemplateControl("TextLJDM") as ASPxTextBox;
ASPxTextBox uLJMC = ASPxGridView2.FindEditFormTemplateControl("TextLJMC") as ASPxTextBox;
ASPxTextBox uLJJC = ASPxGridView2.FindEditFormTemplateControl("TextLJJC") as ASPxTextBox;
ASPxTextBox uLJGG = ASPxGridView2.FindEditFormTemplateControl("TextLJGG") as ASPxTextBox;
ASPxTextBox uLJDW = ASPxGridView2.FindEditFormTemplateControl("TextLJDW") as ASPxTextBox;
string strLJLB = uLJLB.Value.ToString();
string strLJDM = uLJDM.Text.Trim();
string strLJMC = uLJMC.Text.Trim();
string strLJJC = uLJJC.Text.Trim();
string strLJGG = uLJGG.Text.Trim();
string strLJDW = uLJDW.Text.Trim();
string Sql = "INSERT INTO DMFJBZB (LJDM,LJMC,LJJC,LJGG,LJDW,LJLB,INPUT_PERSON,INPUT_TIME) "
+ "VALUES('" + strLJDM + "', '" + strLJMC + "','" + strLJJC + "','" + strLJGG + "','" + strLJDW + "','" + strLJLB + "','" + theUserCode + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO DMFJBZB_LOG (LJDM,LJMC,LJJC,LJGG,LJDW,LJLB,user_code,flag,rqsj)"
+ " SELECT LJDM,LJMC,LJJC,LJGG,LJDW,LJLB,'" + theUserCode + "' , 'ADD', SYSDATE FROM DMFJBZB WHERE LJDM = '" + strLJDM + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
