/// <summary> /// 同步薪酬体系 /// </summary> public static void SychSalaryPlan() { //添加所有PS中存在的记录 foreach (SalPlan sp in SalPlan.薪酬体系) { AddSalaryPlan(sp.集合, sp.英文名, sp.中文名, sp.状态); } //冲突处理:有VS无 / 有VS变 / 无VS有 List <SalaryPlan> all = GetAll(); foreach (SalaryPlan plan in all) { SalPlan sp = SalPlan.薪酬体系.Find(a => a.集合 == plan.集合 && a.英文名 == plan.英文名); if (sp == null) { plan.Delete(); } } }
//获取值列表 public static List <SalPlan> GetAll() { List <SalPlan> list = new List <SalPlan>(); OleDbConnection conn = new OleDbConnection(MyHelper.GetPsConnectionString()); using (conn) { OleDbDataReader rs = null; try { conn.Open(); using (OleDbCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select setid, sal_admin_plan, descr, effdt, eff_status from SYSADM.PS_SAL_PLAN_TBL order by setid, sal_admin_plan"; rs = cmd.ExecuteReader(); while (rs.Read()) { SalPlan salPlan = new SalPlan(); salPlan.集合 = (string)rs["setid"]; salPlan.英文名 = (string)rs["sal_admin_plan"]; salPlan.中文名 = (string)rs["descr"]; salPlan.状态 = ((string)rs["eff_status"]).Trim(); list.Add(salPlan); } } } finally { if (rs != null) { rs.Close(); } conn.Close(); } } return(list); }