public List <Operator> GetOperatorListBySql(string sql) { List <Operator> operators = new List <Operator>(); using (SqlDataReader r = DBHelper.GetReader(sql)) { while (r.Read()) { Operator op = new Operator(r); SqlAccountProvider ap = new SqlAccountProvider(); SqlDepartmentProvider dp = new SqlDepartmentProvider(); op.Department = dp.GetDepartmentById(r["DepartmentId"].ToString()); op.Account = ap.GetAccountByAccountId(r["accountId"].ToString()); operators.Add(op); } return(operators); } }
public Operator GetOperatorBySql(string sql) { Operator operators = new Operator(); using (SqlDataReader r = DBHelper.GetReader(sql)) { if (r.Read()) { Operator op = new Operator(r); SqlAccountProvider ap = new SqlAccountProvider(); SqlDepartmentProvider dp = new SqlDepartmentProvider(); op.Department = dp.GetDepartmentById(r["DepartmentId"].ToString()); op.Account = ap.GetAccountByAccountId(r["accountId"].ToString()); return(op); } else { return(null); } } }
public Operator GetOperatorBySql(string sql) { Operator operators = new Operator(); using (SqlDataReader r = DBHelper.GetReader(sql)) { if (r.Read()) { Operator op = new Operator(r); SqlAccountProvider ap = new SqlAccountProvider(); SqlDepartmentProvider dp = new SqlDepartmentProvider(); op.Department = dp.GetDepartmentById(r["DepartmentId"].ToString()); op.Account = ap.GetAccountByAccountId(r["accountId"].ToString()); return op; } else { return null; } } }
public List<Operator> GetOperatorListBySql(string sql) { List<Operator> operators = new List<Operator>(); using (SqlDataReader r = DBHelper.GetReader(sql)) { while (r.Read()) { Operator op = new Operator(r); SqlAccountProvider ap = new SqlAccountProvider(); SqlDepartmentProvider dp = new SqlDepartmentProvider(); op.Department = dp.GetDepartmentById(r["DepartmentId"].ToString()); op.Account = ap.GetAccountByAccountId(r["accountId"].ToString()); operators.Add(op); } return operators; } }