public string DeleteData(string userId, string mId,string mFlag) { try { string result = "操作失败!"; B_OA_NewsService _En = new B_OA_NewsService(); _En.Condition.Add("id = " + mId); _En = Utility.Database.QueryObject<B_OA_NewsService>(_En); if (null != _En) { _En.flag = int.Parse(mFlag); _En.Condition.Add("id = " + mId); if (Utility.Database.Update<B_OA_NewsService>(_En) > 0) { result = "操作成功!"; } } return result; } catch (Exception e) { return "操作失败!msg: " + e.Message; } }
public string GetData(string userId, string mId) { try { B_OA_NewsData data = new B_OA_NewsData(); data.lst_CommandType = new List<Para_CommType>(); List<Para_CommType> lstCommandType = CommonClass.GetCommType("News"); if (lstCommandType != null && lstCommandType.Count > 0) { if (userId == "U000008") { data.lst_CommandType = lstCommandType; } else { List<Privilege> listPrivilege = IWorkFlow.BaseService.IWorkPrivilegeManage.QueryPrivilegebyUserID(userId).FindAll(g => g.Type == "维护权限集"); if (listPrivilege != null && listPrivilege.Count > 0) { foreach (var item in listPrivilege) { if (item.ModelKey.IndexOf("Edit") > 0) { string type = item.ModelKey.Substring(item.ModelKey.IndexOf("Edit") + 4, 2); data.lst_CommandType.Add(lstCommandType.Where(p => p.id == int.Parse(type)).FirstOrDefault()); } } } } } B_OA_NewsService _En = new B_OA_NewsService(); _En.Condition.Add("id = " + mId); _En = Utility.Database.QueryObject<B_OA_NewsService>(_En); if (_En == null) { _En = new B_OA_NewsService(); _En.userID = userId; UserSelect us = CommonClass.GetUserSelect(userId); if (us != null) _En.author = us.CnName; _En.dateTime = DateTime.Now; } data._entity_B_OA_News = _En; return JsonConvert.SerializeObject(data); } catch (Exception e) { // throw new Exception("数据加载失败! ERR:" + e.Message); return "ERR:数据加载失败!msg: " + e.Message; } }
public string GetNewsListForiPad(string userid, string type, string pages) { try { B_OA_NewsService ent = new B_OA_NewsService(); ent.Condition.Add(" (flag=0 or flag is null)"); if (!string.IsNullOrEmpty(type) && int.Parse(type) > 0) { ent.Condition.Add(" and type=" + int.Parse(type)); } ent.OrderInfo = " addDate desc"; List<B_OA_NewsService> list = Utility.Database.QueryList<B_OA_NewsService>(ent); if (!string.IsNullOrEmpty(pages) && int.Parse(pages) > 0) { list = list.Take(int.Parse(pages)).ToList(); } var data = from p in list select new { id = p.id, title = p.title, openurl = p.openurl, addDate = p.addDate, }; return JsonConvert.SerializeObject(data); } catch (Exception e) { return Utility.JsonMsg(true, e.Message); } }
public string GetListAll(string userid) { try { B_OA_NewsService en = new B_OA_NewsService(); en.Condition.Add(" (flag=0 or flag is null)"); // List<Privilege> listPrivilege = PrivilegeManageService.GetListPrivilegeType(userid, "维护权限集"); List<Privilege> listPrivilege = PrivilegeManageService.Instance.GetListPrivilegeType(userid, "维护权限集"); if (userid !="U000008" && listPrivilege != null && listPrivilege.Count > 0) { string str = " and (1>1 "; foreach (var item in listPrivilege) { if (item.ModelKey.IndexOf("Edit") > 0) { string type = item.ModelKey.Substring(item.ModelKey.IndexOf("Edit") + 4, 2); if (!string.IsNullOrEmpty(type) && int.Parse(type) > 0) { str += " or type=" + int.Parse(type); //en.Condition.Add(" or type=" + int.Parse(type)); } } } str += ")"; en.Condition.Add(str); } en.OrderInfo = "dateTime desc"; List<B_OA_NewsService> data = Utility.Database.QueryList<B_OA_NewsService>(en); var ad = from p in data select new { id = p.id, title = p.title, openurl = p.openurl, author = p.author, dateTime = p.dateTime, type = p.type, source = p.source, typeName = CommonClass.GetCommTypeName(p.type), flagName = p.flag == 1 ? "未发布" : "已发布" }; return JsonConvert.SerializeObject(ad); } catch (Exception e) { return Utility.JsonMsg(true, e.Message); } }