public override bool Edit(AdQcodeInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUserId", Value = ParameterHelper.ConvertValue(m.AdUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeUrl", Value = ParameterHelper.ConvertValue(m.QcodeUrl)
});
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 = "@QcodeUrl2", Value = ParameterHelper.ConvertValue(m.QcodeUrl2)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
/// <summary>
/// 随机获取二维码
/// </summary>
/// <param name="adid"></param>
/// <returns></returns>
public AdQcodeInfoVO GetRandQcode(int adid)
{
AdQcodeInfoVO info = null;
if (m_leng == 0)
{
Refresh();
}
var list = _list.Where(p => p.AdId == adid).ToList <AdQcodeInfoVO>();
if (list.Count() == 1)
{
info = list[0];
}
else if (list.Count() != 0)
{
info = list[_random.Next(list.Count)];
}
return(info);
}
public override int InsertIdentityId(AdQcodeInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUserId", Value = ParameterHelper.ConvertValue(m.AdUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeUrl", Value = ParameterHelper.ConvertValue(m.QcodeUrl)
});
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 = "@QcodeUrl2", Value = ParameterHelper.ConvertValue(m.QcodeUrl2)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdQcodeInfoVO info = new AdQcodeInfoVO();
info.Name = txtName.Value;
info.AdUserId = Account.UserId;
info.AdId = int.Parse(hidAdId.Value);
info.CreateDate = DateTime.Now;
info.CreateUserId = Account.UserId;
txtWeiXinName.Text = info.QcodeUrl2;
if (string.IsNullOrEmpty(txtQcodeUrl.Text))
{
info.QcodeUrl = imgPreview.ImageUrl;
}
else
{
info.QcodeUrl = txtQcodeUrl.Text;
}
AdQcodeInfoBLL.Instance.Add(info);
var adinfo = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara()
{
Id = info.AdId
});
if (adinfo != null)
{
adinfo.QcodeCount = AdQcodeInfoBLL.Instance.GetRecords(new AdQcodeInfoPara()
{
AdId = info.AdId
});
adinfo.LastDate = DateTime.Now;
AdPageInfoBLL.Instance.Edit(adinfo);
}
AdQcodeInfoBLL.Instance.Refresh();
Response.Redirect("/Accounts/Pages/QcodeList.aspx?adid=" + hidAdId.Value);
}
public override string GetOtherConditionByModel(AdQcodeInfoVO m)
{
return("");
}
public override string GetOrderByModel(AdQcodeInfoVO m)
{
return("");
}
