public override List <AdQcodeInfoVO> GetModels(ref AdQcodeInfoPara 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 <AdQcodeInfoVO> list = new List <AdQcodeInfoVO>(); for (int i = 0; i < table.Rows.Count; i++) { list.Add(new AdQcodeInfoVO(table.Rows[i])); } if (!mp.Recount.HasValue) { mp.Recount = GetRecords(mp); } return(list); }
public override string GetOrderByPara(AdQcodeInfoPara mp) { if (!string.IsNullOrEmpty(mp.OrderBy)) { return(string.Format(" order by {0}", mp.OrderBy)); } return(""); }
public override AdQcodeInfoVO GetSingle(AdQcodeInfoPara mp) { var list = GetModels(mp); if (list.Count == 1) { return(list[0]); } return(null); }
public override int GetRecords(AdQcodeInfoPara 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) { AdQcodeInfoPara cip = new AdQcodeInfoPara(); cip.PageIndex = pageIndex - 1; cip.PageSize = 10; cip.AdId = int.Parse(hidAdId.Value); cip.OrderBy = " id desc "; var list = AdQcodeInfoBLL.Instance.GetModels(ref cip); rptTable.DataSource = list; rptTable.DataBind(); apPager.RecordCount = cip.Recount.Value; }
public override bool Delete(AdQcodeInfoPara 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); }
public override string GetConditionByPara(AdQcodeInfoPara mp) { StringBuilder sb = new StringBuilder(); if (mp.Id.HasValue) { sb.AppendFormat(" AND [Id]='{0}' ", mp.Id); } if (mp.AdId.HasValue) { sb.AppendFormat(" AND [AdId]='{0}' ", mp.AdId); } if (mp.AdUserId.HasValue) { sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name))) { sb.AppendFormat(" AND [Name]='{0}' ", mp.Name); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.QcodeUrl))) { sb.AppendFormat(" AND [QcodeUrl]='{0}' ", mp.QcodeUrl); } if (mp.CreateDate.HasValue) { sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate); } if (mp.CreateUserId.HasValue) { sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.QcodeUrl2))) { sb.AppendFormat(" AND [QcodeUrl2]='{0}' ", mp.QcodeUrl2); } sb.Insert(0, " WHERE 1=1 "); return(sb.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hidAdId.Value = Request.Params["adid"] ?? "0"; hidQcodeId.Value = Request.Params["id"] ?? "0"; string isdel = Request.Params["isdel"] ?? ""; if (isdel == "1") { AdQcodeInfoPara ap = new AdQcodeInfoPara(); ap.Id = int.Parse(hidQcodeId.Value); ap.AdUserId = Account.UserId; var qinfo = AdQcodeInfoBLL.Instance.GetSingle(ap); if (qinfo != null) { AdQcodeInfoBLL.Instance.Delete(ap); var adinfo = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara() { Id = qinfo.AdId }); if (adinfo != null) { adinfo.QcodeCount = AdQcodeInfoBLL.Instance.GetRecords(new AdQcodeInfoPara() { AdId = qinfo.AdId }); adinfo.LastDate = DateTime.Now; AdPageInfoBLL.Instance.Edit(adinfo); } } } BindPage(); Bind(); } }
public override List <AdQcodeInfoVO> GetModels(AdQcodeInfoPara 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 <AdQcodeInfoVO> list = new List <AdQcodeInfoVO>(); for (int i = 0; i < table.Rows.Count; i++) { list.Add(new AdQcodeInfoVO(table.Rows[i])); } return(list); }
public override string GetOtherConditionByPara(AdQcodeInfoPara mp) { return(""); }