/// <summary> /// 得到一个对象实体 /// </summary> public Model.common_adR DataRowToModel(DataRow row) { Model.common_adR model = new Model.common_adR(); if (row != null) { if (row["id"] != null) //&& row["id"].ToString() != "" { model.id = Convert.ToInt32(row["id"]); } if (row["ad_group_id"] != null) //&& row["ad_group_id"].ToString() != "" { model.ad_group_id = Convert.ToInt32(row["ad_group_id"]); } if (row["ad_group_name"] != null) //&& row["ad_group_name"].ToString() != "" { model.ad_group_name = Convert.ToString(row["ad_group_name"]); } if (row["ad_type_id"] != null) //&& row["ad_type_id"].ToString() != "" { model.ad_type_id = Convert.ToInt32(row["ad_type_id"]); } if (row["ad_type_name"] != null) //&& row["ad_type_name"].ToString() != "" { model.ad_type_name = Convert.ToString(row["ad_type_name"]); } if (row["ad_data_id"] != null) //&& row["ad_data_id"].ToString() != "" { model.ad_data_id = Convert.ToInt32(row["ad_data_id"]); } if (row["ad_data_title"] != null) //&& row["ad_data_title"].ToString() != "" { model.ad_data_title = Convert.ToString(row["ad_data_title"]); } if (row["ad_data_subtitle"] != null) //&& row["ad_data_subtitle"].ToString() != "" { model.ad_data_subtitle = Convert.ToString(row["ad_data_subtitle"]); } if (row["ad_data_img"] != null) //&& row["ad_data_img"].ToString() != "" { model.ad_data_img = Convert.ToString(row["ad_data_img"]); } if (row["ad_data_url"] != null) //&& row["ad_data_url"].ToString() != "" { model.ad_data_url = Convert.ToString(row["ad_data_url"]); } if (row["ad_sort_id"] != null) //&& row["ad_sort_id"].ToString() != "" { model.ad_sort_id = Convert.ToInt32(row["ad_sort_id"]); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = Convert.ToDateTime(row["add_time"]); } return(model); } else { return(null); } }
private void SetRecommend(HttpContext context) { int id = RequestHelper.GetFormInt("id"); BLL.common_adR bll = new BLL.common_adR(); Model.common_adR model = bll.GetModel("ad_data_id=" + id + " and ad_group_id=" + (int)EnumCollection.adR_group.精品微课推荐课程); if (model != null) { new BLL.common_adR().Delete(model.id); } else { model = new Model.common_adR(); model.ad_group_id = (int)EnumCollection.adR_group.精品微课推荐课程; model.ad_group_name = EnumCollection.adR_group.精品微课推荐课程.ToString(); model.ad_type_id = 0; model.ad_type_name = ""; model.ad_data_title = ""; model.ad_data_subtitle = ""; model.ad_data_img = ""; model.ad_data_url = ""; model.ad_data_id = id; model.ad_sort_id = 0; model.add_time = System.DateTime.Now; bll.Add(model); } context.Response.Write("1"); context.Response.End(); }
/// <summary> /// 获得Model /// </summary> /// <param name="whereStr"></param> /// <returns></returns> public Model.common_adR GetModel(string whereStr) { DataTable dt = dal.GetList(whereStr).Tables[0]; Model.common_adR model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
/// <summary> /// 获得Model /// </summary> /// <param name="Top">大于0取前几行数据,否则取全部</param> /// <param name="whereStr">where条件</param> /// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param> /// <returns></returns> public Model.common_adR GetModel(int Top, string whereStr, string filedOrder) { DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0]; Model.common_adR model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
private bool DoAdd() { BLL.common_adR bll = new BLL.common_adR(); Model.common_adR model = new Model.common_adR(); model.ad_group_id = (int)EnumCollection.adR_group.梧桐花轮播图; model.ad_group_name = Enum.GetName(typeof(EnumCollection.adR_group), model.ad_group_id); model.ad_type_id = 0; model.ad_type_name = ""; model.ad_data_id = Convert.ToInt32(this.txtad_data_id.Text); model.ad_data_title = this.txtad_data_title.Text; model.ad_data_subtitle = ""; model.ad_data_url = ""; model.ad_data_img = this.txtad_data_img.Text; model.ad_sort_id = Convert.ToInt32(this.txtad_sort_id.Text); model.add_time = System.DateTime.Now; int id = bll.Add(model); if (id > 0) { AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加轮播图信息,主键:" + id); //记录日志 return(true); } else { return(false); } }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_common_adR", EnumCollection.ActionEnum.Modify.ToString()); //检查权限 BLL.common_adR bll = new BLL.common_adR(); Model.common_adR model = bll.GetModel(this.id); model.ad_group_id = Convert.ToInt32(txtad_group_id.Text); model.ad_group_name = Convert.ToString(txtad_group_name.Text); model.ad_type_id = Convert.ToInt32(txtad_type_id.Text); model.ad_type_name = Convert.ToString(txtad_type_name.Text); model.ad_data_id = Convert.ToInt32(txtad_data_id.Text); model.ad_data_title = Convert.ToString(txtad_data_title.Text); model.ad_data_subtitle = Convert.ToString(txtad_data_subtitle.Text); model.ad_data_img = Convert.ToString(txtad_data_img.Text); model.ad_data_url = Convert.ToString(txtad_data_url.Text); model.ad_sort_id = Convert.ToInt32(txtad_sort_id.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改广告位与数据对应信息,主键:" + id); //记录日志 JscriptMsg("修改广告位与数据对应信息成功!", "Manage.aspx"); } else { JscriptMsg("保存过程中发生错误!", ""); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.common_adR model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"UPDATE ybd_common_adR SET ad_group_id = @ad_group_id ,ad_group_name = @ad_group_name ,ad_type_id = @ad_type_id ,ad_type_name = @ad_type_name ,ad_data_id = @ad_data_id ,ad_data_title = @ad_data_title ,ad_data_subtitle = @ad_data_subtitle ,ad_data_img = @ad_data_img ,ad_data_url = @ad_data_url ,ad_sort_id = @ad_sort_id ,add_time = @add_time WHERE id = @id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) , new SqlParameter("@ad_group_id", SqlDbType.Int, 4) , new SqlParameter("@ad_group_name", SqlDbType.NVarChar, 50) , new SqlParameter("@ad_type_id", SqlDbType.Int, 4) , new SqlParameter("@ad_type_name", SqlDbType.NVarChar, 50) , new SqlParameter("@ad_data_id", SqlDbType.Int, 4) , new SqlParameter("@ad_data_title", SqlDbType.NVarChar, 50) , new SqlParameter("@ad_data_subtitle", SqlDbType.NVarChar, 500) , new SqlParameter("@ad_data_img", SqlDbType.NVarChar, 500) , new SqlParameter("@ad_data_url", SqlDbType.NVarChar, 500) , new SqlParameter("@ad_sort_id", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.id; parameters[1].Value = model.ad_group_id; parameters[2].Value = model.ad_group_name; parameters[3].Value = model.ad_type_id; parameters[4].Value = model.ad_type_name; parameters[5].Value = model.ad_data_id; parameters[6].Value = model.ad_data_title; parameters[7].Value = model.ad_data_subtitle; parameters[8].Value = model.ad_data_img; parameters[9].Value = model.ad_data_url; parameters[10].Value = model.ad_sort_id; parameters[11].Value = model.add_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int _id) { BLL.common_adR bll = new BLL.common_adR(); Model.common_adR model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } this.txtad_data_title.Text = model.ad_data_title; this.txtad_data_id.Text = model.ad_data_id + ""; this.txtad_data_img.Text = model.ad_data_img; this.txtad_sort_id.Text = model.ad_sort_id + ""; }
private bool DoEdit(int id) { BLL.common_adR bll = new BLL.common_adR(); Model.common_adR model = bll.GetModel(id); model.ad_data_id = Convert.ToInt32(this.txtad_data_id.Text); model.ad_data_title = this.txtad_data_title.Text; model.ad_data_subtitle = ""; model.ad_data_img = this.txtad_data_img.Text; model.ad_sort_id = Convert.ToInt32(this.txtad_sort_id.Text); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改轮播图信息,主键:" + id); //记录日志 return(true); } else { return(false); } }
private void BindInfo() { BLL.common_adR bll = new BLL.common_adR(); Model.common_adR model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txtad_group_id.Text = model.ad_group_id + ""; txtad_group_name.Text = model.ad_group_name + ""; txtad_type_id.Text = model.ad_type_id + ""; txtad_type_name.Text = model.ad_type_name + ""; txtad_data_id.Text = model.ad_data_id + ""; txtad_data_title.Text = model.ad_data_title + ""; txtad_data_subtitle.Text = model.ad_data_subtitle + ""; txtad_data_img.Text = model.ad_data_img + ""; txtad_data_url.Text = model.ad_data_url + ""; txtad_sort_id.Text = model.ad_sort_id + ""; txtadd_time.Text = model.add_time + ""; }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_common_adR", EnumCollection.ActionEnum.Add.ToString()); //检查权限 #region string strError = string.Empty; if (txtad_group_id.Text.Trim() == "" || txtad_group_id.Text.Trim().Length > 4) { strError += "广告分组id为空或超出长度![br]"; } if (txtad_group_name.Text.Trim() == "" || txtad_group_name.Text.Trim().Length > 50) { strError += "广告分组名称为空或超出长度![br]"; } if (txtad_type_id.Text.Trim() == "" || txtad_type_id.Text.Trim().Length > 4) { strError += "广告类型id为空或超出长度![br]"; } if (txtad_type_name.Text.Trim() == "" || txtad_type_name.Text.Trim().Length > 50) { strError += "广告类型name为空或超出长度![br]"; } if (txtad_data_id.Text.Trim() == "" || txtad_data_id.Text.Trim().Length > 4) { strError += "广告数据id为空或超出长度![br]"; } if (txtad_data_title.Text.Trim() == "" || txtad_data_title.Text.Trim().Length > 50) { strError += "广告数据标题为空或超出长度![br]"; } if (txtad_data_subtitle.Text.Trim() == "" || txtad_data_subtitle.Text.Trim().Length > 500) { strError += "广告数据副标题为空或超出长度![br]"; } if (txtad_data_img.Text.Trim() == "" || txtad_data_img.Text.Trim().Length > 500) { strError += "广告数据图片为空或超出长度![br]"; } if (txtad_data_url.Text.Trim() == "" || txtad_data_url.Text.Trim().Length > 500) { strError += "广告位链接为空或超出长度![br]"; } if (txtad_sort_id.Text.Trim() == "" || txtad_sort_id.Text.Trim().Length > 4) { strError += "排序为空或超出长度![br]"; } if (txtadd_time.Text.Trim() == "" || txtadd_time.Text.Trim().Length > 8) { strError += "添加时间为空或超出长度![br]"; } if (strError != string.Empty) { JscriptMsg(strError, "", "Error"); return; } #endregion Model.common_adR model = new Model.common_adR(); BLL.common_adR bll = new BLL.common_adR(); model.ad_group_id = Convert.ToInt32(txtad_group_id.Text); model.ad_group_name = Convert.ToString(txtad_group_name.Text); model.ad_type_id = Convert.ToInt32(txtad_type_id.Text); model.ad_type_name = Convert.ToString(txtad_type_name.Text); model.ad_data_id = Convert.ToInt32(txtad_data_id.Text); model.ad_data_title = Convert.ToString(txtad_data_title.Text); model.ad_data_subtitle = Convert.ToString(txtad_data_subtitle.Text); model.ad_data_img = Convert.ToString(txtad_data_img.Text); model.ad_data_url = Convert.ToString(txtad_data_url.Text); model.ad_sort_id = Convert.ToInt32(txtad_sort_id.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); int id = bll.Add(model); if (id > 0) { AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加广告位与数据对应信息,主键:" + id); //记录日志 JscriptMsg("添加广告位与数据对应信息成功!", "Manage.aspx", ""); } else { JscriptMsg("保存过程中发生错误!", ""); } }
private void SetGoodsIndex() { int id = RequestHelper.GetFormInt("id"); Model.goods_goods goods = new BLL.goods_goods().GetModel(id); if (goods != null) { BLL.common_adR bll = new BLL.common_adR(); if (goods.group_id == (int)EnumCollection.goods_group.教育商城) { Model.common_adR model = bll.GetModel("ad_data_id=" + id + " and ad_group_id=" + (int)EnumCollection.adR_group.教育商城推荐商品); if (model != null) { new BLL.common_adR().Delete(model.id); } else { model = new Model.common_adR(); model.ad_group_id = (int)EnumCollection.adR_group.教育商城推荐商品; model.ad_group_name = EnumCollection.adR_group.教育商城推荐商品.ToString(); model.ad_type_id = 0; model.ad_type_name = ""; model.ad_data_title = ""; model.ad_data_subtitle = ""; model.ad_data_img = ""; model.ad_data_url = ""; model.ad_data_id = id; model.ad_sort_id = 0; model.add_time = System.DateTime.Now; bll.Add(model); } HttpContext.Current.Response.Write("1"); HttpContext.Current.Response.End(); return; } if (goods.group_id == (int)EnumCollection.goods_group.积分专区) { Model.common_adR model = bll.GetModel("ad_data_id=" + id + " and ad_group_id=" + (int)EnumCollection.adR_group.积分商城推荐商品); if (model != null) { new BLL.common_adR().Delete(model.id); } else { model = new Model.common_adR(); model.ad_group_id = (int)EnumCollection.adR_group.积分商城推荐商品; model.ad_group_name = EnumCollection.adR_group.积分商城推荐商品.ToString(); model.ad_type_id = 0; model.ad_type_name = ""; model.ad_data_title = ""; model.ad_data_subtitle = ""; model.ad_data_img = ""; model.ad_data_url = ""; model.ad_data_id = id; model.ad_sort_id = 0; model.add_time = System.DateTime.Now; bll.Add(model); } HttpContext.Current.Response.Write("1"); HttpContext.Current.Response.End(); return; } HttpContext.Current.Response.Write("0"); HttpContext.Current.Response.End(); return; } else { HttpContext.Current.Response.Write("0"); HttpContext.Current.Response.End(); return; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.common_adR model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.common_adR model) { return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.common_adR model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert Into ybd_common_adR( ad_group_id ,ad_group_name ,ad_type_id ,ad_type_name ,ad_data_id ,ad_data_title ,ad_data_subtitle ,ad_data_img ,ad_data_url ,ad_sort_id ,add_time ) Values ( @ad_group_id ,@ad_group_name ,@ad_type_id ,@ad_type_name ,@ad_data_id ,@ad_data_title ,@ad_data_subtitle ,@ad_data_img ,@ad_data_url ,@ad_sort_id ,@add_time ); SELECT @@IDENTITY;"); SqlParameter[] parameters = { new SqlParameter("@ad_group_id", SqlDbType.Int, 4) , new SqlParameter("@ad_group_name", SqlDbType.NVarChar, 50) , new SqlParameter("@ad_type_id", SqlDbType.Int, 4) , new SqlParameter("@ad_type_name", SqlDbType.NVarChar, 50) , new SqlParameter("@ad_data_id", SqlDbType.Int, 4) , new SqlParameter("@ad_data_title", SqlDbType.NVarChar, 50) , new SqlParameter("@ad_data_subtitle", SqlDbType.NVarChar, 500) , new SqlParameter("@ad_data_img", SqlDbType.NVarChar, 500) , new SqlParameter("@ad_data_url", SqlDbType.NVarChar, 500) , new SqlParameter("@ad_sort_id", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.ad_group_id; parameters[1].Value = model.ad_group_name; parameters[2].Value = model.ad_type_id; parameters[3].Value = model.ad_type_name; parameters[4].Value = model.ad_data_id; parameters[5].Value = model.ad_data_title; parameters[6].Value = model.ad_data_subtitle; parameters[7].Value = model.ad_data_img; parameters[8].Value = model.ad_data_url; parameters[9].Value = model.ad_sort_id; parameters[10].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }