/// <summary> /// 添加文章 /// </summary> /// <param name="notify">文章的一个对象</param> public void AddNotifyInfo(AdminNotifyInfo notify) { try { string sql = "INSERT INTO usta_AdminNotifyInfo(notifyTitle,notifyContent,notifyTypeId,attachmentIds) VALUES(@notifyTitle,@notifyContent,@notifyTypeId,@attachmentIds)"; SqlParameter[] parameters = { new SqlParameter("@notifyTitle", SqlDbType.NChar,50), new SqlParameter("@notifyContent", SqlDbType.NText), new SqlParameter("@notifyTypeId", SqlDbType.Int,4), new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200) }; parameters[0].Value = notify.notifyTitle; parameters[1].Value = notify.notifyContent; parameters[2].Value = notify.notifyTypeId; parameters[3].Value = notify.attachmentIds; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
//第1个标签:结束 protected void btnAdd_Click(object sender, EventArgs e) { if (ddlNotifyTypeChild.Items.Count == 0) { Javascript.GoHistory(-1, "请选择“" + ddlNotifyType.SelectedItem.Text + "”下的二级分类\n若无二级分类,请在文章类别管理页面添加相应地的二级分类", Page); return; } if (txtTitle.Text.Trim().Length == 0 || Textarea1.Value.Trim().Length == 0) { Javascript.GoHistory(-1, "标题和内容不能为空,请输入!", Page); } else { DalOperationAboutAdminNotify doan = new DalOperationAboutAdminNotify(); AdminNotifyInfo notify = new AdminNotifyInfo(); notify.notifyTitle = txtTitle.Text.Trim(); notify.notifyContent = Textarea1.Value.Trim(); notify.notifyTypeId = int.Parse(ddlNotifyTypeChild.SelectedValue); //以下提交附件的判断与相关操作 if (hidAttachmentId.Value.CompareTo(string.Empty) != 0) { notify.attachmentIds = hidAttachmentId.Value;//保存了附件并且返回了attachmentId(自增长类型主键) } try { doan.AddNotifyInfo(notify);//保存通知 //Javascript.ExcuteJavascriptCode("delBeforeUnloadEvent();", Page); Javascript.AlertAndRedirect("添加成功!", "/Common/NotifyList.aspx", Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); //Javascript.ExcuteJavascriptCode("delBeforeUnloadEvent();", Page); Javascript.GoHistory(-1, "添加失败,请检查格式是否有误!", Page); } } }
/// <summary> /// 查询文章 /// </summary> /// <param name="notityId"> 文章主键</param> /// <returns>一个文章对象</returns> public AdminNotifyInfo FindNotifyByNo(int notityId) { AdminNotifyInfo notify = null; string sql = "SELECT [adminNotifyInfoId],[notifyTitle] ,[notifyContent] ,[notifyTypeId],[updateTime] ,[attachmentIds] ,[isTop],[scanCount] FROM [USTA].[dbo].[usta_AdminNotifyInfo] WHERE adminNotifyInfoId=@adminNotifyInfoId"; SqlParameter[] parameters = new SqlParameter[1]{ new SqlParameter("@adminNotifyInfoId",notityId) }; SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql,parameters); while (dr.Read()) { notify = new AdminNotifyInfo(); notify.adminNotifyInfoIds = dr["adminNotifyInfoId"].ToString(); notify.notifyTitle = dr["notifyTitle"].ToString().Trim(); notify.notifyContent = dr["notifyContent"].ToString().Trim(); notify.notifyTypeId = int.Parse(dr["notifyTypeId"].ToString()); notify.updateTime = DateTime.Parse(dr["updateTime"].ToString()); notify.attachmentIds = dr["attachmentIds"].ToString(); notify.isTop = int.Parse(dr["isTop"].ToString()); notify.scanCount = int.Parse(dr["scanCount"].ToString()); } dr.Close(); conn.Close(); return notify; }
/// <summary> /// 修改文章 /// </summary> /// <param name="notify">文章实体</param> public void UpdateNotifyInfo(AdminNotifyInfo notify) { try { string sql = "UPDATE usta_AdminNotifyInfo SET notifyTypeId=@notifyTypeId, notifyTitle=@notifyTitle, notifyContent=@notifyContent, attachmentIds=@attachmentIds, updateTime=@updateTime WHERE adminNotifyInfoId=@adminNotifyInfoId"; SqlParameter[] parameters = { new SqlParameter("@adminNotifyInfoId", SqlDbType.Int,4), new SqlParameter("@notifyTitle", SqlDbType.NChar,50), new SqlParameter("@notifyContent", SqlDbType.NText), new SqlParameter("@notifyTypeId", SqlDbType.Int,4), new SqlParameter("@updateTime", SqlDbType.DateTime), new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200)}; parameters[0].Value = notify.adminNotifyInfoIds; parameters[1].Value = notify.notifyTitle; parameters[2].Value = notify.notifyContent; parameters[3].Value = notify.notifyTypeId; parameters[4].Value = notify.updateTime; parameters[5].Value = notify.attachmentIds; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
//修改 protected void btnUpdate_Click(object sender, EventArgs e) { if (ddlNotifyTypeChild.Items.Count == 0) { Javascript.GoHistory(-1, "请选择“" + ddlNotifyType.SelectedItem.Text + "”下的二级分类\n若无二级分类,请在文章类别管理页面添加相应地的二级分类", Page); return; } if (txtTitle.Text.Trim().Length == 0 || this.Textarea1.Value.Trim().Length == 0) { Javascript.GoHistory(-1, "标题和内容不能为空,请输入!", Page); } else { DalOperationAboutAdminNotify doan = new DalOperationAboutAdminNotify(); AdminNotifyInfo notify = new AdminNotifyInfo(); notify.adminNotifyInfoIds = notifyId.ToString(); notify.notifyTitle = txtTitle.Text.Trim(); notify.notifyContent = this.Textarea1.Value.Trim(); notify.notifyTypeId = int.Parse(ddlNotifyTypeChild.SelectedValue.ToString().Trim()); notify.attachmentIds = hidAttachmentId.Value; notify.updateTime = DateTime.Now; try { doan.UpdateNotifyInfo(notify);//修改 Javascript.RefreshParentWindow("修改成功!", "/Administrator/NotifyInfoManage.aspx", Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "修改失败,请检查格式是否有误!", Page); } } }