BLL/TCWL_B_ProTime.cs

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

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

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

    public class TCWL_B_ProTime
    {
        private readonly TCWL_D_ProTime dal = new TCWL_D_ProTime();

        public string getCPTime(string strWhere, string type)
        {
            DataTable dt = new DataTable();
            if (type == "month")
            {
                dt = this.dal.getCPAllTime(strWhere);
            }
            if (type == "year")
            {
                dt = this.dal.getCPAllYears(strWhere);
            }
            if (type == "Quarter")
            {
                dt = this.dal.getCPAllQuarter(strWhere);
            }
            return ("{\"rows\":" + JsonHelper.DataTableToJson(dt) + "}");
        }

        public string GetCPTop(string strWhere)
        {
            DataTable table = new DataTable();
            table = this.dal.getCPTop(strWhere);
            string str = "";
            for (int i = 0; i < table.Rows.Count; i++)
            {
                str = str + "'" + table.Rows[i]["ProductsName"].ToString() + "',";
            }
            if (table.Rows.Count > 0)
            {
                str = str.Substring(0, str.Length - 1);
            }
            return str;
        }

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

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