Пример #1
0
        /// <summary>
        /// 功能描述:插入
        /// 创建时间:2018-14-4
        /// 创建  人:周文卿
        /// </summary>
        /// <param name="tblAccounting"></param>
        /// <returns></returns>
        public DataTable InsertAccounting(tblAccounting tblAccounting)
        {
            try {
                DataTable table = new DataTable();

                SqlParameter[] sqlParas =
                {
                    new SqlParameter("@fldAutoID",         "0"),
                    new SqlParameter("@fldAccountingnum",  tblAccounting.fldAccountingnum),
                    new SqlParameter("@fldMerchID",        tblAccounting.fldMerchID),
                    new SqlParameter("@fldTotalAmount",    tblAccounting.fldTotalAmount),
                    new SqlParameter("@fldWithdraw",       tblAccounting.fldWithdraw),
                    new SqlParameter("@fldFrozenAmount",   tblAccounting.fldFrozenAmount),
                    new SqlParameter("@fldUnsettledAmoun", tblAccounting.fldUnsettledAmoun),
                    new SqlParameter("@fldState",          tblAccounting.fldState),
                };

                table = rule.RunProcedure_V2("usp_tblOrdertable_Insert", sqlParas.ToList(), "", "YYPlayContext");
                return(table);
            }
            catch (Exception e)
            {
                throw new InsertException(e.Message, "RuleAccounting", "InsertAccounting", "插入失败");
            }
        }