Project_Net4/040_高速驿网/101_WebApi/GSYWApi/Helper/Business/HIGHWAYPROINSTHelper.cs

using System;
using System.Collections.Generic;
using System.Data;
using SuperMap.RealEstate.ServiceModel;
using Business = SuperMap.RealEstate.BasicArchives.Storage.Business;

namespace GSYWApi.Helper
{
    /// <summary>
    /// 项目实例表相关方法
    /// </summary>
    public class HIGHWAYPROINSTHelper
    {
        #region 获取项目实例表列表
        public static List<Model.HIGHWAYPROINSTModel> GetHIGHWAYPROINSTList(Transaction transaction,
            ref int TotalCount, int PageIndex = 1, int PageSize = 10)
        {
            List<Model.HIGHWAYPROINSTModel> HIGHWAYPROINSTList = new List<Model.HIGHWAYPROINSTModel>();

            string WhereSQL = "", RowFilterSQL = "";

            DataTable dtHIGHWAYPROINST = new Business.HIGHWAYPROINST(transaction).FillDataTable(WhereSQL);
            if (RowFilterSQL != "")
            {
                dtHIGHWAYPROINST.DefaultView.RowFilter = RowFilterSQL;
            }
            //排序：
            dtHIGHWAYPROINST.DefaultView.Sort = "";
            dtHIGHWAYPROINST = dtHIGHWAYPROINST.DefaultView.ToTable();
            //获取查询结果总记录条数
            TotalCount = dtHIGHWAYPROINST.Rows.Count;
            //根据传入的页码和每页显示条数返回结果
            dtHIGHWAYPROINST = CommonHelper.GetDataTableWithPageSize(dtHIGHWAYPROINST, PageSize, PageIndex);

            foreach (DataRow drHIGHWAYPROINST in dtHIGHWAYPROINST.Rows)
            {
                Model.HIGHWAYPROINSTModel highwayproinstModel = new Model.HIGHWAYPROINSTModel();

                highwayproinstModel.HIGHWAYPROINST_ID = drHIGHWAYPROINST["HIGHWAYPROINST_ID"].TryParseToInt();    //项目内码
                highwayproinstModel.PROINST_ID = drHIGHWAYPROINST["PROINST_ID"].TryParseToInt();    //流程内码
                highwayproinstModel.ACCEPT_CODE = drHIGHWAYPROINST["ACCEPT_CODE"].ToString();    //业务编号
                highwayproinstModel.HIGHWAYPROINST_CREATEDATE = drHIGHWAYPROINST["HIGHWAYPROINST_CREATEDATE"].TryParseToDateTime();    //创建时间
                highwayproinstModel.STAFF_ID = drHIGHWAYPROINST["STAFF_ID"].TryParseToInt();    //员工内码
                highwayproinstModel.STAFF_NAME = drHIGHWAYPROINST["STAFF_NAME"].ToString();    //员工名称
                highwayproinstModel.DEPT_ID = drHIGHWAYPROINST["DEPT_ID"].TryParseToInt();    //部门
                highwayproinstModel.DEPT_NAME = drHIGHWAYPROINST["DEPT_NAME"].ToString();    //部门内码
                highwayproinstModel.HIGHWAYPROINST_ENDDATE = drHIGHWAYPROINST["HIGHWAYPROINST_ENDDATE"].TryParseToDateTime();    //结束时间
                highwayproinstModel.HIGHWAYPROINST_NEXTID = drHIGHWAYPROINST["HIGHWAYPROINST_NEXTID"].TryParseToInt();    //HIGHWAYPROINST_NEXTID
                highwayproinstModel.HIGHWAYPROINST_DESC = drHIGHWAYPROINST["HIGHWAYPROINST_DESC"].ToString();    //备注
                highwayproinstModel.PROINST_FINISHDATE = drHIGHWAYPROINST["PROINST_FINISHDATE"].TryParseToDateTime();    //实际办结时间

                HIGHWAYPROINSTList.Add(highwayproinstModel);
            }

            return HIGHWAYPROINSTList;
        }
        #endregion

        #region 获取项目实例表明细
        public static Model.HIGHWAYPROINSTModel GetHIGHWAYPROINSTDetail(Transaction transaction, int HIGHWAYPROINSTId)
        {
            Model.HIGHWAYPROINSTModel highwayproinstModel = new Model.HIGHWAYPROINSTModel();

            Business.HIGHWAYPROINST _HIGHWAYPROINST = new Business.HIGHWAYPROINST(transaction);
            _HIGHWAYPROINST.HIGHWAYPROINST_ID = HIGHWAYPROINSTId;
            if (_HIGHWAYPROINST.Select())
            {
                highwayproinstModel.HIGHWAYPROINST_ID = _HIGHWAYPROINST.HIGHWAYPROINST_ID;    //项目内码
                highwayproinstModel.PROINST_ID = _HIGHWAYPROINST.PROINST_ID;    //流程内码
                highwayproinstModel.ACCEPT_CODE = _HIGHWAYPROINST.ACCEPT_CODE;    //业务编号
                highwayproinstModel.HIGHWAYPROINST_CREATEDATE = _HIGHWAYPROINST.HIGHWAYPROINST_CREATEDATE;    //创建时间
                highwayproinstModel.STAFF_ID = _HIGHWAYPROINST.STAFF_ID;    //员工内码
                highwayproinstModel.STAFF_NAME = _HIGHWAYPROINST.STAFF_NAME;    //员工名称
                highwayproinstModel.DEPT_ID = _HIGHWAYPROINST.DEPT_ID;    //部门
                highwayproinstModel.DEPT_NAME = _HIGHWAYPROINST.DEPT_NAME;    //部门内码
                highwayproinstModel.HIGHWAYPROINST_ENDDATE = _HIGHWAYPROINST.HIGHWAYPROINST_ENDDATE;    //结束时间
                highwayproinstModel.HIGHWAYPROINST_NEXTID = _HIGHWAYPROINST.HIGHWAYPROINST_NEXTID;    //HIGHWAYPROINST_NEXTID
                highwayproinstModel.HIGHWAYPROINST_DESC = _HIGHWAYPROINST.HIGHWAYPROINST_DESC;    //备注
                highwayproinstModel.PROINST_FINISHDATE = _HIGHWAYPROINST.PROINST_FINISHDATE;    //实际办结时间
            }

            return highwayproinstModel;
        }
        #endregion

        #region 同步项目实例表
        public static bool SynchroHIGHWAYPROINST(Transaction transaction, Model.HIGHWAYPROINSTModel highwayproinstModel)
        {
            bool SynchroFlag = true;

            Business.HIGHWAYPROINST _HIGHWAYPROINST = new Business.HIGHWAYPROINST(transaction);
            if (highwayproinstModel.HIGHWAYPROINST_ID != null)
            {
                _HIGHWAYPROINST.HIGHWAYPROINST_ID = highwayproinstModel.HIGHWAYPROINST_ID;
                if (_HIGHWAYPROINST.Select())
                {
                    SynchroModelToObject(_HIGHWAYPROINST, highwayproinstModel);
                    _HIGHWAYPROINST.Update();
                }
                else
                {
                    SynchroFlag = false;
                }
            }
            else
            {
                SynchroModelToObject(_HIGHWAYPROINST, highwayproinstModel);
                _HIGHWAYPROINST.Insert();
            }

            return SynchroFlag;
        }

        #region 赋值项目实例表数据对象
        public static void SynchroModelToObject(Business.HIGHWAYPROINST _HIGHWAYPROINST, Model.HIGHWAYPROINSTModel highwayproinstModel)
        {
            _HIGHWAYPROINST.PROINST_ID = highwayproinstModel.PROINST_ID;    //流程内码
            _HIGHWAYPROINST.ACCEPT_CODE = highwayproinstModel.ACCEPT_CODE;    //业务编号
            _HIGHWAYPROINST.HIGHWAYPROINST_CREATEDATE = highwayproinstModel.HIGHWAYPROINST_CREATEDATE;    //创建时间
            _HIGHWAYPROINST.STAFF_ID = highwayproinstModel.STAFF_ID;    //员工内码
            _HIGHWAYPROINST.STAFF_NAME = highwayproinstModel.STAFF_NAME;    //员工名称
            _HIGHWAYPROINST.DEPT_ID = highwayproinstModel.DEPT_ID;    //部门
            _HIGHWAYPROINST.DEPT_NAME = highwayproinstModel.DEPT_NAME;    //部门内码
            _HIGHWAYPROINST.HIGHWAYPROINST_ENDDATE = highwayproinstModel.HIGHWAYPROINST_ENDDATE;    //结束时间
            _HIGHWAYPROINST.HIGHWAYPROINST_NEXTID = highwayproinstModel.HIGHWAYPROINST_NEXTID;    //HIGHWAYPROINST_NEXTID
            _HIGHWAYPROINST.HIGHWAYPROINST_DESC = highwayproinstModel.HIGHWAYPROINST_DESC;    //备注
            _HIGHWAYPROINST.PROINST_FINISHDATE = highwayproinstModel.PROINST_FINISHDATE;    //实际办结时间
        }
        #endregion

        #endregion

        #region 删除项目实例表
        public static bool DeleteHIGHWAYPROINST(Transaction transaction, int HIGHWAYPROINSTId)
        {
            bool DeleteFlag = false;

            if (HIGHWAYPROINSTId != null)
            {
                Business.HIGHWAYPROINST _HIGHWAYPROINST = new Business.HIGHWAYPROINST(transaction);
                _HIGHWAYPROINST.HIGHWAYPROINST_ID = HIGHWAYPROINSTId;
                if (_HIGHWAYPROINST.Select())
                {
                    _HIGHWAYPROINST.Delete();
                    DeleteFlag = true;
                }
            }

            return DeleteFlag;
        }
        #endregion
    }
}