/// <summary> /// 插入Z_Role_Menu /// </summary> /// <param name="role_id">角色ID</param> /// <param name="menus">菜单code串</param> /// <returns></returns> public bool Update_Menus(string role_id, string menus) { try { using (JSZX_ResourceEntities db = new JSZX_ResourceEntities()) { var list = ( from t in db.Z_Role_Menu where t.Role_ID == role_id select t ).ToList(); for (int i = 0; i < list.Count; i++) { db.Z_Role_Menu.Remove(list[i]); } db.SaveChanges(); } return(Insert_Menus(role_id, menus)); } catch (Exception ex) { return(false); } }
/// <summary> /// 更新Z_Role /// </summary> /// <param name="id">角色ID</param> /// <param name="title">角色名称</param> /// <param name="remark">描述</param> /// <returns></returns> public bool Update_Role(string id, string title, string remark) { try { using (JSZX_ResourceEntities db = new JSZX_ResourceEntities()) { var list = ( from t in db.Z_Role where t.ID == id select t ).Take(1).ToList(); if (list != null && list.Count > 0) { var it = list.First(); it.Title = title; it.Remark = remark; it.EditMan = ""; it.EditDate = DateTime.Now; it.Version = Parameters.Version; db.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }
/// <summary> /// 获得凭证 /// </summary> /// <param name="Account"></param> /// <param name="guid"></param> /// <param name="pLoginReturn"></param> /// <returns></returns> public bool Verification(string Account, string guid, out LoginReturn pLoginReturn) { pLoginReturn = new LoginReturn(); try { using (JSZX_ResourceEntities db = new JSZX_ResourceEntities()) { var rls = (from t in db.Z_User where t.ID == Account select t).Take(1).ToList(); if (rls.Count > 0) { var pl = rls.First(); #region /*给返回类 赋值 start*/ //ID pLoginReturn.ID = pl.ID; //姓名 pLoginReturn.Name = pl.Name; //权限ID pLoginReturn.Role_ID = pl.PageRole_ID; //类型 pLoginReturn.Type = pl.Type; pLoginReturn.DataRole = pl.DataRole; #endregion return(true); } } } catch (Exception ex) { string s = ex.Message; } return(false); }
/// <summary> /// 插入Z_Role /// </summary> /// <param name="id">角色ID</param> /// <param name="title">角色名称</param> /// <param name="remark">描述</param> /// <returns></returns> public bool Insert_Role(ref string id, string title, string remark) { try { using (JSZX_ResourceEntities db = new JSZX_ResourceEntities()) { id = Guid.NewGuid().ToString(); Z_Role it = new Z_Role(); it.ID = id; it.Title = title; it.Remark = remark; it.Del = false; it.EditMan = ""; it.EditDate = DateTime.Now; it.Version = Parameters.Version; db.Z_Role.Add(it); db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
/**获取新的版本号**/ public int GetVersionNum(JSZX_ResourceEntities db, string AId) { List <string> OidArr = new List <string>(); GetVersion(db, AId, ref OidArr); return(OidArr.Count + 1); }
/// <summary> /// /// </summary> /// <param name="res_type"></param> /// <param name="db"></param> /// <returns></returns> public List <T_Resource> GetResourceList(string res_type, JSZX_ResourceEntities db) { List <T_Resource> rlt = null; var query = from t in db.T_Resource select t; if (!string.IsNullOrEmpty(res_type)) { query = query.Where(t => t.TYPE_ID.Contains(res_type)); } //审核状态:通过(1) query = query.Where(t => t.STATUS.Contains("1")); //删除状态:未删除(0) query = query.Where(t => t.DEL_FLG.Contains("0")); //公开状态:公开(1) query = query.Where(t => t.SHARE_FLG.Contains("1")); int a = query.Count(); query = query.OrderByDescending((t => t.CREATETIME)); rlt = query.ToList(); DateTime dt = DateTime.Now.AddHours(0); //缓存6小时 System.Web.HttpRuntime.Cache.Insert("T_Resource", rlt, null, dt, System.Web.Caching.Cache.NoSlidingExpiration); return(rlt); }
/**根据资源附件ID获取之前所有的版本ID**/ private void GetVersion(JSZX_ResourceEntities db, string Aid, ref List <VersionModel> VersionList) { try { var query = from t in db.V_Version select t; query = query.Where(t => t.NID == Aid); query = query.OrderByDescending(t => t.CreateTime); List <V_Version> models = query.ToList(); if (models != null && models.Count > 0) { foreach (V_Version model in models) { VersionModel vModel = new VersionModel(); vModel.ID = model.OID; vModel.Name = model.FileName; vModel.Version = model.VERSION_NUM; vModel.DtTime = model.CreateTime; VersionList.Add(vModel); GetVersion(db, model.OID, ref VersionList); } } else { return; } } catch (Exception) { return; } }
/// <summary> /// 保存评价 /// </summary> /// <param name="rm">评价信息</param> /// <param name="db"></param> /// <returns></returns> public bool insertScore(ResourceModel rm, JSZX_ResourceEntities db) { try { T_Res_Score score = new T_Res_Score(); score.ID = Guid.NewGuid().ToString(); score.RES_ID = rm.Id; score.APPEND_ID = rm.AppId; score.GRADE = Convert.ToDecimal(rm.Grade); score.REVIEW = rm.Review; score.CREATEID = rm.UserId; score.CREATETIME = DateTime.Now; db.T_Res_Score.Add(score); AddReviewNum(rm.Id, rm.AppId, Convert.ToDouble(rm.Grade), rm.UserId, db); db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "insertScore", ex.Message); return(false); } }
/// <summary> /// 查询分类有无被使用 /// </summary> /// <param name="typeId"></param> /// <returns></returns> public Boolean TypeIsUsed(string typeId) { bool ret = false; try { if (!string.IsNullOrEmpty(typeId)) { using (JSZX_ResourceEntities db = new JSZX_ResourceEntities()) { string typeStr = GetTypeCondition(db, typeId); var query = from t in db.T_Resource select t; query = query.Where(t => typeStr.Contains(t.TYPE_ID)); query = query.Where(t => t.DEL_FLG == "0");//只需要判断没有被删除的资源当中,有没有使用该分类 if (query.Count() > 0) { ret = true; } } } else { ret = true; } } catch (Exception ex) { clsLog.ErrorLog("Resource", "TypeIsUsed", "Error! " + ex.Message); } return(ret); }
/// <summary> /// 删除资源 /// </summary> /// <param name="id">资源ID</param> /// <param name="db"></param> /// <returns></returns> public bool deleteResource(string id, string userId, JSZX_ResourceEntities db) { try { T_Resource tr = db.T_Resource.First(t => t.ID == id); tr.DEL_FLG = "1"; tr.MODIFYID = userId; tr.MODIFYTIME = DateTime.Now; List <T_Res_Appendix> list = db.T_Res_Appendix.Where(t => t.RES_ID == id).ToList(); if (list != null) { foreach (T_Res_Appendix item in list) { item.DEL_FLG = "1"; item.MODIFYID = userId; item.MODIFYTIME = DateTime.Now; } } db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "deleteResource", ex.Message); return(false); } }
/// <summary> /// 获取资源分类 /// </summary> /// <param name="db"></param> /// <returns></returns> public List <ComboTreeModels> GetResTypeList(string type, JSZX_ResourceEntities db) { List <T_Res_Type> list = new List <T_Res_Type>(); var query = from t in db.T_Res_Type orderby t.BELONG_ID, t.ID select t; query = query.OrderBy(t => t.CREATETIME); list = query.ToList(); List <ComboTreeModels> treeList = new List <ComboTreeModels>(); if (list != null && list.Count > 0) { ReturnTreeList(list, null, 1, ref treeList); if (type == "combox") { ComboTreeModels tree1 = new ComboTreeModels(); tree1.id = ""; tree1.text = ""; tree1.belong = ""; treeList.Insert(0, tree1); } } return(treeList); }
/// <summary> /// 新建分类 /// </summary> /// <param name="type">分类名</param> /// <param name="father">分类名</param> /// <param name="userId">用户</param> /// <param name="db"></param> /// <returns></returns> public bool insertResType(string type, string father, string userId, JSZX_ResourceEntities db) { try { T_Res_Type rt = new T_Res_Type(); rt.ID = Guid.NewGuid().ToString(); if (father != "-1") { rt.BELONG_ID = father; } rt.NAME = type; rt.CREATEID = userId; rt.CREATETIME = DateTime.Now; db.T_Res_Type.Add(rt); db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "insertResType", ex.Message); return(false); } }
/// <summary> /// 前台管理 获取精品资源 /// </summary> /// <param name="db"></param> /// <returns></returns> public List <View_Res_Appendix> GetExcellentAppendix(string typeFlag, JSZX_ResourceEntities db) { List <View_Res_Appendix> list = new List <View_Res_Appendix>(); DateTime dt = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); var query = from t in db.View_Res_Appendix where t.EXCELLENT_FLG == "1" && t.STATUS == "1" && t.DEL_FLG == "0" && t.APP_DEl_FLG == "0" && typeFlag.Contains(t.TYPE_FLG) && (t.IS_FOREVER == true || (t.IS_FOREVER == false && t.ACTIVE_TIME_START <= dt && t.ACTIVE_TIME_END >= dt)) select t; query = query.OrderByDescending(t => t.UPLOAD_TIME); if (typeFlag == "1") { list = query.Take(Constant.HOME_VIDEO_NUMBER).ToList(); } else { list = query.Take(Constant.HOME_DOC_NUMBER).ToList(); } return(list); }
/// <summary> /// 更新资源信息 /// </summary> /// <param name="rm">资源信息</param> /// <param name="db"></param> /// <returns></returns> public bool updateResource(ResourceModel rm, JSZX_ResourceEntities db) { try { T_Resource tr = db.T_Resource.First(t => t.ID == rm.Id); tr.NAME = rm.Name; tr.TYPE_ID = rm.TypeId; tr.INTRODUCTION = rm.Introduction; tr.STATUS = "0"; tr.LABEL = rm.Label; tr.NOTE = rm.Note; tr.MODIFYID = rm.UserId; tr.MODIFYTIME = DateTime.Now; doAppendix(rm, db); db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "updateResource", ex.Message); return(false); } }
/**根据资源附件ID获取之前所有的版本ID**/ private void GetVersion(JSZX_ResourceEntities db, string Aid, ref List <string> OidArr) { try { var query = from t in db.T_Version select t; query = query.Where(t => t.NID == Aid); query = query.OrderByDescending(t => t.CreateTime); List <T_Version> models = query.ToList(); if (models != null && models.Count > 0) { foreach (T_Version model in models) { OidArr.Add(model.OID); GetVersion(db, model.OID, ref OidArr); } } else { return; } } catch (Exception) { return; } }
/// <summary> /// 插入Z_Role_Menu /// </summary> /// <param name="role_id">角色ID</param> /// <param name="menus">菜单code串</param> /// <returns></returns> public bool Insert_Menus(string role_id, string menus) { try { using (JSZX_ResourceEntities db = new JSZX_ResourceEntities()) { string[] codes = menus.Split(','); for (int i = 0; i < codes.Length; i++) { if (codes[i] != "") { Z_Role_Menu it = new Z_Role_Menu(); it.Role_ID = role_id; it.Menu_Code = codes[i]; it.Del = false; it.EditMan = ""; it.EditDate = DateTime.Now; it.Version = Parameters.Version; db.Z_Role_Menu.Add(it); } } db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
/// <summary> /// 根据分类获取附件总件数 /// </summary> /// <param name="typeId">分类id</param> /// <param name="db"></param> /// <returns></returns> public int GetFileSizeByTypeId(string typeId, string like, JSZX_ResourceEntities db) { DateTime dt = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); string typeStr = GetTypeCondition(db, typeId); var query = from t in db.AppendixByLike(like, dt) where typeStr.Contains(t.TYPE_ID) select t; return(query.Count()); }
/// <summary> /// 获取资源评分 /// </summary> /// <param name="id">资源ID</param> /// <param name="db"></param> /// <returns>资源评分信息</returns> public List <View_Score> GetResourceScoreGrade(string id, JSZX_ResourceEntities db) { List <View_Score> list = null; var query = from t in db.View_Score where t.RES_ID == id select t; list = query.ToList(); return(list); }
/// <summary> /// 获取附件信息 /// </summary> /// <param name="id">资源ID</param> /// <param name="db"></param> /// <returns>附件信息</returns> public List <T_Res_Appendix> GetAppendixList(string id, JSZX_ResourceEntities db) { List <T_Res_Appendix> list = new List <T_Res_Appendix>(); var query = from t in db.T_Res_Appendix where t.DEL_FLG == "0" && t.RES_ID == id select t; list = query.ToList(); return(list); }
/// <summary> /// 获取资源提问信息 /// </summary> /// <param name="id">资源ID</param> /// <param name="db"></param> /// <returns>提问信息</returns> public List <View_Qa> GetResQa(string id, JSZX_ResourceEntities db) { List <View_Qa> list = null; var query = from t in db.View_Qa where t.ID == id select t; list = query.ToList(); return(list); }
/// <summary> /// 根据类型获取所有子类型 /// </summary> /// <param name="db"></param> /// <param name="type"></param> /// <returns></returns> public string GetTypeCondition(JSZX_ResourceEntities db, string type) { List <T_Res_Type> list = new List <T_Res_Type>(); var query = from t in db.T_Res_Type orderby t.BELONG_ID, t.ID select t; list = query.ToList(); string ret = type + ","; ReturnTypeStr(list, type, ref ret); return(ret); }
/// <summary> /// 更新附件信息 /// </summary> /// <param name="rm">附件id</param> /// <param name="db"></param> private void updateAppendix(AppendixModel am, JSZX_ResourceEntities db) { T_Res_Appendix app = db.T_Res_Appendix.FirstOrDefault(t => t.ID == am.Id); app.AUTHOR = am.Author; app.ACTIVE_TIME_START = am.GetStartTime(); app.ACTIVE_TIME_END = am.GetEndTime(); app.MODIFYID = am.ModifyId; app.MODIFYTIME = DateTime.Now; app.IS_FOREVER = am.getIsForever(); }
/// <summary> /// 记录下载数 /// </summary> /// <param name="id">资源id</param> /// <param name="appId">附件id</param> /// <param name="db"></param> /// <returns></returns> public bool AddDownLoadNum(string id, string appId, string userId, JSZX_ResourceEntities db) { T_Res_Result result = null; try { //var query = from t in db.T_Res_Result // where t.RES_ID == id && t.APPEND_ID == appId // select t; //资源ID不作为条件检索数据,附件ID唯一,才是关键字 var query = from t in db.T_Res_Result where t.APPEND_ID == appId select t; List <T_Res_Result> list = query.ToList(); if (list == null || list.Count == 0) { result = new T_Res_Result(); result.ID = Guid.NewGuid().ToString(); result.RES_ID = id; result.APPEND_ID = appId; result.DOWNLOAD_NUM = 1; result.CREATEID = userId; result.CREATETIME = DateTime.Now; db.T_Res_Result.Add(result); db.SaveChanges(); } else { //result = db.T_Res_Result.First(t => t.APPEND_ID == appId && t.RES_ID == id); //资源ID不作为条件检索数据,附件ID唯一,才是关键字 result = db.T_Res_Result.First(t => t.APPEND_ID == appId); int downloadNum = Convert.ToInt32(result.DOWNLOAD_NUM); downloadNum = downloadNum + 1; result.DOWNLOAD_NUM = downloadNum; result.MODIFYID = userId; result.MODIFYTIME = DateTime.Now; db.SaveChanges(); } return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "AddDownLoadNum", ex.Message); return(false); } }
/// <summary> /// 获取分类和其子分类id /// </summary> /// <param name="typeId"></param> /// <param name="db"></param> /// <returns></returns> private string[] GetAllType(string typeId, JSZX_ResourceEntities db) { string[] type = { }; var query = from t in db.T_Res_Type where t.ID == typeId || t.BELONG_ID == typeId select t.ID; type = query.ToArray(); return(type); }
//#region 获取ftp地址,上传文件大小信息 ///// <summary> ///// 获取ftp地址,上传文件大小信息 ///// </summary> ///// <param name="db"></param> ///// <returns></returns> //public Z_FTP_Parameters GetFtpInfo(GM_BasiceEntities db) //{ // Z_FTP_Parameters ftp = null; // var query = from t in db.Z_FTP_Parameters select t; // query = query.OrderByDescending(t => t.EditDate); // ftp = query.FirstOrDefault(); // return ftp; //} //#endregion /// <summary> /// 安全退出 /// </summary> /// <param name="guid"></param> public void outLogin(string guid) { #region /*更改数据库信息 start*/ JSZX_ResourceEntities db = new JSZX_ResourceEntities(); var rlt = (from t in db.Z_User where t.GUID == guid select t).Take(1).ToList(); var up = rlt.First(); up.GUID = ""; //保存数据 db.SaveChanges(); #endregion }
public Boolean DelType(string typeID, JSZX_ResourceEntities db) { try { DelTypeList(typeID, db); db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog(clsName, "DelType", ex.Message); return(false); } }
/**获取最新版本信息和之前版本号**/ public T_Res_Appendix GetVersionContrast(JSZX_ResourceEntities db, string Aid, ref List <VersionModel> VersionList) { try { T_Res_Appendix model = db.T_Res_Appendix.First(t => t.ID == Aid); GetVersion(db, Aid, ref VersionList); return(model); } catch (Exception ex) { clsLog.ErrorLog("Resource", "GetVersionContrast", "Error! " + ex.Message); return(null); } }
public Boolean AddType(T_Res_Type newType, JSZX_ResourceEntities db) { try { db.T_Res_Type.Add(newType); db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog(clsName, "AddType", ex.Message); return(false); } }
/// <summary> /// 根据id获取分类 /// </summary> /// <param name="id">分类id</param> /// <param name="db"></param> /// <returns></returns> public T_Res_Type GetTypeById(string id, JSZX_ResourceEntities db) { T_Res_Type type = new T_Res_Type(); var query = from t in db.T_Res_Type where t.ID == id select t; List <T_Res_Type> typeList = query.ToList(); if (typeList != null) { type = typeList[0]; } return(type); }
/// <summary> /// 获取资源详细信息 /// </summary> /// <param name="id">资源ID</param> /// <param name="db"></param> /// <returns>资源详细信息</returns> public View_Resource GetResourceDetail(string id, JSZX_ResourceEntities db) { View_Resource detail = new View_Resource(); List <View_Resource> list = null; var query = from t in db.View_Resource where t.DEL_FLG == "0" && t.ID == id select t; list = query.ToList(); if (list != null && list.Count > 0) { detail = list[0]; } return(detail); }