//#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 + ",删除失败");
}
}
