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; } }
protected void Save() { SafeDS ds = new SafeDS("d_sys_roles_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; } ds.Dispose(); }
//#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; } }
//#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; } }
//单据保存 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 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); }
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; } }
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 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(); } }
//单据保存 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; } }
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; } }
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; } }
//发送欧恒 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; } }
//#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 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; } }
//备注存盘 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; } }
//单据保存 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; } }
//单据保存 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 Save() { string userID = AppService.GetUserID(); string yfkdbh = Request.Form["yfkdbh"].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_hddz_hdfyhycdfy_edit"); SafeDS ds_jzxxx = new SafeDS("dw_hddz_hdfyhycdfy_edit_cmd"); try { ds_master.SetChanges(dw_master); ds_jzxxx.SetChanges(dw_jzxxx); //TODO 在服务器端,最好是重做一次数据校验,Demo简化处理,不再重复校验了。 if (yfkdbh == null || yfkdbh == "") { var year = System.DateTime.Now.ToString("yyyyMMdd"); SqlCommand cmd = this.DBHelp.GetCommand("select max(right(yfkdbh,4)) from yw_hddz_fksqd_cmd where substring(yfkdbh,4,8) = '" + year.Substring(0, 8) + "' "); object value = cmd.ExecuteScalar(); if (Convert.IsDBNull(value) || value == null) { yfkdbh = "yfk" + year.Substring(0, 8) + "0001"; } else { yfkdbh = "yfk" + year.Substring(0, 8) + String.Format("{0:0000}", (long.Parse((string)value) + 1)); } if (ds_master.RowCount == 1) { ds_master.SetItemString(1, "jzxxx_yfkdbh", yfkdbh); } } else { yfkdbh = ds_master.GetItemString(1, "jzxxx_yfkdbh"); }; for (int row = 1; row <= ds_jzxxx.RowCount; row++) { ds_jzxxx.SetItemString(row, "sqdbh", yfkdbh); ds_jzxxx.SetItemString(row, "yfkdbh", yfkdbh); ds_jzxxx.SetItemDouble(row, "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.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 Response.Write(yfkdbh); } 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 SaveCopy() { 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(); string detail = Request.Form["dw_Detail"].ToString(); string fy = Request.Form["dw_Fy"].ToString(); SafeDS ds_master = new SafeDS("ds_read_jhdj"); SafeDS ds_cmd = new SafeDS("ds_read_jhdj_cmd"); SafeDS ds_fy = new SafeDS("ds_read_jhdj_fy"); try { ds_master.SetChanges(master); ds_cmd.SetChanges(detail); ds_fy.SetChanges(fy); for (int row = 1; row <= ds_cmd.RowCount; row++) { ds_cmd.SetItemString(row, "mxdbh", mxdbh); ds_cmd.SetItemDouble(row, "bbh", bbh); ds_cmd.SetItemDouble(row, "cxh", row); } for (int row = 1; row <= ds_fy.RowCount; row++) { ds_fy.SetItemString(row, "mxdbh", mxdbh); ds_fy.SetItemDouble(row, "bbh", bbh); ds_fy.SetItemDouble(row, "cxh", row); } ds_master.SetTransaction(this.DBHelp.TransAction); ds_cmd.SetTransaction(this.DBHelp.TransAction); ds_fy.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); ds_master.SetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); for (int row = 1; row <= ds_cmd.RowCount; row++) { ds_cmd.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } for (int row = 1; row <= ds_fy.RowCount; row++) { ds_fy.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } if (ds_master.UpdateData() == 1) { if (ds_cmd.UpdateData() == 1) { if (ds_fy.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 Response.Write(mxdbh); } else { this.DBHelp.Rollback(); this.SetErrorInfo("费用信息保存失败!\n\n详细错误信息:\n" + ds_fy.DBError); } } else { this.DBHelp.Rollback(); this.SetErrorInfo("商品信息保存失败!\n\n详细错误信息:\n" + ds_cmd.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_cmd.Dispose(); ds_cmd = null; ds_fy.Dispose(); ds_fy = null; } }
//单据保存 protected void Save() { string userID = AppService.GetUserID(); //string billID = string.Empty; string mxdbh = Request.Form["mxdbh"].ToString(); int bbh = Convert.ToInt32(Request.Form["bbh"].ToString()); var operation = Request.Form["operation"].ToString(); string master = Request.Form["dw_Master"].ToString(); string detail = Request.Form["dw_Detail"].ToString(); string memo = Request.Form["dw_Memo"].ToString(); string fy = Request.Form["dw_Fy"].ToString(); SafeDS ds_master = new SafeDS("dw_jhdj_edit_primary"); SafeDS ds_cmd = new SafeDS("dw_jhdj_edit_cmd"); SafeDS ds_fy = new SafeDS("dw_jhdj_edit_fy"); SafeDS ds_memo = new SafeDS("dw_jhdj_memo"); try { ds_master.SetChanges(master); ds_cmd.SetChanges(detail); ds_fy.SetChanges(fy); ds_memo.SetChanges(memo); //TODO 在服务器端,最好是重做一次数据校验,Demo简化处理,不再重复校验了。 if (mxdbh == null) { if (ds_master.GetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary) == Sybase.DataWindow.RowStatus.NewAndModified) { SqlCommand cmd = this.DBHelp.GetCommand("select max(mxdbh) from yw_detail "); object value = cmd.ExecuteScalar(); if (Convert.IsDBNull(value) || value == null) { mxdbh = "000001"; } else { mxdbh = String.Format("{0:000000}", (long.Parse((string)value) + 1)); } ds_master.SetItemString(1, "mxdbh", mxdbh); } else { mxdbh = ds_master.GetItemString(1, "mxdbh"); } } for (int row = 1; row <= ds_memo.RowCount; row++) { ds_memo.SetItemString(row, "dz_zhuangtai_dtl_no", mxdbh); } for (int row = 1; row <= ds_cmd.RowCount; row++) { ds_cmd.SetItemString(row, "mxdbh", mxdbh); ds_cmd.SetItemDouble(row, "bbh", bbh); ds_cmd.SetItemDouble(row, "cxh", row); } for (int row = 1; row <= ds_fy.RowCount; row++) { ds_fy.SetItemString(row, "mxdbh", mxdbh); ds_fy.SetItemDouble(row, "bbh", bbh); ds_fy.SetItemDouble(row, "cxh", row); } ds_master.SetTransaction(this.DBHelp.TransAction); ds_cmd.SetTransaction(this.DBHelp.TransAction); ds_fy.SetTransaction(this.DBHelp.TransAction); ds_memo.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (operation == "copy" || operation == "modify") { ds_master.SetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); for (int row = 1; row <= ds_cmd.RowCount; row++) { ds_cmd.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } for (int row = 1; row <= ds_fy.RowCount; row++) { ds_fy.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } for (int row = 1; row <= ds_memo.RowCount; row++) { ds_memo.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } } ; if (ds_master.UpdateData() == 1) { if (ds_cmd.UpdateData() == 1) { if (ds_fy.UpdateData() == 1) { if (ds_memo.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 Response.Write(mxdbh); } else { this.DBHelp.Rollback(); this.SetErrorInfo("结汇单据单证格式保存失败!\n\n详细错误信息:\n" + ds_memo.DBError); } } else { this.DBHelp.Rollback(); this.SetErrorInfo("结汇单据保存失败!\n\n详细错误信息:\n" + ds_fy.DBError); } } else { this.DBHelp.Rollback(); this.SetErrorInfo("结汇单据保存失败!\n\n详细错误信息:\n" + ds_cmd.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_cmd.Dispose(); ds_cmd = null; ds_fy.Dispose(); ds_fy = null; ds_memo.Dispose(); ds_memo = 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 billID = string.Empty; string mxdbh = Request.Form["mxdbh"].ToString(); int bbh = Convert.ToInt32(Request.Form["bbh"].ToString()); var operation = Request.Form["operation"].ToString(); string master = Request.Form["dw_Master"].ToString(); string detail = Request.Form["dw_Detail"].ToString(); string bgcmd = Request.Form["dw_Bg"].ToString(); string fy = Request.Form["dw_Fy"].ToString(); string memo = Request.Form["dw_Memo"].ToString(); SafeDS ds_master = new SafeDS("dw_bgdj_edit_primary"); SafeDS ds_cmd = new SafeDS("dw_bgdj_edit_cmd"); SafeDS ds_cmdbg = new SafeDS("dw_bgdj_edit_cmd_hb"); SafeDS ds_fy = new SafeDS("dw_bgdj_edit_fy"); SafeDS ds_memo = new SafeDS("dw_bgdj_memo"); try { ds_master.SetChanges(master); ds_cmd.SetChanges(detail); ds_cmdbg.SetChanges(bgcmd); ds_fy.SetChanges(fy); ds_memo.SetChanges(memo); for (int row = 1; row <= ds_memo.RowCount; row++) { ds_memo.SetItemString(row, "cy_zhuangtai_dtl_no", mxdbh); } for (int row = 1; row <= ds_cmdbg.RowCount; row++) { ds_cmdbg.SetItemString(row, "mxdbh", mxdbh); ds_cmdbg.SetItemDouble(row, "bbh", bbh); ds_cmdbg.SetItemDouble(row, "cxh", row); } for (int row = 1; row <= ds_cmd.RowCount; row++) { ds_cmd.SetItemString(row, "mxdbh", mxdbh); ds_cmd.SetItemDouble(row, "bbh", bbh); ds_cmd.SetItemDouble(row, "cxh", row); } for (int row = 1; row <= ds_fy.RowCount; row++) { ds_fy.SetItemString(row, "mxdbh", mxdbh); ds_fy.SetItemDouble(row, "bbh", bbh); ds_fy.SetItemDouble(row, "cxh", row); } ds_master.SetTransaction(this.DBHelp.TransAction); ds_cmd.SetTransaction(this.DBHelp.TransAction); ds_cmdbg.SetTransaction(this.DBHelp.TransAction); ds_fy.SetTransaction(this.DBHelp.TransAction); ds_memo.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (operation == "copy" || operation == "modify") { ds_master.SetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); for (int row = 1; row <= ds_cmd.RowCount; row++) { ds_cmd.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } for (int row = 1; row <= ds_fy.RowCount; row++) { ds_fy.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } for (int row = 1; row <= ds_memo.RowCount; row++) { ds_memo.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } for (int row = 1; row <= ds_cmdbg.RowCount; row++) { ds_cmdbg.SetRowStatus(row, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } } ; if (ds_master.UpdateData() == 1) { if (ds_cmd.UpdateData() == 1) { if (ds_cmdbg.UpdateData() == 1) { if (ds_fy.UpdateData() == 1) { if (ds_memo.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 Response.Write(mxdbh); } else { this.DBHelp.Rollback(); this.SetErrorInfo("单据单证格式保存失败!\n\n详细错误信息:\n" + ds_memo.DBError); } } else { this.DBHelp.Rollback(); this.SetErrorInfo("单据费用信息保存失败!\n\n详细错误信息:\n" + ds_fy.DBError); } } else { this.DBHelp.Rollback(); this.SetErrorInfo("单据报关商品保存失败!\n\n详细错误信息:\n" + ds_cmdbg.DBError); } } else { this.DBHelp.Rollback(); this.SetErrorInfo("单据明细商品保存失败!\n\n详细错误信息:\n" + ds_cmd.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_cmd.Dispose(); ds_cmd = null; ds_cmdbg.Dispose(); ds_cmdbg = null; ds_fy.Dispose(); ds_fy = null; ds_memo.Dispose(); ds_memo = null; } }
//单据保存 protected void Save() { string userID = AppService.GetUserID(); string yw_spbm = Request.Form["yw_spbm"].ToString(); var operation = Request.Form["operation"].ToString(); string master = Request.Form["dw_Master"].ToString(); SafeDS ds_master = new SafeDS("dw_ywy_commodity_edit"); try { ds_master.SetChanges(master); //TODO 在服务器端,最好是重做一次数据校验,Demo简化处理,不再重复校验了。 if ((operation == "copy" || operation == "modify") && yw_spbm == "") { ds_master.SetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary, Sybase.DataWindow.RowStatus.New); } ; if (yw_spbm == null || yw_spbm == "") { if (ds_master.GetRowStatus(1, Sybase.DataWindow.DataBuffer.Primary) == Sybase.DataWindow.RowStatus.NewAndModified || operation == "copy") { SqlCommand cmd = this.DBHelp.GetCommand("select max(yw_spbm) from yw_commodity where sqr=@userid "); cmd.Parameters.Add(new SqlParameter("@userid", userID)); object value = cmd.ExecuteScalar(); if (Convert.IsDBNull(value) || value == null) { yw_spbm = userID + "000001"; } else { yw_spbm = (string)value; yw_spbm = yw_spbm.Remove(0, userID.Length); yw_spbm = userID + String.Format("{0:000000}", (long.Parse(yw_spbm) + 1)); } ds_master.SetItemString(1, "yw_spbm", yw_spbm); } else { yw_spbm = ds_master.GetItemString(1, "yw_spbm"); } } ds_master.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (ds_master.UpdateData() == 1) { this.DBHelp.Commit(); //把单据号码,传回到客户端 Response.Write(yw_spbm); } 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 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 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_log = Request.Form["dw_log"].ToString(); SafeDS ds_master = new SafeDS("dw_ywxx_edit"); SafeDS ds_jzxxx = new SafeDS("dw_ywxx_edit_jzxxx"); SafeDS ds_spxx = new SafeDS("dw_ywxx_edit_spxx"); SafeDS ds_log = new SafeDS("dw_s_log_list"); try { ds_master.SetChanges(dw_master); ds_jzxxx.SetChanges(dw_jzxxx); ds_spxx.SetChanges(dw_spxx); ds_log.SetChanges(dw_log); 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_log.RowCount; row++) { ds_log.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 Dqdm = ds_master.GetItemString(1, "dqdm"); var year = System.DateTime.Now.ToShortDateString().Substring(2, 2); SqlCommand cmd = this.DBHelp.GetCommand("select max(substring( ywbh,5,4)) from yw_hddz where substring(ywbh,1,2) = '" + year + "' and dqdm = '" + Dqdm + "' "); object value = cmd.ExecuteScalar(); if (Convert.IsDBNull(value) || value == null) { ywbh = year + Dqdm + "0001"; } else { ywbh = year + Dqdm + 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_log.RowCount; row++) { if (ds_log.GetItemString(row, "funname") != "DelHddz") { ds_log.SetItemString(row, "mainid", ywbh); } } ds_master.SetTransaction(this.DBHelp.TransAction); ds_jzxxx.SetTransaction(this.DBHelp.TransAction); ds_spxx.SetTransaction(this.DBHelp.TransAction); ds_log.SetTransaction(this.DBHelp.TransAction); this.DBHelp.BeginTransAction(); if (ds_master.UpdateData() == 1) { if (ds_jzxxx.UpdateData() == 1) { ds_spxx.UpdateData(); if (ds_log.UpdateData() == 1) { this.DBHelp.Commit(); var cm = ds_master.GetItemString(1, "cm"); var yjkgsj = ds_master.GetItemDateTime(1, "yjkgsj"); var sjkgsj = ds_master.GetItemDateTime(1, "sjkgsj"); var hcorhbh = ds_master.GetItemString(1, "hcorhbh"); var mtxx = ds_master.GetItemString(1, "mtxx"); var ssbm = ds_master.GetItemString(1, "ssbm"); var bgdh = ds_master.GetItemString(1, "bgdh"); var ztdh = ds_master.GetItemString(1, "ztdh"); var bgsj = ds_master.GetItemDate(1, "bgsj"); var jgwq = ds_master.GetItemDateTime(1, "jgwq"); var hgdc = ds_master.GetItemString(1, "hgdc"); var mcq_rq = ds_master.GetItemDateTime(1, "mcq_rq"); if (cm.Length > 0 && hcorhbh.Length > 0) { if (mtxx == null) { mtxx = ""; } ; if (ssbm == null) { ssbm = ""; } ; SetUpdatekgsj(cm, yjkgsj, sjkgsj, hcorhbh, mtxx, ssbm); } ; if (ztdh.Length > 0) { SetUpdatebgdh(ztdh, bgdh, bgsj, hgdc, jgwq, mcq_rq); } //把单据号码,传回到客户端 Response.Write(ywbh); } 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_jzxxx.DBError + " " + ds_jzxxx.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_jzxxx.Dispose(); ds_jzxxx = null; ds_spxx.Dispose(); ds_spxx = null; ds_log.Dispose(); ds_log = null; } }