BN089-BS开发框架MVC4版/source20131023/Zephyr.Web/Areas/Mms/Common/MmsService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Newtonsoft.Json.Linq;
using Zephyr.Core;
using Zephyr.Data;
using Zephyr.Models;

namespace Zephyr.Web.Areas.Mms.Common
{
    [Module("Mms")]
    public class MmsService : ServiceBase<ModelBase>
    {
        //审核表单
        public int Audit(string tableName, string billNo, string status, string comment)
        {
            db.UseTransaction(true);

            var userName = MmsHelper.GetUserName();
            var pUpdate = ParamUpdate.Instance()
                .Update(tableName)
                .Column("ApproveState", status)
                .Column("ApproveRemark", comment)
                .Column("ApprovePerson", userName)
                .Column("ApproveDate", DateTime.Now)
                .AndWhere("BillNo", billNo);

            var rowsAffected = BuilderParse(pUpdate).Execute();

            if (rowsAffected<=0)
            {
                db.Rollback();
                return rowsAffected;
            }

            switch (tableName)
            {
                case "mms_receive":
                case "mms_refund":
                    rowsAffected = mms_warehouseStockService.UpdateWarehouseStock(db, tableName, billNo, status == "passed");
                    break;

                case "mms_send":
                case "mms_return":
                case "mms_transfer":
                case "mms_lossReport":
                    rowsAffected = mms_warehouseStockService.UpdateWarehouseStock(db, tableName, billNo, status != "passed");
                    break;

                case "mms_rentOut":
                    rowsAffected = mms_rentOutService.CalcRentOutMoney(db, billNo);
                    break;
            }
 
            if (rowsAffected<0)
            {
                db.Rollback();
                return rowsAffected;
            }