ChengDa_English/SGGL/BLL/CQMS/Information/VisaApplicationApproveService.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BLL
{
    public class VisaApplicationApproveService
    {
        public static Model.CQMS_VisaApplicationApprove GetSee(string VisaApplicationId, string userId)
        {
            Model.SGGLDB db = Funs.DB;
            return db.CQMS_VisaApplicationApprove.FirstOrDefault(x => x.VisaApplicationId == VisaApplicationId && x.ApproveType == "S" && x.ApproveMan == userId && x.ApproveDate == null);
        }

        public static void See(string VisaApplicationId, string userId)
        {
            using (var db = new Model.SGGLDB(Funs.ConnString))
            {
                var res = db.CQMS_VisaApplicationApprove.FirstOrDefault(x => x.VisaApplicationId == VisaApplicationId && x.ApproveType == "S" && x.ApproveMan == userId && x.ApproveDate == null);
                if (res != null)
                {
                    res.ApproveDate = DateTime.Now;
                    db.SubmitChanges();
                }
            }
        }

        public static Model.CQMS_VisaApplicationApprove GetCompile(string VisaApplicationId)
        {
            return Funs.DB.CQMS_VisaApplicationApprove.FirstOrDefault(x => x.VisaApplicationId == VisaApplicationId && x.ApproveType == BLL.Const.VisaApplication_Compile);
        }

        /// <summary>
        /// 根据工程签证申请/评审表发布Id获取对应组会签人id集合信息
        /// </summary>
        /// <param name="VisaApplicationCode">工程签证申请/评审表发布Id</param>
        /// <returns>工程签证申请/评审表审批集合</returns>
        public static List<string> GetUserIdsApprovesBySignType(string VisaApplicationId, string signType)
        {
            var edtion = (from x in Funs.DB.CQMS_VisaApplicationApprove where x.VisaApplicationId == VisaApplicationId && x.ApproveType == BLL.Const.VisaApplication_Audit2 orderby x.Edition select x.Edition ?? 0).FirstOrDefault();
            return (from x in Funs.DB.CQMS_VisaApplicationApprove where x.VisaApplicationId == VisaApplicationId && x.ApproveType != "S" && x.SignType == signType && x.Edition == edtion select x.ApproveMan).ToList();
        }

        public static int? GetUserIdsApprovesBySignTypeEditon(string VisaApplicationId)
        {
            int edition = 0;
            var solution = Funs.DB.CQMS_VisaApplication.FirstOrDefault(p => p.VisaApplicationId == VisaApplicationId);
            if (solution != null)
            {
                edition = Convert.ToInt32(solution.Edition);
            }
            return edition;
        }

        /// <summary>
        /// 修改工程签证申请/评审表审批信息
        /// </summary>
        /// <param name="managerRuleApprove">工程签证申请/评审表审批实体</param>
        public static void UpdateVisaApplicationApprove(Model.CQMS_VisaApplicationApprove approve)
        {
            Model.SGGLDB db = Funs.DB;
            Model.CQMS_VisaApplicationApprove newApprove = db.CQMS_VisaApplicationApprove.First(e => e.VisaApplicationApproveId == approve.VisaApplicationApproveId && e.ApproveDate == null);
            newApprove.VisaApplicationId = approve.VisaApplicationId;
            newApprove.ApproveMan = approve.ApproveMan;
            newApprove.ApproveDate = approve.ApproveDate;
            newApprove.ApproveIdea = approve.ApproveIdea;
            newApprove.IsAgree = approve.IsAgree;
            newApprove.ApproveType = approve.ApproveType;
            newApprove.Edition = approve.Edition;
            db.SubmitChanges();
        }
        /// <summary>
        /// 根据工程签证申请/评审表发布Id获取所以对应工程签证申请/评审表审批信息(查询全部会签状态)
        /// </summary>
        /// <param name="VisaApplicationCode">工程签证申请/评审表发布Id</param>
        /// <returns>工程签证申请/评审表审批集合</returns>
        public static List<Model.CQMS_VisaApplicationApprove> GetHandleVisaApplicationApprovesByVisaApplicationId(string VisaApplicationId, int edition)
        {
            var list = Funs.DB.CQMS_VisaApplicationApprove.Where(p => p.VisaApplicationId == VisaApplicationId && p.ApproveType == Const.VisaApplication_Audit2 && p.Edition == edition).ToList();
            return list;

        }

        public static List<Model.CQMS_VisaApplicationApprove> GetHandleConstruct(string VisaApplicationId, int edition)
        {
            var list = Funs.DB.CQMS_VisaApplicationApprove.Where(p => p.VisaApplicationId == VisaApplicationId && p.ApproveType != "S" && p.ApproveDate != null && p.Edition == edition).ToList();
            return list;

        }
        /// <summary>
        /// 根据工程签证申请/评审表发布Id获取所以对应工程签证申请/评审表审批信息
        /// </summary>
        /// <param name="VisaApplicationCode">工程签证申请/评审表发布Id</param>
        /// <returns>工程签证申请/评审表审批集合</returns>
        public static List<Model.CQMS_VisaApplicationApprove> GetVisaApplicationApprovesByVisaApplicationId(string VisaApplicationId, string state)
        {
            Model.SGGLDB db = Funs.DB;
            var reDate = (from x in db.CQMS_VisaApplicationApprove where x.VisaApplicationId == VisaApplicationId && x.ApproveType == BLL.Const.VisaApplication_ReCompile orderby x.ApproveDate descending select x.ApproveDate).FirstOrDefault();
            if (reDate == null)
            {
                return (from x in db.CQMS_VisaApplicationApprove where x.VisaApplicationId == VisaApplicationId && x.ApproveType == state select x).ToList();
            }
            else
            {
                return (from x in db.CQMS_VisaApplicationApprove where x.VisaApplicationId == VisaApplicationId && x.ApproveType == state && (x.ApproveDate == null || x.ApproveDate > reDate) select x).ToList();
            }
        }
        /// <summary>
        /// 根据工程签证申请/评审表发布Id获取所有对应版次会签不同意的工程签证申请/评审表审批信息
        /// </summary>
        /// <param name="visaApplicationId">工程签证申请/评审表发布Id</param>
        /// <param name="edtion">版次</param>
        /// <returns>工程签证申请/评审表审批集合</returns>
        public static List<Model.CQMS_VisaApplicationApprove> GetHQNotAggreeApprovesByVisaApplicationIdAndEdtion(string visaApplicationId, int edtion)
        {
            Model.SGGLDB db = Funs.DB;
            return (from x in db.CQMS_VisaApplicationApprove where x.VisaApplicationId == visaApplicationId && x.Edition == edtion && x.IsAgree == false select x).ToList();
        }
        /// <summary>
        /// 获取工程签证申请/评审表模板列表
        /// </summary>
        /// <param name="satartRowIndex"></param>
        /// <param name="maximumRows"></param>
        /// <returns></returns>
        public static IList<Model.CQMS_VisaApplicationApprove> getListData(string VisaApplicationId)
        {
            Model.SGGLDB db = Funs.DB;
            var res = from x in db.CQMS_VisaApplicationApprove
                      where x.VisaApplicationId == VisaApplicationId && x.ApproveDate != null && x.ApproveType != "S"
                      orderby x.ApproveDate
                      select x;

            //select new
            //{
            //    x.VisaApplicationApproveId,
            //    x.VisaApplicationId,
            //    x.ApproveMan,
            //    x.ApproveDate,
            //    x.IsAgree,
            //    x.ApproveIdea,
            //    x.ApproveType,
            //    x.SignType,
            //    //= x.IsAgree == true ? "是" : "否",
            //};
            return res.ToList();
        }

        /// <summary>
        /// 获取未代办的记录数量
        /// </summary>
        /// <param name="satartRowIndex"></param>
        /// <param name="maximumRows"></param>
        /// <returns></returns>
        public static int getListSolutionApproveCount(string visaApplicationId, string man, string signType)
        {

            var res = (from x in Funs.DB.CQMS_VisaApplicationApprove
                       where x.VisaApplicationId == visaApplicationId && x.ApproveDate == null && x.ApproveType != "S" && x.ApproveMan.Equals(man) && x.SignType == signType
                       orderby x.ApproveDate
                       select x).Count();
            return res;
        }
        public static IList<Model.CQMS_VisaApplicationApprove> getListSolutionApprove(string visaApplicationId, string man)
        {

            var res = (from x in Funs.DB.CQMS_VisaApplicationApprove
                       where x.VisaApplicationId == visaApplicationId && x.ApproveDate == null && x.ApproveType != "S" && x.ApproveMan.Equals(man)
                       orderby x.ApproveDate
                       select x).ToList();
            return res;
        }
        /// <summary>
        /// 删除未代办的记录
        /// </summary>
        /// <param name="VisaApplicationId"></param>
        public static void delSolutionApprove(string visaApplicationId, string man)
        {
            Model.SGGLDB db = Funs.DB;
            var q = (from x in Funs.DB.CQMS_VisaApplicationApprove where x.VisaApplicationId == visaApplicationId && x.ApproveType != "S" && x.ApproveMan.Equals(man) && x.ApproveDate == null select x).ToList();
            db.CQMS_VisaApplicationApprove.DeleteAllOnSubmit(q);
            db.SubmitChanges();

        }


        /// <summary>
        /// 根据工程签证申请/评审表编号删除对应的所有工程签证申请/评审表审批信息
        /// </summary>
        /// <param name="VisaApplicationCode">工程签证申请/评审表编号</param>
        public static void DeleteVisaApplicationApprovesByVisaApplicationId(string VisaApplicationId)
        {
            Model.SGGLDB db = Funs.DB;
            var q = (from x in Funs.DB.CQMS_VisaApplicationApprove where x.VisaApplicationId == VisaApplicationId select x).ToList();
            db.CQMS_VisaApplicationApprove.DeleteAllOnSubmit(q);
            db.SubmitChanges();
        }
        /// <summary>
        /// 根据工程签证申请/评审表编号获取一个工程签证申请/评审表审批信息
        /// </summary>
        /// <param name="VisaApplicationCode">工程签证申请/评审表编号</param>
        /// <returns>一个工程签证申请/评审表审批实体</returns>
        public static Model.CQMS_VisaApplicationApprove GetVisaApplicationApproveByApproveMan(string VisaApplicationId, string approveMan)
        {

            return Funs.DB.CQMS_VisaApplicationApprove.FirstOrDefault(x => x.VisaApplicationId == VisaApplicationId && x.ApproveMan == approveMan && x.ApproveType != "S" && x.ApproveDate == null);
        }
        public static Model.CQMS_VisaApplicationApprove GetConstructSoluAppByApproveMan(string VisaApplicationId, string approveMan, int edtion)
        {

            return Funs.DB.CQMS_VisaApplicationApprove.FirstOrDefault(x => x.VisaApplicationId == VisaApplicationId && x.Edition == edtion && x.ApproveMan == approveMan && x.ApproveType != "S" && x.ApproveDate == null);
        }

        public static Model.CQMS_VisaApplicationApprove GetConstructSolApproveByApproveMan(string VisaApplicationId, string approveMan)
        {
            return Funs.DB.CQMS_VisaApplicationApprove.FirstOrDefault(x => x.VisaApplicationId == VisaApplicationId && x.ApproveMan == approveMan && x.ApproveType != "S" && x.ApproveDate == null);
        }


        /// <summary>
        /// 增加工程签证申请/评审表审批信息
        /// </summary>
        /// <param name="managerRuleApprove">工程签证申请/评审表审批实体</param>
        public static void AddVisaApplicationApprove(Model.CQMS_VisaApplicationApprove approve)
        {
            var db = Funs.DB;
            Model.CQMS_VisaApplicationApprove newApprove = new Model.CQMS_VisaApplicationApprove();
            if (string.IsNullOrWhiteSpace(approve.VisaApplicationApproveId))
            {
                newApprove.VisaApplicationApproveId = SQLHelper.GetNewID(typeof(Model.CQMS_VisaApplicationApprove));
            }
            else
            {
                newApprove.VisaApplicationApproveId = approve.VisaApplicationApproveId;
            }
            newApprove.VisaApplicationId = approve.VisaApplicationId;
            newApprove.ApproveMan = approve.ApproveMan;
            newApprove.ApproveDate = approve.ApproveDate;
            newApprove.ApproveIdea = approve.ApproveIdea;
            newApprove.IsAgree = approve.IsAgree;
            newApprove.ApproveType = approve.ApproveType;
            newApprove.SignType = approve.SignType;
            newApprove.Edition = approve.Edition;
            db.CQMS_VisaApplicationApprove.InsertOnSubmit(newApprove);
            db.SubmitChanges();
        }
    }
}