public override int InsertIdentityId(CpsUserInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter() { ParameterName = "@CpsUserId", Value = ParameterHelper.ConvertValue(m.CpsUserId) });
command.Parameters.Add(new SqlParameter() { ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId) });
command.Parameters.Add(new SqlParameter() { ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate) });
command.Parameters.Add(new SqlParameter() { ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId) });
command.Parameters.Add(new SqlParameter() { ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState) });
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return int.Parse(result.ToString());
}
public override bool Insert(CpsUserInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT;
command.Parameters.Add(new SqlParameter() { ParameterName = "@CpsUserId", Value = ParameterHelper.ConvertValue(m.CpsUserId) });
command.Parameters.Add(new SqlParameter() { ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId) });
command.Parameters.Add(new SqlParameter() { ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate) });
command.Parameters.Add(new SqlParameter() { ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId) });
command.Parameters.Add(new SqlParameter() { ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState) });
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1) return true;
return false;
}
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 GetConditionByModel(CpsUserInfoVO m)
{
return "";
}
public override string GetOrderByModel(CpsUserInfoVO m)
{
return "";
}
