LYGJJ_4.0/BLL/DockingSyste...

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

namespace XYFDRQ.BLL
{
    /// <summary>
    /// 工单流转表
    /// </summary>
    public partial class DockingSystem
    {
        private readonly XYFDRQ.DAL.DockingSystem dal = new XYFDRQ.DAL.DockingSystem();
        public DockingSystem()
        { }

        #region 基本代码段
        /// <summary>
        /// 获取客户信息
        /// </summary>
        /// <returns></returns>
        public DataTable GetUserInfo(string strWhere)
        {
            return dal.GetUserInfo(strWhere);
        }

        /// <summary>
        /// 根据小区id获取小区信息
        /// </summary>
        /// <param name="lvId"></param>
        /// <returns></returns>
        public DataTable GetLvInfo(string lvId)
        {
            return dal.GetLvInfo(lvId);
        }

        /// <summary>
        /// 根据小区编号或名称获取小区信息
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        public DataTable GetLvInfos(string code)
        {
            return dal.GetLvInfos(code);
        }

        /// <summary>
        /// 获取小区信息列表
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        public DataTable GetLvInfos()
        {
            return dal.GetLvInfos();
        }
        /// <summary>
        /// 根据区域id获取区域信息
        /// </summary>
        /// <param name="regionId"></param>
        /// <returns></returns>
        public DataTable GetRegionInfo(string regionId)
        {
            return dal.GetRegionInfo(regionId);
        }

        /// <summary>
        /// 获取用气类型信息
        /// </summary>
        /// <returns></returns>
        public DataTable GetPrice(string GasPriceId)
        {
            return dal.GetPrice(GasPriceId);
        }

        /// <summary>
        /// 获取表具信息
        /// </summary>
        /// <returns></returns>
        public DataTable GetDevice(string AddressId)
        {
            return dal.GetDevice(AddressId);
        }

        /// <summary>
        /// 获取IC卡信息
        /// </summary>
        /// <param name="DeviceId"></param>
        /// <returns></returns>
        public DataTable GetICCard(string DeviceId)
        {
            return dal.GetICCard(DeviceId);
        }

        /// <summary>
        /// 获取最后一次读表信息
        /// </summary>
        /// <param name="AddressId"></param>
        /// <param name="GasUserId"></param>
        /// <returns></returns>
        public DataTable GetLastReadMeterRecord(string AddressId, string GasUserId)
        {
            return dal.GetLastReadMeterRecord(AddressId, GasUserId);
        }

        /// <summary>
        /// 获取读表信息
        /// </summary>
        /// <param name="AddressId"></param>
        /// <param name="GasUserId"></param>
        /// <returns></returns>
        public DataTable GetReadMeterRecord(string AddressId, string GasUserId)
        {

            return dal.GetReadMeterRecord(AddressId, GasUserId);
        }

        /// <summary>
        /// 获取报装记录信息
        /// </summary>
        /// <param name="AddressId"></param>
        /// <returns></returns>
        public DataTable GetAddressProjectInfo(string AddressId)
        {
            return dal.GetAddressProjectInfo(AddressId);
        }

        /// <summary>
        /// 获取产品类型信息
        /// </summary>
        /// <param name="ProductId"></param>
        /// <returns></returns>
        public DataTable GetProduct(string ProductId)
        {
            return dal.GetProduct(ProductId);
        }
        #region 根据客户编号获取客户所有的欠费金额
        /// <summary>
        /// 根据客户编号获取客户所有的欠费金额
        /// </summary>
        /// <param name="cusCode"></param>
        /// <returns></returns>
        public DataTable GetALLQFMoneyByCusCode(string cusCode)
        {
            return dal.GetALLQFMoneyByCusCode(cusCode);
        }
        #endregion
        #region 根据客户编号获取客户的欠费金额
        /// <summary>
        /// 根据客户编号获取客户的欠费金额
        /// </summary>
        /// <param name="cusCode"></param>
        /// <returns></returns>
        public DataTable GetQFMoneyByCusCode(string cusCode)
        {
            return dal.GetQFMoneyByCusCode(cusCode);
        }
        #endregion
        #endregion



        #region 二次处理代码段

        /// <summary>
        /// 迭代获取小区地址
        /// </summary>
        /// <param name="LvId"></param>
        /// <returns></returns>
        public string GetLvAddressInfos(string LvId)
        {
            string lvName = string.Empty;
            DataTable dtLv = GetLvInfo(LvId);
            if (dtLv != null && dtLv.Rows.Count > 0)
            {
                if (dtLv.Rows[0]["Parent"] != null && !string.IsNullOrEmpty(dtLv.Rows[0]["Parent"].ToString()))
                {
                    lvName = GetLvAddressInfos(dtLv.Rows[0]["Parent"].ToString()) + lvName;
                }
                lvName += dtLv.Rows[0]["Text"] == null ? "" : dtLv.Rows[0]["Text"].ToString();

            }
            return lvName;
        }

        /// <summary>
        /// 获取住址信息
        /// </summary>
        /// <param name="addressId"></param>
        /// <returns></returns>
        public string GetAddress(string addressId)
        {
            string address = string.Empty;
            DataTable dtUserInfo = GetUserInfo(" and addressId=" + addressId);
            if (dtUserInfo != null && dtUserInfo.Rows.Count > 0)
            {
                ////区域
                //if (dtUserInfo.Rows[0]["regionId"] != null && dtUserInfo.Rows[0]["regionId"].ToString() != "")
                //{
                //    DataTable dtRegion = GetRegionInfo(dtUserInfo.Rows[0]["regionId"].ToString());
                //    if (dtRegion != null && dtRegion.Rows.Count > 0)
                //    {
                //        address += dtRegion.Rows[0]["Name"] == null ? "" : dtRegion.Rows[0]["Name"].ToString();                      
                //    }
                //}
                //小区
                if (dtUserInfo.Rows[0]["lvId"] != null && dtUserInfo.Rows[0]["lvId"].ToString() != "")
                {
                    //DataTable dtLv = GetLvInfo(dtUserInfo.Rows[0]["lvId"].ToString());
                    //if (dtLv != null && dtLv.Rows.Count > 0)
                    //{
                    //    address += dtLv.Rows[0]["Text"] == null ? "" : dtLv.Rows[0]["Text"].ToString();   
                    //}
                    address += GetLvAddressInfos(dtUserInfo.Rows[0]["lvId"].ToString());
                }
                //楼栋              
                address += dtUserInfo.Rows[0]["Lv4"] == null ? "" : dtUserInfo.Rows[0]["Lv4"].ToString();
                address += dtUserInfo.Rows[0]["Lv4Tag"] == null ? "" : dtUserInfo.Rows[0]["Lv4Tag"].ToString();
                //单元              
                address += dtUserInfo.Rows[0]["Lv5"] == null ? "" : dtUserInfo.Rows[0]["Lv5"].ToString();
                address += dtUserInfo.Rows[0]["Lv5Tag"] == null ? "" : dtUserInfo.Rows[0]["Lv5Tag"].ToString();
                //门牌号              
                address += dtUserInfo.Rows[0]["Lv6"] == null ? "" : dtUserInfo.Rows[0]["Lv6"].ToString();
                address += dtUserInfo.Rows[0]["Lv6Tag"] == null ? "" : dtUserInfo.Rows[0]["Lv6Tag"].ToString();
                //位置              
                address += dtUserInfo.Rows[0]["Lv7"] == null ? "" : dtUserInfo.Rows[0]["Lv7"].ToString();
                address += dtUserInfo.Rows[0]["Lv7Tag"] == null ? "" : dtUserInfo.Rows[0]["Lv7Tag"].ToString();
                if (string.IsNullOrEmpty(address.Trim()))
                {
                    address += dtUserInfo.Rows[0]["HomeAddress"] == null ? "" : dtUserInfo.Rows[0]["HomeAddress"].ToString();
                }
            }
            return address;
        }

        /// <summary>
        /// 获取用气类型
        /// </summary>
        /// <returns></returns>
        public string GetPriceType(string GasPriceId)
        {
            string typeName = string.Empty;
            DataTable dt = GetPrice(GasPriceId);
            if (dt != null && dt.Rows.Count > 0)
            {
                typeName = dt.Rows[0]["Name"] == null ? "" : dt.Rows[0]["Name"].ToString();
            }
            return typeName;
        }

        #region 根据区域id获取区域名称
        /// <summary>
        /// 根据区域id获取区域名称
        /// </summary>
        /// <param name="GasPriceId"></param>
        /// <returns></returns>
        public string GetRegionName(string RegionId)
        {
            string RegionName = string.Empty;
            DataTable dtRegion = GetRegionInfo(RegionId);
            if (dtRegion != null && dtRegion.Rows.Count > 0)
            {
                RegionName = dtRegion.Rows[0]["Name"] == null ? "" : dtRegion.Rows[0]["Name"].ToString();
            }
            return RegionName;
        }
        #endregion

        #region 根据小区id获取小区名称

        /// <summary>
        /// 根据小区id获取小区名称
        /// </summary>
        /// <returns></returns>
        public string GetLvName(object lvId)
        {
            string lvName = string.Empty;
            if (lvId != null && !string.IsNullOrEmpty(lvId.ToString()))
            {
                DataTable dt = GetLvInfo(lvId.ToString());
                if (dt != null && dt.Rows.Count > 0)
                {
                    lvName = dt.Rows[0]["Text"] == null ? "" : dt.Rows[0]["Text"].ToString();
                }
            }
            return lvName;
        }

        #endregion
        #endregion
    }
}