public List<Site> Query(Site query) { StringBuilder stb = new StringBuilder(); try { query.Replace4MySQL(); stb.Append("select site_id,site_name,domain,cart_delivery from site where 1=1 "); if (!string.IsNullOrEmpty(query.Site_Name)) { stb.AppendFormat(" and site_name like N'%{0}%'", query.Site_Name); } if (query.Site_Id != 0) { stb.AppendFormat(" and site_id={0}", query.Site_Id); } return _access.getDataTableForObj<Site>(stb.ToString()); } catch (Exception ex) { throw new Exception("SiteDao-->Query-->" + ex.Message + stb.ToString(), ex); } }
public List<Site> GetSite(Site query) { query.Replace4MySQL(); StringBuilder sql = new StringBuilder(); sql.AppendFormat("select site_id,site_name from site where site_status=1 "); GroupAuthMapQuery groupAuthMapModel = new GroupAuthMapQuery(); groupAuthMapModel.table_name = "site"; groupAuthMapModel.user_id = query.Create_Userid; sql.Append(_groupAuthMapMgr.Query(groupAuthMapModel)); try { return _access.getDataTableForObj<Site>(sql.ToString()); } catch (Exception ex) { throw new Exception("SiteDao-->GetSite-->" + ex.Message + sql.ToString(), ex); } }