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 CHECKCOMMODITYHelper
    {
        #region 获取盘存表列表
        public static List<Model.CHECKCOMMODITYModel> GetCHECKCOMMODITYList(Transaction transaction,
            ref int TotalCount, int PageIndex = 1, int PageSize = 10, string SortStr = "")
        {
            List<Model.CHECKCOMMODITYModel> CHECKCOMMODITYList = new List<Model.CHECKCOMMODITYModel>();

            string WhereSQL = "", RowFilterSQL = "";

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

            foreach (DataRow drCHECKCOMMODITY in dtCHECKCOMMODITY.Rows)
            {
                Model.CHECKCOMMODITYModel checkcommodityModel = new Model.CHECKCOMMODITYModel();

                checkcommodityModel.CHECKCOMMODITY_ID = drCHECKCOMMODITY["CHECKCOMMODITY_ID"].TryParseToInt();    //内码
                checkcommodityModel.CHECKPERSON = drCHECKCOMMODITY["CHECKPERSON"].ToString();    //盘存人
                checkcommodityModel.CHECKDATE = drCHECKCOMMODITY["CHECKDATE"].TryParseToDateTime();    //盘存时间
                checkcommodityModel.SERVERPART_ID = drCHECKCOMMODITY["SERVERPART_ID"].TryParseToInt();    //盘存服务区
                checkcommodityModel.SERVERPARTSHOP_ID = drCHECKCOMMODITY["SERVERPARTSHOP_ID"].TryParseToInt();    //盘存门店
                checkcommodityModel.CHECKCOMMODITY_DESC = drCHECKCOMMODITY["CHECKCOMMODITY_DESC"].ToString();    //说明
                checkcommodityModel.CHECK_STATE = (short)drCHECKCOMMODITY["CHECK_STATE"].TryParseToInt();    //状态 0未生效  1 生效
                checkcommodityModel.CHECK_PASSPORT_GUID = drCHECKCOMMODITY["CHECK_PASSPORT_GUID"].ToString();    //操作GUID
                checkcommodityModel.CHECK_TYPE = drCHECKCOMMODITY["CHECK_TYPE"].TryParseToInt();    //盘存类型
                checkcommodityModel.SERVERPART_CODE = drCHECKCOMMODITY["SERVERPART_CODE"].ToString();    //服务区编码
                checkcommodityModel.SERVERPART_NAME = drCHECKCOMMODITY["SERVERPART_NAME"].ToString();    //服务区名称
                checkcommodityModel.SHOPCODE = drCHECKCOMMODITY["SHOPCODE"].ToString();    //门店编码
                checkcommodityModel.SHOPNAME = drCHECKCOMMODITY["SHOPNAME"].ToString();    //门店名称
                checkcommodityModel.STAFF_NAME = drCHECKCOMMODITY["STAFF_NAME"].ToString();    //操作人员
                checkcommodityModel.OPERATE_DATE = drCHECKCOMMODITY["OPERATE_DATE"].TryParseToDateTime();    //操作时间
                checkcommodityModel.TRANSFER_STATE = drCHECKCOMMODITY["TRANSFER_STATE"].TryParseToInt();    //盘点状态

                CHECKCOMMODITYList.Add(checkcommodityModel);
            }

            return CHECKCOMMODITYList;
        }
        #endregion

        #region 获取盘存表列表
        /// <summary>
        /// 获取盘存表列表
        /// </summary>
        /// <param name="transaction">事务管理器</param>
        /// <param name="TotalCount">查询结果总数</param>
        /// <param name="searchModel">查询条件对象</param>
        public static List<Model.CHECKCOMMODITYModel> GetCHECKCOMMODITYList(Transaction transaction,
            ref int TotalCount, Models.SearchModel<Model.CHECKCOMMODITYModel> searchModel)
        {
            List<Model.CHECKCOMMODITYModel> CHECKCOMMODITYList = new List<Model.CHECKCOMMODITYModel>();

            string WhereSQL = "", RowFilterSQL = "";
            if (searchModel.SearchParameter != null)
            {
                WhereSQL = OperationDataHelper<Model.CHECKCOMMODITYModel>.GetWhereSQL(searchModel.SearchParameter, searchModel.QueryType);
                if (WhereSQL != "")
                {
                    WhereSQL = "WHERE " + WhereSQL;
                }
            }

            DataTable dtCHECKCOMMODITY = new Business.CHECKCOMMODITY(transaction).FillDataTable(WhereSQL);
            //增加组合查询条件
            if (searchModel.keyWord != null && !string.IsNullOrWhiteSpace(searchModel.keyWord.Key))
            {
                foreach (string KeyName in searchModel.keyWord.Key.Split(','))
                {
                    RowFilterSQL += (RowFilterSQL == "" ? "" : " or ") +
                        KeyName + " like '%" + searchModel.keyWord.Value + "%'";
                }
            }
            if (RowFilterSQL != "")
            {
                dtCHECKCOMMODITY.DefaultView.RowFilter = RowFilterSQL;
            }
            //排序：
            dtCHECKCOMMODITY.DefaultView.Sort = searchModel.SortStr;
            dtCHECKCOMMODITY = dtCHECKCOMMODITY.DefaultView.ToTable();
            //获取查询结果总记录条数
            TotalCount = dtCHECKCOMMODITY.Rows.Count;
            //根据传入的页码和每页显示条数返回结果
            dtCHECKCOMMODITY = CommonHelper.GetDataTableWithPageSize(dtCHECKCOMMODITY, searchModel.PageSize, searchModel.PageIndex);

            foreach (DataRow drCHECKCOMMODITY in dtCHECKCOMMODITY.Rows)
            {
                Model.CHECKCOMMODITYModel checkcommodityModel = new Model.CHECKCOMMODITYModel();

                checkcommodityModel.CHECKCOMMODITY_ID = drCHECKCOMMODITY["CHECKCOMMODITY_ID"].TryParseToInt();    //内码
                checkcommodityModel.CHECKPERSON = drCHECKCOMMODITY["CHECKPERSON"].ToString();    //盘存人
                checkcommodityModel.CHECKDATE = drCHECKCOMMODITY["CHECKDATE"].TryParseToDateTime();    //盘存时间
                checkcommodityModel.SERVERPART_ID = drCHECKCOMMODITY["SERVERPART_ID"].TryParseToInt();    //盘存服务区
                checkcommodityModel.SERVERPARTSHOP_ID = drCHECKCOMMODITY["SERVERPARTSHOP_ID"].TryParseToInt();    //盘存门店
                checkcommodityModel.CHECKCOMMODITY_DESC = drCHECKCOMMODITY["CHECKCOMMODITY_DESC"].ToString();    //说明
                checkcommodityModel.CHECK_STATE = (short)drCHECKCOMMODITY["CHECK_STATE"].TryParseToInt();    //状态 0未生效  1 生效
                checkcommodityModel.CHECK_PASSPORT_GUID = drCHECKCOMMODITY["CHECK_PASSPORT_GUID"].ToString();    //操作GUID
                checkcommodityModel.CHECK_TYPE = drCHECKCOMMODITY["CHECK_TYPE"].TryParseToInt();    //盘存类型
                checkcommodityModel.SERVERPART_CODE = drCHECKCOMMODITY["SERVERPART_CODE"].ToString();    //服务区编码
                checkcommodityModel.SERVERPART_NAME = drCHECKCOMMODITY["SERVERPART_NAME"].ToString();    //服务区名称
                checkcommodityModel.SHOPCODE = drCHECKCOMMODITY["SHOPCODE"].ToString();    //门店编码
                checkcommodityModel.SHOPNAME = drCHECKCOMMODITY["SHOPNAME"].ToString();    //门店名称
                checkcommodityModel.STAFF_NAME = drCHECKCOMMODITY["STAFF_NAME"].ToString();    //操作人员
                checkcommodityModel.OPERATE_DATE = drCHECKCOMMODITY["OPERATE_DATE"].TryParseToDateTime();    //操作时间
                checkcommodityModel.TRANSFER_STATE = drCHECKCOMMODITY["TRANSFER_STATE"].TryParseToInt();    //盘点状态

                CHECKCOMMODITYList.Add(checkcommodityModel);
            }

            return CHECKCOMMODITYList;
        }
        #endregion

        #region 获取盘存表明细
        public static Model.CHECKCOMMODITYModel GetCHECKCOMMODITYDetail(Transaction transaction, int CHECKCOMMODITYId)
        {
            Model.CHECKCOMMODITYModel checkcommodityModel = new Model.CHECKCOMMODITYModel();

            Business.CHECKCOMMODITY _CHECKCOMMODITY = new Business.CHECKCOMMODITY(transaction);
            _CHECKCOMMODITY.CHECKCOMMODITY_ID = CHECKCOMMODITYId;
            if (_CHECKCOMMODITY.Select())
            {
                checkcommodityModel.CHECKCOMMODITY_ID = _CHECKCOMMODITY.CHECKCOMMODITY_ID;    //内码
                checkcommodityModel.CHECKPERSON = _CHECKCOMMODITY.CHECKPERSON;    //盘存人
                checkcommodityModel.CHECKDATE = _CHECKCOMMODITY.CHECKDATE;    //盘存时间
                checkcommodityModel.SERVERPART_ID = _CHECKCOMMODITY.SERVERPART_ID;    //盘存服务区
                checkcommodityModel.SERVERPARTSHOP_ID = _CHECKCOMMODITY.SERVERPARTSHOP_ID;    //盘存门店
                checkcommodityModel.CHECKCOMMODITY_DESC = _CHECKCOMMODITY.CHECKCOMMODITY_DESC;    //说明
                checkcommodityModel.CHECK_STATE = _CHECKCOMMODITY.CHECK_STATE;    //状态 0未生效  1 生效
                checkcommodityModel.CHECK_PASSPORT_GUID = _CHECKCOMMODITY.CHECK_PASSPORT_GUID;    //操作GUID
                checkcommodityModel.CHECK_TYPE = _CHECKCOMMODITY.CHECK_TYPE;    //盘存类型
                checkcommodityModel.SERVERPART_CODE = _CHECKCOMMODITY.SERVERPART_CODE;    //服务区编码
                checkcommodityModel.SERVERPART_NAME = _CHECKCOMMODITY.SERVERPART_NAME;    //服务区名称
                checkcommodityModel.SHOPCODE = _CHECKCOMMODITY.SHOPCODE;    //门店编码
                checkcommodityModel.SHOPNAME = _CHECKCOMMODITY.SHOPNAME;    //门店名称
                checkcommodityModel.STAFF_NAME = _CHECKCOMMODITY.STAFF_NAME;    //操作人员
                checkcommodityModel.OPERATE_DATE = _CHECKCOMMODITY.OPERATE_DATE;    //操作时间
                checkcommodityModel.TRANSFER_STATE = _CHECKCOMMODITY.TRANSFER_STATE;    //盘点状态
            }

            return checkcommodityModel;
        }
        #endregion

        #region 同步盘存表
        /// <summary>
        /// 赋值盘存表数据对象
        /// </summary>
        /// <param name="transaction">事务管理器</param>
        /// <param name="checkcommodityModel">盘存表数据对象</param>
        public static bool SynchroCHECKCOMMODITY(Transaction transaction, Model.CHECKCOMMODITYModel checkcommodityModel)
        {
            bool SynchroFlag = true;

            Business.CHECKCOMMODITY _CHECKCOMMODITY = new Business.CHECKCOMMODITY(transaction);
            if (checkcommodityModel.CHECKCOMMODITY_ID != null)
            {
                _CHECKCOMMODITY.CHECKCOMMODITY_ID = checkcommodityModel.CHECKCOMMODITY_ID;
                if (_CHECKCOMMODITY.Select())
                {
                    SynchroModelToObject(_CHECKCOMMODITY, checkcommodityModel);
                    _CHECKCOMMODITY.Update();
                }
                else
                {
                    SynchroFlag = false;
                }
            }
            else
            {
                SynchroModelToObject(_CHECKCOMMODITY, checkcommodityModel);
                _CHECKCOMMODITY.Insert();
            }

            return SynchroFlag;
        }

        #region 赋值盘存表数据对象
        /// <summary>
        /// 赋值盘存表数据对象
        /// </summary>
        /// <param name="_CHECKCOMMODITY"></param>
        /// <param name="checkcommodityModel"></param>
        public static void SynchroModelToObject(Business.CHECKCOMMODITY _CHECKCOMMODITY, Model.CHECKCOMMODITYModel checkcommodityModel)
        {
            _CHECKCOMMODITY.CHECKPERSON = checkcommodityModel.CHECKPERSON;    //盘存人
            _CHECKCOMMODITY.CHECKDATE = checkcommodityModel.CHECKDATE;    //盘存时间
            _CHECKCOMMODITY.SERVERPART_ID = checkcommodityModel.SERVERPART_ID;    //盘存服务区
            _CHECKCOMMODITY.SERVERPARTSHOP_ID = checkcommodityModel.SERVERPARTSHOP_ID;    //盘存门店
            _CHECKCOMMODITY.CHECKCOMMODITY_DESC = checkcommodityModel.CHECKCOMMODITY_DESC;    //说明
            _CHECKCOMMODITY.CHECK_STATE = checkcommodityModel.CHECK_STATE;    //状态 0未生效  1 生效
            _CHECKCOMMODITY.CHECK_PASSPORT_GUID = checkcommodityModel.CHECK_PASSPORT_GUID;    //操作GUID
            _CHECKCOMMODITY.CHECK_TYPE = checkcommodityModel.CHECK_TYPE;    //盘存类型
            _CHECKCOMMODITY.SERVERPART_CODE = checkcommodityModel.SERVERPART_CODE;    //服务区编码
            _CHECKCOMMODITY.SERVERPART_NAME = checkcommodityModel.SERVERPART_NAME;    //服务区名称
            _CHECKCOMMODITY.SHOPCODE = checkcommodityModel.SHOPCODE;    //门店编码
            _CHECKCOMMODITY.SHOPNAME = checkcommodityModel.SHOPNAME;    //门店名称
            _CHECKCOMMODITY.STAFF_NAME = checkcommodityModel.STAFF_NAME;    //操作人员
            _CHECKCOMMODITY.OPERATE_DATE = checkcommodityModel.OPERATE_DATE;    //操作时间
            _CHECKCOMMODITY.TRANSFER_STATE = checkcommodityModel.TRANSFER_STATE;    //盘点状态
        }
        #endregion

        #endregion

        #region 删除盘存表
        public static bool DeleteCHECKCOMMODITY(Transaction transaction, int? CHECKCOMMODITYId)
        {
            bool DeleteFlag = false;

            if (CHECKCOMMODITYId != null)
            {
                Business.CHECKCOMMODITY _CHECKCOMMODITY = new Business.CHECKCOMMODITY(transaction);
                _CHECKCOMMODITY.CHECKCOMMODITY_ID = CHECKCOMMODITYId;
                if (_CHECKCOMMODITY.Select())
                {
                    _CHECKCOMMODITY.Delete();
                    DeleteFlag = true;
                }
            }

            return DeleteFlag;
        }
        #endregion
    }
}