//根据管理员编号，获取管理员信息
public Model.Admin GetModel(string Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 a_id,a_name,a_pass ");
strSql.Append("from admin where a_id=@Id ");
SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) };
parameters[0].Value = Id;
Model.Admin model = new Model.Admin();
DataTable dt = DbHelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["a_id"] != null && dt.Rows[0]["a_id"].ToString() != "")
{
model.Id = dt.Rows[0]["a_id"].ToString();
}
if (dt.Rows[0]["a_name"] != null && dt.Rows[0]["a_name"].ToString() != "")
{
model.Name = dt.Rows[0]["a_name"].ToString();
}
if (dt.Rows[0]["a_pass"] != null && dt.Rows[0]["a_pass"].ToString() != "")
{
model.Pass = dt.Rows[0]["a_pass"].ToString();
}
return(model);
}
else
{
return(null);
}
}
//查询所有用户
public DataTable getAllAdmin()
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from admin");
Console.WriteLine(sb.ToString());
return(DbHelper.ExecuteDataTable(sb.ToString()));
}
//根据条件查询
public DataTable getRecordsByCondition(string str)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from book");
if (str.Trim() != "")
{
sb.Append(" where " + str);
}
return(DbHelper.ExecuteDataTable(sb.ToString()));
}
//得到最新添加的10条记录
public DataTable getLast10Records()
{
string str = "select top 10 * from book order by b_id desc";
return(DbHelper.ExecuteDataTable(str));
}
//根据关键字查询，所有字段都进行匹配
public DataTable queryByAll(string all)
{
string cmdText = "select * from book where b_id like '%" + all + "%' or b_name like '%" + all + "%' or b_author like '%" + all + "%' or b_publisher like '%" + all + "%' or b_pubtime like '%" + all + "%' or b_pritime like '%" + all + "%' or b_edition like '%" + all + "%' or b_impression like '%" + all + "%' or b_pages like '%" + all + "%' or b_words like '%" + all + "%' or b_format like '%" + all + "%' or b_paper like '%" + all + "%' or b_packaging like '%" + all + "%' or b_isbn like '%" + all + "%' or b_price like '%" + all + "%' or b_sort like '%" + all + "%' or b_inventory like '%" + all + "%'";
return(DbHelper.ExecuteDataTable(cmdText));
}
//返回提醒库存量少于10的书本的DataTable
public DataTable getWarningRecords()
{
string str = "select * from book where b_inventory < 10";
return(DbHelper.ExecuteDataTable(str));
}