/// <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 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))); }
/// <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)); }
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); }
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; }
/// <summary> /// 广告列表 /// </summary> /// <param name="setting"></param> /// <returns></returns> public static IPageOfList <AdDeliveryInfo> List(AdSearchSetting setting) { FastPaging fp = new FastPaging(); fp.OverOrderBy = " CreateDateTime DESC"; fp.PageIndex = setting.PageIndex; fp.PageSize = setting.PageSize; fp.QueryFields = "*"; fp.TableName = "AdDelivery"; fp.PrimaryKey = "Id"; fp.WithOptions = " WITH(NOLOCK)"; if (setting.AdPositionId > 0) { fp.Condition = string.Format(" AdPositionId = {0}", setting.AdPositionId); } IList <AdDeliveryInfo> list = new List <AdDeliveryInfo>(); AdDeliveryInfo model = null; DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005()); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { model = GetByRow(dr); if (model != null) { list.Add(model); } } } int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL())); return(new PageOfList <AdDeliveryInfo>(list, setting.PageIndex, setting.PageSize, count)); }
public ActionResult Modify(AdDeliveryInfo model) { Update(model); return(View("Create", model)); }
public ActionResult Create(AdDeliveryInfo model) { Update(model); return(View(model)); }