using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CoreFS.CA06;


namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData
{
    public class SlmBaseRegionBll : SaleBusinessMgt.BllBase.BaseBll
    {

        public SlmBaseRegionBll(OpeBase ob)
            : base(ob)
        {
        }

        /// <summary>
        /// 查询入口
        /// </summary>
        /// <param name="sqlCondition"></param>
        /// <returns></returns>
        private DataSet GetSlmBaseRegion(string sqlCondition)
        {
            string sqlStr = string.Format(SqlCollection.BaseData._QUERYSLMBASEREGION, sqlCondition);
            return base.ExecuteQuery(sqlStr);
        }

        /// <summary>
        /// 查询区域类型
        /// </summary>
        /// <param name="sqlCondition"></param>
        /// <returns></returns>
        private DataSet GetSlmBaseRegionTpe(string sqlCondition)
        {
            string sqlStr = string.Format(SqlCollection.BaseData._QUERYSLMBASEREGIONTYPE, sqlCondition);
            return base.ExecuteQuery(sqlStr);
        }

        /// <summary>
        /// 查询所有区域信息
        /// </summary>
        /// <returns></returns>
        public DataSet GetSlmBaseRegionAll()
        {
            return GetSlmBaseRegion("");
        }

        public DataSet GetValidSlmBaseRegion()
        {
            return Util.UtilDataSet.GetDataSetWithRowFilter(GetSlmBaseRegionAll(), "FL", "1");
        }

        public DataSet GetSlmBaseRegionTpeAll()
        {
            return GetSlmBaseRegionTpe("");
        }

        /// <summary>
        /// 获取行政区域级别信息
        /// </summary>
        /// <returns></returns>
        public DataSet GetDistinctRegionTpe()
        {
            string sqlStr = SqlCollection.BaseData._GETDISTINCTREGIONTPE;
            return base.ExecuteQuery(sqlStr);
        }

        /// <summary>
        /// 获取行政区域属性信息
        /// </summary>
        /// <returns></returns>
        public DataSet GetDistinctRegionType()
        {
            string sqlStr = SqlCollection.BaseData._GETDISTINCTREGIONTYPE;
            return base.ExecuteQuery(sqlStr);
        }

        /// <summary>
        /// 区域信息新增
        /// </summary>
        /// <param name="hs"></param>
        /// <param name="errMsg"></param>
        public void Insert(System.Collections.Hashtable hs, out string errMsg)
        {
            errMsg = "";
            CoreClientParam param = base.GetCoreClientParam(_ServerName, "insert", new object[] { hs });
            CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
            errMsg = base.GetReturnErrorInfo(result);
        }

        /// <summary>
        /// 区域信息删除
        /// </summary>
        /// <param name="regionNo"></param>
        /// <param name="deleteName"></param>
        /// <param name="errMsg"></param>
        public void Delete(string regionNo,string deleteName,out  string errMsg)
        {
            errMsg = "";
            CoreClientParam param = base.GetCoreClientParam(_ServerName, "delete", new object[] { regionNo, deleteName });
            CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
            errMsg = base.GetReturnErrorInfo(result);
        }

        private string _ServerName = "core.stlmes.server.sale.service.SlmBaseRegion";
    }
}