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

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

        public   DataTable Load(BLLContext context, string guid)
        {
           string sql = @"SELECT A.GUID,A.SFHRLX,A.STATUS,A.ZJM,A.NAME
                           ,A.ADDRESS,A.CODE,A.AEO,A.COUNTRY,A.PROVINCE
                           ,A.CITY,A.ZIP,A.TEL,A.FAX,A.PIRNT
                           ,A.COMPANY_CODE,A.COMPANY_NAME,A.CREATE_USER,A.CREATE_USER_NAME,A.CREATE_DATE
                           ,A.UPDATE_USER,A.UPDATE_USER_NAME,A.UPDATE_DATE,A.NODE_CODE,A.NODE_NAME
                           ,A.GROUP_CODE,A.GROUP_NAME ";
           sql +=" FROM FMS_CRM_SFHR 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.SFHRLX,A.STATUS,A.ZJM,A.NAME
                           ,A.ADDRESS,A.CODE,A.AEO,A.COUNTRY,A.PROVINCE
                           ,A.CITY,A.ZIP,A.TEL,A.FAX,A.PIRNT
                           ,A.COMPANY_CODE,A.COMPANY_NAME,A.CREATE_USER,A.CREATE_USER_NAME,A.CREATE_DATE
                           ,A.UPDATE_USER,A.UPDATE_USER_NAME,A.UPDATE_DATE,A.NODE_CODE,A.NODE_NAME
                           ,A.GROUP_CODE,A.GROUP_NAME 
,(CASE WHEN A.STATUS='Y' THEN 'ÊÇ' WHEN A.STATUS='N' THEN '·ñ' ELSE '' END) AS STATUS_NAME
,(SELECT MAX(NAME) FROM FMS_BD_EXTEND_DATA E WHERE E.DATA_TYPE = 'SFHRLX' AND E.CODE =A.SFHRLX ) AS SFHRLX_NAME";
            sql +=" FROM FMS_CRM_SFHR A ";
            sql +=" WHERE 1=1";

            string condition ="";

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

    }

}