/// <summary> /// chaojie_zz添加於2014/10/14 /// </summary> /// <param name="site"></param> /// <param name="totalCount"></param> #region site站臺列表 /// <summary> /// site站臺列表 /// </summary> /// <param name="site"></param> /// <param name="totalCount"></param> /// <returns>List</returns> public List<SiteQuery> QuerryAll(SiteQuery site, out int totalCount) { StringBuilder stb = new StringBuilder(); StringBuilder sqlCondi = new StringBuilder(); StringBuilder sqlWhere = new StringBuilder(); site.Replace4MySQL(); try { sqlCondi.AppendFormat(@"select site.site_id,site.site_name,site.domain,site.cart_delivery,st.site_name as csitename,site.online_user,"); sqlCondi.AppendFormat(@"site.max_user,site.page_location,site.site_status,site.site_createdate,site.site_updatedate,site.create_userid,site.update_userid "); stb.AppendFormat(@"from site left join site st on site.cart_delivery=st.site_id "); GroupAuthMapQuery groupAuthMapModel = new GroupAuthMapQuery(); groupAuthMapModel.table_name = "site"; groupAuthMapModel.user_id = site.create_userid; stb.Append(_groupAuthMapMgr.Query(groupAuthMapModel)); //if (site.site_id != 0) //{ // strcondition.AppendFormat(@" and site.site_id='{0}' ", site.site_id); //} if (!string.IsNullOrEmpty(site.site_name)) { sqlWhere.AppendFormat(" and site.site_name like N'%{0}%' ", site.site_name); } totalCount = 0; if (sqlWhere.Length != 0) { stb.Append(" WHERE "); stb.Append(sqlWhere.ToString().TrimStart().Remove(0, 3)); } if (site.IsPage) { System.Data.DataTable _dt = _access.getDataTable(" select count(site.site_id) as totalcount " + stb.ToString()); if (_dt != null && _dt.Rows.Count > 0) { totalCount = Convert.ToInt32(_dt.Rows[0]["totalcount"]); } stb.AppendFormat(" order by site.site_id desc limit {0},{1}", site.Start, site.Limit); } return _access.getDataTableForObj<SiteQuery>(sqlCondi.ToString() + stb.ToString()); } catch (Exception ex) { throw new Exception("SiteDao-->QuerryAll-->" + ex.Message + sqlCondi.ToString() + stb.ToString(), ex); } }