public override List <DomainInfoVO> GetModels(ref DomainInfoPara mp) { string where = GetConditionByPara(mp); int pStart = mp.PageIndex.Value * mp.PageSize.Value; int pEnd = mp.PageSize.Value; string cmd = QUERYPAGE .Replace("@PAGESIZE", pEnd.ToString()) .Replace("@PTOP", pStart.ToString()) .Replace("@WHERE", where) .Replace("@ORDER", GetOrderByPara(mp)); CodeCommand command = new CodeCommand(); command.CommandText = cmd; var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command); List <DomainInfoVO> list = new List <DomainInfoVO>(); for (int i = 0; i < table.Rows.Count; i++) { list.Add(new DomainInfoVO(table.Rows[i])); } if (!mp.Recount.HasValue) { mp.Recount = GetRecords(mp); } return(list); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/json"; string sname = context.Request.Params["sname"] ?? ""; ApiResult result = new ApiResult(); try { DomainInfoPara dip = new DomainInfoPara(); dip.SerName = sname; var list = DomainInfoBLL.Instance.GetModels(dip); result.datajson = DN.Framework.Utility.Serializer.SerializeObject(list); result.code = 1; result.msg = "获取成功。"; } catch (Exception ex) { result.msg = ex.Message; result.code = 2; } string json = DN.Framework.Utility.Serializer.SerializeObject(result); context.Response.ClearContent(); context.Response.Write(json); context.Response.End(); }
public override string GetOrderByPara(DomainInfoPara mp) { if (!string.IsNullOrEmpty(mp.OrderBy)) { return(string.Format(" order by {0}", mp.OrderBy)); } return(""); }
public override DomainInfoVO GetSingle(DomainInfoPara mp) { var list = GetModels(mp); if (list.Count == 1) { return(list[0]); } return(null); }
public override int GetRecords(DomainInfoPara mp) { string where = GetConditionByPara(mp); CodeCommand command = new CodeCommand(); command.CommandText = QUERYCOUNT + where; var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command); return(int.Parse(result.ToString())); }
private void Bind(int pageIndex = 1) { DomainInfoPara cip = new DomainInfoPara(); cip.PageIndex = pageIndex - 1; cip.PageSize = 10; cip.OrderBy = " id desc "; var list = DomainInfoBLL.Instance.GetModels(ref cip); rptTable.DataSource = list; rptTable.DataBind(); apPager.RecordCount = cip.Recount.Value; }
public override bool Delete(DomainInfoPara mp) { string where = GetConditionByPara(mp); CodeCommand command = new CodeCommand(); command.CommandText = DELETE + where; int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command); if (result >= 1) { return(true); } return(false); }
private string ReplaceMiddlePageHtml(string html, AdPageInfoVO info) { //有效域名 DomainInfoPara dp = new DomainInfoPara(); dp.IsAuth = 1; dp.IsState = 0; var list = DomainInfoBLL.Instance.GetModels(dp); StringBuilder sbDomain = new StringBuilder(); foreach (var item in list) { sbDomain.AppendFormat("\"{0}\",", item.Domain); } if (sbDomain.Length != 0) { sbDomain = sbDomain.Remove(sbDomain.Length - 1, 1); } //有效页面 AdUserPagePara aup = new AdUserPagePara(); aup.AdPageId = info.Id; var plist = AdUserPageBLL.Instance.GetModels(aup); StringBuilder sbPage = new StringBuilder(); foreach (var item in plist) { sbPage.AppendFormat("\"{0}\",", item.PageName); } sbPage.AppendFormat("\"{0}\"", info.ViewPage); html = html .Replace("$domains$", sbDomain.ToString()) .Replace("$pages$", sbPage.ToString()); return(html); }
public override List <DomainInfoVO> GetModels(DomainInfoPara mp) { string where = GetConditionByPara(mp); CodeCommand command = new CodeCommand(); string cmd = LOAD .Replace("@WHERE", where) .Replace("@ORDER", GetOrderByPara(mp)); command.CommandText = cmd; var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command); List <DomainInfoVO> list = new List <DomainInfoVO>(); for (int i = 0; i < table.Rows.Count; i++) { list.Add(new DomainInfoVO(table.Rows[i])); } return(list); }
public override string GetOtherConditionByPara(DomainInfoPara mp) { return(""); }
public override string GetConditionByPara(DomainInfoPara mp) { StringBuilder sb = new StringBuilder(); if (mp.Id.HasValue) { sb.AppendFormat(" AND [Id]='{0}' ", mp.Id); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name))) { sb.AppendFormat(" AND [Name]='{0}' ", mp.Name); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Domain))) { sb.AppendFormat(" AND [Domain]='{0}' ", mp.Domain); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PageName))) { sb.AppendFormat(" AND [PageName]='{0}' ", mp.PageName); } if (mp.IsState.HasValue) { sb.AppendFormat(" AND [IsState]='{0}' ", mp.IsState); } if (mp.IsAuth.HasValue) { sb.AppendFormat(" AND [IsAuth]='{0}' ", mp.IsAuth); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.CityName))) { sb.AppendFormat(" AND [CityName]='{0}' ", mp.CityName); } if (mp.CreateDate.HasValue) { sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate); } if (mp.CreateUserId.HasValue) { sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId); } if (mp.IsColse.HasValue) { sb.AppendFormat(" AND [IsColse]='{0}' ", mp.IsColse); } if (mp.ColseDate.HasValue) { sb.AppendFormat(" AND [ColseDate]='{0}' ", mp.ColseDate); } if (mp.CloseUserId.HasValue) { sb.AppendFormat(" AND [CloseUserId]='{0}' ", mp.CloseUserId); } if (mp.AdUserId.HasValue) { sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId); } if (mp.IsResolution.HasValue) { sb.AppendFormat(" AND [IsResolution]='{0}' ", mp.IsResolution); } if (mp.ResolutionDate.HasValue) { sb.AppendFormat(" AND [ResolutionDate]='{0}' ", mp.ResolutionDate); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.SerName))) { sb.AppendFormat(" AND [SerName]='{0}' ", mp.SerName); } if (mp.ResolutionType.HasValue) { sb.AppendFormat(" AND [ResolutionType]='{0}' ", mp.ResolutionType); } sb.Insert(0, " WHERE 1=1 "); return(sb.ToString()); }