Ejemplo n.º 1
0
        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;
        }
Ejemplo n.º 2
0
        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;
        }