private async Task <bool> UpdateStaff() { var success = true; await ServiceProxyFactory.LifeTime(async factory => { StaffResult saveResult = null; Staff staff = new Staff(); staff.CompanyId = CompanyId; staff.Code = txtStaffCode.Text; staff.Name = txtStaffName.Text.Trim(); staff.DepartmentId = DeparmentId; staff.Mail = txtStaffMail.Text.Trim(); staff.Tel = txtStaffTel.Text.Trim(); staff.Fax = txtStaffFax.Text.Trim(); staff.UpdateBy = Login.UserId; staff.UpdateAt = DateTime.Now; staff.CreateBy = Login.UserId; staff.CreateAt = DateTime.Now; staff.Id = StaffId; staff.DepartmentCode = txtDepartmentCode.Text; staff.DepartmentName = lblDepartmentName.Text; var service = factory.Create <StaffMasterClient>(); saveResult = await service.SaveAsync(SessionKey, staff); success = saveResult?.ProcessResult.Result ?? false; var syncResult = true; if (SavePostProcessor != null && success) { syncResult = SavePostProcessor.Invoke(new IMasterData[] { saveResult.Staff as IMasterData }); } success &= syncResult; if (success) { await LoadStaffGrid(); } }); return(success); }
public StaffResult getOneStaffDataBase(string sID) { StaffDataBase sDB = new StaffDataBase(); sDB.personnelFunction(); StaffResult returnValue = new StaffResult(); if (int.Parse(sDB._StaffhaveRoles[3]) == 1) { returnValue=sDB.getOneStaffDataBase(sID); } else { returnValue.checkNo = _noRole; returnValue.errorMsg = _errorMsg; } List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); if (returnValue.StaffBaseData.unit != UserFile[2] && int.Parse(sDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0) { returnValue.checkNo = _getcheckNo; returnValue.errorMsg = _errorMsg; } return returnValue; }
public StaffResult getOneStaffDataBase(string ID) { StaffResult returnValue = new StaffResult(); returnValue.StaffBaseData = new CreateStaff(); returnValue.WorkData = new List<staffWorkData>(); DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT * FROM StaffDatabase WHERE isDeleted=0 AND ID=(@ID)"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = Int64.Parse(ID); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { CreateStaff addValue1 = new CreateStaff(); addValue1.FamilyStatu = new List<string[]>(); addValue1.SpecialtySkill = new List<string[]>(); returnValue.ID = Int64.Parse(dr["ID"].ToString()); addValue1.unit = dr["Unit"].ToString(); addValue1.staffID = dr["StaffID"].ToString(); addValue1.staffName = dr["StaffName"].ToString(); addValue1.officeDate = DateTime.Parse(dr["AppointmentDate"].ToString()).ToString("yyyy-MM-dd"); addValue1.resignDate = DateTime.Parse(dr["ResignationDate"].ToString()).ToString("yyyy-MM-dd"); addValue1.applyJob = dr["WorkItem"].ToString(); addValue1.jobTitle = dr["JobCapacity"].ToString(); addValue1.jobLevel = dr["JobGrade"].ToString(); addValue1.staffTWID = dr["StaffIdentity"].ToString(); addValue1.staffPhoto = dr["StaffAvatar"].ToString(); addValue1.comeCity = dr["Hometown"].ToString(); addValue1.staffbirthday = DateTime.Parse(dr["Birthday"].ToString()).ToString("yyyy-MM-dd"); addValue1.staffsex = dr["sex"].ToString(); addValue1.marriage = dr["Marriage"].ToString(); addValue1.censusAddress = dr["AddressOther1"].ToString(); addValue1.censusAddressZip = dr["AddressZip1"].ToString(); addValue1.censusCity = dr["AddressCity1"].ToString(); addValue1.address = dr["AddressOther2"].ToString(); addValue1.addressCity = dr["AddressCity2"].ToString(); addValue1.addressZip = dr["AddressZip2"].ToString(); addValue1.TDaytime = dr["TelDaytime"].ToString(); addValue1.TNight = dr["TelNight"].ToString(); addValue1.Phone = dr["Phone"].ToString(); addValue1.staffemail = dr["Email"].ToString(); addValue1.EmergencyName = dr["UrgentContactName"].ToString(); addValue1.EmergencyAddress = dr["UrgentContactAddress"].ToString(); addValue1.EmergencyPhone = dr["UrgentContactTel"].ToString(); addValue1.DSchoolName = dr["DoctorSchoolName"].ToString(); addValue1.DDepartment = dr["DoctorDepartment"].ToString(); addValue1.DSince = dr["DoctorSince"].ToString(); addValue1.DUntil = dr["DoctorUntil"].ToString(); addValue1.study1 = dr["DoctorState"].ToString(); addValue1.MSchoolName = dr["MasterSchoolName"].ToString(); addValue1.MDepartment = dr["MasterDepartment"].ToString(); addValue1.MSince = dr["MasterSince"].ToString(); addValue1.MUntil = dr["MasterUntil"].ToString(); addValue1.study2 = dr["MasterState"].ToString(); addValue1.USchoolName = dr["UniversitySchoolName"].ToString(); addValue1.UDepartment = dr["UniversityDepartment"].ToString(); addValue1.USince = dr["UniversitySince"].ToString(); addValue1.UUntil = dr["UniversityUntil"].ToString(); addValue1.study3 = dr["UniversityState"].ToString(); addValue1.VSchoolName = dr["VocationalSchoolName"].ToString(); addValue1.VDepartment = dr["VocationalDepartment"].ToString(); addValue1.VSince = dr["VocationalSince"].ToString(); addValue1.VUntil = dr["VocationalUntil"].ToString(); addValue1.study4 = dr["VocationalState"].ToString(); addValue1.JDateSince1 = dr["Experience1Since"].ToString(); addValue1.JDateUntil1 = dr["Experience1Until"].ToString(); addValue1.JCname1 = dr["Experience1Company"].ToString(); addValue1.Jposition1 = dr["Experience1Post"].ToString(); addValue1.Jsalary1 = dr["Experience1Salary"].ToString(); addValue1.prove1 = dr["Experience1Prove"].ToString(); addValue1.JTitle1 = dr["Experience1Director"].ToString(); addValue1.JTitleName1 = dr["Experience1DirectorName"].ToString(); addValue1.JDateSince2 = dr["Experience2Since"].ToString(); addValue1.JDateUntil2 = dr["Experience2Until"].ToString(); addValue1.JCname2 = dr["Experience2Company"].ToString(); addValue1.Jposition2 = dr["Experience2Post"].ToString(); addValue1.Jsalary2 = dr["Experience2Salary"].ToString(); addValue1.prove2 = dr["Experience2Prove"].ToString(); addValue1.JTitle2 = dr["Experience2Director"].ToString(); addValue1.JTitleName2 = dr["Experience2DirectorName"].ToString(); addValue1.JDateSince3 = dr["Experience3Since"].ToString(); addValue1.JDateUntil3 = dr["Experience3Until"].ToString(); addValue1.JCname3 = dr["Experience3Company"].ToString(); addValue1.Jposition3 = dr["Experience3Post"].ToString(); addValue1.Jsalary3 = dr["Experience3Salary"].ToString(); addValue1.prove3 = dr["Experience3Prove"].ToString(); addValue1.JTitle3 = dr["Experience3Director"].ToString(); addValue1.JTitleName3 = dr["Experience3DirectorName"].ToString(); addValue1.JDateSince4 = dr["Experience4Since"].ToString(); addValue1.JDateUntil4 = dr["Experience4Until"].ToString(); addValue1.JCname4 = dr["Experience4Company"].ToString(); addValue1.Jposition4 = dr["Experience4Post"].ToString(); addValue1.Jsalary4 = dr["Experience4Salary"].ToString(); addValue1.prove4 = dr["Experience4Prove"].ToString(); addValue1.JTitle4 = dr["Experience4Director"].ToString(); addValue1.JTitleName4 = dr["Experience4DirectorName"].ToString(); for (int i = 1; i <= 6; i++) { string[] Familyitem = new string[4]; Familyitem[0] = dr["Family" + i + "Title"].ToString(); Familyitem[1] = dr["Family" + i + "Name"].ToString(); Familyitem[2] = dr["Family" + i + "Age"].ToString(); Familyitem[3] = dr["Family" + i + "Profession"].ToString(); addValue1.FamilyStatu.Add(Familyitem); } addValue1.bailName = dr["GuarantorName"].ToString(); addValue1.bailUnit = dr["GuarantorUnit"].ToString(); addValue1.bailJob = dr["GuarantorPost"].ToString(); addValue1.bailRelationship = dr["GuarantorRelationship"].ToString(); addValue1.bailContact = dr["GuarantorContact"].ToString(); addValue1.bailContactTime = dr["GuarantorContactTime"].ToString(); addValue1.recruited = dr["CandidatesMessage"].ToString(); addValue1.recruitedText = dr["MessageExplain"].ToString(); addValue1.langAbility1 = dr["Language1Name"].ToString(); addValue1.langL1 = dr["Language1Listen"].ToString(); addValue1.langS1 = dr["Language1Say"].ToString(); addValue1.langR1 = dr["Language1Read"].ToString(); addValue1.langW1 = dr["Language1Write"].ToString(); addValue1.langAbility2 = dr["Language2Name"].ToString(); addValue1.langL2 = dr["Language2Listen"].ToString(); addValue1.langS2 = dr["Language2Say"].ToString(); addValue1.langR2 = dr["Language2Read"].ToString(); addValue1.langW2 = dr["Language2Write"].ToString(); addValue1.langAbility3 = dr["Language3Name"].ToString(); addValue1.langL3 = dr["Language3Listen"].ToString(); addValue1.langS3 = dr["Language3Say"].ToString(); addValue1.langR3 = dr["Language3Read"].ToString(); addValue1.langW3 = dr["Language3Write"].ToString(); for (int i = 1; i <= 4; i++) { string[] SpecialtySkillitem = new string[6]; SpecialtySkillitem[0] = dr["ExpertiseSkill" + i].ToString(); SpecialtySkillitem[1] = dr["ExpertiseSkill" + i + "License"].ToString(); SpecialtySkillitem[2] = dr["ExpertiseSkill" + i + "Progression"].ToString(); SpecialtySkillitem[3] = dr["ExpertiseSkill" + i + "GetUnit"].ToString(); SpecialtySkillitem[4] = DateTime.Parse(dr["ExpertiseSkill" + i + "GetDate"].ToString()).ToString("yyyy-MM-dd"); SpecialtySkillitem[5] = DateTime.Parse(dr["ExpertiseSkill" + i + "ValidDate"].ToString()).ToString("yyyy-MM-dd"); addValue1.SpecialtySkill.Add(SpecialtySkillitem); } addValue1.disease = dr["Disease"].ToString(); addValue1.diseaseText = dr["DiseaseExplain"].ToString(); addValue1.fillInDate = DateTime.Parse(dr["FileDate"].ToString()).ToString("yyyy-MM-dd"); addValue1.TrialStart = DateTime.Parse(dr["TrialStart"].ToString()).ToString("yyyy-MM-dd"); addValue1.TrialEnd = DateTime.Parse(dr["TrialEnd"].ToString()).ToString("yyyy-MM-dd"); addValue1.DealStart = DateTime.Parse(dr["DealStart"].ToString()).ToString("yyyy-MM-dd"); addValue1.DealEnd = DateTime.Parse(dr["DealEnd"].ToString()).ToString("yyyy-MM-dd"); addValue1.CardNum = dr["CardNum"].ToString(); returnValue.StaffBaseData = addValue1; returnValue.WorkData = this.GetStaffWorkData(dr["StaffID"].ToString()); } dr.Close(); Sqlconn.Close(); } catch (Exception e) { returnValue.checkNo = "-1"; returnValue.errorMsg = e.Message; } } return returnValue; }