public object SyncToolsDepts() { try { DataTable dt = deptBll.GetDataTable(string.Format("select deptid,unitid,keys from BIS_TOOLSDEPT")); foreach (DataRow dr in dt.Rows) { DepartmentEntity dept = deptBll.GetEntity(dr[0].ToString()); if (dept != null) { SstmsService.CheckHeader header = new SstmsService.CheckHeader(); header.Key = dr[2].ToString(); List <SstmsService.DictionaryEntry> dic = new List <SstmsService.DictionaryEntry>(); SstmsService.DictionaryEntry de = new SstmsService.DictionaryEntry(); de.Key = "LaterID"; de.Value = dr[1].ToString(); dic.Add(de); de = new SstmsService.DictionaryEntry(); de.Key = "Identify"; de.Value = ""; dic.Add(de); // 实例化服务对象 SstmsService.DataServiceSoapClient service = new SstmsService.DataServiceSoapClient(); SstmsService.PersonInfo[] data = service.GetPersonsPage(header, dic.ToArray <SstmsService.DictionaryEntry>(), 1, 1000).List; DepartmentEntity org = deptBll.GetEntity(dept.OrganizeId); foreach (SstmsService.PersonInfo per in data) { string unitId = per.OwnerDeptID; string userId = ""; string roleName = "承包商级用户"; string roleId = "c5530ccf-e84e-4df8-8b27-fd8954a9bbe9"; if (dt.Rows.Count > 0) { string nature = dept.Nature; switch (nature) { case "部门": roleName = "部门级用户"; roleId = "6c094cef-cca3-4b41-a71b-6ee5e6b89008"; break; case "专业": roleName = "专业级用户"; roleId = "e3062d59-2484-4046-a420-478886d58656"; break; case "班组": roleName = "班组级用户"; roleId = "d9432a6e-5659-4f04-9c10-251654199714"; break; case "厂级": roleName = "公司级用户"; roleId = "aece6d68-ef8a-4eac-a746-e97f0067fab5"; break; case "省级": roleName = "省级用户"; roleId = "9a834c93-ff60-440e-845d-79b311eeacae"; break; } roleName += ",普通用户"; roleId += ",2a878044-06e9-4fe4-89f0-ba7bd5a1bde6"; UserEntity user = userBll.GetUserByIdCard(per.IdentifyID); if (user == null) { // userId = user.UserId; //} //else //{ user = new UserEntity(); user.UserId = Guid.NewGuid().ToString(); user.Account = per.IdentifyID; userId = user.UserId; // } user.MSN = "1"; user.UserType = "一般工作人员"; user.EnCode = per.TraID; user.Degrees = user.DegreesID = per.Degrees; user.Birthday = per.BirthDay; user.RoleId = roleId; user.RoleName = roleName; user.IdentifyID = per.IdentifyID; user.Gender = per.Sex; user.Nation = per.Nation; user.Email = per.Email; user.EnterTime = per.EntranceDate; user.RealName = per.PersonName; user.Degrees = per.Degrees; user.Native = per.Native; user.DepartureTime = per.LeaveDate; user.Telephone = per.TelPhone; user.IsPresence = per.IsOut == "是" ? "0" : "1"; user.Password = "******"; user.DepartmentId = dept.DepartmentId; user.DepartmentCode = dept.EnCode; user.OrganizeId = dept.OrganizeId; user.OrganizeCode = org.EnCode; user.Craft = per.Category; user.IsEpiboly = roleName.Contains("承包商") || roleName.Contains("分包商") ? "1" : "0"; if (user.ModifyDate != null) { if (per.OperDate > user.ModifyDate) { userBll.SaveForm(userId, user); } } else { userBll.SaveForm(userId, user); } } } } } } Task.Factory.StartNew(() => { string fileName = DateTime.Now.ToString("yyyyMMdd") + ".log"; System.IO.File.AppendAllText(HttpContext.Current.Server.MapPath("~/logs/") + fileName, string.Format("{0}:同步工具箱人员信息成功\r\n", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); }); return(new { Code = 1, message = "同步工具箱人员信息成功" }); } catch (Exception ex) { Task.Run(() => { string fileName = DateTime.Now.ToString("yyyyMMdd") + ".log"; System.IO.File.AppendAllText(HttpContext.Current.Server.MapPath("~/logs/") + fileName, string.Format("{0}:{1}\r\n", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ex.Message)); }); return(new { code = 0, message = ex.Message }); } }
public object GetTrainResult(string IdCard) { try { SstmsService.CheckHeader header = new SstmsService.CheckHeader(); header.Key = "C8E52648921869CE5BF5C80569046C11"; // 实例化服务对象 SstmsService.DataServiceSoapClient service = new SstmsService.DataServiceSoapClient(); SstmsService.Depart[] data = service.GetDeparts(header); //string json = "{\"Examdata\":[{\"PARTYID\":\"1785106885\",\"USERNAME\":\"冯亮\",\"DEPARTID\":\"-1014595119\",\"USERACCOUNT\":\"20018576\",\"DEPARTNAME\":\"人事\",\"EXAMNAME\":\"2016年非生产人员安全培训_考试\",\"EXAMSTARTTIME\":\"2016-05-31T00:00:00\",\"EXAMENDTIME\":\"2016-07-30T23:59:00\",\"TRAINPLANCODE\":\"1766144250\",\"POINT\":67.0,\"STATE\":\"合格\",\"CREATEDATE\":\"2016-06-16T10:30:09\",\"PARENTID\":\"1781654785\",\"TIMES\":null,\"PASSLINE\":\"60\",\"EXAMID\":\"-1065522118\",\"CREATENAME\":\"沙角B管理员\"},{\"PARTYID\":\"1785106885\",\"USERNAME\":\"冯亮\",\"DEPARTID\":\"-1014595119\",\"USERACCOUNT\":\"20018576\",\"DEPARTNAME\":\"人事\",\"EXAMNAME\":\"2017年非生产人员安全培训考试补考2\",\"EXAMSTARTTIME\":\"2017-08-10T15:45:00\",\"EXAMENDTIME\":\"2017-09-01T15:43:00\",\"TRAINPLANCODE\":\"1766144250\",\"POINT\":null,\"STATE\":null,\"CREATEDATE\":null,\"PARENTID\":\"1781654785\",\"TIMES\":null,\"PASSLINE\":\"60\",\"EXAMID\":\"24380e16-bd6e-4a0e-8c1c-7cc97d8fe721\",\"CREATENAME\":\"沙角B管理员\"}]}"; //var dtExams = Newtonsoft.Json.JsonConvert.DeserializeObject<DataTable>(json.Replace("{\"Examdata\":", "").TrimEnd('}')); //if (string.IsNullOrEmpty(IdCard)) //{ // return new { code = 0, result = 3, message = "身份证号不允许为空" }; //} //if(!BSFramework.Util.ValidateUtil.IsIdCard(IdCard)) //{ // return new { code = 0, result = 3, message = "身份证格式不正确" }; //} //var user = userBll.GetUserByIdCard(IdCard); //if(user==null) //{ // return new { code = 0,result=4, message = "该人员信息不存在" }; //} //bool flag=new AptitudeinvestigatepeopleBLL().IsAuditByUserId(user.UserId); //if (1!=1) //{ // return new { code = 0, result = 2, message = "资质未审核通过" }; //} //else //{ // //json = userBll.GetExamRecord(user.Account, user.DepartmentId); // if (json.Length > 30) // { // //dtExams = Newtonsoft.Json.JsonConvert.DeserializeObject<DataTable>(json.Replace("{\"Examdata\":", "").TrimEnd('}')); // var rows = dtExams.Select("point is not null"); // if (rows.Count() > 0) // { // if (int.Parse(rows[0]["point"].ToString()) < int.Parse(rows[0]["passline"].ToString())) // { // return new { code = 0, result =2, message = "培训考试成绩不合格" }; // } // else // { // return new { code = 0, result =1, message = "培训考试及资质通过" }; // } // } // else // { // return new { code = 0, result = 0, message = "未参加培训考试,没有查询到记录" }; // } // } // else // { // return new { code = 0, result = 0, message = "未参加培训考试,没有查询到记录" }; // } //} return(new { Code = 0, Info = data }); } catch (Exception ex) { return(new { code = 0, result = 5, message = ex.Message }); } }