public string[] SearchStaffMeritDataBaseCount(SearchStaff SearchStaffMeritCondition) { StaffDataBase sDB = new StaffDataBase(); sDB.personnelFunction(); if (int.Parse(sDB._StaffhaveRoles[3]) == 1) { return sDB.SearchStaffMeritDataBaseCount(SearchStaffMeritCondition); } else { return new string[2] { _noRole, _errorMsg }; } }
public string[] SearchStaffDataBaseWorkCount(SearchStaff SearchStaffCondition) { StaffDataBase sDB = new StaffDataBase(); return sDB.SearchStaffDataBaseWorkCount(SearchStaffCondition); }
public List<StaffMeritDataList> SearchStaffMeritDataBase(int index, SearchStaff SearchStaffMeritCondition) { StaffDataBase sDB = new StaffDataBase(); return sDB.SearchStaffMeritDataBase(index, SearchStaffMeritCondition); }
public string[] SearchStaffDataBaseCountCase(SearchStaff SearchStaffCondition, string getid) { StaffDataBase sDB = new StaffDataBase(); return sDB.SearchStaffDataBaseCountCase(SearchStaffCondition, getid); }
public List<WorkRecordManagePeople> SearchStaffDataBaseWork(int index, SearchStaff SearchStaffCondition) { StaffDataBase sDB = new StaffDataBase(); return sDB.SearchStaffDataBaseWork(index, SearchStaffCondition); }
public string[] SearchStaffDataBaseWorkCount(SearchStaff SearchStaffConditionData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = "0"; DataBase Base = new DataBase(); string SearchStaffCondition = "and (ResignationDate='1900-01-01' or ResignationDate>@SearchDate ) and AppointmentDate<@SearchDate"; using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT COUNT(*) AS QCOUNT FROM StaffDatabase WHERE isDeleted=0 " + SearchStaffCondition; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@StaffID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffID); cmd.Parameters.Add("@StaffName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchStaffConditionData.txtstaffName) + "%"; cmd.Parameters.Add("@sex", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffSex); cmd.Parameters.Add("@SearchDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayStart); cmd.Parameters.Add("@sBirthdayStart", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayStart); //cmd.Parameters.Add("@sBirthdayEnd", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayEnd); cmd.Parameters.Add("@WorkItem", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffJob); cmd.Parameters.Add("@Unit", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffUnit); returnValue[0] = cmd.ExecuteScalar().ToString(); Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
public string[] SearchStaffDataBaseCount2(SearchStaff SearchStaffCondition) { StaffDataBase sDB = new StaffDataBase(); return sDB.SearchStaffDataBaseCount(SearchStaffCondition);//不能加搜尋權限 }
public string[] SearchStaffSalaryBaseCount(SearchStaff SearchStaffConditionData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = "0"; DataBase Base = new DataBase(); string SearchStaffCondition = this.SearchStaffSalaryConditionReturn(SearchStaffConditionData); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT COUNT(*) AS QCOUNT FROM StaffSalary " + "INNER JOIN StaffDatabase ON StaffSalary.StaffID=StaffDatabase.StaffID " + "WHERE StaffSalary.isDeleted=0 " + SearchStaffCondition; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@StaffID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffID); cmd.Parameters.Add("@StaffName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchStaffConditionData.txtstaffName) + "%"; cmd.Parameters.Add("@sex", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffSex); cmd.Parameters.Add("@sBirthdayStart", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayStart); cmd.Parameters.Add("@sBirthdayEnd", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayEnd); cmd.Parameters.Add("@Unit", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffUnit); returnValue[0] = cmd.ExecuteScalar().ToString(); Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
public List<StaffDataList> SearchStaffSalaryData(int indexpage, SearchStaff SearchStaffConditionData) { List<StaffDataList> returnValue = new List<StaffDataList>(); DataBase Base = new DataBase(); string SearchStaffCondition = this.SearchStaffSalaryConditionReturn(SearchStaffConditionData); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY StaffSalary.WriteDate DESC) " + "AS RowNum, StaffSalary.*,StaffDatabase.StaffName, StaffDatabase.sex " + "FROM StaffSalary " + "INNER JOIN StaffDatabase ON StaffSalary.StaffID=StaffDatabase.StaffID WHERE StaffSalary.isDeleted=0 " + SearchStaffCondition + " ) " + "AS NewTable " + "WHERE RowNum >= (@indexpage-" + PageMinNumFunction() + ") AND RowNum <= (@indexpage)"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@indexpage", SqlDbType.Int).Value = indexpage; cmd.Parameters.Add("@StaffID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffID); cmd.Parameters.Add("@StaffName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchStaffConditionData.txtstaffName) + "%"; cmd.Parameters.Add("@sex", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffSex); cmd.Parameters.Add("@sBirthdayStart", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayStart); cmd.Parameters.Add("@sBirthdayEnd", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayEnd); cmd.Parameters.Add("@Unit", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffUnit); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { StaffDataList addValue = new StaffDataList(); addValue.ID = dr["ID"].ToString(); addValue.sID = dr["StaffID"].ToString(); addValue.sName = dr["StaffName"].ToString(); addValue.sSex = dr["sex"].ToString(); addValue.sUnit = dr["Unit"].ToString(); addValue.FileDate = DateTime.Parse(dr["WriteDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.Add(addValue); } dr.Close(); Sqlconn.Close(); } catch (Exception e) { StaffDataList addValue = new StaffDataList(); addValue.checkNo = "-1"; addValue.errorMsg = e.Message; returnValue.Add(addValue); } } return returnValue; }
private string SearchStaffWorkConditionReturn(SearchStaff SearchStaffConditionData) { string ConditionReturn = ""; string DateBase = "1900-01-01"; if (SearchStaffConditionData.txtstaffID != null) { ConditionReturn += " AND StaffID=(@StaffID) "; } if (SearchStaffConditionData.txtstaffName != null) { ConditionReturn += " AND StaffName like (@StaffName) "; } if (SearchStaffConditionData.txtstaffSex != null) { ConditionReturn += " AND sex=(@sex) "; } //if (SearchStaffConditionData.txtstaffBirthdayStart != null && SearchStaffConditionData.txtstaffBirthdayStart != DateBase) //{ // ConditionReturn += " AND "; //} //if (SearchStaffConditionData.txtstaffBirthdayStart != null && SearchStaffConditionData.txtstaffBirthdayEnd != null && SearchStaffConditionData.txtstaffBirthdayStart != DateBase && SearchStaffConditionData.txtstaffBirthdayEnd != DateBase) //{ // ConditionReturn += " AND Birthday BETWEEN (@sBirthdayStart) AND (@sBirthdayEnd) "; //} if (SearchStaffConditionData.txtstaffJob != null) { ConditionReturn += " AND WorkItem =(@WorkItem) "; } if (SearchStaffConditionData.txtstaffUnit != null) { ConditionReturn += " AND Unit =(@Unit) "; } List<string> UserFile = this.getStaffDataName(HttpContext.Current.User.Identity.Name); this.personnelFunction(); if (int.Parse(_StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0) { ConditionReturn += " AND Unit =" + UserFile[2] + " "; } return ConditionReturn; }
private string SearchStaffSalaryConditionReturn(SearchStaff SearchStaffConditionData) { string ConditionReturn = ""; string DateBase = "1900-01-01"; if (SearchStaffConditionData.txtstaffID != null) { ConditionReturn += " AND StaffSalary.StaffID=(@StaffID) "; } if (SearchStaffConditionData.txtstaffName != null) { ConditionReturn += " AND StaffDatabase.StaffName like (@StaffName) "; } if (SearchStaffConditionData.txtstaffSex != null) { ConditionReturn += " AND StaffDatabase.sex=(@sex) "; } if (SearchStaffConditionData.txtstaffBirthdayStart != null && SearchStaffConditionData.txtstaffBirthdayEnd != null && SearchStaffConditionData.txtstaffBirthdayStart != DateBase && SearchStaffConditionData.txtstaffBirthdayEnd != DateBase) { ConditionReturn += " AND StaffDatabase.Birthday BETWEEN (@sBirthdayStart) AND (@sBirthdayEnd) "; } if (SearchStaffConditionData.txtstaffUnit != null) { ConditionReturn += " AND StaffSalary.Unit =(@Unit) "; } StaffDataBase sDB = new StaffDataBase(); List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); if (int.Parse(_StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0) { ConditionReturn += " AND StaffSalary.Unit =" + UserFile[2] + " "; } return ConditionReturn; }
private string[] SearchStaffMeritConditionReturn(SearchStaff SearchStaffMeritConditionData) { string[] returnValue = new string[2]; string ConditionReturn = ""; string ConditionReturn1 = ""; string DataBase = "1900-01-01"; if (SearchStaffMeritConditionData.txtstaffID != null) { ConditionReturn += " AND StaffDatabase.StaffID=(@StaffID) "; } if (SearchStaffMeritConditionData.txtstaffName != null) { ConditionReturn += " AND StaffDatabase.StaffName like (@StaffName) "; } if (SearchStaffMeritConditionData.txtstaffSex != null) { ConditionReturn += " AND StaffDatabase.sex=(@sex) "; } if (SearchStaffMeritConditionData.txtstaffBirthdayStart != null && SearchStaffMeritConditionData.txtstaffBirthdayEnd != null && SearchStaffMeritConditionData.txtstaffBirthdayStart != DataBase && SearchStaffMeritConditionData.txtstaffBirthdayEnd != DataBase) { ConditionReturn += " AND StaffDatabase.Birthday BETWEEN (@sBirthdayStart) AND (@sBirthdayEnd) "; } if (SearchStaffMeritConditionData.txtstaffJob != null) { ConditionReturn += " AND StaffDatabase.WorkItem =(@WorkItem) "; } if (SearchStaffMeritConditionData.txtstaffUnit != null) { ConditionReturn1 += " AND EmployeePerformance.AgencyType =(@AgencyType) "; } if (SearchStaffMeritConditionData.txtstaffYear != null) { ConditionReturn1 = " AND EmployeePerformance.AcademicYear =(@AcademicYear) "; } List<string> UserFile = this.getStaffDataName(HttpContext.Current.User.Identity.Name); this.personnelFunction(); if (int.Parse(_StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0) { ConditionReturn1 += " AND EmployeePerformance.Unit =" + UserFile[2] + " "; } returnValue[0] = ConditionReturn; returnValue[1] = ConditionReturn1; return returnValue; }
public string[] SearchStaffMeritDataBaseCount(SearchStaff SearchStaffMeritConditionData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = "0"; DataBase Base = new DataBase(); string[] ConditionReturn = this.SearchStaffMeritConditionReturn(SearchStaffMeritConditionData); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT Count(EmployeePerformance.ID) " + "FROM EmployeePerformance INNER JOIN StaffDatabase ON EmployeePerformance.EmployeeID=StaffDatabase.StaffID " + ConditionReturn[0] + "WHERE EmployeePerformance.isDeleted=0 " + ConditionReturn[1]; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@StaffID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffID); cmd.Parameters.Add("@StaffName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchStaffMeritConditionData.txtstaffName) + "%"; cmd.Parameters.Add("@sex", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffSex); cmd.Parameters.Add("@sBirthdayStart", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffMeritConditionData.txtstaffBirthdayStart); cmd.Parameters.Add("@sBirthdayEnd", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffMeritConditionData.txtstaffBirthdayEnd); cmd.Parameters.Add("@WorkItem", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffJob); cmd.Parameters.Add("@AgencyType", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffUnit); cmd.Parameters.Add("@AcademicYear", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffYear); returnValue[0] = cmd.ExecuteScalar().ToString(); Sqlconn.Close(); } catch (Exception e) { returnValue[0] ="-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
public List<StaffMeritDataList> SearchStaffMeritDataBase(int indexpage, SearchStaff SearchStaffMeritConditionData) { List<StaffMeritDataList> returnValue = new List<StaffMeritDataList>(); DataBase Base = new DataBase(); string[] ConditionReturn = this.SearchStaffMeritConditionReturn(SearchStaffMeritConditionData); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY EmployeePerformance.ID DESC) "+ "AS RowNum, EmployeePerformance.*,StaffDatabase.StaffID,StaffDatabase.StaffName,StaffDatabase.sex,StaffDatabase.Unit " + "FROM EmployeePerformance INNER JOIN StaffDatabase ON EmployeePerformance.EmployeeID=StaffDatabase.StaffID " + ConditionReturn[0] + "WHERE EmployeePerformance.isDeleted=0 " + ConditionReturn[1] + " ) " + "AS NewTable " + "WHERE RowNum >= (@indexpage-" + PageMinNumFunction() + ") AND RowNum <= (@indexpage)"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@indexpage", SqlDbType.Int).Value = indexpage; cmd.Parameters.Add("@StaffID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffID); cmd.Parameters.Add("@StaffName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchStaffMeritConditionData.txtstaffName) + "%"; cmd.Parameters.Add("@sex", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffSex); cmd.Parameters.Add("@sBirthdayStart", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffMeritConditionData.txtstaffBirthdayStart); cmd.Parameters.Add("@sBirthdayEnd", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffMeritConditionData.txtstaffBirthdayEnd); cmd.Parameters.Add("@WorkItem", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffJob); cmd.Parameters.Add("@AgencyType", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffUnit); cmd.Parameters.Add("@AcademicYear", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffMeritConditionData.txtstaffYear); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { StaffMeritDataList addValue = new StaffMeritDataList(); addValue.sData = new StaffDataList(); addValue.sData.sID = dr["StaffID"].ToString(); addValue.sData.sName = dr["StaffName"].ToString(); addValue.sData.sSex = dr["sex"].ToString(); addValue.sData.sUnit = dr["Unit"].ToString(); addValue.MID = dr["ID"].ToString(); addValue.sUnit = int.Parse(dr["AgencyType"].ToString()); addValue.AY = int.Parse(dr["AcademicYear"].ToString()); addValue.AScore = int.Parse(dr["AttendanceScore"].ToString()); addValue.PScore = int.Parse(dr["ProfessionalScore"].ToString()); addValue.WScore = int.Parse(dr["WorkAttitudeScore"].ToString()); addValue.AddScore = int.Parse(dr["AddScore"].ToString()); addValue.LowerScore = int.Parse(dr["LowerScore"].ToString()); returnValue.Add(addValue); } dr.Close(); Sqlconn.Close(); } catch (Exception e) { StaffMeritDataList addValue = new StaffMeritDataList(); addValue.sData.sID = "-1"; addValue.sData.sName = e.Message; returnValue.Add(addValue); } } return returnValue; }
public string[] SearchStaffSalaryBaseCount(SearchStaff SearchStaffCondition) { SalaryManagement smDB = new SalaryManagement(); if (int.Parse(smDB._StaffhaveRoles[3]) == 1) { return smDB.SearchStaffSalaryBaseCount(SearchStaffCondition); } else { return new string[2] { _noRole, _errorMsg }; } }
public List<StaffDataList> SearchStaffDataBaseCase(int index, SearchStaff SearchStaffCondition, int getid) { StaffDataBase sDB = new StaffDataBase(); return sDB.SearchStaffDataBaseCase(index, SearchStaffCondition, getid); }
public List<StaffDataList> SearchStaffSalaryDataBase(int index, SearchStaff SearchStaffCondition) { SalaryManagement smDB = new SalaryManagement(); return smDB.SearchStaffSalaryData(index, SearchStaffCondition); }
public List<WorkRecordManagePeople> SearchStaffDataBaseWork(int indexpage, SearchStaff SearchStaffConditionData) { List<WorkRecordManagePeople> returnValue = new List<WorkRecordManagePeople>(); DataBase Base = new DataBase(); string SearchStaffCondition = "and (ResignationDate='1900-01-01' or ResignationDate>@SearchDate ) and AppointmentDate<@SearchDate"; using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY unit,StaffID asc) " + "AS RowNum, StaffDatabase.* " + "FROM StaffDatabase WHERE isDeleted=0 " + SearchStaffCondition + " ) " + "AS NewTable " + "WHERE RowNum >= (@indexpage-" + PageMinNumFunction() + ") AND RowNum <= (@indexpage) "; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@indexpage", SqlDbType.Int).Value = indexpage; cmd.Parameters.Add("@SearchDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayStart); cmd.Parameters.Add("@StaffID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffID); cmd.Parameters.Add("@StaffName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchStaffConditionData.txtstaffName) + "%"; cmd.Parameters.Add("@sex", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffSex); cmd.Parameters.Add("@sBirthdayStart", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayStart); cmd.Parameters.Add("@sBirthdayEnd", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchStaffConditionData.txtstaffBirthdayEnd); cmd.Parameters.Add("@WorkItem", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffJob); cmd.Parameters.Add("@Unit", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(SearchStaffConditionData.txtstaffUnit); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { WorkRecordManagePeople addValue = new WorkRecordManagePeople(); addValue.StaffID = dr["StaffID"].ToString(); addValue.StaffName = dr["StaffName"].ToString(); addValue.WorkRecord = SearchStaffWorkRecord(dr["StaffID"].ToString(), SearchStaffConditionData.txtstaffBirthdayStart); WorkRecordManage thisValue = new WorkRecordManage();//新增搜尋方法 thisValue.Date = SearchStaffConditionData.txtstaffBirthdayStart; thisValue.StaffID = dr["StaffID"].ToString(); addValue.WorkRecordManage = GetWorkRecordManage(thisValue); returnValue.Add(addValue); } dr.Close(); Sqlconn.Close(); } catch (Exception e) { string Ex = e.Message.ToString(); //StaffDataList addValue = new StaffDataList(); //addValue.checkNo = "-1"; //addValue.errorMsg = e.Message.ToString(); //returnValue.Add(addValue); } } return returnValue; }