//根据管理员编号,获取管理员信息 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)); }