public SYS_MENU GetMenuByCode(string code)
{
string sql = "select *from sys_menu where Menu_code=@code and Menu_unit is not null";
SqlDataReader reader = SqlHelper_cory.ExecuteReader(sql, CommandType.Text, new SqlParameter("@code", code));
SYS_MENU model = new SYS_MENU();
if (reader.HasRows)
{
if (reader.Read())
{
model.MENU_CODE = reader.GetString(reader.GetOrdinal("MENU_CODE"));
model.MENU_NAME = reader.GetString(reader.GetOrdinal("MENU_NAME"));
model.MENU_UNIT = reader.GetString(reader.GetOrdinal("MENU_UNIT"));
model.PARENT_MENU_CODE = reader.GetString(reader.GetOrdinal("PARENT_MENU_CODE"));
}
}
return(model);
}
/// <summary>
/// 根据ID返回实体
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public SYS_USER CheckUid(string uid)
{
string sql = "select * from SYS_USER where USER_CODE=@uid";
using (SqlDataReader reader = SqlHelper_cory.ExecuteReader(sql, CommandType.Text, new SqlParameter("@uid", uid)))
{
SYS_USER model = new SYS_USER();
if (reader.HasRows)
{
if (reader.Read())
{
model.USER_CODE = reader.GetString(reader.GetOrdinal("USER_CODE"));
model.PASSWORD = reader.GetString(reader.GetOrdinal("PASSWORD"));
model.USER_NAME = reader.GetString(reader.GetOrdinal("USER_NAME"));
model.STOCK_CODE = reader.GetString(reader.GetOrdinal("STOCK_CODE"));
model.STOCK_NAME = reader.GetString(reader.GetOrdinal("STOCK_NAME"));
model.PPRICE_SHOW = reader.GetBoolean(reader.GetOrdinal("PPRICE_SHOW"));
model.DEPARTMENT_CODE = reader.GetString(reader.GetOrdinal("DEPARTMENT_CODE"));
model.DEPARTMENT_NAME = reader.GetString(reader.GetOrdinal("DEPARTMENT_NAME"));
}
}
return(model);
}
}