FMS24/FMS24/FMS.DAL/Bd/BdMoudleHeadDAL.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 BdMoudleHeadDAL : BaseDAL
    {
      public BD_MOUDLE_HEAD Get(string guid)
        {
            return Get(guid, null);
        }

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

        public   DataTable Load(BLLContext context, string guid)
        {
           string sql = @"SELECT A.GUID,A.MOUDLE_TYPE,A.BIZ_TYPE,A.MOUDLE_NAME,A.START_PORT
                           ,A.REAMRK,A.CREATE_USER,A.CREATE_DATE,A.UPDATE_USER,A.UPDATE_DATE
                           ,A.CREATE_USER_NAME,A.UPDATE_USER_NAME,A.GROUP_CODE,A.GROUP_NAME,A.COMPANY_CODE
                           ,A.COMPANY_NAME,A.NODE_CODE,A.NODE_NAME ";
           sql +=" FROM FMS_BD_MOUDLE_HEAD 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.MOUDLE_TYPE,A.BIZ_TYPE,A.MOUDLE_NAME,A.START_PORT
                           ,A.REAMRK,A.CREATE_USER,A.CREATE_DATE,A.UPDATE_USER,A.UPDATE_DATE
                           ,A.CREATE_USER_NAME,A.UPDATE_USER_NAME,A.GROUP_CODE,A.GROUP_NAME,A.COMPANY_CODE
                           ,A.COMPANY_NAME,A.NODE_CODE,A.NODE_NAME ";
            sql +=" FROM FMS_BD_MOUDLE_HEAD A ";
            sql +=" WHERE 1=1";

            string condition ="";

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

    }

}