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