//#endregion protected void HfSx() { bool successed = false; string dlxyh = Request.Form["dlxyh"].ToString(); int bbh = Convert.ToInt32(Request.Form["bbh"].ToString()); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("update yw_dlxy set state = '新制' from yw_dlxy Where dlxyh =@dlxyh and bbh=@bbh"); master.Parameters.Add(new SqlParameter("@dlxyh", dlxyh)); master.Parameters.Add(new SqlParameter("@bbh", bbh)); if (master.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("代理协议编号为<" + dlxyh + ">,已恢复失效"); } else { this.SetErrorInfo("代理协议编号为<" + dlxyh + ">,恢复失效失败"); } }
//取消打印标志 protected void Cancel() { bool successed = false; string sqdbh = Request.Form["Sqdbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("update yw_yfkd set dy_flag='N',dybh= null Where charindex(sqdbh,@id)>0 "); cmd.Parameters.Add(new SqlParameter("@id", sqdbh)); if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("付款申请<" + sqdbh + ">打印标志取消成功"); } else { this.SetErrorInfo("更新付款申请<" + sqdbh + ">打印状态取消失败"); } }
//单据删除 protected void Delete() { bool successed = false; string skdbh = Request.Form["skdbh"].ToString(); int skd_cxh = int.Parse(Request.Form["skd_cxh"]); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_skhx_cmd Where skdbh=@skdbh"); cmd.Parameters.Add(new SqlParameter("@sqdbh", skdbh)); if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("收款核销编号为<" + skdbh + ">,已被成功删除"); } else { this.SetErrorInfo("收款核销编号为<" + skdbh + ">,删除失败"); } }
//单据审核 protected void Audit() { string userID = AppService.GetUserID(); string billID = Request.Form["BillID"].ToString(); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("UPDATE Sales Set Auditor=@Auditor, AuditDate=@AuditDate, Status='审核' Where ID=@id AND Status='录入' "); cmd.Parameters.Add(new SqlParameter("@Auditor", userID)); cmd.Parameters.Add(new SqlParameter("@AuditDate", DateTime.Today)); cmd.Parameters.Add(new SqlParameter("@id", billID)); if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); AuditInfo audit = new AuditInfo(userID); //转为Javascript的JSON字符串 string javascriptJson = JsonConvert.SerializeObject(audit, new JavaScriptDateTimeConverter()); Response.Write("(" + javascriptJson + ")"); //加上(),以便在客户端可以通过eval生成JS对象 } else { DBHelp.Rollback(); this.SetErrorInfo("单据审核失败,可能该单据已被其它用户删除或审核!"); } }
//单据删除 protected void Delete() { bool successed = false; string yshdfygjbh = Request.Form["yshdfygjbh"].ToString(); string dw_log = Request.Form["dw_log"].ToString(); SafeDS ds_log = new SafeDS("dw_s_log_list"); ds_log.SetChanges(dw_log); ds_log.SetTransaction(this.DBHelp.TransAction); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_yshdfygj_cmd Where yshdfygjbh=@yshdfygjbh"); SqlCommand cmd_yshdfygj = DBHelp.GetCommand("update yw_hddz_fksqd_cmd set yshdfygjbh = null from yw_hddz_fksqd_cmd Where yshdfygjbh = @yshdfygjbh"); SqlCommand master = DBHelp.GetCommand("delete yw_hddz_yshdfygj where yshdfygjbh = @yshdfygjbh"); master.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); cmd.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); cmd_yshdfygj.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() >= 0) { var dd = ds_log.UpdateData(); if (ds_log.UpdateData() == 1) { if (cmd_yshdfygj.ExecuteNonQuery() >= 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("账单编号为<" + yshdfygjbh + ">,已被成功删除"); } else { this.SetErrorInfo("账单编号为<" + yshdfygjbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string rwbh = Request.Form["rwbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_wlgz_fyqr Where rwbh=@rwbh"); cmd.Parameters.Add(new SqlParameter("@rwbh", rwbh)); if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("物流费用确认编号为<" + rwbh + ">,已被成功删除"); } else { this.SetErrorInfo("物流费用确认编号为<" + rwbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string yw_spbm = Request.Form["yw_spbm"].ToString(); string userid = AppService.GetUserID(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_commodity Where yw_spbm =@id "); master.Parameters.Add(new SqlParameter("@id", yw_spbm)); if (master.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("商品<" + yw_spbm + ">,已被成功删除"); } else { this.SetErrorInfo("商品<" + yw_spbm + ">,删除失败"); } }
protected void UpdateState() { ///// bool successed = false; string yw_khbm = Request.Form["yw_khbm"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("update yw_wldw set state = (case when gwcgs = '1' or fgf = '1' then '批准' else '待批' end ),spjc = (case when gwcgs = '1' then '自动审批' else '未审批' end ),khzt = (case when gwcgs = '1' then '在线' else '潜在' end ) from yw_wldw Where yw_khbm=@id "); master.Parameters.Add(new SqlParameter("@id", yw_khbm)); master.ExecuteReader(); //if (master.ExecuteReader() ) //{ // DBHelp.Commit(); // successed = true; //} //else //{ // DBHelp.Rollback(); //} }
//单据审核 protected void Audit() { string userID = AppService.GetUserID(); string sqdbh = Request.Form["sqdbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("UPDATE yw_yfkd Set state=@state Where charindex(sqdbh,@id)>0 "); cmd.Parameters.Add(new SqlParameter("@state", "待审核")); cmd.Parameters.Add(new SqlParameter("@id", sqdbh)); if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); AuditInfo audit = new AuditInfo(userID); //转为Javascript的JSON字符串 string javascriptJson = JsonConvert.SerializeObject(audit, new JavaScriptDateTimeConverter()); Response.Write("(" + javascriptJson + ")"); //加上(),以便在客户端可以通过eval生成JS对象 } else { DBHelp.Rollback(); this.SetErrorInfo("单据提交审核失败,可能该单据已被其它用户删除或审核!"); } }
//单据删除 protected void Delete() { bool successed = false; string id = Request.Form["id"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from interTb Where id =@id"); SqlCommand cmd = DBHelp.GetCommand("delete from interfield Where interid=@id"); master.Parameters.Add(new SqlParameter("@id", id)); cmd.Parameters.Add(new SqlParameter("@id", id)); if (master.ExecuteNonQuery() > 0) { cmd.ExecuteNonQuery(); DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("生鲜港接口数据设置编号为<" + id + ">,已被成功删除"); } else { this.SetErrorInfo("生鲜港接口数据设置编号为<" + id + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string zxbh = Request.Form["zxbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_tszx Where zxbh =@zxbh"); master.Parameters.Add(new SqlParameter("@zxbh", zxbh)); if (master.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("咨询投诉编号为<" + zxbh + ">,已被成功删除"); } else { this.SetErrorInfo("咨询投诉编号为<" + zxbh + ">,删除失败"); } }
//打印 protected void Print() { bool successed = false; string sqdbh = Request.Form["Sqdbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("update yw_yfkd set dy_flag='Y' Where charindex(sqdbh,@id)>0 "); cmd.Parameters.Add(new SqlParameter("@id", sqdbh)); if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { var year = System.DateTime.Now.ToShortDateString().Substring(2, 2); string userID = AppService.GetUserID(); string dybh = ""; SqlCommand d = this.DBHelp.GetCommand("select max(substring(dybh,3,6)) from yw_yfkd where substring(dybh,1,2)=@year and sqr =@userid "); d.Parameters.Add(new SqlParameter("@userid", userID)); d.Parameters.Add(new SqlParameter("@year", year)); object value = d.ExecuteScalar(); if (Convert.IsDBNull(value) || value == null) { dybh = year + "000001"; } else { dybh = year + String.Format("{0:000000}", (long.Parse((string)value) + 1)); } SqlCommand cmd2 = DBHelp.GetCommand("update yw_yfkd set dybh=@dybh Where charindex(sqdbh,@id)>0 "); cmd2.Parameters.Add(new SqlParameter("@id", sqdbh)); cmd2.Parameters.Add(new SqlParameter("@dybh", dybh)); if (cmd2.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { this.SetErrorInfo("更新费用申请<" + sqdbh + ">打印状态失败"); } }
//单据删除 protected void Delete() { bool successed = false; string ywbh = Request.Form["ywbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz Where ywbh =@ywbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_jzxxx Where ywbh=@ywbh"); SqlCommand cmd_bg = DBHelp.GetCommand("delete from yw_hddz_spxx Where ywbh=@ywbh"); SqlCommand cmd_zzxx = DBHelp.GetCommand("delete from yw_hddz_zzxx Where ywbh=@ywbh"); SqlCommand cmd_fsdz = DBHelp.GetCommand("delete from yw_hddz_fsdz Where ywbh=@ywbh"); master.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd_bg.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd_zzxx.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd_fsdz.Parameters.Add(new SqlParameter("@ywbh", ywbh)); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() > 0) { if (cmd_bg.ExecuteNonQuery() > 0) { cmd_zzxx.ExecuteNonQuery(); cmd_fsdz.ExecuteNonQuery(); DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("货代单证编号为<" + ywbh + ">,已被成功删除"); } else { this.SetErrorInfo("货代单证编号为<" + ywbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string czdbh = Request.Form["czdbh"].ToString(); string dw_log = Request.Form["dw_log"].ToString(); SafeDS ds_log = new SafeDS("dw_s_log_list"); ds_log.SetChanges(dw_log); ds_log.SetTransaction(this.DBHelp.TransAction); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_czd Where czdbh =@czdbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_czd_mx Where czdbh=@czdbh"); //SqlCommand update_yszyf = DBHelp.GetCommand("update yw_hddz_fksqd_cmd set yshdfygjbh = null from yw_hddz_fksqd_cmd Where yshdfygjbh=@yshdfygjbh"); master.Parameters.Add(new SqlParameter("@czdbh", czdbh)); cmd.Parameters.Add(new SqlParameter("@czdbh", czdbh)); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() > 0) { if (ds_log.UpdateData() == 1) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); this.SetErrorInfo("传输错误日志信息保存失败!\n\n详细错误信息:\n" + ds_log.DBError); } } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("出账单编号为<" + czdbh + ">,已被成功删除"); } else { this.SetErrorInfo("出账单编号为<" + czdbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string skdbh = Request.Form["skdbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_sjskd Where skdbh=@skdbh"); SqlCommand cmd_skhx = DBHelp.GetCommand("update yw_hddz_zdgl set dzje =isnull((select sum(a.skje) from yw_hddz_skhx_cmd a where yw_hddz_zdgl.zdbm = a.djh and a.sjly = '账单' and a.skdbh <> @skdbh ),0), wsje = isnull(ysje,0) - isnull((select sum(b.skje) from yw_hddz_skhx_cmd b where yw_hddz_zdgl.zdbm = b.djh and b.sjly = '账单' and b.skdbh <> @skdbh),0) from yw_hddz_zdgl,yw_hddz_skhx_cmd Where yw_hddz_zdgl.zdbm = yw_hddz_skhx_cmd.djh and yw_hddz_skhx_cmd.sjly = '账单' and yw_hddz_skhx_cmd.skdbh = @skdbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_skhx_cmd Where skdbh=@skdbh"); master.Parameters.Add(new SqlParameter("@skdbh", skdbh)); cmd_skhx.Parameters.Add(new SqlParameter("@skdbh", skdbh)); cmd.Parameters.Add(new SqlParameter("@skdbh", skdbh)); if (master.ExecuteNonQuery() > 0) { if (cmd_skhx.ExecuteNonQuery() >= 0) { if (cmd.ExecuteNonQuery() >= 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("收款核销编号为<" + skdbh + ">,已被成功删除"); } else { this.SetErrorInfo("收款核销编号为<" + skdbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string yshdfygjbh = Request.Form["yshdfygjbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_yshdfygj Where yshdfygjbh =@yshdfygjbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_yshdfygj_cmd Where yshdfygjbh=@yshdfygjbh"); SqlCommand update_yszyf = DBHelp.GetCommand("update yw_hddz_fksqd_jzxxx set yshdfygjbh = null from yw_hddz_fksqd_jzxxx Where yshdfygjbh=@yshdfygjbh"); SqlCommand update_hdfyys = DBHelp.GetCommand("update yw_hddz_jzxxx set yshdfygjbh = null from yw_hddz_jzxxx Where yshdfygjbh=@yshdfygjbh"); SqlCommand update_cqfys = DBHelp.GetCommand("update yw_hddz_jzxxx set yshdfygjbh_cqf = null from yw_hddz_jzxxx Where yshdfygjbh_cqf=@yshdfygjbh"); SqlCommand update_qtys = DBHelp.GetCommand("update yw_hddz_qtysk_cmd set yshdfygjbh = null from yw_hddz_qtysk_cmd Where yshdfygjbh=@yshdfygjbh"); master.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); cmd.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); update_yszyf.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); update_hdfyys.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); update_cqfys.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); update_qtys.Parameters.Add(new SqlParameter("@yshdfygjbh", yshdfygjbh)); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() > 0) { update_yszyf.ExecuteNonQuery(); update_hdfyys.ExecuteNonQuery(); update_cqfys.ExecuteNonQuery(); update_qtys.ExecuteNonQuery(); DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("应收货代费用归集编号为<" + yshdfygjbh + ">,已被成功删除"); } else { this.SetErrorInfo("应收货代费用归集编号为<" + yshdfygjbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string userID = AppService.GetUserID(); string sqdbh = Request.Form["sqdbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_qtysk Where sqdbh =@sqdbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_qtysk_cmd Where sqdbh=@sqdbh"); SqlCommand logCmd = DBHelp.GetCommand("insert into s_log_err(eid,tablename,changecols,mainid,cscs,sfcg,funname) values('qtys'+ @userid + @GUID,'yw_hddz_qtysk_cmd','je',@sqdbh,getdate(),0,0,'DataToFreshPort');"); master.Parameters.Add(new SqlParameter("@sqdbh", sqdbh)); cmd.Parameters.Add(new SqlParameter("@sqdbh", sqdbh)); logCmd.Parameters.Add(new SqlParameter("@sqdbh", sqdbh)); logCmd.Parameters.Add(new SqlParameter("@userid", userID)); logCmd.Parameters.Add(new SqlParameter("@GUID", Guid.NewGuid().ToString())); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() > 0) { //资金管理注释 if (logCmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("其它应收款编号为<" + sqdbh + ">,已被成功删除"); } else { this.SetErrorInfo("其它应收款编号为<" + sqdbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string zdbm = Request.Form["zdbm"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_zdgl Where zdbm =@zdbm"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_zdgl_cmd Where zdbm=@zdbm"); SqlCommand cmd_yshdfygj = DBHelp.GetCommand("update yw_hddz_yshdfygj set zdbm = null from yw_hddz_yshdfygj Where zdbm=@zdbm"); master.Parameters.Add(new SqlParameter("@zdbm", zdbm)); cmd.Parameters.Add(new SqlParameter("@zdbm", zdbm)); cmd_yshdfygj.Parameters.Add(new SqlParameter("@zdbm", zdbm)); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() >= 0) { if (cmd_yshdfygj.ExecuteNonQuery() >= 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("账单编号为<" + zdbm + ">,已被成功删除"); } else { this.SetErrorInfo("账单编号为<" + zdbm + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string sqdbh = Request.Form["sqdbh"].ToString(); string dw_log = Request.Form["dw_log"].ToString(); SafeDS ds_log = new SafeDS("dw_s_log_list"); ds_log.SetChanges(dw_log); ds_log.SetTransaction(this.DBHelp.TransAction); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_fksqd Where sqdbh =@sqdbh"); SqlCommand cmd_zpxx = DBHelp.GetCommand("update yw_hddz_sdzpgl_cmd set yw_hddz_sdzpgl_cmd.sfzf = 'N' from yw_hddz_sdzpgl_cmd,yw_hddz_fksqd_cmd where yw_hddz_fksqd_cmd.sqdbh = @sqdbh and yw_hddz_sdzpgl_cmd.fph=yw_hddz_fksqd_cmd.fph and yw_hddz_sdzpgl_cmd.ywbh = yw_hddz_fksqd_cmd.ywbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_fksqd_cmd Where sqdbh=@sqdbh"); master.Parameters.Add(new SqlParameter("@sqdbh", sqdbh)); cmd_zpxx.Parameters.Add(new SqlParameter("@sqdbh", sqdbh)); cmd.Parameters.Add(new SqlParameter("@sqdbh", sqdbh)); if (master.ExecuteNonQuery() > 0) { cmd_zpxx.ExecuteNonQuery(); if (cmd.ExecuteNonQuery() > 0) { ds_log.UpdateData(); DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("国际运费支付编号为<" + sqdbh + ">,已被成功删除"); } else { this.SetErrorInfo("国际运费支付编号为<" + sqdbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string cpxxkbm = Request.Form["cpxxkbm"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_cpxxk Where cpxxkbm =@cpxxkbm"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_cpxxk_cmd Where cpxxkbm=@cpxxkbm"); SqlCommand cmd_jycljtyq = DBHelp.GetCommand("delete from yw_hddz_cpxxk_jycljtyq Where cpxxkbm=@cpxxkbm"); SqlCommand cmd_jydzyq = DBHelp.GetCommand("delete from yw_hddz_cpxxk_jydzyq Where cpxxkbm=@cpxxkbm"); SqlCommand cmd_hgsj = DBHelp.GetCommand("delete from yw_hddz_cpxxk_hgsj Where cpxxkbm=@cpxxkbm"); SqlCommand cmd_clqy = DBHelp.GetCommand("delete from yw_hddz_cpxxk_clqy Where cpxxkbm=@cpxxkbm"); SqlCommand cmd_slb = DBHelp.GetCommand("delete from yw_hddz_cpxxk_slb Where cpxxkbm=@cpxxkbm"); master.Parameters.Add(new SqlParameter("@cpxxkbm", cpxxkbm)); cmd.Parameters.Add(new SqlParameter("@cpxxkbm", cpxxkbm)); cmd_jycljtyq.Parameters.Add(new SqlParameter("@cpxxkbm", cpxxkbm)); cmd_jydzyq.Parameters.Add(new SqlParameter("@cpxxkbm", cpxxkbm)); cmd_hgsj.Parameters.Add(new SqlParameter("@cpxxkbm", cpxxkbm)); cmd_clqy.Parameters.Add(new SqlParameter("@cpxxkbm", cpxxkbm)); cmd_slb.Parameters.Add(new SqlParameter("@cpxxkbm", cpxxkbm)); if (master.ExecuteNonQuery() > 0) { cmd.ExecuteNonQuery(); cmd_jycljtyq.ExecuteNonQuery(); cmd_jydzyq.ExecuteNonQuery(); cmd_hgsj.ExecuteNonQuery(); cmd_clqy.ExecuteNonQuery(); cmd_slb.ExecuteNonQuery(); DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("产品信息库编号为<" + cpxxkbm + ">,已被成功删除"); } else { this.SetErrorInfo("产品信息库编号为<" + cpxxkbm + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string ywbh = Request.Form["ywbh"].ToString(); string dw_log = Request.Form["dw_log"].ToString(); SafeDS ds_log = new SafeDS("dw_s_log_list"); ds_log.SetChanges(dw_log); ds_log.SetTransaction(this.DBHelp.TransAction); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz Where ywbh =@ywbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_jzxxx Where ywbh=@ywbh"); SqlCommand cmd_bg = DBHelp.GetCommand("delete from yw_hddz_spxx Where ywbh=@ywbh"); SqlCommand cmd_sxgsjjl = DBHelp.GetCommand("delete from yw_hddz_sxgsjjl Where ywbh=@ywbh"); master.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd_bg.Parameters.Add(new SqlParameter("@ywbh", ywbh)); cmd_sxgsjjl.Parameters.Add(new SqlParameter("@ywbh", ywbh)); if (master.ExecuteNonQuery() > 0) { cmd.ExecuteNonQuery(); cmd_bg.ExecuteNonQuery(); cmd_sxgsjjl.ExecuteNonQuery(); ds_log.UpdateData(); DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("货代单证编号为<" + ywbh + ">,已被成功删除"); } else { this.SetErrorInfo("货代单证编号为<" + ywbh + ">,删除失败"); } }
//#endregion //更新同一个委托单位的其他代理协议为失效 protected void UpdateDlxyState(string dlxyh, string dlwtf_bm) { Response.Write(dlxyh); Response.Write(dlwtf_bm); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("update yw_dlxy set state='失效' Where isnull(dlxyh,'') <> isnull(@dlxyh,'') and dlwtf_bm=@dlwtf_bm"); master.Parameters.Add(new SqlParameter("@dlxyh", dlxyh)); master.Parameters.Add(new SqlParameter("@dlwtf_bm", dlwtf_bm)); Response.Write("存盘成功"); if (master.ExecuteNonQuery() > 0) { DBHelp.Commit(); } else { DBHelp.Rollback(); } }
//单据删除 protected void Delete() { bool successed = false; string sqdbh = Request.Form["sqdbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_bgdsy Where sqdbh =@sqdbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_bgdsy_cmd Where sqdbh=@sqdbh"); master.Parameters.Add(new SqlParameter("@sqdbh", sqdbh)); cmd.Parameters.Add(new SqlParameter("@sqdbh", sqdbh)); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("报关单使用编号为<" + sqdbh + ">,已被成功删除"); } else { this.SetErrorInfo("报关单使用编号为<" + sqdbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string cdphbm = Request.Form["cdphbm"].ToString(); string dw_log = Request.Form["dw_log"].ToString(); SafeDS ds_log = new SafeDS("dw_s_log_list"); ds_log.SetChanges(dw_log); ds_log.SetTransaction(this.DBHelp.TransAction); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_hddz_kycd Where cdphbm =@cdphbm"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_tpcdxx Where cdphbm=@cdphbm"); master.Parameters.Add(new SqlParameter("@cdphbm", cdphbm)); cmd.Parameters.Add(new SqlParameter("@cdphbm", cdphbm)); if (master.ExecuteNonQuery() > 0) { cmd.ExecuteNonQuery(); ds_log.UpdateData(); DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } if (successed) { Response.Write("空运车队配货编号为<" + cdphbm + ">,已被成功删除"); } else { this.SetErrorInfo("空运车队配货编号为<" + cdphbm + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string yfkdbh = Request.Form["yfkdbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("update yw_hddz_jzxxx set yfkdbh = null from yw_hddz_jzxxx Where yfkdbh =@yfkdbh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_hddz_fksqd_cmd Where yfkdbh=@yfkdbh"); master.Parameters.Add(new SqlParameter("@yfkdbh", yfkdbh)); cmd.Parameters.Add(new SqlParameter("@yfkdbh", yfkdbh)); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("海运车队费用申请单编号为<" + yfkdbh + ">,已被成功删除"); } else { this.SetErrorInfo("海运车队费用申请单编号为<" + yfkdbh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string sqdbh = Request.Form["Sqdbh"].ToString(); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("delete from yw_yfkd Where sqdbh=@id "); SqlCommand cmd_d = DBHelp.GetCommand("delete from yw_yfkd_mx Where sqdbh=@id "); cmd.Parameters.Add(new SqlParameter("@id", sqdbh)); cmd_d.Parameters.Add(new SqlParameter("@id", sqdbh)); if (cmd.ExecuteNonQuery() > 0) { if (cmd_d.ExecuteNonQuery() >= 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("付款申请<" + sqdbh + ">已被成功删除"); } else { this.SetErrorInfo("付款申请<" + sqdbh + ">删除失败,请检查是否已被其它用户删除或审核了"); } }
//单据删除 protected void Delete() { bool successed = false; string dlxyh = Request.Form["dlxyh"].ToString(); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_dlxy Where dlxyh =@dlxyh"); SqlCommand cmd = DBHelp.GetCommand("delete from yw_dlxy_bz Where dlxyh =@dlxyh"); master.Parameters.Add(new SqlParameter("@dlxyh", dlxyh)); cmd.Parameters.Add(new SqlParameter("@dlxyh", dlxyh)); if (master.ExecuteNonQuery() > 0) { if (cmd.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("货代单证编号为<" + dlxyh + ">,已被成功删除"); } else { this.SetErrorInfo("货代单证编号为<" + dlxyh + ">,删除失败"); } }
//单据删除 protected void Delete() { bool successed = false; string billID = Request.Form["BillID"].ToString(); DBHelp.BeginTransAction(); SqlCommand cmd = DBHelp.GetCommand("delete from Sales Where ID=@id AND Status='录入' "); SqlCommand cmd_d = DBHelp.GetCommand("delete from SalesDetail Where ID=@id "); cmd.Parameters.Add(new SqlParameter("@id", billID)); cmd_d.Parameters.Add(new SqlParameter("@id", billID)); if (cmd.ExecuteNonQuery() > 0) { if (cmd_d.ExecuteNonQuery() > 0) { DBHelp.Commit(); successed = true; } else { DBHelp.Rollback(); } } else { DBHelp.Rollback(); } if (successed) { Response.Write("销售订单<" + billID + ">已被成功删除"); } else { this.SetErrorInfo("销售订单<" + billID + ">删除失败,请检查是否已被其它用户删除或审核了"); } }
//单据保存 protected void Save() { string userID = AppService.GetUserID(); string skdbh = Request.Form["skdbh"].ToString(); var operation = Request.Form["operation"].ToString(); string dw_master = Request.Form["dw_master"].ToString(); string dw_jzxxx = Request.Form["dw_jzxxx"].ToString(); SafeDS ds_master = new SafeDS("dw_gmhx_skhx_edit"); SafeDS ds_jzxxx = new SafeDS("dw_gmhx_skhx_edit_cmd"); try { ds_master.SetChanges(dw_master); ds_jzxxx.SetChanges(dw_jzxxx); if (operation == "copy" || operation == "modify") { ds_master.SetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); for (int row = 1; row <= ds_jzxxx.RowCount; row++) { ds_jzxxx.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } } ; //TODO 在服务器端,最好是重做一次数据校验,Demo简化处理,不再重复校验了。 if (skdbh == null || skdbh == "") { if (ds_master.GetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary) == Sybase.DataWindow.RowStatus.NewAndModified) { //var year = System.DateTime.Now.ToShortDateString().Substring(0, 8); var year = System.DateTime.Now.ToString("yyyyMMdd"); SqlCommand cmd = this.DBHelp.GetCommand("select max(right(skdbh,4)) from yw_hddz_sjskd where substring(skdbh,1,8) = '" + year.Substring(0, 8) + "' "); object value = cmd.ExecuteScalar(); if (Convert.IsDBNull(value) || value == null) { skdbh = year.Substring(0, 8) + "0001"; } else { skdbh = year.Substring(0, 8) + String.Format("{0:0000}", (long.Parse((string)value) + 1)); } ds_master.SetItemString(1, "skdbh", skdbh); } else { skdbh = ds_master.GetItemString(1, "skdbh"); } } for (int row = 1; row <= ds_jzxxx.RowCount; row++) { ds_jzxxx.SetItemString(row, "skdbh", skdbh); ds_jzxxx.SetItemDouble(row, "skd_cxh", row); } ds_master.SetTransaction(this.DBHelp.TransAction); ds_jzxxx.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (ds_master.UpdateData() == 1) { if (ds_jzxxx.RowCount > 0) { if (ds_jzxxx.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("update yw_hddz_zdgl set dzje =isnull((select sum(a.skje) from yw_hddz_skhx_cmd a where yw_hddz_zdgl.zdbm = a.djh and a.sjly = '账单'),0), wsje = isnull(ysje,0) - isnull((select sum(a.skje) from yw_hddz_skhx_cmd a where yw_hddz_zdgl.zdbm = a.djh and a.sjly = '账单'),0) from yw_hddz_zdgl,yw_hddz_skhx_cmd Where yw_hddz_zdgl.zdbm = yw_hddz_skhx_cmd.djh and yw_hddz_skhx_cmd.sjly = '账单' and yw_hddz_skhx_cmd.skdbh = @skdbh"); master.Parameters.Add(new SqlParameter("@skdbh", skdbh)); if (master.ExecuteNonQuery() > 0) { DBHelp.Commit(); } else { DBHelp.Rollback(); this.SetErrorInfo("更新账单到账金额信息:\n"); } Response.Write(skdbh); } else { this.DBHelp.Rollback();; this.SetErrorInfo("收款核销明细信息保存失败!\n\n详细错误信息:\n" + ds_jzxxx.DBError); } } else { this.DBHelp.Commit(); //把单据号码,传回到客户端 } } else { this.DBHelp.Rollback(); this.SetErrorInfo("收款核销保存失败!\n\n详细错误信息:\n" + ds_master.DBError + " " + ds_master.LastError); } } catch (Exception ex) { this.SetErrorInfo(ex.Message); } finally { ds_master.Dispose(); ds_master = null; ds_jzxxx.Dispose(); ds_jzxxx = null; } }
//单据删除 protected void Delete() { bool successed = false; string mxdbh = Request.Form["mxdbh"].ToString(); int bbh = Convert.ToInt32(Request.Form["bbh"].ToString()); DBHelp.BeginTransAction(); SqlCommand master = DBHelp.GetCommand("delete from yw_detail Where mxdbh=@id "); SqlCommand cmd = DBHelp.GetCommand("delete from yw_detail_cmd Where mxdbh=@id "); //SqlCommand cmd_hb = DBHelp.GetCommand("delete from yw_detail_cmd_hb Where mxdbh=@id "); //SqlCommand packing_cmd = DBHelp.GetCommand("delete from yw_detail_packing_cmd Where mxdbh=@id "); SqlCommand fy = DBHelp.GetCommand("delete from yw_detail_fy Where mxdbh=@id "); SqlCommand zhuangtai = DBHelp.GetCommand("delete from dz_zhuangtai Where dtl_no=@id "); master.Parameters.Add(new SqlParameter("@id", mxdbh)); cmd.Parameters.Add(new SqlParameter("@id", mxdbh)); //cmd_hb.Parameters.Add(new SqlParameter("@id", mxdbh)); //packing_cmd.Parameters.Add(new SqlParameter("@id", mxdbh)); fy.Parameters.Add(new SqlParameter("@id", mxdbh)); zhuangtai.Parameters.Add(new SqlParameter("@id", mxdbh)); if (master.ExecuteNonQuery() > 0) //主表 { if (cmd.ExecuteNonQuery() > 0) //商品 { //if (cmd_hb.ExecuteNonQuery() >= 0)//合并商品 //{ // if (packing_cmd.ExecuteNonQuery() >= 0)//装箱信息 // { if (fy.ExecuteNonQuery() >= 0) //费用 { if (zhuangtai.ExecuteNonQuery() >= 0) //单证编号 { DBHelp.Commit(); successed = true; } else //单证编号 { DBHelp.Rollback(); } } else //费用信息 { DBHelp.Rollback(); } // } // else//装箱信息 // { // DBHelp.Rollback(); // } //} //else//合并商品 //{ // DBHelp.Rollback(); //} } else//商品 { DBHelp.Rollback(); } } else//主表 { DBHelp.Rollback(); } if (successed) { Response.Write("结汇单据" + mxdbh + ",已被成功删除"); } else { this.SetErrorInfo("结汇单据" + mxdbh + ",删除失败"); } }