DAL/TCWL_D_KaoQinXiangXi.cs

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

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

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

    public class TCWL_D_KaoQinXiangXi
    {
        public DataTable exportExcel(string strWhere, string srvid)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("SELECT * FROM ( ");
            builder.Append(" SELECT ROW_NUMBER() OVER (");
            builder.Append("order by T.TimeStr desc");
            DataTable dataTable = DBHelper.GetDataTable(string.Format("select * from TCWL_KaoQinSheZhi ", srvid));
            int num = 4;
            if (dataTable.Rows.Count > 0)
            {
                num = Convert.ToInt32(dataTable.Rows[0]["Setting"].ToString());
            }
            if (num == 4)
            {
                builder.Append(")AS Row,u.userXM,CONVERT(varchar(100),T.TimeStr,23) as TimeStr,DATENAME(weekday,T.TimeStr) as weekdays, CONVERT(varchar(100), T.DKShiJian1, 108) as DKShiJian1,T.DKDiDian1, CONVERT(varchar(100), T.DKShiJian2, 108) as DKShiJian2,T.DKDiDian2, CONVERT(varchar(100), T.DKShiJian3, 108) as DKShiJian3,T.DKDiDian3, CONVERT(varchar(100), T.DKShiJian4, 108) as DKShiJian4,T.DKDiDian4,T.Remarks,T.DKStart1,T.DKStart2,T.DKStart3,T.DKStart4  from TCWL_KaoQinXiangXi T left join TCWL_KaoQinSheZhi s on  1=1 left join TCWL_User u on T.YongHuID = u.userName ");
            }
            else
            {
                builder.Append(")AS Row,u.userXM,CONVERT(varchar(100),T.TimeStr,23) as TimeStr,DATENAME(weekday,T.TimeStr) as weekdays, CONVERT(varchar(100), T.DKShiJian1, 108) as DKShiJian1,T.DKDiDian1, CONVERT(varchar(100), T.DKShiJian2, 108) as DKShiJian2,T.DKDiDian2,T.Remarks,T.DKStart1,T.DKStart2  from TCWL_KaoQinXiangXi T left join TCWL_KaoQinSheZhi s on 1=1 left join TCWL_User u on T.YongHuID = u.userName ");
            }
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                builder.Append(" where " + strWhere);
            }
            builder.Append(" ) TT ORDER BY timeStr desc");
            return DBHelper.Query(builder.ToString(), new SqlParameter[0]).Tables[0];
        }

        public string getCpyArea(string serviceid)
        {
            DataTable dataTable = DBHelper.GetDataTable(string.Format("select Area_Name FROM TCWL_All_CompanyInformation ", serviceid));
            if (dataTable.Rows.Count > 0)
            {
                return dataTable.Rows[0][0].ToString();
            }
            return "";
        }

        public DataTable GetDepartment(string strWhere)
        {
            StringBuilder builder = new StringBuilder();
            DataTable table = new DataTable();
            builder.Append("select ID,unitName,ServiceID ");
            builder.Append(" FROM TCWL_Unit ");
            if (strWhere.Trim() != "")
            {
                builder.Append(" where " + strWhere);
            }
            return DBHelper.GetDataTable(builder.ToString());