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

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

        public   DataTable Load(BLLContext context, string guid)
        {
           string sql = @"SELECT A.GUID,A.CUSTOMER_GUID,A.DZLX,A.SHORT_ADDRESS,A.ADDRESS
                           ,A.STATUS,A.GROUP_CODE,A.GROUP_NAME,A.COMPANY_CODE,A.COMPANY_NAME
                           ,A.CREATE_USER,A.CREATE_DATE,A.UPDATE_USER,A.UPDATE_DATE,A.CREATE_USER_NAME
                           ,A.UPDATE_USER_NAME,A.NODE_CODE,A.NODE_NAME ";
           sql +=" FROM FMS_CRM_CUSTOMER_ADDRESS 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.CUSTOMER_GUID,A.DZLX,A.SHORT_ADDRESS,A.ADDRESS
                           ,A.STATUS,A.GROUP_CODE,A.GROUP_NAME,A.COMPANY_CODE,A.COMPANY_NAME
                           ,A.CREATE_USER,A.CREATE_DATE,A.UPDATE_USER,A.UPDATE_DATE,A.CREATE_USER_NAME
                           ,A.UPDATE_USER_NAME,A.NODE_CODE,A.NODE_NAME ";
            sql +=" FROM FMS_CRM_CUSTOMER_ADDRESS A ";
            sql +=" WHERE 1=1";

            string condition ="";

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

    }

}