public FileResult DownloadDwg(string UserID)
{
if (string.IsNullOrEmpty(UserID))
{
UserID = FormulaHelper.UserID;
}
S_A_User user = entities.Set <S_A_User>().FirstOrDefault(a => a.ID == UserID);
if (user == null)
{
throw new Exception("用户不存在");
}
S_A_UserImg sa = entities.Set <S_A_UserImg>().FirstOrDefault(c => c.UserID == UserID);
if (sa == null)
{
throw new Exception("尚未上传Dwg签名文件");
}
byte[] dwgFile = sa.DwgFile;
if (dwgFile == null || dwgFile.Length == 0)
{
throw new Exception("尚未上传Dwg签名文件");
}
string contentType = "application/x-dwg";
return(File(dwgFile, contentType, user.Name + ".dwg"));
}
public JsonResult FreeSign(string UserID, string imgType = "Sign")
{
if (string.IsNullOrEmpty(UserID))
{
UserID = FormulaHelper.UserID;
}
S_A_UserImg sa = entities.Set <S_A_UserImg>().Where(c => c.UserID == UserID).SingleOrDefault();
if (sa != null)
{
if (imgType == "Sign")
{
sa.SignImg = null;
}
else if (imgType == "Portrait")
{
sa.Picture = null;
}
else if (imgType == "Dwg")
{
sa.DwgFile = null;
var user = entities.Set <S_A_User>().FirstOrDefault(a => a.ID == UserID);
if (user != null)
{
user.ModifyTime = DateTime.Now;
}
}
entities.SaveChanges();
}
return(Json(new { ImgType = imgType }));
}
public JsonResult UploadImg(string UserID, bool isPortrait = false)
{
if (string.IsNullOrEmpty(UserID))
{
UserID = FormulaHelper.UserID;
}
if (Request.Files.Count > 0)
{
var t = Request.Files[0].InputStream;
byte[] bt = new byte[t.Length];
t.Read(bt, 0, int.Parse(t.Length.ToString()));
S_A_UserImg sa = entities.Set <S_A_UserImg>().Where(c => c.UserID == UserID).SingleOrDefault();
if (sa == null)
{
sa = new S_A_UserImg()
{
ID = FormulaHelper.CreateGuid(), UserID = UserID
};
entities.Set <S_A_UserImg>().Add(sa);
}
if (isPortrait)
{
sa.Picture = bt;
}
else
{
sa.SignImg = bt;
}
entities.SaveChanges();
}
return(Json(""));
}
public JsonResult UploadDwg(string UserID)
{
if (string.IsNullOrEmpty(UserID))
{
UserID = FormulaHelper.UserID;
}
if (Request.Files.Count > 0)
{
var t = Request.Files[0].InputStream;
byte[] bt = new byte[t.Length];
t.Read(bt, 0, int.Parse(t.Length.ToString()));
S_A_UserImg sa = entities.Set <S_A_UserImg>().Where(c => c.UserID == UserID).SingleOrDefault();
if (sa == null)
{
sa = new S_A_UserImg()
{
ID = FormulaHelper.CreateGuid(), UserID = UserID
};
entities.Set <S_A_UserImg>().Add(sa);
}
sa.DwgFile = bt;
var user = entities.Set <S_A_User>().FirstOrDefault(a => a.ID == UserID);
if (user != null)
{
user.ModifyTime = DateTime.Now;
}
entities.SaveChanges();
}
return(Json(""));
}
//更新雇员加入系统用户
public void EmployeeUpdateToUser(S_HR_Employee employee)
{
S_A_User user = baseEntities.Set <S_A_User>().Where(t => t.ID == employee.UserID).FirstOrDefault();
user.WorkNo = employee.Code;
user.Code = employee.Code;
user.Name = employee.Name;
user.IsDeleted = employee.IsDeleted;
if (employee.Address != null)
{
user.Address = employee.Address;
}
if (employee.Email != null)
{
user.Email = employee.Email;
}
if (employee.OfficePhone != null)
{
user.Phone = employee.OfficePhone;
}
if (employee.MobilePhone != null)
{
user.MobilePhone = employee.MobilePhone;
}
//修改用户图片
S_A_UserImg userImg = null;
List <S_A_UserImg> userImgList = baseEntities.Set <S_A_UserImg>().Where(c => c.UserID == user.ID).ToList();
if (userImgList.Count > 0)
{
userImg = userImgList.FirstOrDefault();
}
else
{
userImg = new S_A_UserImg()
{
ID = FormulaHelper.CreateGuid(),
UserID = user.ID
};
baseEntities.Set <S_A_UserImg>().Add(userImg);
}
if (employee.Portrait != null)
{
userImg.Picture = employee.Portrait;
}
if (employee.SignImage != null)
{
userImg.SignImg = employee.SignImage;
}
SyncUserDeptByEmployee(employee, user);
baseEntities.SaveChanges();
}
public ActionResult UploadPic()
{
ViewBag.IsHasDwg = true;
var UserID = GetQueryString("UserID");
S_A_UserImg sa = entities.Set <S_A_UserImg>().FirstOrDefault(c => c.UserID == UserID);
if (sa == null || sa.DwgFile == null)
{
ViewBag.IsHasDwg = false;
}
return(View());
}
public ActionResult MyPic()
{
ViewBag.IsHasDwg = true;
var UserID = FormulaHelper.UserID;
S_A_UserImg sa = entities.Set <S_A_UserImg>().FirstOrDefault(c => c.UserID == UserID);
if (sa == null || sa.DwgFile == null)
{
ViewBag.IsHasDwg = false;
}
return(View());
}
public void UpdatePictureFromFileStore(string fileId)
{
byte[] bytes = FileStoreHelper.GetFile(fileId);
var obj = this.S_A_UserImg.SingleOrDefault(c => c.UserID == this.ID);
if (obj == null)
{
obj = new S_A_UserImg();
obj.ID = FormulaHelper.CreateGuid();
obj.UserID = this.ID;
this.S_A_UserImg.Add(obj);
}
obj.Picture = bytes;
}
public void UpdatePictureFromFileStore(string fileId)
{
OuterService service = new OuterService();
byte[] bytes = service.GetFileBytes(fileId, 0, int.MaxValue);
var obj = this.S_A_UserImg.SingleOrDefault(c => c.UserID == this.ID);
if (obj == null)
{
obj = new S_A_UserImg();
obj.ID = FormulaHelper.CreateGuid();
obj.UserID = this.ID;
this.S_A_UserImg.Add(obj);
}
obj.Picture = bytes;
}
//新添雇员加入系统用户
public void EmployeeAddToUser(S_HR_Employee employee, string Password)
{
if (employee == null || employee.IsDeleted == "1")
{
return;
}
BaseEntities baseEntities = FormulaHelper.GetEntities <BaseEntities>();
//添加新用户
S_A_User user = new S_A_User()
{
ID = FormulaHelper.CreateGuid(),
Code = employee.Code,
Name = employee.Name,
WorkNo = employee.Code,
Address = employee.Address,
Email = employee.Email,
Password = Password,
Sex = employee.Sex,
InDate = employee.JoinCompanyDate,
Phone = employee.OfficePhone,
MobilePhone = employee.MobilePhone,
IsDeleted = "0"
};
baseEntities.Set <S_A_User>().Add(user);
//反写userID
employee.UserID = user.ID;
//添加用户图片
S_A_UserImg userImg = new S_A_UserImg()
{
ID = FormulaHelper.CreateGuid(),
UserID = user.ID,
Picture = employee.Portrait,
SignImg = employee.SignImage
};
baseEntities.Set <S_A_UserImg>().Add(userImg);
SyncUserDeptByEmployee(employee, user);
entities.SaveChanges();
baseEntities.SaveChanges();
}
public JsonResult FreeSign(string UserID, string imgType = "Sign")
{
if (string.IsNullOrEmpty(UserID))
{
UserID = FormulaHelper.UserID;
}
S_A_UserImg sa = entities.Set <S_A_UserImg>().Where(c => c.UserID == UserID).SingleOrDefault();
if (sa != null)
{
if (imgType == "Sign")
{
sa.SignImg = null;
}
else
{
sa.Picture = null;
}
entities.SaveChanges();
}
return(Json(new { ImgType = imgType }));
}
//更新雇员加入系统用户
public void EmployeeUpdateToUser(T_Employee employee)
{
BaseEntities baseEntities = FormulaHelper.GetEntities <BaseEntities>();
HREntities entities = FormulaHelper.GetEntities <HREntities>();
var enumService = FormulaHelper.GetService <IEnumService>();
S_A_User user = baseEntities.Set <S_A_User>().Find(employee.UserID);
if (user == null)
{
user = baseEntities.Set <S_A_User>().FirstOrDefault(c => c.Code == employee.Code && c.IsDeleted == "0");
}
employee.UserID = user.ID;
user.WorkNo = employee.Code;
//user.Code = employee.Code;
user.Name = employee.Name;
user.IsDeleted = employee.IsDeleted;
user.Sex = employee.Sex;
user.ModifyTime = DateTime.Now;
if (employee.Address != null)
{
user.Address = employee.Address;
}
if (employee.Email != null)
{
user.Email = employee.Email;
}
if (employee.OfficePhone != null)
{
user.Phone = employee.OfficePhone;
}
if (employee.MobilePhone != null)
{
user.MobilePhone = employee.MobilePhone;
}
S_A_Org org = null;
user.S_A__OrgUser.RemoveWhere(c => c.S_A_Org.Type != "Post");
List <string> orgIDList = user.S_A__OrgUser.Select(a => a.OrgID).ToList();
List <S_A_Org> orgList = baseEntities.Set <S_A_Org>().Where(a => a.IsDeleted == "0").ToList();
if (employee.DeptID != null)
{
org = orgList.Where(c => c.ID == employee.DeptID).FirstOrDefault();
}
if (org == null)
{
org = orgList.Where(c => c.ParentID == null || c.ParentID == "").FirstOrDefault();
}
if (org != null)
{
user.DeptID = org.ID;
user.DeptName = org.Name;
user.DeptFullID = org.FullID;
string companyID = "";
string companyName = "";
//逆序判断类型是否为集团/公司
string[] orgIDs = org.FullID.Split('.');
var orgs = orgList.Where(c => orgIDs.Contains(c.ID)).ToDictionary <S_A_Org, string>(d => d.ID);
for (var i = orgIDs.Length; i > 0; i--)
{
if ((orgs[orgIDs[i - 1]].Type ?? "none").IndexOf("Company") > -1)
{
companyID = orgs[orgIDs[i - 1]].ID;
companyName = orgs[orgIDs[i - 1]].Name;
break;
}
}
user.CorpID = companyID;
user.CorpName = companyName;
}
if (!string.IsNullOrEmpty(user.DeptFullID))
{
foreach (var id in user.DeptFullID.Split('.'))
{
if (!orgIDList.Contains(id))
{
S_A__OrgUser orgUser = new S_A__OrgUser();
orgUser.OrgID = id;
orgUser.UserID = user.ID;
baseEntities.Set <S_A__OrgUser>().Add(orgUser);
orgIDList.Add(id);
}
}
}
if (!string.IsNullOrEmpty(employee.ParttimeDeptID))
{
foreach (var id in employee.ParttimeDeptID.Split(','))
{
var parttimeOrg = orgList.FirstOrDefault(c => c.ID == employee.DeptID);
if (parttimeOrg != null)
{
foreach (var parttimeOrgID in parttimeOrg.FullID.Split('.'))
{
if (!orgIDList.Contains(parttimeOrgID))
{
S_A__OrgUser orgUser = new S_A__OrgUser();
orgUser.OrgID = parttimeOrgID;
orgUser.UserID = user.ID;
baseEntities.Set <S_A__OrgUser>().Add(orgUser);
orgIDList.Add(id);
}
}
}
}
}
//修改用户图片
S_A_UserImg userImg = null;
List <S_A_UserImg> userImgList = baseEntities.Set <S_A_UserImg>().Where(c => c.UserID == user.ID).ToList();
if (userImgList.Count > 0)
{
userImg = userImgList.FirstOrDefault();
}
else
{
userImg = new S_A_UserImg()
{
ID = FormulaHelper.CreateGuid(),
UserID = user.ID
};
baseEntities.Set <S_A_UserImg>().Add(userImg);
}
if (employee.Portrait != null)
{
userImg.Picture = employee.Portrait;
}
if (employee.SignImage != null)
{
userImg.SignImg = employee.SignImage;
}
if (employee.SignDwg != null)
{
userImg.DwgFile = employee.SignDwg;
}
entities.SaveChanges();
baseEntities.SaveChanges();
}
//新添雇员加入系统用户
public void EmployeeAddToUser(T_Employee employee, string Password)
{
if (employee.IsDeleted == "1")
{
return;
}
BaseEntities baseEntities = FormulaHelper.GetEntities <BaseEntities>();
HREntities entities = FormulaHelper.GetEntities <HREntities>();
//添加新用户
S_A_User user = new S_A_User()
{
ID = FormulaHelper.CreateGuid(),
Code = employee.Code,
Name = employee.Name,
WorkNo = employee.Code,
Address = employee.Address,
Email = employee.Email,
Password = Password,
Sex = employee.Sex,
InDate = employee.JoinCompanyDate,
Phone = employee.OfficePhone,
MobilePhone = employee.MobilePhone,
ModifyTime = DateTime.Now,
IsDeleted = "0"
};
baseEntities.Set <S_A_User>().Add(user);
//反写userID
employee.UserID = user.ID;
List <string> orgIDList = new List <string>();
List <S_A_Org> orgList = baseEntities.Set <S_A_Org>().Where(a => a.IsDeleted == "0").ToList();
S_A_Org org = null;
if (employee.DeptID != null)
{
org = orgList.Where(c => c.ID == employee.DeptID && c.IsDeleted == "0").FirstOrDefault();
}
if (org == null)
{
org = orgList.Where(c => c.ParentID == null || c.ParentID == "").FirstOrDefault();
}
if (org != null)
{
user.DeptID = org.ID;
user.DeptName = org.Name;
user.DeptFullID = org.FullID;
string companyID = "";
string companyName = "";
//逆序判断类型是否为集团/公司
string[] orgIDs = org.FullID.Split('.');
var orgs = orgList.Where(c => orgIDs.Contains(c.ID)).ToDictionary <S_A_Org, string>(d => d.ID);
for (var i = orgIDs.Length; i > 0; i--)
{
if ((orgs[orgIDs[i - 1]].Type ?? "none").IndexOf("Company") > -1)
{
companyID = orgs[orgIDs[i - 1]].ID;
companyName = orgs[orgIDs[i - 1]].Name;
break;
}
}
user.CorpID = companyID;
user.CorpName = companyName;
}
if (!string.IsNullOrEmpty(user.DeptFullID))
{
foreach (var id in user.DeptFullID.Split('.'))
{
if (!orgIDList.Contains(id))
{
S_A__OrgUser orgUser = new S_A__OrgUser();
orgUser.OrgID = id;
orgUser.UserID = user.ID;
baseEntities.Set <S_A__OrgUser>().Add(orgUser);
orgIDList.Add(id);
}
}
}
if (!string.IsNullOrEmpty(employee.ParttimeDeptID))
{
foreach (var id in employee.ParttimeDeptID.Split(','))
{
var parttimeOrg = orgList.FirstOrDefault(c => c.ID == employee.DeptID);
if (parttimeOrg != null)
{
foreach (var parttimeOrgID in parttimeOrg.FullID.Split('.'))
{
if (!orgIDList.Contains(parttimeOrgID))
{
S_A__OrgUser orgUser = new S_A__OrgUser();
orgUser.OrgID = parttimeOrgID;
orgUser.UserID = user.ID;
baseEntities.Set <S_A__OrgUser>().Add(orgUser);
orgIDList.Add(id);
}
}
}
}
}
//添加用户图片
S_A_UserImg userImg = new S_A_UserImg()
{
ID = FormulaHelper.CreateGuid(),
UserID = user.ID,
Picture = employee.Portrait,
SignImg = employee.SignImage
};
baseEntities.Set <S_A_UserImg>().Add(userImg);
entities.SaveChanges();
baseEntities.SaveChanges();
}
