lyfz_repos/铂金版源码/LYFZ.CloudServerData/DAL/EnterpriseStore.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace LYFZ.CloudServerData.DAL
{
   public class EnterpriseStore : BaseDataOperate<LYFZ.CloudServerData.Model.EnterpriseStore>
    {
        public EnterpriseStore(LYFZ.CloudServerData.Model.DBConnection dbConn)
        {
            base.DBConn = dbConn;
        }
       /// <summary>
       /// 根据指定企业ID数组查询统计门店个数
       /// </summary>
       /// <param name="EnterpriseIDs"></param>
       /// <returns></returns>
        public System.Data.DataTable GetEnterpriseStoreStatistics(string[] EnterpriseIDs)
        {
            string whereStr = " id=0 ";
            if (EnterpriseIDs.Length > 0)
            {
                whereStr = " EnterpriseID in ('" + String.Join(",", EnterpriseIDs).Replace(",", "','") + "')";
            }
            string sql = "select EnterpriseID,count(id)as sumCount from [tb_EnterpriseStore] where " + whereStr + " group by EnterpriseID";
            
            return LYFZ.Helper.SQLHelper.Query(sql, this.DBConn.GetDBConnectionString()).Tables[0];
        }
       /// <summary>
       /// 
       /// </summary>
       /// <param name="enterpriseid"></param>
       /// <param name="isHeadquarters"></param>
       /// <returns></returns>
        public bool UpdateStoreIsHeadquarters(string enterpriseid,int isHeadquarters)
        {
            if (isHeadquarters >= 1)
            {
                string sql = " update [dbo].[tb_EnterpriseStore] set [IsHeadquarters]=0 where [EnterpriseID]='" + enterpriseid + "' and [IsHeadquarters]>0";
                if (LYFZ.Helper.SQLHelper.ExecuteSql(sql, this.DBConn.GetDBConnectionString()) > 0)
                {
                    return true;
                }
                else {
                    return false;
                }
            }
            else {
                return true;
            }
        }
      

    }
}