/// <summary>
/// 查询实体
/// </summary>
private List <SC_OrderDetailedArrange> GetList(string sql, IList <DbParameter> parameters)
{
List <SC_OrderDetailedArrange> ls = new List <SC_OrderDetailedArrange>();
SqlDataReader reader = (SqlDataReader)_commonDbConneciton.ExecuteReader(sql, parameters);
SC_OrderDetailedArrange model;
while (reader.Read())
{
model = new SC_OrderDetailedArrange();
model = GetEntity(reader);
ls.Add(model);
}
reader.Close();
return(ls);
}
/// <summary>
/// 查询模具列表
/// </summary>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
private List <Roles> GetList(string sql, IList <DbParameter> parameters)
{
List <Roles> ls = new List <Roles>();
SqlDataReader reader = (SqlDataReader)_commonDbConneciton.ExecuteReader(sql, parameters);
Roles model;
while (reader.Read())
{
model = new Roles();
GetRoles(reader, ref model);
ls.Add(model);
}
reader.Close();
return(ls);
}
/// <summary>
/// 判断账号是否存在
/// </summary>
/// <param name="userAccount"></param>
/// <returns></returns>
public bool ExsitModel(string userAccount)
{
string sql = "SELECT COUNT(UserID) AS [Count] FROM [QX_Users] WHERE [UserAccount] = @UserAccount";
IList <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_commonDbConneciton.CreateSqlParameter("@UserAccount", SqlDbType.NVarChar, 50, userAccount));
SqlDataReader reader = (SqlDataReader)_commonDbConneciton.ExecuteReader(sql, parameters);
int count = 0;
while (reader.Read())
{
count = Convert.ToInt32(reader["Count"]);
}
return(count > 0);
}
