예제 #1
0
        //单据保存
        protected void Save()
        {
            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");
            SafeDS ds_jzxxx  = new SafeDS("dw_wlgz_edit_cmd_js");

            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_jzxxx.GetItemDouble(row, "fyje");
                }

                ds_master.SetTransaction(this.DBHelp.TransAction);
                ds_jzxxx.SetTransaction(this.DBHelp.TransAction);

                this.DBHelp.BeginTransAction();

                var dd = ds_master.UpdateData();
                var cc = ds_jzxxx.UpdateData();

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