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);
}
}
