/// <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> /// 插入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="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> /// 插入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); } }
/// <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="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> /// 插入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="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); } }
/// <summary> /// 删除附件信息 /// </summary> /// <param name="rm">附件id</param> /// <param name="db"></param> private void DeleteAppendix(AppendixModel am, JSZX_ResourceEntities db) { T_Res_Appendix app = db.T_Res_Appendix.FirstOrDefault(t => t.ID == am.Id); app.DEL_FLG = "1"; app.MODIFYID = am.ModifyId; app.MODIFYTIME = DateTime.Now; //删除评价信息 var query = from t in db.T_Res_Score where t.APPEND_ID == am.Id select t; List <T_Res_Score> scoList = query.ToList(); if (scoList != null) { foreach (T_Res_Score item in scoList) { db.T_Res_Score.Remove(item); db.SaveChanges(); } } //删除问题信息 var query2 = from t in db.T_Res_Qa where t.APPEND_ID == am.Id select t; List <T_Res_Qa> qaList = query2.ToList(); if (qaList != null) { foreach (T_Res_Qa item in qaList) { db.T_Res_Qa.Remove(item); db.SaveChanges(); } } //删除评价结果表 var query3 = from t in db.T_Res_Result where t.APPEND_ID == am.Id select t; List <T_Res_Result> resList = query3.ToList(); if (resList != null) { foreach (T_Res_Result item in resList) { db.T_Res_Result.Remove(item); db.SaveChanges(); } } }
//#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 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); } }
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); } }
/// <summary> /// 批量删除资源 /// </summary> /// <param name="rm">资源ID</param> /// <param name="db"></param> /// <returns></returns> public bool deleteResource2(ResourceModel rm, JSZX_ResourceEntities db) { string[] ids = rm.Ids; string[] isSelect = rm.isSelect; string userId = rm.UserId; try { if (ids != null) { for (int i = 0; i < ids.Length; i++) { if (isSelect[i] == "1") { string id = ids[i]; 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", "deleteResource2", ex.Message); return(false); } }
/// <summary> /// 删除提问 /// </summary> /// <param name="id"></param> /// <param name="db"></param> /// <returns></returns> public Boolean deleteQuestion(string id, JSZX_ResourceEntities db) { try { T_Res_Qa qa = db.T_Res_Qa.First(t => t.ID == id); db.T_Res_Qa.Remove(qa); db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "deleteQuestion", ex.Message); return(false); } }
/// <summary> /// 回复问题 /// </summary> /// <param name="id"></param> /// <param name="answer"></param> /// <param name="userId"></param> /// <param name="db"></param> /// <returns></returns> public bool updateResQa(string id, string answer, string userId, JSZX_ResourceEntities db) { try { T_Res_Qa qa = db.T_Res_Qa.First(t => t.ID == id); qa.ANSWER = answer; qa.MODIFYID = userId; qa.MODIFYTIME = DateTime.Now; db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "updateResQa", ex.Message); return(false); } }
/// <summary> /// 保存资源信息 /// </summary> /// <param name="rm">资源信息</param> /// <param name="db"></param> /// <returns></returns> public bool insertResource(ResourceModel rm, JSZX_ResourceEntities db) { try { T_Resource tr = new T_Resource(); tr.ID = rm.Id; tr.NAME = rm.Name; tr.TYPE_ID = rm.TypeId; tr.INTRODUCTION = rm.Introduction; tr.LABEL = rm.Label; tr.NOTE = rm.Note; tr.STATUS = "0"; tr.DEL_FLG = "0"; tr.ORIGIN_FLG = "1"; tr.SHARE_FLG = "1"; tr.EXCELLENT_FLG = "0"; tr.CREATEID = rm.UserId; tr.CREATETIME = DateTime.Now; tr.MODIFYID = rm.UserId; tr.MODIFYTIME = DateTime.Now; db.T_Resource.Add(tr); doAppendix(rm, db); db.SaveChanges(); //上传资源时,可以获得积分 PointRule pr = new PointRule(); pr.AddPoint(tr.ID, tr.MODIFYID, "0"); //上传资源时,可以获得积分 return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "insertResource", ex.Message); return(false); } }
/// <summary> /// /// </summary> /// <param name="rm"></param> /// <param name="db"></param> /// <returns></returns> public bool examineResource(ResourceModel rm, JSZX_ResourceEntities db) { try { T_Resource tr = db.T_Resource.First(t => t.ID == rm.Id); tr.TYPE_ID = rm.TypeId; tr.INTRODUCTION = rm.Introduction; tr.LABEL = rm.Label; tr.STATUS = rm.Status; tr.EXCELLENT_FLG = rm.Excellent_Flg; tr.MODIFYID = rm.UserId; tr.MODIFYTIME = DateTime.Now; db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "examineResource", ex.Message); return(false); } }
/// <summary> /// 保存提问 /// </summary> /// <param name="rm">提问信息</param> /// <param name="db"></param> /// <returns></returns> public bool insertQa(ResourceModel rm, JSZX_ResourceEntities db) { try { T_Res_Qa qa = new T_Res_Qa(); qa.ID = Guid.NewGuid().ToString(); qa.RES_ID = rm.Id; qa.APPEND_ID = rm.AppId; qa.QUESTION = rm.Question; qa.CREATEID = rm.UserId; qa.CREATETIME = DateTime.Now; db.T_Res_Qa.Add(qa); db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "insertQa", ex.Message); return(false); } }
/// <summary> /// 批量审核资源 /// </summary> /// <param name="rm"></param> /// <param name="db"></param> /// <returns></returns> public bool examineResource2(ResourceModel rm, JSZX_ResourceEntities db) { string[] ids = rm.Ids; string[] isSelect = rm.isSelect; string status = rm.Status; string excellentFlg = rm.Excellent_Flg; string userId = rm.UserId; try { if (ids != null) { for (int i = 0; i < ids.Length; i++) { if (isSelect[i] == "1") { string id = ids[i]; T_Resource tr = db.T_Resource.First(t => t.ID == id); tr.STATUS = status; tr.EXCELLENT_FLG = excellentFlg; tr.MODIFYID = userId; tr.MODIFYTIME = DateTime.Now; } } } db.SaveChanges(); return(true); } catch (Exception ex) { clsLog.ErrorLog("Resource", "examineResource2", ex.Message); return(false); } }
/// <summary> /// 登录 /// </summary> /// <param name="uid">用户名</param> /// <param name="pwd">密码</param> /// <param name="ip">IP</param> /// <param name="guid">GUID</param> /// <param name="pLoginReturn">返回类</param> /// <returns>bool是否登录成功</returns> public bool Login(string uid, string pwd, string ip, string guid, bool autoLogin, out LoginReturn pLoginReturn) { //实例化返回类 pLoginReturn = new LoginReturn(); try { //实例化数据库实体 using (JSZX_ResourceEntities db = new JSZX_ResourceEntities()) { //用户登录查询 //密码改成MD5,和BBS及CMS一致 byte[] result = Encoding.Default.GetBytes(pwd); //Password为输入密码的文本 MD5 md5 = new MD5CryptoServiceProvider(); byte[] output = md5.ComputeHash(result); pwd = BitConverter.ToString(output).Replace("-", "").ToLower(); //tbMd5pass为输出加密文本的 var rls = (from t in db.Z_User where t.ID == uid && t.Password == pwd && t.Del == false select t).Take(1).ToList(); if (rls.Count > 0) { #region /*更改数据库信息 start*/ var pl = rls.First(); //登录次数 pl.Link_Count++; //登录时间 pl.Login_Time = DateTime.Now; //IP pl.IP = ip; //GUID //pl.GUID = guid; if (autoLogin) { pl.isSeven = true; } else { pl.isSeven = false; } #endregion #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; pLoginReturn.IsCmsAdmin = pl.IsCmsAdmin; pLoginReturn.IsMonitorAdmin = pl.IsMonitorAdmin; pLoginReturn.SchoolId = pl.SchoolId; #endregion //保存数据 db.SaveChanges(); return(true); } } return(false); } catch (Exception ex) { string s = ex.Message; return(false); } }
/// <summary> /// 大文件上传数据保存 /// </summary> /// <param name="model"></param> /// <param name="db"></param> /// <returns></returns> public Boolean JavaUploadSaveData(JavaUploadModel model, JSZX_ResourceEntities db) { try { #region 资源 T_Resource rModel = new T_Resource(); rModel.ID = model.ID; rModel.NAME = model.Name; rModel.TYPE_ID = model.TypeID; rModel.INTRODUCTION = model.Introduction; rModel.LABEL = model.Label; rModel.NOTE = model.Note; rModel.STATUS = "0"; rModel.DEL_FLG = "0"; rModel.ORIGIN_FLG = "1"; rModel.SHARE_FLG = "1"; rModel.EXCELLENT_FLG = "0"; rModel.CREATEID = model.CreateID; rModel.CREATETIME = DateTime.Now; db.T_Resource.Add(rModel); #endregion #region 附件 if (model.FileUrl != null && model.FileUrl.Length > 0) { #region 循环插入附件 for (int i = 0; i < model.FileUrl.Length; i++) { string path = model.FileUrl[i]; string fileType = Constant.GetFileType(System.IO.Path.GetExtension(path)); string fileID = System.IO.Path.GetFileNameWithoutExtension(path); T_Res_Appendix aModel = new T_Res_Appendix(); aModel.ID = fileID; aModel.RES_ID = model.ID; aModel.FILE_NAME = model.FileName[i]; aModel.UPLOAD_TIME = DateTime.Now; aModel.AUTHOR = model.Author; aModel.ACTIVE_TIME_START = StringToDateTime(model.ActiveTimeStart); aModel.ACTIVE_TIME_END = StringToDateTime(model.ActiveTimeEnd); aModel.CREATEID = model.CreateID; aModel.CREATETIME = DateTime.Now; aModel.DEL_FLG = "0"; aModel.FILE_URL = path; aModel.TYPE_FLG = fileType; aModel.IS_FOREVER = model.isForever == "1" ? true : false; db.T_Res_Appendix.Add(aModel); #region 转换任务 T_ToChange change = new T_ToChange(); change.ID = Guid.NewGuid().ToString(); change.FileName = fileID; change.SourceFilePath = path; change.TargetFilePath = Constant.DISK_ADDRESS + Constant.UPLOADDIRECTORY + "\\" + Constant.SWFDIRECTORY; string sql = "update JSZX_Resource.dbo.T_Res_Appendix set READ_URL=@TargetFilePath,[IMAGE]=@FileFirstImg,[PAGECOUNT]=@PageCount where ID='" + fileID + "'"; change.RetSql = sql; change.TaskTime = DateTime.Now; db.T_ToChange.Add(change); #endregion } #endregion db.SaveChanges(); return(true); } else { clsLog.ErrorLog("Resource", "ShareResource", "Error! 缺少必要的附件!"); return(false); } #endregion } catch (Exception ex) { clsLog.ErrorLog("Resource", "JavaUploadSaveData", "Error! " + ex.Message); return(false); } }