/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_OnClick(object sender, EventArgs e) { if (ddlYear.SelectedIndex == 0 || ddlMoth.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择年月!');", true); return; } string sqlifsc = "select * from OM_GZHSB where GZ_YEARMONTH='" + ddlYear.SelectedValue.ToString().Trim() + "-" + ddlMoth.SelectedValue.ToString().Trim() + "' and OM_GZSCBZ='1'"; System.Data.DataTable dtifsc = DBCallCommon.GetDTUsingSqlText(sqlifsc); if (dtifsc.Rows.Count > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('该月已生成工资,不能修改!!!');", true); return; } if (action == "update") { List <string> sqllist = new List <string>(); sqllist.Clear(); sqllist.Add("update OM_GZQD set QD_YEARMONTH='" + ddlYear.SelectedValue.ToString().Trim() + "-" + ddlMoth.SelectedValue.ToString().Trim() + "',QD_QFBS='" + txtQD_QuFen.Text.Trim() + "', QD_JCGZ=" + CommonFun.ComTryDecimal(txtQD_JCGZ.Text.Trim()) + ", QD_GZGL=" + CommonFun.ComTryDecimal(txtQD_GZGL.Text.Trim()) + ", QD_GDGZ=" + CommonFun.ComTryDecimal(txtQD_GDGZ.Text.Trim()) + ", QD_JXGZ=" + CommonFun.ComTryDecimal(txtQD_JXGZ.Text.Trim()) + ", QD_JiangLi=" + CommonFun.ComTryDecimal(txtQD_JiangLi.Text.Trim()) + ", QD_BingJiaGZ=" + CommonFun.ComTryDecimal(txtQD_BingJiaGZ.Text.Trim()) + ", QD_JiaBanGZ=" + CommonFun.ComTryDecimal(txtQD_JiaBanGZ.Text.Trim()) + ",QD_BFJB=" + CommonFun.ComTryDecimal(txtQD_BFJB.Text.Trim()) + ",QD_ZYBF=" + CommonFun.ComTryDecimal(txtQD_ZYBF.Text.Trim()) + ",QD_BFZYB=" + CommonFun.ComTryDecimal(txtQD_BFZYB.Text.Trim()) + ",QD_NianJiaGZ=" + CommonFun.ComTryDecimal(txtQD_NianJiaGZ.Text.Trim()) + ",QD_YKGW=" + CommonFun.ComTryDecimal(txtQD_YKGW.Text.Trim()) + ",QD_TZBF=" + CommonFun.ComTryDecimal(txtQD_TZBF.Text.Trim()) + ",QD_TZBK=" + CommonFun.ComTryDecimal(txtQD_TZBK.Text.Trim()) + ",QD_QTFY=" + CommonFun.ComTryDecimal(txtQD_QTFY.Text.Trim()) + ",QD_JTBT=" + CommonFun.ComTryDecimal(txtQD_JTBT.Text.Trim()) + ",QD_FSJW=" + CommonFun.ComTryDecimal(txtQD_FSJW.Text.Trim()) + ",QD_CLBT=" + CommonFun.ComTryDecimal(txtQD_CLBT.Text.Trim()) + ",QD_YLBX=" + CommonFun.ComTryDecimal(txtQD_YLBX.Text.Trim()) + ",QD_SYBX=" + CommonFun.ComTryDecimal(txtQD_SYBX.Text.Trim()) + ",QD_YiLiaoBX=" + CommonFun.ComTryDecimal(txtQD_YiLiaoBX.Text.Trim()) + ",QD_DEJZ=" + CommonFun.ComTryDecimal(txtQD_DEJZ.Text.Trim()) + ",QD_BuBX=" + CommonFun.ComTryDecimal(txtQD_BuBX.Text.Trim()) + ",QD_GJJ=" + CommonFun.ComTryDecimal(txtQD_GJJ.Text.Trim()) + ",QD_BGJJ=" + CommonFun.ComTryDecimal(txtQD_BGJJ.Text.Trim()) + ",QD_KOUXIANG=" + CommonFun.ComTryDecimal(txtQD_KOUXIANG.Text.Trim()) + ",QD_ShuiDian=" + CommonFun.ComTryDecimal(txtQD_ShuiDian.Text.Trim()) + ",QD_GeShui=" + CommonFun.ComTryDecimal(txtQD_GeShui.Text.Trim()) + ",QD_NOTE='" + tbnote.Text.Trim() + "' where QD_ID=" + CommonFun.ComTryInt(lbQD_ID.Text.ToString().Trim()) + ""); DBCallCommon.ExecuteTrans(sqllist); updategeshui(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('修改成功!');", true); Response.Redirect("OM_GZQDJS.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { List <string> sql_list = new List <string>(); for (int i = 0; i < rptProNumCost.Items.Count; i++) { string Id = ((System.Web.UI.WebControls.Label)rptProNumCost.Items[i].FindControl("lblId")).Text.Trim(); string scoreHp = ((System.Web.UI.WebControls.TextBox)rptProNumCost.Items[i].FindControl("txtScoreHP")).Text.Trim(); string txtlScoreLD = ((System.Web.UI.WebControls.TextBox)rptProNumCost.Items[i].FindControl("txtlScoreLD")).Text.Trim(); string lblScoreZong = ((HtmlInputHidden)rptProNumCost.Items[i].FindControl("hidScoreZong")).Value.Trim(); string txtNote = ((System.Web.UI.WebControls.TextBox)rptProNumCost.Items[i].FindControl("txtNote")).Text.Trim(); //Id, Kh_Year, Kh_Month, Kh_ScoreHP, Kh_ScoreLD, Kh_ScoreTotal, Kh_BL, Kh_Id, Kh_BeiZhu, ST_NAME, ST_SEQUEN, ST_GENDER, DEP_NAME, POSITION, ST_WORKNO string sqlText = "update TBDS_KaoHeTotal set Kh_ScoreHP=" + CommonFun.ComTryDecimal(scoreHp) + ",Kh_ScoreLD=" + CommonFun.ComTryDecimal(txtlScoreLD) + ",Kh_ScoreTotal=" + CommonFun.ComTryDecimal(lblScoreZong) + ",Kh_BeiZhu='" + txtNote + "' where Id='" + Id + "'"; sql_list.Add(sqlText); } //更新 DBCallCommon.ExecuteTrans(sql_list); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('数据已保存!!!');", true); sql_list.Clear(); bindGrid(); } //删除功能建议在使用时隐藏
//保存 protected void btnsave_Click(object sender, EventArgs e) { List <string> listsql = new List <string>(); string sqltext = ""; string shenpibh = ""; if (txt_content.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请输入权限变更内容!');", true); return; } if (action == "add") { shenpibh = "JP" + DateTime.Now.ToString("yyyyMMddHHmmss").Trim() + "" + Session["UserID"].ToString().Trim() + ""; } else { shenpibh = auditno; } if (action == "add") { sqltext = "insert into PowerContent(contentno,stid,stname,fankui,powercontent) values('" + shenpibh + "','" + stid.Text.Trim() + "','" + stname.Text.Trim() + "','否','" + txt_content.Text.Trim() + "')"; listsql.Add(sqltext); sqltext = "insert into AuditNew(auditno,audittype,addpername,addperid,addtime) values('" + shenpibh + "','" + audittitle.Text.Trim() + "','" + Session["UserName"].ToString().Trim() + "','" + Session["UserID"].ToString().Trim() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim() + "')";//不需要修改 listsql.Add(sqltext); } else if (action == "edit") { sqltext = "update PowerContent set fankui='否',powercontent='" + txt_content.Text.Trim() + "' where contentno='" + shenpibh + "'"; listsql.Add(sqltext); } DBCallCommon.ExecuteTrans(listsql); Response.Redirect("~/OM_Data/PowerAudit.aspx?action=edit&auditno=" + shenpibh); }
//删除房间号 protected void btnfjh_click(object sender, EventArgs e) { List <string> sqltextlist = new List <string>(); int num = 0; foreach (RepeaterItem rptitem in rptsushe.Items) { System.Web.UI.WebControls.CheckBox CKBOX_SELECT = (System.Web.UI.WebControls.CheckBox)rptitem.FindControl("CKBOX_SELECT"); if (CKBOX_SELECT.Checked == true) { num++; } } if (num == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择要删除的数据!');", true); return; } foreach (RepeaterItem rptitem in rptsushe.Items) { System.Web.UI.WebControls.CheckBox CKBOX_SELECT = (System.Web.UI.WebControls.CheckBox)rptitem.FindControl("CKBOX_SELECT"); System.Web.UI.WebControls.Label housenum = (System.Web.UI.WebControls.Label)rptitem.FindControl("housenum"); if (CKBOX_SELECT.Checked == true) { string sqldelete1 = "delete from OM_SUSHE where housenum='" + housenum.Text.Trim() + "'"; string sqldelete2 = "delete from OM_SSDEtail where SUSHEnum='" + housenum.Text.Trim() + "'"; sqltextlist.Add(sqldelete1); sqltextlist.Add(sqldelete2); } } DBCallCommon.ExecuteTrans(sqltextlist); UCPaging1.CurrentPage = 1; bindrpt(); danyuangehebing(); }
protected void btnDelete_onserverclick(object sender, EventArgs e) { List <string> list = new List <string>(); for (int i = 0, length = rptZPJH.Items.Count; i < length; i++) { CheckBox cbx = (CheckBox)rptZPJH.Items[i].FindControl("cbxXuHao"); if (cbx.Checked) { string JH_ID = ((HiddenField)rptZPJH.Items[i].FindControl("JH_ID")).Value; string sql = "update OM_ZPJH set JH_SFCL='b' where JH_ID=" + JH_ID; list.Add(sql); } } if (list.Count == 0) { Response.Write("<script>alert('请勾选一条进行处理!!!')</script>"); return; } try { DBCallCommon.ExecuteTrans(list); } catch { Response.Write("<script>alert('删除的语句出现问题,请与管理员联系!!!')</script>"); return; } bindrpt(); }
//任务预算编制更新 public void Repeater1_ItemCommand(object sender, RepeaterCommandEventArgs e) { if (e.CommandName == "change") { // string task_code = ((LinkButton)sender).CommandArgument + "";//获取传递的任务号 string task_code = e.CommandArgument + ""; List <string> listsql = new List <string>(); //listsql.Add(string.Format("DELETE FROM dbo.YS_TASK_BUDGET WHERE task_code='{0}';", tsaId));//删除任务预算表内的信息 listsql.Add(string.Format("DELETE FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='{0}';", task_code)); //删除历史表内的信息 //listsql.Add(string.Format("DELETE FROM dbo.YS_NODE_INSTANCE WHERE task_code='{0}';", tsaId));//删除node实例表中的信息 listsql.Add(getInsertIntoHistoryInfoTableSqltext(task_code)); //向历史表重新插入信息 // listsql.Add(getInsertIntoTaskBudgetTableSqltext(tsaId));//向任务预算表重新插入信息 //listsql.Add(string.Format("UPDATE dbo.TBPM_TCTSASSGN SET TSA_BUDGET_DATETIME=GETDATE() WHERE TSA_ID='{0}';", tsaId));//更新任务表中预算提交的时间 //DBCallCommon.ExecuteTrans(listsql); //listsql.Clear(); //string[] ids = new string[] { ConfigurationSettings.AppSettings["BudgetEditorId"] };//配置文件中读取预算编制人id //BudgetFlowEngine.activeFollowNode(tsaId, "0", ids);//向node实例表中插入第一个实例 //更新任务预算表 string sqlText = " SELECT TOP 1 '" + task_code + "', CM_CONTR, CM_PROJ , TSA_ENGNAME ,( SELECT BM_TUTOTALWGHT FROM TBPM_STRINFODQO WHERE BM_ZONGXU='1' AND BM_ENGID='" + task_code + "'), ( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code LIKE '01.07%'),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code LIKE '01.11%'),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code LIKE '01.15%'),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code LIKE '01.03%'),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND (material_code LIKE '01.08%' OR material_code LIKE '01.09%')),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code NOT LIKE '01.07%' AND material_code NOT LIKE '01.11%' AND material_code NOT LIKE '01.15%' AND material_code NOT LIKE '01.03%' AND material_code NOT LIKE '01.08%' AND material_code NOT LIKE '01.09%'), GETDATE(), 1,( SELECT TSA_CONTYPE FROM TBPM_TCTSASSGN WHERE TSA_ID='" + task_code + "' ) FROM dbo.View_TM_TaskAssign WHERE TSA_ID = '" + task_code + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText); ////任务预算编制更新的时间和人员以及更新的各种材料价格 listsql.Add(string.Format("UPDATE dbo.YS_TASK_BUDGET SET task_weight= '{0}',ys_ferrous_metal_dep='{1}',ys_ferrous_metal='{1}', ys_purchase_part_dep='{2}',ys_purchase_part='{2}', ys_paint_coating_dep='{3}',ys_paint_coating='{3}',ys_electrical_dep='{4}', ys_electrical='{4}', ys_casting_forging_dep='{5}',ys_casting_forging_cost='{5}',ys_othermat_cost_dep='{6}',ys_othermat_cost='{6}',change_time=GETDATE(),change_name='" + Session["UserName"] + "' WHERE task_code='{7}';", dt.Rows[0][4].ToString(), dt.Rows[0][5].ToString(), dt.Rows[0][6].ToString(), dt.Rows[0][7].ToString(), dt.Rows[0][8].ToString(), dt.Rows[0][9].ToString(), dt.Rows[0][10].ToString(), task_code)); DBCallCommon.ExecuteTrans(listsql); listsql.Clear(); tb = new YS_Data.Model.TaskBudget(task_code); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提交成功!');window.location='ys_task_budget_change.aspx'", true); } }
protected void btnPush_OnClick(object sender, EventArgs e) { List <string> sqllist = new List <string>(); string sql = "UPDATE EQU_Part_Store SET State=''"; sqllist.Add(sql); string name = ""; string Type = ""; for (int i = 0; i < Repeater1.Items.Count; i++) { if (((CheckBox)Repeater1.Items[i].FindControl("CheckBox1")).Checked == true) { name = ((Label)Repeater1.Items[i].FindControl("lblName")).Text; Type = ((Label)Repeater1.Items[i].FindControl("lblType")).Text; sql = "UPDATE EQU_Part_Store SET State='1' WHERE ParName='" + name + "' AND ParType='" + Type + "'";//到备件领料单界面 sqllist.Add(sql); } } if (sqllist.Count < 2) { string alert = "<script>alert('请选择下推条目!!!')</script>"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", alert, false); return; } DBCallCommon.ExecuteTrans(sqllist); Response.Redirect("EQU_Part_Outbill.aspx?FLAG=PUSH"); }
//审核驳回 protected void btnshreject_Click(object sender, EventArgs e) { List <string> sqlshbh = new List <string>(); string fpbh = txtfpbh.Text.Trim(); string sqlgetjhgzh = "select YFGJ_JHGZH from TBFM_YFFPDETAIL where YFGJ_FPID='" + fpbh + "'"; DataTable dtjhgzh = DBCallCommon.GetDTUsingSqlText(sqlgetjhgzh); //获取该发票编号的计划跟踪号 string sqlrelationshstate = "update TBFM_YFFPDETAIL set YFGJ_SHSTATE='0',YFGJ_SHRNAME='',YFGJ_SHRID='' where YFGJ_FPID='" + fpbh + "'"; //勾稽关系表状态更改 string sqltotalshstate = "update TBFM_YFFPTOTAL set YFGI_STATE='0' where YFGI_CODE='" + fpbh + "'"; //发票总表状态更改 for (int i = 0; i < dtjhgzh.Rows.Count; i++) { string jhgzh = dtjhgzh.Rows[i]["YFGJ_JHGZH"].ToString(); string sqljsdstate = "update PM_CPFYJSD set JS_GJSTATE='1' where JS_JHGZH='" + jhgzh + "'"; sqlshbh.Add(sqljsdstate); }//结算单 sqlshbh.Add(sqlrelationshstate);//勾稽关系表 sqlshbh.Add(sqltotalshstate);//发票总表 DBCallCommon.ExecuteTrans(sqlshbh); btnbaocunxg.Visible = true; btnshpass.Visible = true; btnshreject.Visible = false; btngjpass.Visible = false; btngjreject.Visible = false; this.BindInvrpt(yfgicode); this.BindInvHead(yfgicode); }
//勾稽驳回 protected void btngjreject_Click(object sender, EventArgs e) { List <string> sqlgjbh = new List <string>(); string gjyear = DateTime.Now.Year.ToString(); string gjmonth = DateTime.Now.Month.ToString(); string gjdate = DateTime.Now.ToString("yyyy-MM-dd"); if (Convert.ToInt32(gjmonth) < 10) { gjmonth = "0" + gjmonth; } string fpbh = txtfpbh.Text.Trim(); string sqlgetjhgzh = "select YFGJ_JHGZH from TBFM_YFFPDETAIL where YFGJ_FPID='" + fpbh + "'"; DataTable dtjhgzh = DBCallCommon.GetDTUsingSqlText(sqlgetjhgzh); //获取该发票编号的计划跟踪号 string sqlrelationshstate = "update TBFM_YFFPDETAIL set YFGJ_MONTH='',YFGJ_YEAR='',YFGJ_GJDATE='',YFGJ_GJRNAME='',YFGJ_GJRID='' where YFGJ_FPID='" + fpbh + "'"; //勾稽关系表时间信息更改 string sqltotalshstate = "update TBFM_YFFPTOTAL set YFGI_GJFLAG='0' where YFGI_CODE='" + fpbh + "'"; //发票总表状态更改 for (int i = 0; i < dtjhgzh.Rows.Count; i++) { string jhgzh = dtjhgzh.Rows[i]["YFGJ_JHGZH"].ToString(); string sqljsdstate = "update PM_CPFYJSD set JS_GJSTATE='2' where JS_JHGZH='" + jhgzh + "'"; sqlgjbh.Add(sqljsdstate); }//结算单 sqlgjbh.Add(sqlrelationshstate);//勾稽关系表 sqlgjbh.Add(sqltotalshstate);//发票总表 DBCallCommon.ExecuteTrans(sqlgjbh); btnbaocunxg.Visible = false; btnshpass.Visible = false; btnshreject.Visible = true; btngjpass.Visible = true; btngjreject.Visible = false; this.BindInvrpt(yfgicode); this.BindInvHead(yfgicode); }
public void BuBJ() { List <string> sqllist = new List <string>(); string data = Request.Form["data"].ToString(); JArray ja = (JArray)JsonConvert.DeserializeObject(data); foreach (JObject Jobj in ja) { string sql = "update TBPM_STRINFODQO set BM_YFNUM=BM_YFNUM+" + Jobj["bjnum"].ToString() + " where BM_ID='" + Jobj["pid"].ToString().Split('|')[0] + "' and BM_ZONGXU='" + Jobj["zongxu"] + "'"; sqllist.Add(sql); // sql = "update a set CM_YBJNUM=CM_YBJNUM+" + Jobj["bjnum"].ToString() + " from TBCM_FHBASIC as a left join TBCM_FHNOTICE as b on a.CM_FID=b.CM_FID where CM_ID='" + Jobj["pid"].ToString().Split('|')[0] + "' and ID='" + Jobj["zongxu"] + "' and b.CM_BIANHAO='" + Jobj["bianhao"] + "'"; sqllist.Add(sql); } foreach (JObject Jobj in ja) { string sql1 = "update TBPM_STRINFODQO set BM_FHSTATE=case when BM_YFNUM<BM_NUMBER then '4' else '2' end where BM_ENGID='" + Jobj["tsaid"].ToString() + "' and BM_ZONGXU='" + Jobj["zongxu"] + "'"; sqllist.Add(sql1); sql1 = "update TBCM_FHBASIC set CM_BJZT=case when CM_YBJNUM< CM_FHNUM then '4' else '2' end where CM_ID='" + Jobj["pid"].ToString().Split('|')[0] + "' and ID='" + Jobj["zongxu"] + "'"; sqllist.Add(sql1); } result = "{\"msg\":\"操作成功!\"}"; try { DBCallCommon.ExecuteTrans(sqllist); } catch (Exception) { result = "{\"msg\":\"数据错误,请联系管理员\"}"; } Response.Write(result); }
protected void btnDelete_OnClick(object sender, EventArgs e) { List <string> list = new List <string>(); foreach (GridViewRow grow in GridView1.Rows) { CheckBox chk = (CheckBox)grow.FindControl("CHK"); if (chk.Checked) { string code = ((Label)grow.FindControl("lblCode")).Text; string sqltext = "delete from TBOM_GDZCPCAPPLY where CODE='" + code + "'"; list.Add(sqltext); sqltext = "delete from TBOM_GDZCRVW where CODE='" + code + "'"; list.Add(sqltext); } } if (list.Count > 0) { DBCallCommon.ExecuteTrans(list); this.ReGetBoundData(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('删除成功!!!');", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请勾选要删除的行!!!');", true); } }
protected void btn_save_Click(object sender, EventArgs e) { List <string> sql_list = new List <string>(); List <string> sql = new List <string>(); string str_up = "update TBPM_SCWXRVW set PM_JHQ='" + tb_jhq.Text + "' where PM_DocuNum='" + tb_doc.Text.ToString() + "'"; sql.Add(str_up); //string str_up1 = "update TBPM_SCWXRVW set PM_SPZT='0' where PM_DocuNum='" + tb_doc.Text.ToString() + "'"; //sql.Add(str_up1); foreach (RepeaterItem LabelID in tbpc_otherpurbill_lookRepeater.Items) { Label lb_zj = ((Label)LabelID.FindControl("lb_zj")); TextBox MS_PROCESS = ((TextBox)LabelID.FindControl("MS_PROCESS")); TextBox MS_BZ = ((TextBox)LabelID.FindControl("MS_BZ")); string id = ((Label)LabelID.FindControl("lb_id")).Text; int num = Convert.ToInt32(((TextBox)LabelID.FindControl("MS_NUM")).Text); double f_wght = Convert.ToDouble(((Label)LabelID.FindControl("MS_TUWGHT")).Text); double f_totalwght = num * f_wght; // string totalnum = ((Label)LabelID.FindControl("lab_num")).Text; //if (Convert.ToInt32(num) <= Convert.ToInt32(totalnum))//外协的数量小于等于总数量 //{ string sqltext = "update TBPM_WXDetail set MS_PROCESS='" + MS_PROCESS.Text + "',MS_NUM=" + num + ",MS_TUTOTALWGHT=" + f_totalwght + ", MS_XHBZ='" + MS_BZ.Text + "',MS_scwaixie='1' WHERE MS_ID='" + lb_zj.Text.Trim() + "' and MS_PID='" + tb_pid.Text.ToString() + "'and ID='" + id + "'"; sql.Add(sqltext); } DBCallCommon.ExecuteTrans(sql); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('保存成功!!!');window.location=window.location;", true); }
protected void btnSave_onserverclick(object sender, EventArgs e) { List <string> list = new List <string>(); for (int i = 0, length = rptRYPZ.Items.Count; i < length; i++) { CheckBox cbx = (CheckBox)rptRYPZ.Items[i].FindControl("cbxXuHao"); if (cbx.Checked) { string ST_POSITION = ((HiddenField)rptRYPZ.Items[i].FindControl("ST_POSITION")).Value; string DEP_PZSR = ((TextBox)rptRYPZ.Items[i].FindControl("DEP_PZSR")).Text.Trim(); string sql = "update TBDS_DEPINFO set DEP_PZRS=" + DEP_PZSR + " where DEP_CODE='" + ST_POSITION + "'"; list.Add(sql); } } if (list.Count == 0) { Response.Write("<script>alert('请勾选需要修改的数据行!!!')</script>"); return; } try { DBCallCommon.ExecuteTrans(list); } catch { Response.Write("<script>alert('保存的语句出现问题!!!请与管理员联系')</script>"); return; } bindrpt(); }
//删除选中行 protected void btndelete_Click(object sender, EventArgs e) { //需要删除的ID int num = 0; List <string> sqls = new List <string>(); for (int i = 0; i < GridView1.Rows.Count; i++) { GridViewRow gr = GridView1.Rows[i]; CheckBox chk = (CheckBox)gr.FindControl("CheckBox1"); if (chk.Checked) { string hidID = ((HtmlInputHidden)this.GridView1.Rows[i].FindControl("hidID")).Value.Trim(); //物料代码 string sql = "DELETE FROM TBOM_BGYPPCAPPLYINFO where ID='" + hidID + "'"; sqls.Add(sql); num++; } } //如果有删除的行 if (num != 0) { //执行删除操作 DBCallCommon.ExecuteTrans(sqls); Binddata_add(); } else { Response.Write("<script>alert('请选中删除行!')</script>"); } }
//删除当前单据,删除单据前判断是否满足删除单据条件,删除单据后关闭当前页面。 protected void DeleteBill_Click(object sender, EventArgs e) { if (LabelState.Text == "1") { List <string> sqllist = new List <string>(); string sql = "DELETE FROM TBWS_OUT WHERE OP_CODE='" + LabelCode.Text + "'"; sqllist.Add(sql); sql = "DELETE FROM TBWS_OUTDETAIL WHERE OP_CODE='" + LabelCode.Text + "'"; sqllist.Add(sql); DBCallCommon.ExecuteTrans(sqllist); string script = @"window.close();"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "error", script, true); return; } else if (LabelState.Text == "0") { string script = @"alert('当前出库单尚未保存!');"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "error", script, true); return; } }
protected void btnqr_OnClick(object sender, EventArgs e) { int count = 0; string ptcode = ""; List <string> list = new List <string>(); for (int i = 0; i < rptProNumCost.Items.Count; i++) { if ((rptProNumCost.Items[i].FindControl("CKBOX_SELECT") as CheckBox).Checked) { count++; ptcode = ((Label)rptProNumCost.Items[i].FindControl("ptcode")).Text; string sql = "update TBPC_PURCHASEPLAN set PUR_CKQR='1' where PUR_PTCODE='" + ptcode + "'"; list.Add(sql); } } if (count > 0) { DBCallCommon.ExecuteTrans(list); } else { ClientScript.RegisterStartupScript(this.GetType(), "myscript", "<script type='text/javascript'>alert('请选择要确认的项!')</script>"); return; } this.InitVar(); this.bindGrid(); }
//核算 protected void btnHS_Click(object sender, EventArgs e) { List <string> list_rwh = new List <string>(); for (int i = 0; i < rptProNumCost.Items.Count; i++) { if (((CheckBox)rptProNumCost.Items[i].FindControl("checkbox")).Checked) { list_rwh.Add(((Label)rptProNumCost.Items[i].FindControl("lbrwh")).Text); } } if (list_rwh.Count > 0) { string b = CheckOutAct(list_rwh); if (b == "") { List <string> sql = new List <string>(); for (int k = 0; k < list_rwh.Count; k++) { string hsrwh = list_rwh[k].ToString(); string sqlcwhs = update_cwcb(hsrwh); sql.Add(sqlcwhs); } DBCallCommon.ExecuteTrans(sql); } } else { this.ClientScript.RegisterStartupScript(GetType(), "js", "alert('请勾选要核算的任务号!!!')", true); } UCPaging1.CurrentPage = 1; this.InitVar(); this.bindGrid(); }
protected void btnTransf_click(object sender, EventArgs e) { List <string> list = new List <string>(); string sqltxt = "DELETE FROM OM_CAR_ZZB"; list.Add(sqltxt); for (int i = 0; i < Repeater1.Items.Count; i++) { if (((CheckBox)Repeater1.Items[i].FindControl("CheckBox1")).Checked == true) { string kc_mc = ((Label)Repeater1.Items[i].FindControl("lblbh")).Text; string kc_gg = ((Label)Repeater1.Items[i].FindControl("lblName")).Text; string kc_danwei = ((Label)Repeater1.Items[i].FindControl("lbdanwei")).Text; string kc_danjia = ((Label)Repeater1.Items[i].FindControl("lbdanjia")).Text; sqltxt = "insert into OM_CAR_ZZB (SP_MC,SP_GG,SP_DJ,SP_DANWEI) VALUES ('" + kc_mc + "','" + kc_gg + "','" + kc_danjia + "','" + kc_danwei + "')"; list.Add(sqltxt); } } if (list.Count == 1) { Response.Write("<script>alert('请勾选序号后后再出库!!!')</script>"); } else { DBCallCommon.ExecuteTrans(list); Response.Redirect("OM_CARCK_detail.aspx?FLAG=add&id=1"); } }
/// <summary> /// 作废:改变审核表中的状态 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void hlDelete_OnClick(object sender, EventArgs e) { string lotnum = ((LinkButton)sender).CommandName; string engid = lotnum.Split('.')[0]; string tablenameOrg = this.GetOrgTableNameByLotNum(lotnum); List <string> list_sql = new List <string>(); if (lotnum.Contains(" WXBG/"))//变更驳回 { //变更外协审核表:修改驳回状态 list_sql.Add(" update TBPM_OUTSCHANGERVW set OST_STATE='9' where OST_CHANGECODE='" + lotnum + "'"); //原始数据表(修改材料计划提交状态及审核状态) list_sql.Add(" update " + tablenameOrg + " set BM_OSSTATE='0' and BM_OSREVIEW='0' where BM_ENGID='" + engid + "' and BM_XUHAO in(select OSL_NEWXUHAO from TBPM_OUTSCHANGE where OST_CHANGECODE='" + lotnum + "')"); } else if (lotnum.Contains(" WX/"))//正常驳回 { //正常外协审核表:修改驳回状态 list_sql.Add(" update TBPM_OUTSOURCETOTAL set OST_STATE='9' where OST_OUTSOURCENO='" + lotnum + "'"); //原始数据表(修改外协提交状态及审核状态) list_sql.Add(" update " + tablenameOrg + " set BM_OSSTATE='0', BM_OSREVIEW='0' where BM_ENGID='" + engid + "' and BM_XUHAO in(select OSL_NEWXUHAO from TBPM_OUTSOURCELIST where OSL_OUTSOURCENO='" + lotnum + "')"); } else if (lotnum.Contains(" WXQX/"))//取消驳回 { //变更外协审核表:修改驳回状态 list_sql.Add(" update TBPM_MPCHANGERVW set OST_STATE='9' where OST_CHANGECODE='" + lotnum + "'"); } DBCallCommon.ExecuteTrans(list_sql); this.SignStatus(rblstate.SelectedValue); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('操作成功!!!');", true); }
protected void lnkDelete_OnClick(object sender, EventArgs e) { string SPBH = ((LinkButton)sender).CommandArgument; List <string> list = new List <string>(); string sqlText = "delete from OM_GDZCBFSP where SPBH='" + SPBH + "'"; list.Add(sqlText); string sql = "update TBOM_GDZCIN set BFSPBH=NULL where BFSPBH='" + SPBH + "'"; list.Add(sql); try { DBCallCommon.ExecuteTrans(list); } catch (Exception) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('数据异常,请联系管理员!!!');", true); return; } ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('删除成功!!!');", true); UCPaging1.CurrentPage = 1; bindrpt(); }
//删除功能建议在使用时隐藏 protected void btnDelete_Click(object sender, EventArgs e) { List <string> sql = new List <string>(); string sqlifsc = "select * from OM_GZHSB where GZ_YEARMONTH='" + dplYear.SelectedValue.ToString().Trim() + "-" + dplMoth.SelectedValue.ToString().Trim() + "' and OM_GZSCBZ='1'"; System.Data.DataTable dtifsc = DBCallCommon.GetDTUsingSqlText(sqlifsc); if (dtifsc.Rows.Count > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('该月已生成工资,不能删除!!!');", true); return; } string sqltext = ""; foreach (RepeaterItem LabelID in rptProNumCost.Items) { System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox)LabelID.FindControl("CKBOX_SELECT"); if (chk.Checked) { string check = ((System.Web.UI.WebControls.Label)LabelID.FindControl("lb_stid")).Text; sqltext = "delete FROM OM_SHBX WHERE SH_STID='" + check + "' and SH_DATE='" + dplYear.SelectedValue.ToString().Trim() + "-" + dplMoth.SelectedValue.ToString().Trim() + "' and symbol='X'"; sql.Add(sqltext); } } DBCallCommon.ExecuteTrans(sql); UCPaging1.CurrentPage = 1; this.InitVar(); this.bindGrid(); }
//保存 protected void save_month_max_onclick(object sender, EventArgs e) { List <string> update_sql = new List <string>(); string sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_02.Text.ToString() + "' where DEP_CODE='02' and Type='0'"; update_sql.Add(sql_update_max); sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_03.Text.ToString() + "' where DEP_CODE='03' and Type='0'"; update_sql.Add(sql_update_max); sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_04.Text.ToString() + "' where DEP_CODE='04' and Type='0'"; update_sql.Add(sql_update_max); sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_05.Text.ToString() + "' where DEP_CODE='05' and Type='0'"; update_sql.Add(sql_update_max); sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_06.Text.ToString() + "' where DEP_CODE='06' and Type='0'"; update_sql.Add(sql_update_max); sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_07.Text.ToString() + "' where DEP_CODE='07' and Type='0'"; update_sql.Add(sql_update_max); sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_10.Text.ToString() + "' where DEP_CODE='10' and Type='0'"; update_sql.Add(sql_update_max); sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_11.Text.ToString() + "' where DEP_CODE='11' and Type='0'"; update_sql.Add(sql_update_max); sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_12.Text.ToString() + "' where DEP_CODE='12' and Type='0'"; update_sql.Add(sql_update_max); DBCallCommon.ExecuteTrans(update_sql); Response.Redirect("OM_Bgyp_DingE.aspx"); }
private void writedata() { string outname; string outtype; int numstore; int outnum; string outnote; List <string> list_sql = new List <string>(); for (int i = 0; i < GridView1.Rows.Count; i++) { GridViewRow gr = GridView1.Rows[i]; outname = ((Label)gr.FindControl("lblName")).Text; outtype = ((Label)gr.FindControl("lblType")).Text; numstore = Convert.ToInt32(((TextBox)gr.FindControl("txtNumstore")).Text); outnum = Convert.ToInt32(((TextBox)gr.FindControl("txtOutNum")).Text); outnote = ((TextBox)gr.FindControl("txtOutNote")).Text; numstore -= outnum; if (outnum == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提示:无法保存!!!没有入库数据!!!');", true); return; } else { sqltext = "insert into EQU_Part_Out(OutCode,OutDep,ParName,ParType,OutNum,OutPer,OutDate,OutDoc,OutNote)"; sqltext += "values('" + lblOutCode.Text + "','" + ddlDep.SelectedValue + "','" + outname + "','" + outtype + "'," + outnum + ",'" + txt_giver.Text + "','" + lblOutDate.Text + "','" + lblOutDoc.Text + "','" + outnote + "')"; list_sql.Add(sqltext); sqltext = "update EQU_Part_Store set ParNumSto=" + numstore + " where ParName='" + outname + "'and ParType='" + outtype + "'"; list_sql.Add(sqltext); } } DBCallCommon.ExecuteTrans(list_sql); }
/// <summary> /// 创建发票,写入相关数据表中 /// </summary> private void CreateInvOpDataBase(string fpbh) { List <string> sql = new List <string>(); string fpcode = fpbh;//发票编号 string jhgzhcode = ""; //string[] arrayUniqCode = arrayJhgzh.Split('/');//计划跟踪号数组 foreach (RepeaterItem Reitem in rptProNumCost.Items) { jhgzhcode = ((Label)Reitem.FindControl("lbjhgzh")).Text.Trim().ToString(); } sql.Add(this.CreateInvTOTAL(jhgzhcode, fpcode));//发票总表,参数传递(结算单计划跟踪号(主要为从结算单获取供应商信息),发票编号) foreach (RepeaterItem Reitem in rptProNumCost.Items) { string Uniqcode = ((Label)Reitem.FindControl("lbjhgzh")).Text.Trim().ToString(); sql.Add(this.CreateJSD(Uniqcode)); //更新结算单结算状态 sql.Add(this.CreateGJrelation(Uniqcode, fpcode)); //更新勾稽关系表 } //根据发票明细上的金额更新发票总表(总金额、含税金额) string str_je = "update TBFM_WXGHINVOICETOTAL set WXGI_MONEY=(select sum(isnull(WXGJ_JE,0)) from TBFM_WXGJRELATION where WXGJ_FPID='" + fpcode + "') where WXGI_CODE='" + fpcode + "'"; string str_hsje = "update TBFM_WXGHINVOICETOTAL set WXGI_HSMONEY=(select sum(isnull(WXGJ_HSJE,0)) from TBFM_WXGJRELATION where WXGJ_FPID='" + fpcode + "') where WXGI_CODE='" + fpcode + "'"; sql.Add(str_je); sql.Add(str_hsje); DBCallCommon.ExecuteTrans(sql); }
protected void btnAll_Click(object sender, EventArgs e) { if (rptCK.Items.Count == 0) { Response.Write("<script>alert('您还未添加出库项目!!!')</script>"); return; } List <string> list = new List <string>(); //更新TBCM_CUSTOMER表 string sql = string.Format("update TBCM_CUSTOMER set CM_BTOUT='1',CM_OUTNUM='{0}',CM_OUT='{1}',CM_OUTDATE='{2}',CM_NOTE='{3}',CM_KGYUAN='{4}' where CM_ID='{5}'", ((TextBox)rptCK.Items[0].FindControl("CM_OUTNUM")).Text, ((TextBox)rptCK.Items[0].FindControl("CM_OUT")).Text, ((TextBox)rptCK.Items[0].FindControl("CM_OUTDATE")).Text, ((TextBox)rptCK.Items[0].FindControl("CM_NOTE")).Text, UserID.Value, CM_ID); list.Add(sql); //删除TBCM_CUSINFO的旧数据 sql = "delete from TBCM_CUSINFO where CM_ID='" + CM_ID + "'"; list.Add(sql); foreach (RepeaterItem item in rptCK.Items) { string cm_out = ((TextBox)item.FindControl("CM_OUT")).Text; string cm_outnum = ((TextBox)item.FindControl("CM_OUTNUM")).Text; string cm_outdate = ((TextBox)item.FindControl("CM_OUTDATE")).Text; string cm_note = ((TextBox)item.FindControl("CM_NOTE")).Text; sql = string.Format("insert into TBCM_CUSINFO (CM_ID,CM_OUT,CM_OUTNUM,CM_OUTDATE,CM_NOTE) values('{0}','{1}','{2}','{3}','{4}')", CM_ID, cm_out, cm_outnum, cm_outdate, cm_note); list.Add(sql); } try { DBCallCommon.ExecuteTrans(list); } catch { Response.Write("<script>alert('添加的sql语句出现问题,请与管理员联系!!!')</script>"); } Response.Write("<script>window.close()</script>"); }
protected void btnsave_click(object sender, EventArgs e) { List <string> list = new List <string>(); string bh = "TZ" + DateTime.Now.ToString("yyyyMMddHHmmss").Trim(); string stryearmonth = ""; for (int i = 0; i < rptProNumCost.Items.Count; i++) { Label lb_QD_YEARMONTH = (Label)rptProNumCost.Items[i].FindControl("lb_QD_YEARMONTH"); stryearmonth = lb_QD_YEARMONTH.Text.Trim(); Label lb_ST_ID = (Label)rptProNumCost.Items[i].FindControl("lb_ST_ID"); TextBox tb_GZTZ_BFJBF = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_BFJBF"); TextBox tb_GZTZ_BFZYBF = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_BFZYBF"); TextBox tb_GZTZ_BF = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_BF"); TextBox tb_GZTZ_BK = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_BK"); TextBox tb_GZTZ_NOTE = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_NOTE"); if (CommonFun.ComTryDecimal(tb_GZTZ_BK.Text.Trim()) > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('补扣应为负数!');", true); return; } string sql = "insert into OM_GZTZdetal(GZTZ_SPBH,GZTZ_YEARMONTH,GZTZ_STID,GZTZ_BFJBF,GZTZ_BFZYBF,GZTZ_BF,GZTZ_BK,GZTZ_NOTE) values('" + bh + "','" + stryearmonth + "','" + lb_ST_ID.Text.Trim() + "'," + CommonFun.ComTryDecimal(tb_GZTZ_BFJBF.Text.Trim()) + "," + CommonFun.ComTryDecimal(tb_GZTZ_BFZYBF.Text.Trim()) + "," + CommonFun.ComTryDecimal(tb_GZTZ_BF.Text.Trim()) + "," + CommonFun.ComTryDecimal(tb_GZTZ_BK.Text.Trim()) + ",'" + tb_GZTZ_NOTE.Text.Trim() + "')"; list.Add(sql); } string sqlinsertsp = "insert into OM_GZTZSP(GZTZSP_SPBH,GZTZSP_YEARMONTH,GZTZSP_SQRSTID,GZTZSP_SQRNAME,GZTZSP_SQTIME) values('" + bh + "','" + stryearmonth + "','" + Session["UserID"].ToString().Trim() + "','" + Session["UserName"].ToString().Trim() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim() + "')"; list.Add(sqlinsertsp); DBCallCommon.ExecuteTrans(list); Response.Redirect("OM_GZTZSPdetail.aspx?spid=" + bh); }
/// <summary> /// 处理材料计划驳回:驳回》驳回已处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void hlDelete_OnClick(object sender, EventArgs e) { string lotnum = ((LinkButton)sender).CommandName; string engid = lotnum.Split('.')[0]; List <string> list_sql = new List <string>(); if (lotnum.Contains("MPBG/"))//变更驳回 { //变更材料计划审核表:修改驳回状态 list_sql.Add(" update TBPM_MPCHANGERVW set MP_STATE='9' where MP_ID='" + lotnum + "'"); //原始数据表(修改材料计划提交状态及审核状态) list_sql.Add(" update TBPM_ set BM_MPSTATE='0',BM_MPREVIEW='0' where BM_ENGID='" + engid + "' and BM_XUHAO in(select MP_NEWXUHAO from TBPM_MPCHANGE where MP_PID='" + lotnum + "')"); } else if (lotnum.Contains("MP/"))//正常驳回 { //正常材料计划审核表:修改驳回状态 list_sql.Add(" update TBPM_MPFORALLRVW set MP_STATE='9' where MP_ID='" + lotnum + "'"); //原始数据表(修改材料计划提交状态及审核状态) list_sql.Add(" update TBPM_STRINFODQO set BM_MPSTATE='0', BM_MPREVIEW='0' where BM_ENGID='" + engid + "' and BM_XUHAO in(select MP_NEWXUHAO from TBPM_MPPLAN where MP_PID='" + lotnum + "')"); } else if (lotnum.Contains("MPQX/"))//取消驳回 { //变更材料计划审核表:修改驳回状态 list_sql.Add(" update TBPM_MPCHANGERVW set MP_STATE='9' where MP_ID='" + lotnum + "'"); } DBCallCommon.ExecuteTrans(list_sql); this.SignStatus(rblstate.SelectedValue); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('操作成功!!!');", true); }
protected void btnSubmit_OnClick(object sender, EventArgs e) { string uprice; string tprice; string rowid; List <string> list_sql = new List <string>(); if (price != '0') { for (int i = 0; i < GridView1.Rows.Count; i++) { GridViewRow gr = GridView1.Rows[i]; uprice = ((TextBox)gr.FindControl("txtUprice")).Text.ToString(); tprice = ((TextBox)gr.FindControl("txtTprice")).Text.ToString(); rowid = ((Label)gr.FindControl("lblid")).Text.ToString(); sqltext = "update TBOM_GDZCPCAPPLY set [UPRICE]='" + uprice + "',[TPRICE]='" + tprice + "',[SHRID]='" + shrid.Value + "',[SHR]='" + txtshr.Text + "',[STATE]=1 where [ID]='" + rowid + "'"; list_sql.Add(sqltext); } sqltext = "update TBOM_GDZCRVW set CARRVWA='" + txtshr.Text.Trim() + "',CARRVWAID='" + shrid.Value.Trim() + "',STATUS='1' where CODE='" + lblCode.Text.Trim() + "'"; list_sql.Add(sqltext); DBCallCommon.ExecuteTrans(list_sql); string _emailto = DBCallCommon.GetEmailAddressByUserID(firstid.Value); string _body = "非固定资产采购审批任务:" + "\r\n单号:" + lblCode.Text.ToString().Trim() + "\r\n制单日期:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string _subject = "您有新的【非固定资产采购】需要审批,请及时处理:" + lblCode.Text.ToString().Trim(); DBCallCommon.SendEmail(_emailto, null, null, _subject, _body); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提交成功,请等待审批!');window.location.href='OM_GdzcPcPlan.aspx'", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请填写金额!!!');", true); } }
protected void btnSave_onserverclick(object sender, EventArgs e) { if (asd.action == "add") { List <string> list = addlist(); try { DBCallCommon.ExecuteTrans(list); } catch { Response.Write("<script>alert('新增sql语句出现问题,请与管理员联系!!!')</script>"); return; } } else if (asd.action == "alter") { List <string> list = alterlist(); try { DBCallCommon.ExecuteTrans(list); } catch { Response.Write("<script>alert('修改sql语句出现问题,请与管理员联系!!!')</script>"); return; } } Response.Redirect("OM_PXXQ_GL.aspx"); }
protected void Page_Load(object sender, EventArgs e) { string CPQRInData = Request.Form["CPQRInData"].ToString().Trim(); string CPQRInNum_Str = Request.Form["CPQRInNum"].ToString().Trim(); string CPnote = Request.Form["CPnote"].ToString().Trim(); string CPQRInPerson = Request.Form["CPQRInPerson"].ToString().Trim(); List <string> list = new List <string>(); string result = ""; string sqlInsert = ""; string[] arrData = CPQRInData.Split(';'); int CPQRIn_Num = Convert.ToInt32(CPQRInNum_Str); //入庫数量 string CPQRIn_Time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim(); //扫码时间 if (checkIfInstate(arrData[2].ToString().Trim(), arrData[3].ToString().Trim())) { sqlInsert = "insert into midTable_Finished_QRIn(CPQRIn_TaskID, CPQRIn_Zongxu, CPQRIn_Num, CPQRIn_Time, CPQRIn_Person, CPQRIn_Note, CPQRIn_State) values('" + arrData[2].ToString().Trim() + "','" + arrData[3].ToString().Trim() + "'," + CPQRIn_Num + ",'" + CPQRIn_Time + "','" + CPQRInPerson + "','" + CPnote + "','0')"; list.Add(sqlInsert); try { DBCallCommon.ExecuteTrans(list); result = "{\"result\":\"success\",\"msg\":\"操作成功!\"}"; } catch { result = "{\"result\":\"fault\",\"msg\":\"程序执行出现错误!\"}"; } } else { result = "{\"result\":\"fault\",\"msg\":\"该成品已入库或正在审核,请勿重复入库!\"}"; } Response.Write(result); }