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