FMS24/FMS24/FMS.DAL/Bdly/BdLyClDAL.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using PL.Base;
using FMS.Entity;

namespace FMS.DAL
{
    public class BdLyClDAL : BaseDAL
    {
      public BD_LY_CL Get(string guid)
        {
            return Get(guid, null);
        }

        public BD_LY_CL Get(string guid, object ts)
        {
            return BD_LY_CL.DAL.Select().Where(a => a.GUID = guid).SingleOrDefault(ts);
        }

        public   DataTable Load(BLLContext context, string guid)
        {
           string sql = @"SELECT A.GUID,A.CAR_NO,A.CAR_LEN,A.DW,A.XZ
                           ,A.MAX_VOL,A.CAR_USERNAME,A.CAR_TEL,A.CREATE_USER,A.CREATE_USER_NAME
                           ,A.CREATE_DATE,A.UPDATE_USER,A.UPDATE_USER_NAME,A.UPDATE_DATE,A.COMPANY_CODE
                           ,A.COMPANY_NAME,A.NODE_CODE,A.NODE_NAME,A.GROUP_CODE,A.GROUP_NAME
                            ";
           sql +=" FROM FMS_BD_LY_CL A ";
           sql +=" WHERE A.GUID=" + cmn.SQLQ(guid);

           DataTable data = DBHelper.GetDataTable(sql);
 
           return data;
        }
 
        public SearchResult Search(BLLContext context, Paging paging, EntityBase queryEntity)
        {
            SearchResult result = new SearchResult();

            string sql = @"SELECT A.GUID,A.CAR_NO,A.CAR_LEN,A.DW,A.XZ
                           ,A.MAX_VOL,A.CAR_USERNAME,A.CAR_TEL,A.CREATE_USER,A.CREATE_USER_NAME
                           ,A.CREATE_DATE,A.UPDATE_USER,A.UPDATE_USER_NAME,A.UPDATE_DATE,A.COMPANY_CODE
                           ,A.COMPANY_NAME,A.NODE_CODE,A.NODE_NAME,A.GROUP_CODE,A.GROUP_NAME
                            ";
            sql +=" FROM FMS_BD_LY_CL A ";
            sql +=" WHERE 1=1";

            string condition ="";

            condition += QueryHelper.BuildCommonSQL(queryEntity);
 
            sql += condition;
            result = SearchHelper.Search(sql, paging);
 
            return result;
        }

    }

}