BLL/TCWL_B_ContractStatic.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace BLL
{
    using Common;
    using DAL;
    using System;
    using System.Data;

    public class TCWL_B_ContractStatic
    {
        private readonly TCWL_D_ContractStatic dal = new TCWL_D_ContractStatic();

        public string CusTop(string strWhere)
        {
            DataTable dt = this.dal.CusTop(strWhere);
            return ("{\"rows\":" + JsonHelper.DataTableToJson(dt) + "}");
        }

        public string GetCus(string strWhere)
        {
            DataTable dt = new DataTable();
            dt = this.dal.GetCus(strWhere);
            return ("{\"rows\":" + JsonHelper.DataTableToJson(dt) + "}");
        }

        public string GetCus(string where, int startIndex, int endIndex)
        {
            int total = 0;
            DataTable dt = this.dal.GetCus(where, startIndex, endIndex, out total);
            return string.Concat(new object[] { "{\"total\":", total, ",\"rows\":", JsonHelper.DataTableToJson(dt), "}" });
        }

        public string getHTTime_cus(string strWhere, string type)
        {
            DataTable dt = new DataTable();
            if (type == "month")
            {
                dt = this.dal.getHTAllTime_cus(strWhere);
            }
            if (type == "year")
            {
                dt = this.dal.getHTAllYears_cus(strWhere);
            }
            if (type == "Quarter")
            {
                dt = this.dal.getHTAllQuarter_cus(strWhere);
            }
            return ("{\"rows\":" + JsonHelper.DataTableToJson(dt) + "}");
        }

        public string getHTTime_user(string strWhere, string type)
        {
            DataTable dt = new DataTable();
            if (type == "month")
            {
                dt = this.dal.getHTAllTime_user(strWhere);
            }
            if (type == "year")
            {
                dt = this.dal.getHTAllYears_user(strWhere);
            }