/// <summary>
/// 分业
/// </summary>
/// <param name="pageindex"></param>
/// <param name="pagenum"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public static List <BillModel.Consume> PageGetConsumes(int pageindex, int pagenum, out int pageCount)
{
List <BillModel.Consume> list = new List <BillModel.Consume>();
SqlParameter[] p =
{
new SqlParameter("@pageIndex", pageindex),
new SqlParameter("@pageCount", pagenum),
new SqlParameter("@pageTotalCount", SqlDbType.Int)
};
p[2].Direction = ParameterDirection.Output;
DataSet dataSet = DBHepler.GetDataSet("proc_Users", CommandType.StoredProcedure, p);
pageCount = Convert.ToInt32(p[2].Value);
foreach (DataRow item in dataSet.Tables[0].Rows)
{
BillModel.Consume consume = new BillModel.Consume();
consume.Cexplain = item["Cexplain"].ToString();
consume.Cid = (int)item["Cid"];
consume.Cimage = item["Cimage"].ToString();
consume.Cincome = (int)item["Cincome"];
consume.Cmoney = (decimal)item["Cmoney"];
consume.Cmoneys = (decimal)item["Cmoneys"];
consume.Ctime = (DateTime)item["Ctime"];
consume.Ctype = item["Ctype"].ToString();
consume.Userid = (int)item["Userid"];
list.Add(consume);
}
return(list);
}
/// <summary>
/// 查看数据
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public static List <BillModel.Consume> GetConsumes(string where = null)
{
List <BillModel.Consume> List = new List <BillModel.Consume>();
string sql = " select * from Consume where Userid = 1";
SqlDataReader dataReader = DBHepler.ExecuteReader(sql);
if (dataReader != null)
{
while (dataReader.Read())
{
List.Add(new BillModel.Consume()
{
Cexplain = dataReader["Cexplain"] as string,
Cid = (int)dataReader["Cid"],
Cimage = dataReader["Cimage"] as string,
Cincome = (int)dataReader["Cincome"],
Cmoney = (decimal)dataReader["Cmoney"],
Cmoneys = (decimal)dataReader["Cmoneys"],
Ctime = (DateTime)dataReader["Ctime"],
Ctype = dataReader["Ctype"] as string,
Userid = (int)dataReader["Userid"]
});
}
}
DBHepler.Close();
return(List);
}
/// <summary>
/// 注册用户
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public static int InsertUser(BillModel.Users users)
{
string sqlstr = "insert Users values(@UName, @UPhone, @UPwd)";
SqlParameter[] p =
{
new SqlParameter("@UName", users.Uname),
new SqlParameter("@UPhone", users.Uphone),
new SqlParameter("@UPwd", users.Upwd)
};
return(DBHepler.ExecuteNonQuery(sqlstr, p));
}
/// <summary>
/// 查询用户
/// </summary>
/// <returns></returns>
public static List <BillModel.Users> GetUsers()
{
List <BillModel.Users> modelList = new List <BillModel.Users>();
string sqlstr = "select * from Users ";
SqlDataReader dr = DBHepler.ExecuteReader(sqlstr);
BillModel.Users model = null;
while (dr.Read())
{
model = new BillModel.Users();
model.UserID = (int)dr["UserID"];
model.Uname = dr["UName"].ToString();
model.Upwd = dr["UPwd"].ToString();
model.Uphone = dr["Uphone"].ToString();
modelList.Add(model);
}
dr.Close();
return(modelList);
}
