public List<BussinessRoleONOR> CombinRole(BussinessRoleOnBussOR windowRole, BussinessRoleOnBussOR empRole) { if (windowRole == null && empRole == null) return null; if (windowRole == null || empRole == null) { if (windowRole == null) return empRole.BussRoleOnList; if (empRole == null) return windowRole.BussRoleOnList; } List<BussinessRoleONOR> list = new List<BussinessRoleONOR>(); foreach (BussinessRoleONOR w in windowRole.BussRoleOnList) { foreach (BussinessRoleONOR e in empRole.BussRoleOnList) { if (w.Bussinessid == e.Bussinessid) { list.Add(e); break; } } } return list; }
public List<BussinessRoleOnBussOR> selectAllBussinessRoleOnBuss() { string sql = "select * from t_BussinessRole"; DataTable dt = null; try { dt = dbMySql.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } if (dt == null) { return null; } List<BussinessRoleOnBussOR> listBuss = new List<BussinessRoleOnBussOR>(); foreach (DataRow dr in dt.Rows) { BussinessRoleOnBussOR obj = new BussinessRoleOnBussOR(dr); listBuss.Add(obj); } return listBuss; }