Estsh-Yiri/Estsh.Core.Services/Repositories/XTTestDataDal.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text; 
using System.Collections;
using ApServerProvider;
using Estsh.Web.Util;
using DbCommon;

namespace Estsh.Core.Repositories
{
    public class XTTestDataDal : BaseApp
    {
        public XTTestDataDal(RemotingProxy remotingProxy)
            : base(remotingProxy)
        { }




        /// <summary>
        /// 电检主表
        /// </summary>
        /// <param name="serialNumber"></param>
        /// <returns></returns>
        public DataTable XTGetDjc(string whereStr2, Pager pager, ref int totalCount)
        {
            lock (_remotingProxy)
            {


                StringBuilder SqlStringBuilder = new StringBuilder();
                SqlStringBuilder.Append(" SELECT    CAST(座椅条形码 AS VARCHAR) sn , ");
                SqlStringBuilder.Append("            CAST(设备名称 AS VARCHAR) shebei , ");
                SqlStringBuilder.Append("            CAST(产品类型 AS VARCHAR) part_type , ");
                SqlStringBuilder.Append("            CAST([测试结果(P/F)] AS VARCHAR) result_test , ");
                SqlStringBuilder.Append("            CAST([所用时间(秒)] AS VARCHAR) used_time , ");
                SqlStringBuilder.Append("            CAST(测试完成日期 AS VARCHAR) test_ymd , ");
                SqlStringBuilder.Append("            CAST(测试完成时间 AS VARCHAR) test_hms , ");
                SqlStringBuilder.Append("            CAST([模块版本(CAN)] AS VARCHAR) mkbb_CAN , ");
                SqlStringBuilder.Append("            CAST([模块版本(CAN)-结果] AS VARCHAR) mkbb_CAN_result , ");
                SqlStringBuilder.Append("            CAST([气囊-电阻] AS VARCHAR) qndz , ");
                SqlStringBuilder.Append("            CAST([气囊-电阻-结果] AS VARCHAR) qndz_result , ");
                SqlStringBuilder.Append("            CAST([气囊对地-电阻] AS VARCHAR) qndddz , ");
                SqlStringBuilder.Append("            CAST([气囊对地-电阻-结果] AS VARCHAR) qndddz_result , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(未插入)-电阻] AS VARCHAR) aqdkwcrdz , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(未插入)-电阻-结果] AS VARCHAR) aqdkwcrdz_result , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(插入)-电阻] AS VARCHAR) aqdkcrdz , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(插入)-电阻-结果] AS VARCHAR) aqdkcrdz_result , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(插入释放)-电阻] AS VARCHAR) aqdkcrsfdz , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(插入释放)-电阻-结果] AS VARCHAR) aqdkcrsfdz_result , ");
                SqlStringBuilder.Append("            CAST([SBR(无加载)-电阻] AS VARCHAR) sbrwjzdz , ");
                SqlStringBuilder.Append("            CAST([SBR(无加载)-电阻-结果] AS VARCHAR) sbrwjzdz_result , ");
                SqlStringBuilder.Append("            CAST([SBR(加载)-电阻] AS VARCHAR) sbrjzdz , ");
                SqlStringBuilder.Append("            CAST([SBR(加载)-电阻-结果] AS VARCHAR) sbrjzdz_result , ");
                SqlStringBuilder.Append("            CAST([SBR(加载释放)-电阻] AS VARCHAR) sbrjzsfdz , ");
                SqlStringBuilder.Append("            CAST([SBR(加载释放)-电阻-结果] AS VARCHAR) sbrjzsfdz_result , ");
                SqlStringBuilder.Append("            CAST([左座椅加热(CAN)-电流] AS VARCHAR) zzyjrcandl , ");
                SqlStringBuilder.Append("            CAST([左座椅加热(CAN)-电流-结果] AS VARCHAR) zzyjrcandl_result , ");
                SqlStringBuilder.Append("            CAST([左座椅对右加热(CAN)-电流] AS VARCHAR) zzydyjrcandl , ");
                SqlStringBuilder.Append("            CAST([左座椅对右加热(CAN)-电流-结果] AS VARCHAR) zzydyjrcandl_result , ");
                SqlStringBuilder.Append("            CAST([右座椅加热(CAN)-电流] AS VARCHAR) yzyjrcandl , ");
                SqlStringBuilder.Append("            CAST([右座椅加热(CAN)-电流-结果] AS VARCHAR) yzyjrcandl_result , ");
                SqlStringBuilder.Append("            CAST([座椅前移-电流] AS VARCHAR) zyqydl , ");
                SqlStringBuilder.Append("            CAST([座椅前移-电流-结果] AS VARCHAR) zyqydl_result , ");
                SqlStringBuilder.Append("            CAST([座椅后移-电流] AS VARCHAR) zyhydl , ");
                SqlStringBuilder.Append("            CAST([座椅后移-电流-结果] AS VARCHAR) zyhydl_result , ");
                SqlStringBuilder.Append("            CAST([靠背向前-电流] AS VARCHAR) kbxqdl , ");
                SqlStringBuilder.Append("            CAST([靠背向前-电流-结果] AS VARCHAR) kbxqdl_result , ");
                SqlStringBuilder.Append("            CAST([靠背向后-电流] AS VARCHAR) kbxhdl , ");
                SqlStringBuilder.Append("            CAST([靠背向后-电流-结果] AS VARCHAR) kbxhdl_result , ");
                SqlStringBuilder.Append("            CAST([前端下降-电流] AS VARCHAR) qdxjdl , ");
                SqlStringBuilder.Append("            CAST([前端下降-电流-结果] AS VARCHAR) qdxjdl_result , ");
                SqlStringBuilder.Append("            CAST([后端上升-电流] AS VARCHAR) hdssdl , ");
                SqlStringBuilder.Append("            CAST([后端上升-电流-结果] AS VARCHAR) hdssdl_result , ");
                SqlStringBuilder.Append("            CAST([后端下降-电流] AS VARCHAR) hdxjdl , ");
                SqlStringBuilder.Append("            CAST([后端下降-电流-结果] AS VARCHAR) hdxjdl_result ");
                SqlStringBuilder.Append("  FROM      dbo.eol_seat ");
                SqlStringBuilder.Append("  WHERE  1=1   " + whereStr2 + " order by test_ymd desc,test_hms desc  ");



                Hashtable ht = new Hashtable();
                DataTable dt = _remotingProxy.GetDataTable(SqlStringBuilder.ToString());
                return dt;

            }
        }


     
      

        public DataTable GetSumDjc(string whereStr)
        {
            lock (_remotingProxy)
            {
                StringBuilder SqlStringBuilder = new StringBuilder();
                SqlStringBuilder.Append(" SELECT    CAST(座椅条形码 AS VARCHAR) sn , ");
                SqlStringBuilder.Append("            CAST(设备名称 AS VARCHAR) shebei , ");
                SqlStringBuilder.Append("            CAST(产品类型 AS VARCHAR) part_type , ");
                SqlStringBuilder.Append("            CAST([测试结果(P/F)] AS VARCHAR) result_test , ");
                SqlStringBuilder.Append("            CAST([所用时间(秒)] AS VARCHAR) used_time , ");
                SqlStringBuilder.Append("            CAST(测试完成日期 AS VARCHAR) test_ymd , ");
                SqlStringBuilder.Append("            CAST(测试完成时间 AS VARCHAR) test_hms , ");
                SqlStringBuilder.Append("            CAST([模块版本(CAN)] AS VARCHAR) mkbb_CAN , ");
                SqlStringBuilder.Append("            CAST([模块版本(CAN)-结果] AS VARCHAR) mkbb_CAN_result , ");
                SqlStringBuilder.Append("            CAST([气囊-电阻] AS VARCHAR) qndz , ");
                SqlStringBuilder.Append("            CAST([气囊-电阻-结果] AS VARCHAR) qndz_result , ");
                SqlStringBuilder.Append("            CAST([气囊对地-电阻] AS VARCHAR) qndddz , ");
                SqlStringBuilder.Append("            CAST([气囊对地-电阻-结果] AS VARCHAR) qndddz_result , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(未插入)-电阻] AS VARCHAR) aqdkwcrdz , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(未插入)-电阻-结果] AS VARCHAR) aqdkwcrdz_result , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(插入)-电阻] AS VARCHAR) aqdkcrdz , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(插入)-电阻-结果] AS VARCHAR) aqdkcrdz_result , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(插入释放)-电阻] AS VARCHAR) aqdkcrsfdz , ");
                SqlStringBuilder.Append("            CAST([安全带卡扣(插入释放)-电阻-结果] AS VARCHAR) aqdkcrsfdz_result , ");
                SqlStringBuilder.Append("            CAST([SBR(无加载)-电阻] AS VARCHAR) sbrwjzdz , ");
                SqlStringBuilder.Append("            CAST([SBR(无加载)-电阻-结果] AS VARCHAR) sbrwjzdz_result , ");
                SqlStringBuilder.Append("            CAST([SBR(加载)-电阻] AS VARCHAR) sbrjzdz , ");
                SqlStringBuilder.Append("            CAST([SBR(加载)-电阻-结果] AS VARCHAR) sbrjzdz_result , ");
                SqlStringBuilder.Append("            CAST([SBR(加载释放)-电阻] AS VARCHAR) sbrjzsfdz , ");
                SqlStringBuilder.Append("            CAST([SBR(加载释放)-电阻-结果] AS VARCHAR) sbrjzsfdz_result , ");
                SqlStringBuilder.Append("            CAST([左座椅加热(CAN)-电流] AS VARCHAR) zzyjrcandl , ");
                SqlStringBuilder.Append("            CAST([左座椅加热(CAN)-电流-结果] AS VARCHAR) zzyjrcandl_result , ");
                SqlStringBuilder.Append("            CAST([左座椅对右加热(CAN)-电流] AS VARCHAR) zzydyjrcandl , ");
                SqlStringBuilder.Append("            CAST([左座椅对右加热(CAN)-电流-结果] AS VARCHAR) zzydyjrcandl_result , ");
                SqlStringBuilder.Append("            CAST([右座椅加热(CAN)-电流] AS VARCHAR) yzyjrcandl , ");
                SqlStringBuilder.Append("            CAST([右座椅加热(CAN)-电流-结果] AS VARCHAR) yzyjrcandl_result , ");
                SqlStringBuilder.Append("            CAST([座椅前移-电流] AS VARCHAR) zyqydl , ");
                SqlStringBuilder.Append("            CAST([座椅前移-电流-结果] AS VARCHAR) zyqydl_result , ");
                SqlStringBuilder.Append("            CAST([座椅后移-电流] AS VARCHAR) zyhydl , ");
                SqlStringBuilder.Append("            CAST([座椅后移-电流-结果] AS VARCHAR) zyhydl_result , ");
                SqlStringBuilder.Append("            CAST([靠背向前-电流] AS VARCHAR) kbxqdl , ");
                SqlStringBuilder.Append("            CAST([靠背向前-电流-结果] AS VARCHAR) kbxqdl_result , ");
                SqlStringBuilder.Append("            CAST([靠背向后-电流] AS VARCHAR) kbxhdl , ");
                SqlStringBuilder.Append("            CAST([靠背向后-电流-结果] AS VARCHAR) kbxhdl_result , ");
                SqlStringBuilder.Append("            CAST([前端下降-电流] AS VARCHAR) qdxjdl , ");
                SqlStringBuilder.Append("            CAST([前端下降-电流-结果] AS VARCHAR) qdxjdl_result , ");
                SqlStringBuilder.Append("            CAST([后端上升-电流] AS VARCHAR) hdssdl , ");
                SqlStringBuilder.Append("            CAST([后端上升-电流-结果] AS VARCHAR) hdssdl_result , ");
                SqlStringBuilder.Append("            CAST([后端下降-电流] AS VARCHAR) hdxjdl , ");
                SqlStringBuilder.Append("            CAST([后端下降-电流-结果] AS VARCHAR) hdxjdl_result ");
                SqlStringBuilder.Append("  FROM      dbo.eol_seat ");
                SqlStringBuilder.Append("  WHERE  1=1   " + whereStr + " order by test_ymd desc,test_hms desc  ");


                DataTable dt = _remotingProxy.GetDataTable(SqlStringBuilder.ToString());
                return dt;
            }
        }

      

    }
}