/// <summary>
/// 添加或编辑物料信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static AdInfo Create(AdInfo model) {
if (model.Id == 0)
{
int id = AdManage.Insert(model);
}
else {
AdManage.Update(model);
}
return model;
}
private void Update(AdInfo model) {
var errors = false;
if(string.IsNullOrEmpty(model.Name)){
ModelState.AddModelError("Name","广告物料不能为空");
errors = true;
}
if(string.IsNullOrEmpty(model.ClickUrl)){
ModelState.AddModelError("ClickUrl","点击链接不能为空");
errors = true;
}
if(ModelState.IsValid && !errors){
AdService.Create(model);
ViewBag.Msg = "保存成功!";
}
}
/// <summary>
/// 添加物料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Insert(AdInfo model) {
string strSQL = "INSERT INTO Ads(Name,ClickUrl,TargetWindow,Type,Width,Height) VALUES(@Name,@ClickUrl,@TargetWindow,@Type,@Width,@Height);SELECT @@IDENTITY";
SqlParameter[] parms = {
new SqlParameter("Name",SqlDbType.NVarChar),
new SqlParameter("ClickUrl",SqlDbType.NVarChar),
new SqlParameter("TargetWindow",SqlDbType.Int),
new SqlParameter("Type",SqlDbType.Int),
new SqlParameter("Width",SqlDbType.Int),
new SqlParameter("Height",SqlDbType.Int),
};
parms[0].Value = model.Name;
parms[1].Value = model.ClickUrl;
parms[2].Value = model.TargetWindow;
parms[3].Value = model.Type;
parms[4].Value = model.Width;
parms[5].Value = model.Height;
return Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text,strSQL,parms));
}
/// <summary>
/// 更新物料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Update(AdInfo model) {
string strSQL = "UPDATE Ads SET Name = @Name,ClickUrl = @ClickUrl,TargetWindow = @TargetWindow,Type = @Type,Width= @Width,height = @Height,Words = @Words WHERE Id = @Id";
SqlParameter[] parms = {
new SqlParameter("Name",SqlDbType.NVarChar),
new SqlParameter("ClickUrl",SqlDbType.NVarChar),
new SqlParameter("Id",SqlDbType.Int),
new SqlParameter("TargetWindow",SqlDbType.Int),
new SqlParameter("Type",SqlDbType.Int),
new SqlParameter("Width",SqlDbType.Int),
new SqlParameter("Height",SqlDbType.Int),
new SqlParameter("Words",SqlDbType.NVarChar)
};
parms[0].Value = model.Name;
parms[1].Value = model.ClickUrl;
parms[2].Value = model.Id;
parms[3].Value = model.TargetWindow;
parms[4].Value = model.Type;
parms[5].Value = model.Width;
parms[6].Value = model.Height;
parms[7].Value = model.Words;
return Goodspeed.Library.Data.SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL,parms);
}
public ActionResult Modify(AdInfo model) {
Update(model);
return View("Create",model);
}
public ActionResult Create(AdInfo model) {
Update(model);
return View(model);
}
