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