//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);
}
