/// <summary> /// 获得数据列表 /// </summary> public List<BWS.ERP.Model.hrEmployeeEntity> DataTableToList(DataTable dt) { List<BWS.ERP.Model.hrEmployeeEntity> modelList = new List<BWS.ERP.Model.hrEmployeeEntity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { BWS.ERP.Model.hrEmployeeEntity model; for (int n = 0; n < rowsCount; n++) { model = new BWS.ERP.Model.hrEmployeeEntity(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } model.sEmpNo = dt.Rows[n]["sEmpNo"].ToString(); model.sEmpCName = dt.Rows[n]["sEmpCName"].ToString(); model.sEmpEName = dt.Rows[n]["sEmpEName"].ToString(); model.sIsInService = dt.Rows[n]["sIsInService"].ToString(); model.sEmpContractID = dt.Rows[n]["sEmpContractID"].ToString(); model.sResidenceType = dt.Rows[n]["sResidenceType"].ToString(); model.sInsureID = dt.Rows[n]["sInsureID"].ToString(); model.sPayMentID = dt.Rows[n]["sPayMentID"].ToString(); model.sSex = dt.Rows[n]["sSex"].ToString(); model.dBirthday = dt.Rows[n]["dBirthday"].ToString(); model.dBabyBirthday = dt.Rows[n]["dBabyBirthday"].ToString(); model.sIdentityCard = dt.Rows[n]["sIdentityCard"].ToString(); model.sNation = dt.Rows[n]["sNation"].ToString(); model.sMarry = dt.Rows[n]["sMarry"].ToString(); if (dt.Rows[n]["sStature"].ToString() != "") { model.sStature = int.Parse(dt.Rows[n]["sStature"].ToString()); } model.sPolityStatus = dt.Rows[n]["sPolityStatus"].ToString(); model.sNativePlace = dt.Rows[n]["sNativePlace"].ToString(); model.sBrood = dt.Rows[n]["sBrood"].ToString(); model.sStudyExperience = dt.Rows[n]["sStudyExperience"].ToString(); model.sGraduateInstitute = dt.Rows[n]["sGraduateInstitute"].ToString(); model.sSpeciality = dt.Rows[n]["sSpeciality"].ToString(); model.dInCompanyDate = dt.Rows[n]["dInCompanyDate"].ToString(); if (dt.Rows[n]["iDepartmentID"].ToString() != "") { model.iDepartmentID = int.Parse(dt.Rows[n]["iDepartmentID"].ToString()); } model.sEmpType = dt.Rows[n]["sEmpType"].ToString(); model.sCallTitle = dt.Rows[n]["sCallTitle"].ToString(); model.dCallTitleDate = dt.Rows[n]["dCallTitleDate"].ToString(); model.sPosition = dt.Rows[n]["sPosition"].ToString(); model.sForeignLangaugeLevel = dt.Rows[n]["sForeignLangaugeLevel"].ToString(); model.sComputerTechnolic = dt.Rows[n]["sComputerTechnolic"].ToString(); model.sEmail = dt.Rows[n]["sEmail"].ToString(); model.sPersonContactTel = dt.Rows[n]["sPersonContactTel"].ToString(); model.sFamilyContactTel = dt.Rows[n]["sFamilyContactTel"].ToString(); model.sOtherContact = dt.Rows[n]["sOtherContact"].ToString(); model.sResidence = dt.Rows[n]["sResidence"].ToString(); model.sFamilyAddr = dt.Rows[n]["sFamilyAddr"].ToString(); model.sFamilyMember = dt.Rows[n]["sFamilyMember"].ToString(); model.sStudyExperienct = dt.Rows[n]["sStudyExperienct"].ToString(); model.sWorkExperience = dt.Rows[n]["sWorkExperience"].ToString(); model.dTryoutDate = dt.Rows[n]["dTryoutDate"].ToString(); model.dFormalDate = dt.Rows[n]["dFormalDate"].ToString(); if (dt.Rows[n]["mPic"].ToString() != "") { model.mPic = (byte[])dt.Rows[n]["mPic"]; } model.dEndDate = dt.Rows[n]["dEndDate"].ToString(); model.sRemark = dt.Rows[n]["sRemark"].ToString(); if (dt.Rows[n]["iFlag"].ToString() != "") { model.iFlag = int.Parse(dt.Rows[n]["iFlag"].ToString()); } model.sUserID = dt.Rows[n]["sUserID"].ToString(); modelList.Add(model); } } return modelList; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWS.ERP.Model.hrEmployeeEntity model, SqlTransaction trans) { return(dal.Add(model, trans)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(BWS.ERP.Model.hrEmployeeEntity model, SqlTransaction trans) { dal.Update(model, trans); }
/// <summary> /// 获得数据列表 /// </summary> public List <BWS.ERP.Model.hrEmployeeEntity> DataTableToList(DataTable dt) { List <BWS.ERP.Model.hrEmployeeEntity> modelList = new List <BWS.ERP.Model.hrEmployeeEntity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { BWS.ERP.Model.hrEmployeeEntity model; for (int n = 0; n < rowsCount; n++) { model = new BWS.ERP.Model.hrEmployeeEntity(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } model.sEmpNo = dt.Rows[n]["sEmpNo"].ToString(); model.sEmpCName = dt.Rows[n]["sEmpCName"].ToString(); model.sEmpEName = dt.Rows[n]["sEmpEName"].ToString(); model.sIsInService = dt.Rows[n]["sIsInService"].ToString(); model.sEmpContractID = dt.Rows[n]["sEmpContractID"].ToString(); model.sResidenceType = dt.Rows[n]["sResidenceType"].ToString(); model.sInsureID = dt.Rows[n]["sInsureID"].ToString(); model.sPayMentID = dt.Rows[n]["sPayMentID"].ToString(); model.sSex = dt.Rows[n]["sSex"].ToString(); model.dBirthday = dt.Rows[n]["dBirthday"].ToString(); model.dBabyBirthday = dt.Rows[n]["dBabyBirthday"].ToString(); model.sIdentityCard = dt.Rows[n]["sIdentityCard"].ToString(); model.sNation = dt.Rows[n]["sNation"].ToString(); model.sMarry = dt.Rows[n]["sMarry"].ToString(); if (dt.Rows[n]["sStature"].ToString() != "") { model.sStature = int.Parse(dt.Rows[n]["sStature"].ToString()); } model.sPolityStatus = dt.Rows[n]["sPolityStatus"].ToString(); model.sNativePlace = dt.Rows[n]["sNativePlace"].ToString(); model.sBrood = dt.Rows[n]["sBrood"].ToString(); model.sStudyExperience = dt.Rows[n]["sStudyExperience"].ToString(); model.sGraduateInstitute = dt.Rows[n]["sGraduateInstitute"].ToString(); model.sSpeciality = dt.Rows[n]["sSpeciality"].ToString(); model.dInCompanyDate = dt.Rows[n]["dInCompanyDate"].ToString(); if (dt.Rows[n]["iDepartmentID"].ToString() != "") { model.iDepartmentID = int.Parse(dt.Rows[n]["iDepartmentID"].ToString()); } model.sEmpType = dt.Rows[n]["sEmpType"].ToString(); model.sCallTitle = dt.Rows[n]["sCallTitle"].ToString(); model.dCallTitleDate = dt.Rows[n]["dCallTitleDate"].ToString(); model.sPosition = dt.Rows[n]["sPosition"].ToString(); model.sForeignLangaugeLevel = dt.Rows[n]["sForeignLangaugeLevel"].ToString(); model.sComputerTechnolic = dt.Rows[n]["sComputerTechnolic"].ToString(); model.sEmail = dt.Rows[n]["sEmail"].ToString(); model.sPersonContactTel = dt.Rows[n]["sPersonContactTel"].ToString(); model.sFamilyContactTel = dt.Rows[n]["sFamilyContactTel"].ToString(); model.sOtherContact = dt.Rows[n]["sOtherContact"].ToString(); model.sResidence = dt.Rows[n]["sResidence"].ToString(); model.sFamilyAddr = dt.Rows[n]["sFamilyAddr"].ToString(); model.sFamilyMember = dt.Rows[n]["sFamilyMember"].ToString(); model.sStudyExperienct = dt.Rows[n]["sStudyExperienct"].ToString(); model.sWorkExperience = dt.Rows[n]["sWorkExperience"].ToString(); model.dTryoutDate = dt.Rows[n]["dTryoutDate"].ToString(); model.dFormalDate = dt.Rows[n]["dFormalDate"].ToString(); if (dt.Rows[n]["mPic"].ToString() != "") { model.mPic = (byte[])dt.Rows[n]["mPic"]; } model.dEndDate = dt.Rows[n]["dEndDate"].ToString(); model.sRemark = dt.Rows[n]["sRemark"].ToString(); if (dt.Rows[n]["iFlag"].ToString() != "") { model.iFlag = int.Parse(dt.Rows[n]["iFlag"].ToString()); } model.sUserID = dt.Rows[n]["sUserID"].ToString(); modelList.Add(model); } } return(modelList); }