private bool DoEdit(int id) { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(id); model.group_id = (int)EnumCollection.article_group.关于我们; model.user_id = 0; model.category_id = 0; model.title = Convert.ToString(txttitle.Text); model.subtitle = ""; model.contents = Convert.ToString(txtcontents.Text); model.img_src = ""; model.click = 0; model.upvote = 0; model.status = (int)EnumCollection.YesOrNot.是; model.add_time = System.DateTime.Now; if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改关于我们,主键:" + id); //记录日志 return(true); } else { return(false); } }
/// <summary> /// 获得Model /// </summary> /// <param name="whereStr"></param> /// <returns></returns> public Model.common_article GetModel(string whereStr) { DataTable dt = dal.GetList(whereStr).Tables[0]; Model.common_article model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_common_article", EnumCollection.ActionEnum.Modify.ToString()); //检查权限 BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(this.id); model.group_id = Convert.ToInt32(txtgroup_id.Text); model.user_id = Convert.ToInt32(txtuser_id.Text); model.category_id = Convert.ToInt32(txtcategory_id.Text); model.title = Convert.ToString(txttitle.Text); model.subtitle = Convert.ToString(txtsubtitle.Text); model.contents = Convert.ToString(txtcontents.Text); model.img_src = Convert.ToString(txtimg_src.Text); model.click = Convert.ToInt32(txtclick.Text); model.upvote = Convert.ToInt32(txtupvote.Text); model.status = Convert.ToInt32(txtstatus.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改全局文章信息,主键:" + id); //记录日志 JscriptMsg("修改全局文章信息成功!", "Manage.aspx"); } else { JscriptMsg("保存过程中发生错误!", ""); } }
private bool DoAdd() { Model.common_article model = new Model.common_article(); BLL.common_article bll = new BLL.common_article(); model.group_id = (int)EnumCollection.article_group.PC站关于我们; model.user_id = 0; model.category_id = 0; model.title = Convert.ToString(txttitle.Text); model.subtitle = ""; model.contents = Convert.ToString(txtcontents.Text); model.img_src = ""; model.click = 0; model.upvote = 0; model.status = (int)EnumCollection.YesOrNot.是; model.add_time = System.DateTime.Now; int id = bll.Add(model); if (id > 0) { AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加PC站关于我们,主键:" + id); //记录日志 return(true); } else { return(false); } }
private void SetProductIsShow() { int id = RequestHelper.GetFormInt("id"); BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(id); if (model != null) { if (model.upvote == (int)EnumCollection.YesOrNot.是) { model.upvote = (int)EnumCollection.YesOrNot.否; } else { model.upvote = (int)EnumCollection.YesOrNot.是; } bll.Update(model); HttpContext.Current.Response.Write("1"); HttpContext.Current.Response.End(); } else { HttpContext.Current.Response.Write("0"); HttpContext.Current.Response.End(); } }
private bool DoAdd() { Model.common_article model = new Model.common_article(); BLL.common_article bll = new BLL.common_article(); model.group_id = (int)EnumCollection.article_group.新闻动态; model.user_id = 0; model.category_id = Convert.ToInt32(ddlCategory.SelectedValue); model.title = Convert.ToString(txttitle.Text.Trim()); model.subtitle = Convert.ToString(txtsubtitle.Text.Trim()); model.contents = Convert.ToString(txtcontents.Text.Trim()); model.img_src = Convert.ToString(txtimg_src.Text.Trim()); model.click = 0; model.upvote = 0; model.status = (int)EnumCollection.examine_status.审核通过; 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); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.common_article DataRowToModel(DataRow row) { Model.common_article model = new Model.common_article(); if (row != null) { if (row["id"] != null) //&& row["id"].ToString() != "" { model.id = Convert.ToInt32(row["id"]); } if (row["group_id"] != null) //&& row["group_id"].ToString() != "" { model.group_id = Convert.ToInt32(row["group_id"]); } if (row["user_id"] != null) //&& row["user_id"].ToString() != "" { model.user_id = Convert.ToInt32(row["user_id"]); } if (row["category_id"] != null) //&& row["category_id"].ToString() != "" { model.category_id = Convert.ToInt32(row["category_id"]); } if (row["title"] != null) //&& row["title"].ToString() != "" { model.title = Convert.ToString(row["title"]); } if (row["subtitle"] != null) //&& row["subtitle"].ToString() != "" { model.subtitle = Convert.ToString(row["subtitle"]); } if (row["contents"] != null) //&& row["contents"].ToString() != "" { model.contents = Convert.ToString(row["contents"]); } if (row["img_src"] != null) //&& row["img_src"].ToString() != "" { model.img_src = Convert.ToString(row["img_src"]); } if (row["click"] != null) //&& row["click"].ToString() != "" { model.click = Convert.ToInt32(row["click"]); } if (row["upvote"] != null) //&& row["upvote"].ToString() != "" { model.upvote = Convert.ToInt32(row["upvote"]); } if (row["status"] != null) //&& row["status"].ToString() != "" { model.status = Convert.ToInt32(row["status"]); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = Convert.ToDateTime(row["add_time"]); } return(model); } else { return(null); } }
/// <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_article GetModel(int Top, string whereStr, string filedOrder) { DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0]; Model.common_article model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.common_article model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"UPDATE ybd_common_article SET group_id = @group_id ,user_id = @user_id ,category_id = @category_id ,title = @title ,subtitle = @subtitle ,contents = @contents ,img_src = @img_src ,click = @click ,upvote = @upvote ,status = @status ,add_time = @add_time WHERE id = @id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) , new SqlParameter("@group_id", SqlDbType.Int, 4) , new SqlParameter("@user_id", SqlDbType.Int, 4) , new SqlParameter("@category_id", SqlDbType.Int, 4) , new SqlParameter("@title", SqlDbType.NVarChar, 200) , new SqlParameter("@subtitle", SqlDbType.NVarChar, 200) , new SqlParameter("@contents", SqlDbType.NVarChar, 4000) , new SqlParameter("@img_src", SqlDbType.NVarChar, 255) , new SqlParameter("@click", SqlDbType.Int, 4) , new SqlParameter("@upvote", SqlDbType.Int, 4) , new SqlParameter("@status", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.id; parameters[1].Value = model.group_id; parameters[2].Value = model.user_id; parameters[3].Value = model.category_id; parameters[4].Value = model.title; parameters[5].Value = model.subtitle; parameters[6].Value = model.contents; parameters[7].Value = model.img_src; parameters[8].Value = model.click; parameters[9].Value = model.upvote; parameters[10].Value = model.status; parameters[11].Value = model.add_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private bool DoAdd() { Model.common_article model = new Model.common_article(); BLL.common_article bll = new BLL.common_article(); model.group_id = (int)EnumCollection.article_group.精品微课问题讨论; model.user_id = 0; model.category_id = this.chapter; model.title = Convert.ToString(txttitle.Text); model.subtitle = ""; model.contents = Convert.ToString(txtcontents.Text); model.img_src = ""; model.click = 0; model.upvote = 0; model.status = (int)EnumCollection.examine_status.审核通过; model.add_time = System.DateTime.Now; int id = bll.Add(model); if (id > 0) { #region 保存图片 string[] albumArr = Request.Form.GetValues("hid_photo_name"); if (albumArr != null && albumArr.Length > 0) { for (int i = 0; i < albumArr.Length; i++) { string[] imgArr = albumArr[i].Split('|'); if (imgArr.Length == 3) { var img = new Model.common_albums { group_id = (int)EnumCollection.img_group.精品微课问题讨论图片, rc_type = 0, rc_data_id = id, add_time = DateTime.Now, original_path = imgArr[1], thumb_path = imgArr[2], remark = "" }; new BLL.common_albums().Add(img); } } } #endregion 保存图片 AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加问题讨论信息,主键:" + id); //记录日志 return(true); } else { return(false); } }
private void ShowInfo() { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(" group_id = " + (int)EnumCollection.article_group.关于我们); if (model != null) { this.txttitle.Text = model.title; this.txtcontents.Text = model.contents; } }
private void ShowInfo(int _id) { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(_id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } this.ddlCategory.SelectedValue = model.category_id + ""; this.txtcontents.Text = model.contents; }
private void ShowInfo(int _id) { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(_id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } this.txttitle.Text = model.title; this.txtimg_src.Text = model.img_src; this.txtcontents.Text = model.contents; }
private bool DoEdit(int id) { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(this.id); model.group_id = (int)EnumCollection.article_group.精品微课问题讨论; model.user_id = 0; model.category_id = this.chapter; model.title = Convert.ToString(txttitle.Text); model.contents = Convert.ToString(txtcontents.Text); if (bll.Update(model)) { #region 保存图片 string[] albumArr = Request.Form.GetValues("hid_photo_name"); if (albumArr != null && albumArr.Length > 0) { DBUtility.DbHelperSQL.ExecuteSql("delete ybd_common_albums where rc_guid=" + model.id + " and group_id=" + (int)EnumCollection.img_group.精品微课问题讨论图片);//删除图片 for (int i = 0; i < albumArr.Length; i++) { string[] imgArr = albumArr[i].Split('|'); if (imgArr.Length == 3) { var img = new Model.common_albums { group_id = (int)EnumCollection.img_group.精品微课问题讨论图片, rc_type = 0, rc_data_id = id, add_time = DateTime.Now, original_path = imgArr[1], thumb_path = imgArr[2], remark = "" }; new BLL.common_albums().Add(img); } } } #endregion 保存图片 AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改问题讨论信息,主键:" + model.id); //记录日志 return(true); } else { return(false); } }
private void BindInfo() { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } ddlClassroom.SelectedValue = model.category_id + ""; txttitle.Text = model.title + ""; txtcontents.Text = model.contents + ""; txtimg_src.Text = model.img_src + ""; }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { #region string strError = string.Empty; if (txttitle.Text.Trim() == "" || txttitle.Text.Trim().Length > 200) { strError += "标题为空或超出长度![br]"; } if (txtcontents.Text.Trim() == "" || txtcontents.Text.Trim().Length > 4000) { strError += "内容为空或超出长度![br]"; } if (strError != string.Empty) { JscriptMsg(strError, "", "Error"); return; } #endregion BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(" group_id = " + (int)EnumCollection.article_group.关于我们); if (model != null) { ChkAdminLevel("_about_us", EnumCollection.ActionEnum.Modify.ToString()); //检查权限 if (!DoEdit(model.id)) { JscriptMsg("保存过程中发生错误!", ""); return; } JscriptMsg("修改关于我们成功!", ""); } else { ChkAdminLevel("_about_us", EnumCollection.ActionEnum.Add.ToString()); //检查权限 if (!DoAdd()) { JscriptMsg("保存过程中发生错误!", ""); return; } JscriptMsg("添加关于我们成功!", ""); } }
private void ShowInfo(int _id) { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(_id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txttitle.Text = model.title + ""; txtcontents.Text = model.contents + ""; this.rptAlbumList.DataSource = new BLL.common_albums().GetList(" group_id = " + (int)EnumCollection.img_group.精品微课问题讨论图片 + " and rc_data_id = " + _id); this.rptAlbumList.DataBind(); }
private bool DoEdit(int id) { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(this.id); model.category_id = Convert.ToInt32(ddlCategory.SelectedValue); model.contents = Convert.ToString(txtcontents.Text.Trim()); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改服务项目,主键:" + model.id); //记录日志 return(true); } else { return(false); } }
private bool DoAdd() { Model.common_article model = new Model.common_article(); BLL.common_article bll = new BLL.common_article(); model.group_id = (int)EnumCollection.article_group.课堂公告; if (adminInfo.role_type == 2)//教师 { Model.user_info user = new BLL.user_info().GetModel(" phone = '" + adminInfo.user_name + "' "); model.user_id = user.id; } else if (adminInfo.role_type == 1)//超管 { Model.classroom_info ciModel = new BLL.classroom_info().GetModel(this.class_id); if (ciModel != null) { model.user_id = ciModel.user_id; } } model.category_id = Convert.ToInt32(ddlClassroom.SelectedValue); //model.category_id = this.class_id; model.title = Convert.ToString(txttitle.Text); model.subtitle = ""; model.contents = Convert.ToString(txtcontents.Text); model.img_src = Convert.ToString(txtimg_src.Text); model.click = 0; model.upvote = 0; model.status = 1; 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 Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(" group_id = " + (int)EnumCollection.article_group.务项目 + " and category_id = " + (int)EnumCollection.service_items_category.微课MOOC开发); if (model != null) { str = model.contents; } model = bll.GetModel(" group_id = " + (int)EnumCollection.article_group.务项目 + " and category_id = " + (int)EnumCollection.service_items_category.立体化教材建设); if (model != null) { str1 = model.contents; } model = bll.GetModel(" group_id = " + (int)EnumCollection.article_group.务项目 + " and category_id = " + (int)EnumCollection.service_items_category.智慧教室); if (model != null) { str2 = model.contents; } model = bll.GetModel(" group_id = " + (int)EnumCollection.article_group.微课慕课项目简介 + " and category_id = " + (int)EnumCollection.mooc_item.参赛微课); if (model != null) { str3 = model.contents; } model = bll.GetModel(" group_id = " + (int)EnumCollection.article_group.微课慕课项目简介 + " and category_id = " + (int)EnumCollection.mooc_item.在线开发课程); if (model != null) { str4 = model.contents; } model = bll.GetModel(" group_id = " + (int)EnumCollection.article_group.微课慕课项目简介 + " and category_id = " + (int)EnumCollection.mooc_item.国家级精品课程); if (model != null) { str5 = model.contents; } } }
private bool DoEdit(int id) { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(this.id); model.title = Convert.ToString(txttitle.Text.Trim()); model.contents = Convert.ToString(txtcontents.Text.Trim()); model.img_src = Convert.ToString(txtimg_src.Text.Trim()); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改我们的团队,主键:" + model.id); //记录日志 return(true); } else { return(false); } }
private void BindInfo() { BLL.common_article bll = new BLL.common_article(); Model.common_article model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txtgroup_id.Text = model.group_id + ""; txtuser_id.Text = model.user_id + ""; txtcategory_id.Text = model.category_id + ""; txttitle.Text = model.title + ""; txtsubtitle.Text = model.subtitle + ""; txtcontents.Text = model.contents + ""; txtimg_src.Text = model.img_src + ""; txtclick.Text = model.click + ""; txtupvote.Text = model.upvote + ""; txtstatus.Text = model.status + ""; txtadd_time.Text = model.add_time + ""; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.common_article model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.common_article model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert Into ybd_common_article( group_id ,user_id ,category_id ,title ,subtitle ,contents ,img_src ,click ,upvote ,status ,add_time ) Values ( @group_id ,@user_id ,@category_id ,@title ,@subtitle ,@contents ,@img_src ,@click ,@upvote ,@status ,@add_time ); SELECT @@IDENTITY;"); SqlParameter[] parameters = { new SqlParameter("@group_id", SqlDbType.Int, 4) , new SqlParameter("@user_id", SqlDbType.Int, 4) , new SqlParameter("@category_id", SqlDbType.Int, 4) , new SqlParameter("@title", SqlDbType.NVarChar, 200) , new SqlParameter("@subtitle", SqlDbType.NVarChar, 200) , new SqlParameter("@contents", SqlDbType.NVarChar, 4000) , new SqlParameter("@img_src", SqlDbType.NVarChar, 255) , new SqlParameter("@click", SqlDbType.Int, 4) , new SqlParameter("@upvote", SqlDbType.Int, 4) , new SqlParameter("@status", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.group_id; parameters[1].Value = model.user_id; parameters[2].Value = model.category_id; parameters[3].Value = model.title; parameters[4].Value = model.subtitle; parameters[5].Value = model.contents; parameters[6].Value = model.img_src; parameters[7].Value = model.click; parameters[8].Value = model.upvote; parameters[9].Value = model.status; parameters[10].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_common_article", EnumCollection.ActionEnum.Add.ToString()); //检查权限 #region string strError = string.Empty; if (txtgroup_id.Text.Trim() == "" || txtgroup_id.Text.Trim().Length > 4) { strError += "分组为空或超出长度![br]"; } if (txtuser_id.Text.Trim() == "" || txtuser_id.Text.Trim().Length > 4) { strError += "发布者id为空或超出长度![br]"; } if (txtcategory_id.Text.Trim() == "" || txtcategory_id.Text.Trim().Length > 4) { strError += "分类id为空或超出长度![br]"; } if (txttitle.Text.Trim() == "" || txttitle.Text.Trim().Length > 200) { strError += "标题为空或超出长度![br]"; } if (txtsubtitle.Text.Trim() == "" || txtsubtitle.Text.Trim().Length > 200) { strError += "副标题为空或超出长度![br]"; } if (txtcontents.Text.Trim() == "" || txtcontents.Text.Trim().Length > 4000) { strError += "内容为空或超出长度![br]"; } if (txtimg_src.Text.Trim() == "" || txtimg_src.Text.Trim().Length > 255) { strError += "封面图为空或超出长度![br]"; } if (txtclick.Text.Trim() == "" || txtclick.Text.Trim().Length > 4) { strError += "点击量为空或超出长度![br]"; } if (txtupvote.Text.Trim() == "" || txtupvote.Text.Trim().Length > 4) { strError += "点赞数为空或超出长度![br]"; } if (txtstatus.Text.Trim() == "" || txtstatus.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_article model = new Model.common_article(); BLL.common_article bll = new BLL.common_article(); model.group_id = Convert.ToInt32(txtgroup_id.Text); model.user_id = Convert.ToInt32(txtuser_id.Text); model.category_id = Convert.ToInt32(txtcategory_id.Text); model.title = Convert.ToString(txttitle.Text); model.subtitle = Convert.ToString(txtsubtitle.Text); model.contents = Convert.ToString(txtcontents.Text); model.img_src = Convert.ToString(txtimg_src.Text); model.click = Convert.ToInt32(txtclick.Text); model.upvote = Convert.ToInt32(txtupvote.Text); model.status = Convert.ToInt32(txtstatus.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("保存过程中发生错误!", ""); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.common_article model) { return(dal.Add(model)); }