public void ChangePwd()
{
SafeDS ds = new SafeDS("d_changepassword");
if (ds.SetChanges(this.Request.Form["data"].ToString()))
{
string userID = AppService.GetUserID();
string oldPwd = ds.GetItemString(1, "oldPwd");
string pwd1 = ds.GetItemString(1, "newPwd1");
string pwd2 = ds.GetItemString(1, "newPwd2");
string error = string.Empty;
if (pwd1.Length < 6)
{
this.SetErrorInfo("帐号密码长度不能小于6位数");
return;
}
if (string.Compare(pwd1, pwd2, false) != 0)
{
this.SetErrorInfo("两次输入的帐号密码不一致,请重新输入!");
return;
}
if (!AppService.ChangePassword(userID, oldPwd, pwd1, ref error))
{
this.SetErrorInfo(error);
}
}
else
{
this.SetErrorInfo("WebService提交的数据不正确");
}
}
public void Save()
{
SafeDS ds = new SafeDS("dw_wxlxr_edit");
if (ds.SetChanges(this.Request.Form["data"].ToString()))
{
ds.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds.UpdateData() == 1)
{
this.DBHelp.Commit();
this.SetSuccessedInfo("数据保存成功");
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
else
{
this.SetErrorInfo("WebService提交的数据不正确");
return;
}
}
//单据删除
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 + ">,删除失败");
}
}
//#region 列表存盘
protected void YscqfListSave()
{
string userID = AppService.GetUserID();
string dw_list = Request.Form["dw_list"].ToString();
SafeDS ds_list = new SafeDS("dw_hddz_hdfyyscqfy_list");
try
{
ds_list.SetChanges(dw_list);
ds_list.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_list.UpdateData() == 1)
{
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write("存盘成功");
////数据上传生鲜港
//Thread t1 = new Thread(new ThreadStart(delegate
//{
//HddzIF serv = new HddzIF();
for (int row = 1; row <= ds_list.RowCount; row++)
{
string zt = ds_list.GetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary).ToString();
if (zt == "NotModified")
{
string ywbh = ds_list.GetItemString(row, "ywbh");
int cxh = ds_list.GetItemInt32(row, "jzxxx_cxh");
string zdmc = "yscqfqrrq";
string strErr;
Interfaces.GeneralPortal.DataToFreshPort("yw_hddz_jzxxx", zdmc, ywbh, out strErr, new string[] { cxh.ToString() });
}
;
}
;
//}));
//t1.IsBackground = true;
//t1.Start();
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("应收超期费保存失败!\n\n详细错误信息：\n" + ds_list.DBError);
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds_list.Dispose();
ds_list = null;
}
}
public void Save()
{
string master = Request.Form["dw_Master"].ToString();
string dw_log = Request.Form["dw_log"].ToString();
SafeDS ds_log = new SafeDS("dw_s_log_list");
SafeDS ds = new SafeDS("dw_xtdm_xl_list");
try
{
//ds.SetChanges(master);
//ds_log.SetChanges(dw_log);
//ds_log.SetTransaction(this.DBHelp.TransAction);
//ds.SetTransaction(this.DBHelp.TransAction);
//this.DBHelp.BeginTransAction();
ds.SetChanges(master);
ds_log.SetChanges(dw_log);
ds_log.SetTransaction(this.DBHelp.TransAction);
ds.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
var dd = ds.UpdateData();
var dd1 = ds_log.UpdateData();
if (ds.UpdateData() == 1)
{
if (ds_log.UpdateData() == 1)
{
this.DBHelp.Commit();
this.SetSuccessedInfo("数据保存成功");
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("修改传输日志保存失败!\n\n详细错误信息：\n" + ds_log.DBError);
}
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds.Dispose();
ds = null;
ds_log.Dispose();
ds_log = null;
}
}
//#region 数据导入存盘
protected void SjdrSave()
{
string userID = AppService.GetUserID();
string dw_list = Request.Form["dw_list"].ToString();
SafeDS ds_list = new SafeDS("dw_hddz_sjdrlist");
try
{
ds_list.SetChanges(dw_list);
ds_list.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_list.UpdateData() == 1)
{
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write("存盘成功");
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("其他应收款保存失败!\n\n详细错误信息：\n" + ds_list.DBError);
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds_list.Dispose();
ds_list = null;
}
}
//单据保存
protected void Save_old()
{
string userID = AppService.GetUserID();
string rwbh = Request.Form["rwbh"].ToString();
string dw_master = Request.Form["dw_master"].ToString();
string dw_jzxxx = Request.Form["dw_jzxxx"].ToString();
SafeDS ds_master = new SafeDS("dw_wlgz_edit_fyqr_master_old");
SafeDS ds_jzxxx = new SafeDS("dw_wlgz_edit_fyqr_old");
try
{
ds_master.SetChanges(dw_master);
ds_jzxxx.SetChanges(dw_jzxxx);
for (int row = 1; row <= ds_jzxxx.RowCount; row++)
{
ds_jzxxx.SetItemString(row, "rwbh", rwbh);
}
ds_master.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_master.UpdateData() == 1)
{
if (ds_jzxxx.UpdateData() == 1)
{
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write(rwbh);
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("物流费用确认信息保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
}
}
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 Tbsxg()
{
string userID = AppService.GetUserID();
string dw_list = Request.Form["dw_list"].ToString();
SafeDS ds_list = new SafeDS("dw_log_err");
try
{
ds_list.SetChanges(dw_list);
ds_list.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_list.UpdateData() == 1)
{
////数据上传生鲜港
////HddzIF serv = new HddzIF();
//for (int row = 1; row <= ds_list.RowCount; row++)
//{
// string zt = ds_list.GetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary).ToString();
// if (zt == "NotModified")
// {
// string tablename = ds_list.GetItemString(row, "tablename");
// string changecols = ds_list.GetItemString(row, "changecols");
// string mainid = ds_list.GetItemString(row, "mainid");
// string parameters = ds_list.GetItemString(row, "parameters");
// string eid = ds_list.GetItemString(row, "eid");
// string strErr;
// Interfaces.GeneralPortal.DataToFreshPort(tablename, changecols, mainid, out strErr, parameters.Split(','), eid);
// };
//};
this.DBHelp.Commit();
this.SetSuccessedInfo("数据保存成功");
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds_list.Dispose();
ds_list = null;
}
}
public override void Dispose()
{
if (_dsRight != null)
{
_dsRight.Dispose();
_dsRight = null;
}
base.Dispose();
}
public void Save()
{
string master = Request.Form["dw_Master"].ToString();
SafeDS ds = new SafeDS("dw_pdy_list");
string cmd = Request.Form["dw_Cmd"].ToString();
SafeDS ds_cmd = new SafeDS("dw_pdy_userid_list");
try
{
ds.SetChanges(master);
ds.SetTransaction(this.DBHelp.TransAction);
ds_cmd.SetChanges(cmd);
ds_cmd.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds.UpdateData() == 1)
{
if (ds_cmd.UpdateData() == 1)
{
this.DBHelp.Commit();
this.SetSuccessedInfo("数据保存成功");
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds.Dispose();
ds = null;
ds_cmd.Dispose();
ds_cmd = null;
}
}
//检疫点编辑保存
protected void JydEditSave()
{
string userID = AppService.GetUserID();
string cdphbm = Request.Form["cdphbm"].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_ky_jyd_edit");
SafeDS ds_jzxxx = new SafeDS("dw_ky_jyd_edit_cmd");
try
{
ds_master.SetChanges(dw_master);
ds_jzxxx.SetChanges(dw_jzxxx);
ds_master.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_master.UpdateData() == 1)
{
if (ds_jzxxx.UpdateData() == 1)
{
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write(cdphbm);
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("货代单据集装箱信息保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
}
}
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 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 + ">,删除失败");
}
}
public void GetValueList()
{
string tableName = Request.Form["tableName"].ToString();
string fieldName = Request.Form["fieldName"].ToString();
string result = string.Empty;
int row = 0;
//只是简单演示通过WebService返回不同的数据,实际项目一般是从数据库取数
//string[] ls_Tables = new string[] { "JB", "YG", "KQ", "JF", "ZQ" };
SafeDS ds = new SafeDS("d_hr_salary_defformula_valuelist");
switch (tableName)
{
case "YG":
{
switch (fieldName)
{
case "deptid":
row = ds.InsertRow(0);
ds.SetItem(row, "value", "001");
row = ds.InsertRow(0);
ds.SetItem(row, "value", "002");
break;
case "deptname":
row = ds.InsertRow(0);
ds.SetItem(row, "value", "办公室");
row = ds.InsertRow(0);
ds.SetItem(row, "value", "信息中心");
break;
case "salarytype":
row = ds.InsertRow(0);
ds.SetItem(row, "value", "月薪");
row = ds.InsertRow(0);
ds.SetItem(row, "value", "日薪");
break;
}
}
break;
}
if (ds.RowCount > 0)
{
Response.Write(ds.GetSyntaxData());
}
ds.Dispose();
ds = null;
}
//单据保存
protected void Save()
{
string userID = AppService.GetUserID();
var operation = Request.Form["operation"].ToString();
string dw_master = Request.Form["dw_master"].ToString();
SafeDS ds_master = new SafeDS("dw_ky_thwljh_edit");
string dw_log = Request.Form["dw_log"].ToString();
SafeDS ds_log = new SafeDS("dw_s_log_list");
try
{
ds_master.SetChanges(dw_master);
ds_log.SetChanges(dw_log);
ds_master.SetTransaction(this.DBHelp.TransAction);
ds_log.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_master.UpdateData() == 1)
{
if (ds_log.UpdateData() == 1)
{
this.DBHelp.Commit();
//把单据号码，传回到客户端
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("传输错误日志保存失败!\n\n详细错误信息：\n" + ds_log.DBError + " " + ds_log.LastError);
}
}
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_log.Dispose();
ds_log = null;
}
}
//设置角色权限
protected void SetPermissions()
{
string roleID = this.Request.Form["roleid"].ToString();
string moduleID = this.Request.Form["moduleid"].ToString();
string data = this.Request.Form["data"].ToString();
SafeDS ds = new SafeDS("d_sys_rolepemessions_permission");
ds.SetSyntaxData(data);
ds.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
try
{
//先删除当前角色原来定义的权限
SqlCommand cmd = this.DBHelp.GetCommand("DELETE FROM Sys_RolePermissions Where RoleID=@roleID AND ModuleID=@moduleID");
cmd.Parameters.Add(new SqlParameter("@roleID", roleID));
cmd.Parameters.Add(new SqlParameter("@moduleID", moduleID));
cmd.ExecuteNonQuery();
//增加新的权限
cmd = this.DBHelp.GetCommand("INSERT INTO Sys_RolePermissions(RoleID, ModuleID, FunID , hasRight ) Values(@roleID,@moduleID,@funID, '1' )");
SqlParameter parm_funID = new SqlParameter("@funID", "");
cmd.Parameters.Add(new SqlParameter("@roleID", roleID));
cmd.Parameters.Add(new SqlParameter("@moduleID", moduleID));
cmd.Parameters.Add(parm_funID);
for (int row = 1; row <= ds.RowCount; row++)
{
if (ds.GetItemString(row, "hasRight") == "1")
{
parm_funID.Value = ds.GetItemString(row, "funID");
cmd.ExecuteNonQuery();
}
}
this.DBHelp.Commit();
}
catch (Exception ex)
{
this.DBHelp.Rollback();
this.SetErrorInfo("更新角色权限时发生错误。\r\n错误信息为：\r\n" + ex.Message);
}
finally
{
ds.Dispose();
}
}
public void Jdrys_Save()
{
string master = Request.Form["dw_1"].ToString();
//string dw_log = Request.Form["dw_log"].ToString();
SafeDS ds = new SafeDS("dw_jdrys_list");
//SafeDS ds_log = new SafeDS("dw_s_log_list");
try
{
ds.SetChanges(master);
//ds_log.SetChanges(dw_log);
ds.SetTransaction(this.DBHelp.TransAction);
//ds_log.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
var dd = ds.UpdateData();
if (ds.UpdateData() == 1)
{
//if (ds_log.UpdateData() == 1)
//{
this.DBHelp.Commit();
this.SetSuccessedInfo("数据保存成功");
//}
//else
//{
// this.DBHelp.Rollback();
// this.SetErrorInfo("数据保存失败!");
// return;
//}
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds.Dispose();
ds = null;
}
}
//单据删除
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 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 + ">,删除失败");
}
}
public void Save()
{
string dw_list = Request.Form["dw_list"].ToString();
string dw_list2 = Request.Form["dw_list2"].ToString();
SafeDS ds = new SafeDS("dw_ky_qdcx_list_hwxx");
SafeDS ds2 = new SafeDS("dw_ky_qdcx_list_clxx");
try
{
ds.SetChanges(dw_list);
ds2.SetChanges(dw_list2);
ds.SetTransaction(this.DBHelp.TransAction);
ds2.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds.UpdateData() == 1 && ds2.UpdateData() == 1)
{
this.DBHelp.Commit();
this.SetSuccessedInfo("数据保存成功");
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds.Dispose();
ds = null;
ds2.Dispose();
ds2 = null;
}
}
public override bool OnPreLoad()
{
if (!base.OnPreLoad())
{
return(false);
}
if (AppService.GetUserID() == "admin")
{
return(true);
}
//如果当前窗口设置了模块ID,取权限列表
if (!string.IsNullOrEmpty(this.FunctionID))
{
//如果不需要把权限信息传到客户端，不要用PermissionDataStore,直接用new SafeDS
_dsRight = new SafeDS("d_sys_user_permissions");
_dsRight.SetTransaction(this.AdoTransaction);
_dsRight.Retrieve(AppService.GetUserID(), this.FunctionID);
if (this._dsRight.RowCount <= 0)
{
_dsRight.Dispose();
_dsRight = null;
return(true);
}
//如果系统有定义权限，但当前用户没有该模块的任何一个功能的权限
//则作为没有权限打开该窗口
if (_dsRight.FindRow("HasRight='1' ", 1, _dsRight.RowCount) <= 0)
{
_dsRight.Dispose();
_dsRight = null;
this.LoadErrorMessage = "当前登录用户没有相应模块的权限";
this.LoadSuccessed = false;
return(false);
}
}
return(true);
}
//发送欧恒
protected void Fszj()
{
string userID = AppService.GetUserID();
//string billID = string.Empty;
string mxdbh = Request.Form["mxdbh"].ToString();
int bbh = Convert.ToInt32(Request.Form["bbh"].ToString());
string master = Request.Form["dw_Master"].ToString();
SafeDS ds_master = new SafeDS("dw_bgdj_list_slwts");
try
{
ds_master.SetChanges(master);
ds_master.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_master.UpdateData() == 1)
{
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;
}
}
//单据删除
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 + ">,删除失败");
}
}
//#region 往来单位设置存盘
protected void SetUserBType()
{
string dw_d_data = Request.Form["dw_d_data"].ToString();
SafeDS ds_list = new SafeDS("d_sys_userroles_wldw");
try
{
ds_list.SetChanges(dw_d_data);
ds_list.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_list.UpdateData() == 1)
{
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write("存盘成功");
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("往来单位信息保存失败!\n\n详细错误信息：\n" + ds_list.DBError);
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds_list.Dispose();
ds_list = null;
}
}
protected void Save()
{
string dataObject = "d_customer_edit";
string dwChanges = Request["dwChanges"].ToString();
SafeDS ds = null;
try
{
ds = new SafeDS(dataObject);
ds.SetTransaction(this.DBHelp.TransAction);
ds.SetChanges(dwChanges);
this.DBHelp.BeginTransAction();
if (ds.UpdateData() == 1)
{
this.DBHelp.Commit();
Response.Write("OK");
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo(ds.DBError);
}
}
catch (Exception ex)
{
this.DBHelp.Rollback();
this.SetErrorInfo(ex.Message);
}
finally
{
if (ds != null)
{
ds.Dispose();
ds = null;
}
}
}
//备注存盘
public void BeizhuSave()
{
string master = Request.Form["dw_list"].ToString();
SafeDS ds = new SafeDS("dw_wldw_zjqk_beizhu");
try
{
ds.SetChanges(master);
ds.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds.UpdateData() == 1)
{
this.DBHelp.Commit();
this.SetSuccessedInfo("数据保存成功");
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds.Dispose();
ds = null;
}
}
public void Save_Edit()
{
string dw_cmd = Request.Form["dw_cmd"].ToString();
SafeDS ds = new SafeDS("dw_wlcjgl_edit");
try
{
ds.SetChanges(dw_cmd);
ds.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds.UpdateData() == 1)
{
this.DBHelp.Commit();
this.SetSuccessedInfo("数据保存成功");
}
else
{
this.DBHelp.Rollback();
this.SetErrorInfo("数据保存失败!");
return;
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds.Dispose();
ds = null;
}
}
//单据保存
protected void Save()
{
string userID = AppService.GetUserID();
string ywbh = Request.Form["ywbh"].ToString();
var operation = Request.Form["operation"].ToString();
string dw_master = Request.Form["dw_master"].ToString();
string dw_jzxxx = Request.Form["dw_jzxxx"].ToString();
string dw_spxx = Request.Form["dw_spxx"].ToString();
string dw_zzxx = Request.Form["dw_zzxx"].ToString();
SafeDS ds_master = new SafeDS("dw_hddz_edit");
SafeDS ds_jzxxx = new SafeDS("dw_hddz_edit_jzxxx");
SafeDS ds_spxx = new SafeDS("dw_hddz_edit_spxx");
SafeDS ds_zzxx = new SafeDS("dw_hddz_edit_zzxx");
try
{
ds_master.SetChanges(dw_master);
ds_jzxxx.SetChanges(dw_jzxxx);
ds_spxx.SetChanges(dw_spxx);
ds_zzxx.SetChanges(dw_zzxx);
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);
}
for (int row = 1; row <= ds_spxx.RowCount; row++)
{
ds_spxx.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New);
}
for (int row = 1; row <= ds_zzxx.RowCount; row++)
{
ds_zzxx.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New);
}
}
;
//TODO 在服务器端，最好是重做一次数据校验，Demo简化处理，不再重复校验了。
if (ywbh == null || ywbh == "")
{
if (ds_master.GetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary) == Sybase.DataWindow.RowStatus.NewAndModified)
{
var year = System.DateTime.Now.ToShortDateString().Substring(2, 2);
SqlCommand cmd = this.DBHelp.GetCommand("select max(right(ywbh,4)) from yw_hddz where substring(ywbh,1,2) = '" + year + "' and zbr = '" + userID + "'");
object value = cmd.ExecuteScalar();
SqlCommand cmd_djdm = this.DBHelp.GetCommand("select max(Djdm) from Sys_Users where ID = '" + userID + "'");
object value_djdm = cmd_djdm.ExecuteScalar();
var Djdm = (string)value_djdm;
if (Convert.IsDBNull(value) || value == null)
{
ywbh = year + Djdm + "0001";
}
else
{
ywbh = year + Djdm + String.Format("{0:0000}", (long.Parse((string)value) + 1));
}
ds_master.SetItemString(1, "ywbh", ywbh);
}
else
{
ywbh = ds_master.GetItemString(1, "ywbh");
}
}
var hth = ds_master.GetItemString(1, "hth");
if (hth == "" || hth == null)
{
ds_master.SetItem(1, "hth", ywbh);
}
for (int row = 1; row <= ds_jzxxx.RowCount; row++)
{
ds_jzxxx.SetItemString(row, "ywbh", ywbh);
ds_jzxxx.SetItemDouble(row, "cxh", row);
}
for (int row = 1; row <= ds_spxx.RowCount; row++)
{
ds_spxx.SetItemString(row, "ywbh", ywbh);
ds_spxx.SetItemDouble(row, "cxh", row);
}
for (int row = 1; row <= ds_zzxx.RowCount; row++)
{
ds_zzxx.SetItemString(row, "ywbh", ywbh);
ds_zzxx.SetItemDouble(row, "cxh", row);
}
ds_master.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx.SetTransaction(this.DBHelp.TransAction);
ds_spxx.SetTransaction(this.DBHelp.TransAction);
ds_zzxx.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_master.UpdateData() == 1)
{
if (ds_jzxxx.UpdateData() == 1)
{
if (ds_spxx.UpdateData() == 1)
{
ds_zzxx.UpdateData();
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write(ywbh);
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("货代单据商品信息保存失败!\n\n详细错误信息：\n" + ds_spxx.DBError);
}
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("货代单据集装箱信息保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
}
}
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;
ds_spxx.Dispose();
ds_spxx = null;
ds_zzxx.Dispose();
ds_spxx = null;
}
}
//单据保存
protected void Save()
{
string userID = AppService.GetUserID();
string cpxxkbm = Request.Form["cpxxkbm"].ToString();
var operation = Request.Form["operation"].ToString();
string dw_master = Request.Form["dw_master"].ToString();
string dw_jzxxx = Request.Form["dw_jzxxx"].ToString();
string dw_jzxxx_jycljtyq = Request.Form["dw_jycljtyq"].ToString();
string dw_jzxxx_jydzyq = Request.Form["dw_jydzyq"].ToString();
string dw_jzxxx_hgsj = Request.Form["dw_hgsj"].ToString();
string dw_jzxxx_clqy = Request.Form["dw_clqy"].ToString();
string dw_jzxxx_slb = Request.Form["dw_slb"].ToString();
SafeDS ds_master = new SafeDS("dw_cpxxk_edit");
SafeDS ds_jzxxx = new SafeDS("dw_cpxxk_edit_cmd");
SafeDS ds_jzxxx_jycljtyq = new SafeDS("dw_cpxxk_edit_jycljtyq");
SafeDS ds_jzxxx_jydzyq = new SafeDS("dw_cpxxk_edit_jydzyq");
SafeDS ds_jzxxx_hgsj = new SafeDS("dw_cpxxk_edit_hgsj");
SafeDS ds_jzxxx_clqy = new SafeDS("dw_cpxxk_edit_clqy");
SafeDS ds_jzxxx_slb = new SafeDS("dw_cpxxk_edit_slb");
try
{
ds_master.SetChanges(dw_master);
ds_jzxxx.SetChanges(dw_jzxxx);
ds_jzxxx_jycljtyq.SetChanges(dw_jzxxx_jycljtyq);
ds_jzxxx_jydzyq.SetChanges(dw_jzxxx_jydzyq);
ds_jzxxx_hgsj.SetChanges(dw_jzxxx_hgsj);
ds_jzxxx_clqy.SetChanges(dw_jzxxx_clqy);
ds_jzxxx_slb.SetChanges(dw_jzxxx_slb);
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);
}
for (int row = 1; row <= ds_jzxxx_jycljtyq.RowCount; row++)
{
ds_jzxxx_jycljtyq.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New);
}
for (int row = 1; row <= ds_jzxxx_jydzyq.RowCount; row++)
{
ds_jzxxx_jydzyq.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New);
}
for (int row = 1; row <= ds_jzxxx_hgsj.RowCount; row++)
{
ds_jzxxx_hgsj.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New);
}
for (int row = 1; row <= ds_jzxxx_clqy.RowCount; row++)
{
ds_jzxxx_clqy.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New);
}
for (int row = 1; row <= ds_jzxxx_slb.RowCount; row++)
{
ds_jzxxx_slb.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New);
}
}
;
//TODO 在服务器端，最好是重做一次数据校验，Demo简化处理，不再重复校验了。
if (cpxxkbm == null || cpxxkbm == "")
{
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(cpxxkbm,5)) from yw_hddz_cpxxk where substring(cpxxkbm,4,8) = '" + year.Substring(0, 8) + "'");
object value = cmd.ExecuteScalar();
if (Convert.IsDBNull(value) || value == null)
{
cpxxkbm = "CPK" + year.Substring(0, 8) + "00001";
}
else
{
cpxxkbm = "CPK" + year.Substring(0, 8) + String.Format("{0:00000}", (long.Parse((string)value) + 1));
}
ds_master.SetItemString(1, "cpxxkbm", cpxxkbm);
}
else
{
cpxxkbm = ds_master.GetItemString(1, "cpxxkbm");
}
}
for (int row = 1; row <= ds_jzxxx.RowCount; row++)
{
ds_jzxxx.SetItemString(row, "cpxxkbm", cpxxkbm);
ds_jzxxx.SetItemDouble(row, "cxh", row);
}
for (int row = 1; row <= ds_jzxxx_jycljtyq.RowCount; row++)
{
ds_jzxxx_jycljtyq.SetItemString(row, "cpxxkbm", cpxxkbm);
ds_jzxxx_jycljtyq.SetItemDouble(row, "cxh", row);
}
for (int row = 1; row <= ds_jzxxx_jydzyq.RowCount; row++)
{
ds_jzxxx_jydzyq.SetItemString(row, "cpxxkbm", cpxxkbm);
ds_jzxxx_jydzyq.SetItemDouble(row, "cxh", row);
}
for (int row = 1; row <= ds_jzxxx_hgsj.RowCount; row++)
{
ds_jzxxx_hgsj.SetItemString(row, "cpxxkbm", cpxxkbm);
ds_jzxxx_hgsj.SetItemDouble(row, "cxh", row);
}
for (int row = 1; row <= ds_jzxxx_clqy.RowCount; row++)
{
ds_jzxxx_clqy.SetItemString(row, "cpxxkbm", cpxxkbm);
ds_jzxxx_clqy.SetItemDouble(row, "cxh", row);
}
for (int row = 1; row <= ds_jzxxx_slb.RowCount; row++)
{
ds_jzxxx_slb.SetItemString(row, "cpxxkbm", cpxxkbm);
ds_jzxxx_slb.SetItemDouble(row, "cxh", row);
}
ds_master.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx_jycljtyq.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx_jydzyq.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx_hgsj.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx_clqy.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx_slb.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_master.UpdateData() == 1)
{
ds_jzxxx.UpdateData();
ds_jzxxx_jycljtyq.UpdateData();
ds_jzxxx_jydzyq.UpdateData();
ds_jzxxx_hgsj.UpdateData();
ds_jzxxx_clqy.UpdateData();
ds_jzxxx_slb.UpdateData();
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write(cpxxkbm);
}
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;
ds_jzxxx_jycljtyq.Dispose();
ds_jzxxx_jycljtyq = null;
ds_jzxxx_jydzyq.Dispose();
ds_jzxxx_jydzyq = null;
ds_jzxxx_hgsj.Dispose();
ds_jzxxx_hgsj = null;
ds_jzxxx_clqy.Dispose();
ds_jzxxx_clqy = null;
ds_jzxxx_slb.Dispose();
ds_jzxxx_slb = null;
}
// if (ds_master.UpdateData() == 1)
// {
// if (ds_jzxxx.UpdateData() == 1)
// {
// if (ds_jzxxx_jycljtyq.UpdateData() == 1)
// {
// if (ds_jzxxx_jydzyq.UpdateData() == 1)
// {
// if (ds_jzxxx_hgsj.UpdateData() == 1)
// {
// if (ds_jzxxx_clqy.UpdateData() == 1)
// {
// this.DBHelp.Commit();
// //把单据号码，传回到客户端
// Response.Write(cpxxkbm);
// }
// else
// {
// this.DBHelp.Rollback(); ;
// this.SetErrorInfo("产品信息库处理区域保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
// }
// }
// else
// {
// this.DBHelp.Rollback(); ;
// this.SetErrorInfo("产品信息库海关审价保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
// }
// }
// else
// {
// this.DBHelp.Rollback(); ;
// this.SetErrorInfo("产品信息库检疫单证要求保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
// }
// }
// else
// {
// this.DBHelp.Rollback(); ;
// this.SetErrorInfo("产品信息库检疫处理具体要求保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
// }
// }
// else
// {
// this.DBHelp.Rollback();;
// this.SetErrorInfo("产品信息库明细保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
// }
// }
// 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;
// ds_jzxxx_jycljtyq.Dispose();
// ds_jzxxx_jycljtyq = null;
// ds_jzxxx_jydzyq.Dispose();
// ds_jzxxx_jydzyq = null;
// ds_jzxxx_hgsj.Dispose();
// ds_jzxxx_hgsj = null;
// ds_jzxxx_clqy.Dispose();
// ds_jzxxx_clqy = null;
//}
}
//单据保存
protected void Save()
{
string userID = AppService.GetUserID();
string tybm = Request.Form["tybm"].ToString();
var operation = Request.Form["operation"].ToString();
string gnkh_lxr = Request.Form["dw_gnkh_lxr"].ToString();
SafeDS ds_gnkh_lxr = new SafeDS("dw_ywy_gnkh_tybm_edit_lxr");
string gnkh_list = Request.Form["dw_gnkh_list"].ToString();
SafeDS ds_gnkh_list = new SafeDS("dw_ywy_gnkh_edit_list");
string gnkh_shdz = Request.Form["dw_gnkh_shdz"].ToString();
SafeDS ds_gnkh_shdz = new SafeDS("dw_ywy_gnkh_tybm_edit_shdz");
try
{
ds_gnkh_lxr.SetChanges(gnkh_lxr);
ds_gnkh_list.SetChanges(gnkh_list);
ds_gnkh_shdz.SetChanges(gnkh_shdz);
//TODO 在服务器端，最好是重做一次数据校验，Demo简化处理，不再重复校验了。
for (int row = 1; row <= ds_gnkh_lxr.RowCount; row++)
{
ds_gnkh_lxr.SetItemString(row, "yw_khbm", tybm);
ds_gnkh_lxr.SetItemDouble(row, "cxh", row);
}
for (int row = 1; row <= ds_gnkh_shdz.RowCount; row++)
{
ds_gnkh_shdz.SetItemString(row, "yw_khbm", tybm);
ds_gnkh_shdz.SetItemDouble(row, "cxh", row);
}
ds_gnkh_lxr.SetTransaction(this.DBHelp.TransAction);
ds_gnkh_list.SetTransaction(this.DBHelp.TransAction);
ds_gnkh_shdz.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_gnkh_lxr.UpdateData() == 1)
{
if (ds_gnkh_list.UpdateData() == 1)
{
if (ds_gnkh_shdz.UpdateData() == 1)
{
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write(tybm);
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("明细国内客户收货地址保存失败!\n\n详细错误信息：\n" + ds_gnkh_lxr.DBError);
}
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("明细国内客户保存失败!\n\n详细错误信息：\n" + ds_gnkh_lxr.DBError);
}
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("国内客户联系人保存失败!\n\n详细错误信息：\n" + ds_gnkh_lxr.DBError);
}
}
catch (Exception ex)
{
this.SetErrorInfo(ex.Message);
}
finally
{
ds_gnkh_lxr.Dispose();
ds_gnkh_lxr = null;
ds_gnkh_list.Dispose();
ds_gnkh_list = null;
ds_gnkh_shdz.Dispose();
ds_gnkh_shdz = null;
}
}
//单据保存
protected void Save()
{
string userID = AppService.GetUserID();
string sqdbh = Request.Form["sqdbh"].ToString();
var operation = Request.Form["operation"].ToString();
string dw_master = Request.Form["dw_master"].ToString();
string dw_cmd = Request.Form["dw_cmd"].ToString();
SafeDS ds_master = new SafeDS("dw_hddz_bgdsy_edit");
SafeDS ds_jzxxx = new SafeDS("dw_hddz_bgdsy_edit_cmd");
try
{
ds_master.SetChanges(dw_master);
ds_jzxxx.SetChanges(dw_cmd);
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 (sqdbh == null || sqdbh == "")
{
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(sqdbh,4)) from yw_hddz_bgdsy where substring(sqdbh,3,8) = '" + year.Substring(0, 8) + "'");
object value = cmd.ExecuteScalar();
if (Convert.IsDBNull(value) || value == null)
{
sqdbh = "QT" + year.Substring(0, 8) + "0001";
}
else
{
sqdbh = "QT" + year.Substring(0, 8) + String.Format("{0:0000}", (long.Parse((string)value) + 1));
}
ds_master.SetItemString(1, "sqdbh", sqdbh);
}
else
{
sqdbh = ds_master.GetItemString(1, "sqdbh");
}
}
for (int row = 1; row <= ds_jzxxx.RowCount; row++)
{
ds_jzxxx.SetItemString(row, "sqdbh", sqdbh);
}
ds_master.SetTransaction(this.DBHelp.TransAction);
ds_jzxxx.SetTransaction(this.DBHelp.TransAction);
this.DBHelp.BeginTransAction();
if (ds_master.UpdateData() == 1)
{
if (ds_jzxxx.UpdateData() == 1)
{
this.DBHelp.Commit();
//把单据号码，传回到客户端
Response.Write(sqdbh);
}
else
{
this.DBHelp.Rollback();;
this.SetErrorInfo("报关单使用明细信息保存失败!\n\n详细错误信息：\n" + ds_jzxxx.DBError);
}
}
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;
}
}
