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