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