/// <summary> /// 添加或编辑广告信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static AdDeliveryInfo Create(AdDeliveryInfo model) { if (model.Id == 0) { int id = AdDeliveryManage.Insert(model); } else { AdDeliveryManage.Update(model); } return model; }
/// <summary> /// 更新广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Update(AdDeliveryInfo model) { string strSQL = "UPDATE dbo.AdDelivery SET AdPositionId = @AdPositionId ,Name = @Name WHERE Id = @Id"; SqlParameter[] parms = { new SqlParameter("AdPositionId",SqlDbType.Int), new SqlParameter("Name",SqlDbType.NVarChar), new SqlParameter("Id",SqlDbType.Int), }; parms[0].Value = model.AdPositionId; parms[1].Value = model.Name; parms[2].Value = model.Id; return Goodspeed.Library.Data.SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL,parms); }
/// <summary> /// 新建广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Insert(AdDeliveryInfo model) { string strSQL = "INSERT INTO dbo.AdDelivery(AdPositionId,Name) VALUES(@AdPositionId,@Name);SELECT @@IDENTITY;"; SqlParameter[] parms = { new SqlParameter("AdPositionId",SqlDbType.Int), new SqlParameter("Name",SqlDbType.NVarChar), }; parms[0].Value = model.AdPositionId; parms[1].Value = model.Name; return Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text,strSQL,parms)); }
private void Update(AdDeliveryInfo model) { bool errors = false; if (string.IsNullOrEmpty(model.Name)) { ModelState.AddModelError("Name", "广告名称不能为空"); errors = true; } if(model.AdPositionId ==0){ ModelState.AddModelError("AdPositionId", "请选择目标广告位"); errors = true; } if (ModelState.IsValid && !errors) { AdDeliveryService.Create(model); ViewBag.Msg = "保存成功!<a href=\"list\">返回</a>"; } var adPositionModel = AdPositionService.Get(model.AdPositionId); ViewBag.AdPositionModel = adPositionModel; }
private static AdDeliveryInfo GetByRow(DataRow dr) { if (dr == null) { return new AdDeliveryInfo(); } var model = new AdDeliveryInfo() { Id = dr.Field<int>("Id"), AdPositionId = dr.Field<int>("AdPositionId"), Name = dr.Field<string>("Name"), BeginTime = dr.Field<string>("BeginTime"), EndTime = dr.Field<string>("EndTime"), CreateDateTime = dr.Field<DateTime>("CreateDateTime") }; return model; }
public ActionResult Modify(AdDeliveryInfo model) { Update(model); return View("Create",model); }
public ActionResult Create(AdDeliveryInfo model) { Update(model); return View(model); }