DAL/TCWL_D_ClientArea.cs

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

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

namespace DAL
{
    using Common;
    using System;
    using System.Data;
    using System.Runtime.InteropServices;

    public class TCWL_D_ClientArea
    {
        public DataTable loadClientAreaByCountry(string srvid, string userids, out int max)
        {
            max = 0;
            DataTable dataTable = null;
            try
            {
                dataTable = DBHelper.GetDataTable(string.Format("select COUNT(1) as num,REPLACE(LEFT(prvne,CHARINDEX(',',prvne)),',','') as prn from (SELECT substring(KeHuQuYu,CHARINDEX(',',KeHuQuYu)+1,LEN(KeHuQuYu)) as prvne from TCWL_KeHuXinXi where TrueorFalse='0' and ServiceID='{0}' and ChuangJianRen in ({1}) ) t group by REPLACE(LEFT(prvne,CHARINDEX(',',prvne)),',','')", srvid, userids));
                if (dataTable.Rows.Count > 0)
                {
                    max = Convert.ToInt32(dataTable.Compute("max(num)", ""));
                }
            }
            catch (Exception)
            {
            }
            return dataTable;
        }

        public DataTable loadClientAreaByPrince(string srvid, string Prince)
        {
            DataTable dataTable = null;
            try
            {
                dataTable = DBHelper.GetDataTable(string.Format("select COUNT(1) as num, replace(left(city,CHARINDEX(',',city)),',','') as cty   from (select  SUBSTRING(substring(KeHuQuYu,CHARINDEX(',',KeHuQuYu)+1,LEN(KeHuQuYu)),CHARINDEX(',',substring(KeHuQuYu,CHARINDEX(',',KeHuQuYu)+1,LEN(KeHuQuYu)))+1,len(substring(KeHuQuYu,CHARINDEX(',',KeHuQuYu)+1,LEN(KeHuQuYu)))) as city from TCWL_KeHuXinXi WHERE TrueorFalse='0' and ServiceID = '{0}' and KeHuQuYu like '%{1}%') t group by replace(left(city,CHARINDEX(',',city)),',','')", srvid, Prince));
            }
            catch (Exception)
            {
            }
            return dataTable;
        }

        public DataTable loadOrderByCty(string ids, string srvid, string prince, string start, string end)
        {
            DataTable dataTable = null;
            try
            {
                dataTable = DBHelper.GetDataTable(string.Format("select REPLACE(LEFT(city,CHARINDEX(',',city)),',','') as cty,sum(totalmoney) as allm,SUM(actualMoney) as actm from (SELECT o.totalmoney,o.actualMoney,isnull(SUBSTRING(substring(KeHuQuYu,CHARINDEX(',',KeHuQuYu)+1,LEN(KeHuQuYu)),CHARINDEX(',',substring(KeHuQuYu,CHARINDEX(',',KeHuQuYu)+1,LEN(KeHuQuYu)))+1,len(substring(KeHuQuYu,CHARINDEX(',',KeHuQuYu)+1,LEN(KeHuQuYu)))) ,'') as city from TCWL_Order o inner join TCWL_KeHuXinXi kh on o.clientID=kh.ID and o.serviceID='{0}' and KeHuQuYu like '%{1}%' and o.state in (1,3,4)  where  (CONVERT(nvarchar(10),o.timeStr,120)>='{2}' and CONVERT(nvarchar(10),o.timeStr,120)<='{3}') and o.saleMan in ({3})  ) t group by REPLACE(LEFT(city,CHARINDEX(',',city)),',','')", new object[] { srvid, prince, start, end, ids }));
            }
            catch (Exception)
            {
            }
            return dataTable;
        }

        public DataTable loadOrderByPrince(string ids, string srvid, string start, string end, out int max)
        {
            max = 0;
            DataTable dataTable = null;
            try
            {
                dataTable = DBHelper.GetDataTable(string.Format("select REPLACE(LEFT(prvne,CHARINDEX(',',prvne)),',','') as prn,sum(totalmoney) as allm from (SELECT o.totalmoney,isnull(substring(kh.KeHuQuYu,CHARINDEX(',',kh.KeHuQuYu)+1,LEN(kh.KeHuQuYu)),'') as prvne from TCWL_Order o inner join TCWL_KeHuXinXi kh on o.clientID=kh.ID and o.serviceID='{0}' and o.state in (1,3,4) where  (CONVERT(nvarchar(10),o.timeStr,120)>='{1}' and CONVERT(nvarchar(10),o.timeStr,120)<='{2}') and o.saleMan in ({3}) ) t group by REPLACE(LEFT(prvne,CHARINDEX(',',prvne)),',','')", new object[] { srvid, start, end, ids }));