//public NotesController(INotesManager notesManager) //{ // _notesManager = notesManager; //} public ActionResult EditNotes(int noteID) { ViewBag.noteID = noteID; ViewBag.NoteSortList = _notesManager.GetNotesSortList(" isDelete=0 AND Type=0 "); var note = _notesManager.GetNoteById(noteID); if (note == null) { note = new Sys_Notes(); } return(View(note)); }
public ActionResult NotesManageDetail(int noteID, int flag = 0) { ViewBag.noteID = noteID; ViewBag.flag = flag; string sqlwhere = string.Format(@" NoteId={0}", noteID); Sys_Notes model = _notesManager.GetListNotes(sqlwhere).FirstOrDefault(); if (model != null) { ViewBag.NoteSort = _notesManager.GetNotesSortList(" isDelete=0 AND Type=0 AND Id=" + model.SortID).FirstOrDefault(); } return(View("NotesDetail")); }
/// <summary> /// 增加政策 /// </summary> /// <param name="model"></param> public void AddNote(Sys_Notes model) { using (IDbConnection conn = OpenConnection()) { string sql = @"INSERT INTO Sys_Notes ( NoteTitle, NoteContent, SortID, UserId, CreateTime, publishflag, publishtime, IsDelete, Type, AdFlag, Num ) VALUES ( @notetitle, @notecontent, @SortID, @userid, @createtime, 0, @publishtime, 0, @Type, @AdFlag, 0 ) SELECT @@IDENTITY as id"; var param = new { notetitle = model.NoteTitle, notecontent = model.NoteContent, SortID = model.SortID, userid = model.UserId, createtime = DateTime.Now, publishtime = model.publishtime, Type = model.Type, AdFlag = model.AdFlag }; decimal id = conn.Query <decimal>(sql, param).FirstOrDefault(); model.NoteId = decimal.ToInt32(id); } }
public JsonResult submitEditNote(string title, string content, int noteID, int SortID, int AdFlag = 0, int type = 0, string deleteID = "") { try { var model = new Sys_Notes() { NoteTitle = title, NoteContent = content, UserId = CurrentUser.UserId, publishflag = 0, IsDelete = 0, NoteId = noteID, SortID = SortID, Type = type, AdFlag = AdFlag }; if (noteID > 0) { noteBL.updateNote(model); //删除附件 if (deleteID != "") { sys_noteresourceBL.DeleteNoteResource(deleteID); } } else { noteBL.AddNote(model); } return(Json(new { result = 1, Id = model.NoteId, content = "添加成功" }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { result = 0, content = "添加失败" }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 更新政策 /// </summary> /// <param name="model"></param> public void updateNote(Sys_Notes model) { using (IDbConnection conn = OpenConnection()) { string sql = @" UPDATE Sys_Notes SET NoteTitle = @notetitle, NoteContent = @notecontent,SortID=@SortID,AdFlag=@AdFlag WHERE NoteId = @noteid" ; var param = new { notetitle = model.NoteTitle, notecontent = model.NoteContent, SortID = model.SortID, noteid = model.NoteId, AdFlag = model.AdFlag }; conn.Execute(sql, param); } }
/// <summary> /// 获取单个的通知公告 /// </summary> /// <param name="noteID"></param> /// <returns></returns> public JsonResult GetSingeNotes(int noteID) { try { string sqlwhere = string.Format(@" NoteId={0}", noteID); List <Sys_Notes> list = _notesManager.GetListNotes(sqlwhere); Sys_Notes model = list.Count > 0 ? list[0] : new Sys_Notes(); List <Sys_NotesResource> NoteResource = _notesManager.GetNotesResourceNote(" NoteId=" + noteID); string html = ""; foreach (Sys_NotesResource item in NoteResource) { html += "<p>"; html += "<span title='" + item.FileName + "'>" + item.FileName + "</span> "; html += "<a href='" + Url.Addr(_noteResourceUrl + item.RealName) + "' target='_Blank' class='icon idown' title='" + NoteLanguage.Download + "'></a>"; html += "</p>"; } return(Json(new { result = 1, model.SortID, content = model.NoteContent, title = model.NoteTitle, date = model.publishtimeStr, model.AdFlag, model.DepTrainFlag, html }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { result = 0, content = "", id = "" }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 查询结果集转化为对象 /// </summary> /// <param name="tempsql"></param> /// <param name="sps"></param> /// <returns></returns> public IList <Sys_Notes> ItemsListMaker(string tempsql, SqlParameter[] sps) { DataTable dt = DataHelper.GetDataTable(tempsql, sps, false); IList <Sys_Notes> list = new List <Sys_Notes>(); foreach (DataRow dr in dt.Rows) { Sys_Notes model = new Sys_Notes(); model.sysCode = dr["sysCode"].ToString(); model.note6 = dr["note6"].ToString(); model.note7 = dr["note7"].ToString(); model.note8 = dr["note8"].ToString(); model.note9 = dr["note9"].ToString(); model.note10 = dr["note10"].ToString(); model.note11 = dr["note11"].ToString(); model.note12 = dr["note12"].ToString(); model.note13 = dr["note13"].ToString(); model.note14 = dr["note14"].ToString(); model.note15 = dr["note15"].ToString(); model.beforestr = dr["beforestr"].ToString(); model.note16 = dr["note16"].ToString(); model.note17 = dr["note17"].ToString(); model.note18 = dr["note18"].ToString(); model.note19 = dr["note19"].ToString(); model.note20 = dr["note20"].ToString(); model.afterstr = dr["afterstr"].ToString(); model.edittype = dr["edittype"].ToString(); model.note1 = dr["note1"].ToString(); model.note2 = dr["note2"].ToString(); model.note3 = dr["note3"].ToString(); model.note4 = dr["note4"].ToString(); model.note5 = dr["note5"].ToString(); list.Add(model); } return(list); }
/// <summary> /// 获取单据子表对象字符串 /// </summary> /// <param name="mainCode">日志主表主键 guid</param> /// <param name="lstItem">单据子表集合</param> /// <returns>子表对象键值对字符串</returns> private List <Sys_Notes> ItemListMaker(string mainCode, List <object> lstItem) { List <Sys_Notes> resultList = new List <Sys_Notes>(); foreach (List <object> item in lstItem) { foreach (object i in item) { Type tItem = i.GetType(); System.Reflection.PropertyInfo[] arrTemp = tItem.GetProperties(); Sys_Notes temp = new Sys_Notes(); temp.sysCode = mainCode; StringBuilder sbItemTemp = new StringBuilder(); sbItemTemp.Append(","); for (int m = 0; m < arrTemp.Length; m++) { string key = Convert.ToString(arrTemp[m].Name); object value = arrTemp[m].GetValue(tItem, null); sbItemTemp.Append(key + ":" + (string)value + ","); } string result = sbItemTemp.ToString(); if (result.Length > 1) { result = result.Substring(0, result.Length - 1); } else { result = ""; } temp.afterstr = result; resultList.Add(temp); } } return(resultList); }
/// <summary> /// 更新政策 /// </summary> /// <param name="model"></param> public void UpdateNotes(Sys_Notes model) { _dataAccess.UpdateEntity(model); }
/// <summary> /// 增加政策 /// </summary> /// <param name="model"></param> public void AddNotes(Sys_Notes model) { _dataAccess.AddEntity(model); }
/// <summary> /// 更新政策 /// </summary> /// <param name="model"></param> public void updateNote(Sys_Notes model) { noteDB.updateNote(model); }
/// <summary> /// 增加政策 /// </summary> /// <param name="model"></param> public void AddNote(Sys_Notes model) { noteDB.AddNote(model); }
public JsonResult submitEditNotes(string title, string content, int noteID, int SortID, string imgUrl, int AdFlag = 0, int DepTrainFlag = 0, int type = 0, string deleteID = "", int publish = 0) { try { var model = new Sys_Notes() { NoteTitle = title, NoteContent = content, UserId = CurrentUser.UserId, publishflag = 0, IsDelete = 0, NoteId = noteID, SortID = SortID, Type = type, AdFlag = AdFlag, DepTrainFlag = DepTrainFlag, TenantId = CurrentTenant.TenantId, publishtime = null, CreateTime = DateTime.Now }; if (publish == 1) { model.publishtime = DateTime.Now; model.publishflag = 1; } if (Request.Files.Count > 0) { model.ImageUrl = SaveFile(Request.Files[0]); } else if (!string.IsNullOrEmpty(imgUrl)) { model.ImageUrl = imgUrl; } if (noteID > 0) { _notesManager.UpdateNotes(model); //删除附件 if (deleteID != "") { _notesManager.DeleteNotesResource(deleteID.GetArray()); } } else { _notesManager.AddNotes(model); } return(Json(new { result = 1, Id = model.NoteId, content = RetechWing.LanguageResources.Common.SaveSuccess + RetechWing.LanguageResources.Common.ExclamationMark }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { result = 0, content = RetechWing.LanguageResources.Common.SaveFailed + RetechWing.LanguageResources.Common.ExclamationMark }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 增加子表 /// </summary> public void AddItem(Sys_Notes model, SqlTransaction tran) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Notes("); strSql.Append("sysCode,note6,note7,note8,note9,note10,note11,note12,note13,note14,note15,beforestr,note16,note17,note18,note19,note20,afterstr,edittype,note1,note2,note3,note4,note5"); strSql.Append(") values ("); strSql.Append("@sysCode,@note6,@note7,@note8,@note9,@note10,@note11,@note12,@note13,@note14,@note15,@beforestr,@note16,@note17,@note18,@note19,@note20,@afterstr,@edittype,@note1,@note2,@note3,@note4,@note5"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@sysCode", SqlDbType.VarChar, 50), new SqlParameter("@note6", SqlDbType.VarChar, 100), new SqlParameter("@note7", SqlDbType.VarChar, 100), new SqlParameter("@note8", SqlDbType.VarChar, 100), new SqlParameter("@note9", SqlDbType.VarChar, 100), new SqlParameter("@note10", SqlDbType.VarChar, 100), new SqlParameter("@note11", SqlDbType.VarChar, 100), new SqlParameter("@note12", SqlDbType.VarChar, 100), new SqlParameter("@note13", SqlDbType.VarChar, 100), new SqlParameter("@note14", SqlDbType.VarChar, 100), new SqlParameter("@note15", SqlDbType.VarChar, 100), new SqlParameter("@beforestr", SqlDbType.Text), new SqlParameter("@note16", SqlDbType.VarChar, 100), new SqlParameter("@note17", SqlDbType.VarChar, 100), new SqlParameter("@note18", SqlDbType.VarChar, 100), new SqlParameter("@note19", SqlDbType.VarChar, 100), new SqlParameter("@note20", SqlDbType.VarChar, 100), new SqlParameter("@afterstr", SqlDbType.Text), new SqlParameter("@edittype", SqlDbType.VarChar, 50), new SqlParameter("@note1", SqlDbType.VarChar, 100), new SqlParameter("@note2", SqlDbType.VarChar, 100), new SqlParameter("@note3", SqlDbType.VarChar, 100), new SqlParameter("@note4", SqlDbType.VarChar, 100), new SqlParameter("@note5", SqlDbType.VarChar, 100) }; parameters[0].Value = SqlNull(model.sysCode); parameters[1].Value = SqlNull(model.note6); parameters[2].Value = SqlNull(model.note7); parameters[3].Value = SqlNull(model.note8); parameters[4].Value = SqlNull(model.note9); parameters[5].Value = SqlNull(model.note10); parameters[6].Value = SqlNull(model.note11); parameters[7].Value = SqlNull(model.note12); parameters[8].Value = SqlNull(model.note13); parameters[9].Value = SqlNull(model.note14); parameters[10].Value = SqlNull(model.note15); parameters[11].Value = SqlNull(model.beforestr); parameters[12].Value = SqlNull(model.note16); parameters[13].Value = SqlNull(model.note17); parameters[14].Value = SqlNull(model.note18); parameters[15].Value = SqlNull(model.note19); parameters[16].Value = SqlNull(model.note20); parameters[17].Value = SqlNull(model.afterstr); parameters[18].Value = SqlNull(model.edittype); parameters[19].Value = SqlNull(model.note1); parameters[20].Value = SqlNull(model.note2); parameters[21].Value = SqlNull(model.note3); parameters[22].Value = SqlNull(model.note4); parameters[23].Value = SqlNull(model.note5); DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false); }