/// <summary>
/// 文件下载
/// </summary>
/// <param name="docId"></param>
/// <returns></returns>
public FileStreamResult FileDownload(string docId)
{
FileStreamResult Ret = null;
try
{
#region 判断是否为空
if (!string.IsNullOrEmpty(docId))
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
KeyValModel kv = GetCurrentStoreDirectory();
T_XT_Doc_Entity _doc = et.T_XT_Doc_Entity.FirstOrDefault(d => d.IsDeleted == false && d.DocId == docId);
if (kv != null && _doc != null)
{
string filePath = Server.MapPath(string.Format("~/DocLib/{0}/{1}", _doc.SubDirectory, _doc.InternalName));//路径
Ret = File(new FileStream(filePath, FileMode.Open), "text/plain", _doc.DocName);
_doc.DownloadCount = _doc.DownloadCount ?? 0;
_doc.DownloadCount++;
et.SaveChanges();
}
}
}
#endregion
}
catch (Exception ex)
{
}
return(Ret);
}
public void YHSumUpdate(string yhId)
{
//JsonRetModel Ret = new JsonRetModel { Ret = false };
#region 验证
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_YH_HiddenDanger_Entity yh = et.T_YH_HiddenDanger_Entity.FirstOrDefault(k => k.HiddenDangerId == yhId);
if (yh != null)
{
string ym = yh.CheckTime.Value.ToString("yyyyMM");
T_YH_SumRecords_Entity sum = et.T_YH_SumRecords_Entity.FirstOrDefault(k => k.MonthDate == ym);
if (sum != null)
{
DateTime _monthFirst = Convert.ToDateTime(yh.CheckTime.Value.ToString("yyyy-MM") + "-01"), _nextFirst = _monthFirst.AddMonths(1);
var _list = et.T_YH_HiddenDanger_Entity.Where(k => k.CheckTime >= _monthFirst && k.CheckTime < _nextFirst && k.IsDeleted == false && k.OrgCode == yh.OrgCode);
sum.CommonlyCnt = _list.Where(k => k.HiddenLevel == "一般隐患").Count();
sum.MajorCnt = _list.Where(k => k.HiddenLevel == "重大隐患").Count();
sum.CorrectCnt = _list.Where(k => k.Result == "已整改").Count();
sum.ScheduleCnt = _list.Where(k => k.CompleteTime <= k.TimeLimit).Count();
sum.TotalCnt = _list.Count();
et.SaveChanges();
}
}
}
}
#endregion
#region 异常
catch (Exception ex)
{
}
#endregion
}
//On<Insert|Updat|Delet|Execut><ed|ing><EntitySetName|ActionName>其中ing的前提交，并ed于提交后。
#region T_XT_Data_Entity
#region 新增
protected void OnInsertingT_XT_Data_Entity(T_XT_Data_Entity entityset)
{
try
{
if (string.IsNullOrEmpty(entityset.DataId))
{
entityset.DataId = Guid.NewGuid().ToString("N");
}
entityset.CreateTime = DateTime.Now;
entityset.IsDeleted = false;
entityset.SubItemAmount = 0;
#region 更新子节点数量
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_XT_Data_Entity _p = et.T_XT_Data_Entity.FirstOrDefault(k => k.DataId == entityset.ParentId);
if (_p != null)
{
_p.SubItemAmount = et.T_XT_Data_Entity.Where(k => k.ParentId == _p.DataId && k.IsDeleted == false).Count() + 1;
et.SaveChanges();
}
}
#endregion
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 清除DbContest锁定
/// </summary>
/// <returns></returns>
public static Boolean RemoveHoldingEntityInContext <T>(T entity, TeamWorkDbContext et) where T : class
{
var objContext = ((IObjectContextAdapter)et).ObjectContext;
var objSet = objContext.CreateObjectSet <T>();
var entityKey = objContext.CreateEntityKey(objSet.EntitySet.Name, entity);
Object foundEntity;
var exists = objContext.TryGetObjectByKey(entityKey, out foundEntity);
if (exists)
{
objContext.Detach(foundEntity);
}
return(exists);
}
protected void OnDeletingT_XT_Data_Entity(T_XT_Data_Entity entityset)
{
entityset.ModifyTime = DateTime.Now;
entityset.IsDeleted = true;
#region 更新子节点数量
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_XT_Data_Entity _p = et.T_XT_Data_Entity.FirstOrDefault(k => k.DataId == entityset.ParentId);
if (_p != null)
{
_p.SubItemAmount = et.T_XT_Data_Entity.Where(k => k.ParentId == _p.DataId && k.IsDeleted == false).Count() - 1;
et.SaveChanges();
}
}
#endregion
}
public override JsonRetModel ExportExcel(string paras)
{
JsonRetModel Ret = new JsonRetModel();
string strPath = string.Format("发布记录{0:yyyyMMddHHmmss}", DateTime.Now);
#region
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
//var list=et.T_XT_PublishRecords_Entity.Where(k => true).ToList();
}
}
catch (Exception ex)
{
}
#endregion
return(Ret);
}
/// <summary>
/// 根据工号获取用户信息
/// </summary>
/// <returns></returns>
public T_XT_User_Entity getUserByEmpCode(string empCode)
{
T_XT_User_Entity _u = null;
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
if (!string.IsNullOrEmpty(empCode))
{
_u = et.T_XT_User_Entity.FirstOrDefault(k => k.EmpCode == empCode);
}
}
}
catch (Exception)
{
}
return(_u);
}
/// <summary>
/// 获取Excel模板版本号
/// </summary>
/// <param name="dataId"></param>
/// <returns></returns>
public string getExcelVersion(string dataId)
{
string ret = "";
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_XT_Data_Entity _data = et.T_XT_Data_Entity.FirstOrDefault(k => k.DataId == dataId);
if (_data != null)
{
ret = _data.DataName;
}
}
}
catch (Exception)
{
}
return(ret);
}
/// <summary>
/// 获取当前用户
/// </summary>
/// <returns></returns>
public T_XT_User_Entity getCurrentUser()
{
T_XT_User_Entity _u = null;
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
string empCode = HttpContext.Current.Session["User"] + "";
if (!string.IsNullOrEmpty(empCode))
{
_u = et.T_XT_User_Entity.FirstOrDefault(k => k.EmpCode == empCode);
}
}
}
catch (Exception)
{
}
return(_u);
}
/// <summary>
/// 获取当前用户信息
/// </summary>
/// <returns></returns>
public T_XT_User_Entity getCurUser()
{
T_XT_User_Entity _u = null;
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
string _empcode = getCurUserEmpCode();
if (!string.IsNullOrEmpty(_empcode))
{
_u = et.T_XT_User_Entity.FirstOrDefault(u => u.EmpCode == _empcode);
}
}
}
catch (Exception)
{
}
return(_u);
}
public JsonResult PersonRecordAdd(T_WH_PersonRecord_Entity saveData)
{
JsonRetModel Ret = new JsonRetModel {
Ret = false
};
#region 验证
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_WH_PersonRecord_Entity u = et.T_WH_PersonRecord_Entity.Find(saveData.RecordId);
if (u != null)
{
CommonHelper.RemoveHoldingEntityInContext <T_WH_PersonRecord_Entity>(u, et);
u = saveData;
et.Entry <T_WH_PersonRecord_Entity>(u).State = System.Data.Entity.EntityState.Modified;
}
else
{
saveData.RecordId = System.Guid.NewGuid().ToString("N");
u = et.T_WH_PersonRecord_Entity.Add(saveData);
}
et.SaveChanges();
Ret.Data = saveData.RecordId;
Ret.Msg = "保存成功";
Ret.Ret = true;
}
}
#endregion
#region 异常
catch (Exception ex)
{
Ret.Ret = false;
Ret.Msg = ex.Message;
}
#endregion
return(Json(Ret, JsonRequestBehavior.AllowGet));
}
public JsonResult XTStaticDatasDelete(string delId)
{
JsonRetModel ret = new JsonRetModel {
Ret = false
};
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_XT_Data_Entity _d = et.T_XT_Data_Entity.FirstOrDefault(k => k.DataId == delId);
if (_d != null)
{
_d.ModifyTime = DateTime.Now;
_d.IsDeleted = true;
T_XT_Data_Entity _p = et.T_XT_Data_Entity.FirstOrDefault(k => k.DataId == _d.ParentId);
if (_p != null)
{
_p.SubItemAmount = et.T_XT_Data_Entity.Where(k => k.ParentId == _p.DataId && k.IsDeleted == false).Count() - 1;
}
et.SaveChanges();
ret.Ret = true;
ret.Msg = "操作成功！";
}
else
{
ret.Msg = "操作失败，此节点可能已经被删除！";
}
}
}
catch (Exception ex)
{
ret.Msg = ex.Message;
}
return(Json(ret));
}
/// <summary>
/// 获取文件储存地址
/// </summary>
/// <returns></returns>
protected KeyValModel GetCurrentStoreDirectory()
{
KeyValModel ret = null;
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_XT_StoreDirectory_Entity st = et.T_XT_StoreDirectory_Entity.FirstOrDefault(k => k.IsDeleted == false);
if (st != null)
{
ret = new KeyValModel
{
Key = st.StoreDirectoryId,
Val = st.StoreDirectoryPath
};
}
}
}
catch (Exception)
{
}
return(ret);
}
public ActionResult getHiddenDangerLsit(int page, int limit)
{
Dictionary <String, Object> Ret = new Dictionary <String, Object>();
#region 验证
try
{
TeamWorkDbContext et = new TeamWorkDbContext();
//var list = et.T_YH_HiddenDanger_Entity.OrderBy(u => u.SerialNo).Skip((page - 1) * limit).Take(limit);
var list = et.T_YH_HiddenDanger_Entity;
int total = et.T_YH_HiddenDanger_Entity.Count <T_YH_HiddenDanger_Entity>();
var dic = new Dictionary <string, object>
{
{ "data", list },
{ "count", total },
{ "msg", "查询成功" },
{ "code", 0 }
};
return(Json(dic, JsonRequestBehavior.AllowGet));
}
#endregion
#region 异常
catch (Exception ex)
{
var dic = new Dictionary <string, object>
{
{ "msg", ex.Message },
{ "code", 1 }
};
return(Json(dic, JsonRequestBehavior.AllowGet));
}
#endregion
finally{
}
}
public JsonResult FileUpload()
{
JsonRetModel ret = new JsonRetModel();
try
{
Response.ContentType = "text/plain";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
Response.Charset = "utf-8";
string _RelevanceId = Request["RelevanceId"],
_FromModuleName = Request["FromModuleName"],
_FromTableName = Request["FromTableName"],
_ExpandOne = Request["ExpandOne"],
_ExpandTwo = Request["ExpandTwo"],
_ExpandThree = Request["ExpandThree"],
_ExpandFour = Request["ExpandFour"],
_ExpandFive = Request["ExpandFive"];
HttpPostedFileBase file = Request.Files["file"];
KeyValModel kv = GetCurrentStoreDirectory();//获取存储物理路径
if (kv != null)
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
string storeDirectoryId = kv.Key,
storeDirectory = kv.Val,
subDirectory = DateTime.Now.ToString("yyyyMM"),
uploadPath = storeDirectory + @"\" + subDirectory + @"\";
bool IsImg = false;
if (file != null)
{
if (!Directory.Exists(uploadPath))
{
Directory.CreateDirectory(uploadPath);
}
string[] array = file.FileName.Split('.');
string suffix = "." + array[array.Length - 1],
internalName = Guid.NewGuid().ToString("N"),
realPath = uploadPath + internalName,
fullPath = realPath + suffix;
if (CheckImageExt(suffix))
{
IsImg = true;
MakeSmallImg(file.InputStream, realPath + "_s" + suffix, 100, 100);
MakeSmallImg(file.InputStream, fullPath, 800, 800);
}
else
{
file.SaveAs(fullPath);
}
string fileName = file.FileName.Substring(file.FileName.LastIndexOf('/') + 1);
T_XT_Doc_Entity _doc = new T_XT_Doc_Entity
{
DocId = Guid.NewGuid().ToString("N"),
StoreDirectoryId = storeDirectoryId,
DocName = fileName,
DocType = suffix,
DocSize = file.ContentLength,
SubDirectory = subDirectory,
InternalName = internalName + suffix,
DownloadCount = 0,
FromModuleName = _FromModuleName,
FromTableName = _FromTableName,
RelevanceId = _RelevanceId,
ExpandOne = _ExpandOne,
ExpandTwo = _ExpandTwo,
ExpandThree = _ExpandThree,
ExpandFour = _ExpandFour,
ExpandFive = _ExpandFive,
CreateTime = DateTime.Now,
IsDeleted = false
};
et.T_XT_Doc_Entity.Add(_doc);
et.SaveChanges();
ret.Ret = true;
ret.Msg = "上传成功";
ret.Data = new
{
DocId = _doc.DocId,
DocName = _doc.DocName,
Size = _doc.DocSize,
CreateTime = _doc.CreateTime,
Path = string.Format("DocLib/{0}/{1}", subDirectory, _doc.InternalName)
//,Path_s = IsImg?string.Format("DocLib/{0}/{1}_s{2}", subDirectory, realPath, suffix):null
};
}
else
{
ret.Ret = false;
ret.Msg = "未检测到文件";
}
}
}
}
catch (Exception ex)
{
ret.Ret = false;
ret.Msg = ex.Message;
}
return(Json(ret));
}
public JsonResult FilesDelete(string[] docIds)
{
JsonRetModel ret = new JsonRetModel {
Ret = false
};
try
{
KeyValModel kv = GetCurrentStoreDirectory();
if (!docIds.Any())
{
ret.Msg = "未检测到需要删除的文件！";
return(Json(ret));
}
if (kv == null)
{
ret.Msg = "未能获取到文件储存目录！";
return(Json(ret));
}
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
foreach (string _docId in docIds)
{
T_XT_Doc_Entity _doc = et.T_XT_Doc_Entity.FirstOrDefault(k => k.DocId == _docId);
if (_doc != null)
{
#region 除文件
string path = string.Format("{0}\\{1}\\{2}", kv.Val, _doc.SubDirectory, _doc.InternalName);
FileInfo info = new FileInfo(path);
if (info.Exists)
{
info.Delete();
}
#endregion
#region 如果是图片类型的连带删除缩略图
if (CheckImageExt(_doc.DocType))
{
string img_sp = string.Format("{0}\\{1}\\{2}_s{3}", kv.Val, _doc.SubDirectory, _doc.InternalName.Replace(_doc.DocType, ""), _doc.DocType);
FileInfo img_s = new FileInfo(img_sp);
if (img_s.Exists)
{
img_s.Delete();
}
}
#endregion
#region 除表数据（伪删除）
_doc.IsDeleted = true;
et.SaveChanges();
#endregion
}
}
ret.Msg = "操作成功";
ret.Ret = true;
}
}
catch (Exception e)
{
ret.Msg = e.Message;
ret.Ret = false;
}
return(Json(ret));
}
public JsonResult SignIn(string userName, string password)
{
JsonRetModel Ret = new JsonRetModel {
Ret = false
};
#region 验证
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_XT_User_Entity _u = et.T_XT_User_Entity.FirstOrDefault(u => u.EmpCode == userName);
#region 存在用户
if (_u != null)
{
#region 验证成功
if (_u.LoginPassword.ToUpper() == CommonHelper.StringToMD5(password))
{
_u.LastLoginTime = _u.TheLoginTime;
_u.TheLoginTime = DateTime.Now;
T_XT_LogRecords_Entity _log = new T_XT_LogRecords_Entity {
LogRecordId = Guid.NewGuid().ToString("N"),
EmpCode = _u.EmpCode,
EmpName = _u.EmpName,
CreateByEmpCode = "system",
CreateByEmpName = "系统",
CreateTime = DateTime.Now,
IsDeleted = false
};
et.T_XT_LogRecords_Entity.Add(_log);
et.SaveChanges();
#region 记录Session
Session["User"] = userName;
#endregion
Ret.Msg = "登录成功";
Ret.Ret = true;
}
#endregion
#region 密码错误
else
{
Ret.Msg = "密码错误";
}
#endregion
}
#endregion
#region 用户不存在
else
{
Ret.Msg = "用户不存在";
}
#endregion
}
}
#endregion
#region 异常
catch (Exception ex)
{
Ret.Ret = false;
Ret.Msg = ex.Message;
}
#endregion
return(Json(Ret, JsonRequestBehavior.AllowGet));
}
public JsonResult XTStaticDatasSort(string DataId, string SortFlag)
{
JsonRetModel ret = new JsonRetModel {
Ret = false
};
try
{
using (TeamWorkDbContext et = new TeamWorkDbContext())
{
T_XT_Data_Entity _d = et.T_XT_Data_Entity.Where(item => item.DataId == DataId).FirstOrDefault();
if (_d != null)
{
var list = et.T_XT_Data_Entity.Where(item => item.ParentId == _d.ParentId && item.IsDeleted == false).OrderBy(k => k.SortIndex);
var _list = list.ToList();
if (_list.Any())
{
if (SortFlag == "up" && _list.FirstOrDefault().DataId == DataId)
{
ret.Msg = "已经是第一个了！";
}
else if (SortFlag == "down" && _list.LastOrDefault().DataId == DataId)
{
ret.Msg = "已经是最后一个了！";
}
else
{
int _index = 0, _target = 0;
foreach (var d in list)
{
d.SortIndex = _index++;
if (d.DataId == DataId)
{
_target = Convert.ToInt32(d.SortIndex);
}
}
T_XT_Data_Entity dd = list.Skip(_target).FirstOrDefault();
switch (SortFlag)
{
case "up":
dd.SortIndex--;
var _prev = list.Skip(_target - 1).FirstOrDefault();
_prev.SortIndex++;
break;
case "down":
dd.SortIndex++;
var _next = list.Skip(_target + 1).FirstOrDefault();
_next.SortIndex--;
break;
default:
break;
}
et.SaveChanges();
ret.Ret = true;
ret.Msg = "操作成功！";
}
}
}
}
}
catch (Exception ex)
{
ret.Msg = ex.Message;
}
return(Json(ret));
}
