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;
}
}
