public override List<CpsUserInfoVO> GetModels(ref CpsUserInfoPara 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<CpsUserInfoVO> list = new List<CpsUserInfoVO>(); for (int i = 0; i < table.Rows.Count; i++) { list.Add(new CpsUserInfoVO(table.Rows[i])); } if (!mp.Recount.HasValue) { mp.Recount = GetRecords(mp); } return list; }
public override CpsUserInfoVO GetSingle(CpsUserInfoPara mp) { var list = GetModels(mp); if (list.Count == 1) return list[0]; return null; }
public override string GetOrderByPara(CpsUserInfoPara mp) { if(!string.IsNullOrEmpty(mp.OrderBy)) { return string.Format(" order by {0}", mp.OrderBy); } return ""; }
public override int GetRecords(CpsUserInfoPara 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()); }
public override bool Delete(CpsUserInfoPara 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 void Bind(int pageIndex = 1) { CpsUserInfoPara aip = new CpsUserInfoPara(); aip.PageIndex = pageIndex - 1; aip.PageSize = 10; aip.OrderBy = " id desc "; var list = CpsUserInfoBLL.Instance.GetModels(ref aip); rptTables.DataSource = list; rptTables.DataBind(); apPager.RecordCount = aip.Recount.Value; }
public override string GetConditionByPara(CpsUserInfoPara mp) { StringBuilder sb = new StringBuilder(); if (mp.Id.HasValue) { sb.AppendFormat(" AND [Id]='{0}' ",mp.Id);} if (mp.CpsUserId.HasValue) { sb.AppendFormat(" AND [CpsUserId]='{0}' ",mp.CpsUserId);} if (mp.AdId.HasValue) { sb.AppendFormat(" AND [AdId]='{0}' ",mp.AdId);} if (mp.CreateDate.HasValue) { sb.AppendFormat(" AND [CreateDate]='{0}' ",mp.CreateDate);} if (mp.CreateUserId.HasValue) { sb.AppendFormat(" AND [CreateUserId]='{0}' ",mp.CreateUserId);} if (mp.IsState.HasValue) { sb.AppendFormat(" AND [IsState]='{0}' ",mp.IsState);} sb.Insert(0, " WHERE 1=1 "); return sb.ToString(); }
private void BindPage() { CpsUserInfoPara cup = new CpsUserInfoPara(); cup.CpsUserId = Account.UserId; var list = CpsUserInfoBLL.Instance.GetModels(cup); foreach (var item in list) { ddlAd.Items.Add(new ListItem() { Text = AdPageInfoBLL.Instance.GetTitleById(item.AdId), Value = item.AdId.ToString() }); } ddlAd.Items.Insert(0, new ListItem() { Text = "不限产品", Value = "" }); }
public override List<CpsUserInfoVO> GetModels(CpsUserInfoPara 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<CpsUserInfoVO> list = new List<CpsUserInfoVO>(); for (int i = 0; i < table.Rows.Count; i++) { list.Add(new CpsUserInfoVO(table.Rows[i])); } return list; }
protected void btnSave_Click(object sender, EventArgs e) { CpsUserInfoPara cup = new CpsUserInfoPara(); cup.AdId = int.Parse(ddlAd.SelectedValue); cup.CpsUserId = int.Parse(ddlCpsUser.SelectedValue); var list = CpsUserInfoBLL.Instance.GetModels(cup); if (list.Count == 0) { CpsUserInfoVO info = new CpsUserInfoVO(); info.AdId = int.Parse(ddlAd.SelectedValue); info.CpsUserId = int.Parse(ddlCpsUser.SelectedValue); info.CreateDate = DateTime.Now; info.CreateUserId = Account.UserId; CpsUserInfoBLL.Instance.Add(info); Response.Redirect("/Accounts/Order/CpsUserConfigList.aspx"); } else { lblMsg.Text = "该用户己配置相关广告。"; } }
public override string GetOtherConditionByPara(CpsUserInfoPara mp) { return ""; }