public static UserInfo GetUserInfoByCard(string card)
{
string sql = string.Format("select * from Card_User where Card_User ='******'", card);
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
//List<UserInfo> list = new List<UserInfo>();
if (dr.Read())
{
UserInfo user = new UserInfo();
user.Cardid = int.Parse(dr[0].ToString());
user.Carduser = dr[1].ToString();
user.Cardpwd = dr[2].ToString();
user.Username = dr[3].ToString();
user.Userjob = dr[4].ToString();
user.Usertel = dr[5].ToString();
user.Useraddr = dr[6].ToString();
user.Userlove = dr[7].ToString();
user.Userphone = dr[8].ToString();
user.Usersex = dr[9].ToString();
user.Userbirth = dr[10].ToString();
user.Cardtime = dr[11].ToString();
user.Cardbak = dr[12].ToString();
user.Cardstata = dr[13].ToString();
user.Price = float.Parse(dr[14].ToString());
// list.Add(user);
return(user);
}
return(null);
}
public static List <ProductInfo> GetAllProduct()
{
string sql = "select * from product_info";
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <ProductInfo> list = new List <ProductInfo>();
if (dr != null)
{
while (dr.Read())
{
ProductInfo product = new ProductInfo();
product.Productid = int.Parse(dr[0].ToString());
product.Productname = dr[1].ToString();
product.Productprice = float.Parse(dr[2].ToString());
product.Productnum = dr[3].ToString();
product.Producttype = dr[4].ToString();
product.Productpprice = float.Parse(dr[5].ToString());
product.Productaddr = dr[6].ToString();
product.Productpd = dr[7].ToString();
product.Productstata = dr[8].ToString();
product.Productpristata = dr[9].ToString();
product.Productdru = dr[10].ToString();
list.Add(product);
}
}
return(list);
}
public static List <UserInfo> GetAllInfo()
{
string sql = string.Format("select * from Card_User");
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <UserInfo> list = new List <UserInfo>();
while (dr.Read())
{
UserInfo user = new UserInfo();
user.Cardid = int.Parse(dr[0].ToString());
user.Carduser = dr[1].ToString();
user.Cardpwd = dr[2].ToString();
user.Username = dr[3].ToString();
user.Userjob = dr[4].ToString();
user.Usertel = dr[5].ToString();
user.Useraddr = dr[6].ToString();
user.Userlove = dr[7].ToString();
user.Userphone = dr[8].ToString();
user.Usersex = dr[9].ToString();
user.Userbirth = dr[10].ToString();
user.Cardtime = dr[11].ToString();
user.Cardbak = dr[12].ToString();
user.Cardstata = dr[13].ToString();
user.Price = float.Parse(dr[14].ToString());
list.Add(user);
}
return(list);
}
public static List <employeeInfo> getallpd()
{
string sql = "select * from EmployeeInfo";
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <employeeInfo> list = new List <employeeInfo>();
if (dr != null)
{
while (dr.Read())
{
employeeInfo pd = new employeeInfo();
pd.Name = dr[1].ToString();
pd.Id = uint.Parse(dr[0].ToString());
pd.CreateTime = DateTime.Parse(dr[3].ToString());
pd.Type = dr[4].ToString();
if (pd.Id > 9)
{
list.Add(pd);
}
}
dr.Close();
}
return(list);
}
public static void test()
{
string sql = string.Format("select * from admin_info");
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
while (dr.Read())
{
}
}
/// <summary>
/// 管理员登陆
/// </summary>
/// <param name="username">管理员用户名</param>
/// <param name="userpwd">管理员密码</param>
/// <returns>登陆管理员用户信</returns>
public static AdminInfo LoginAdmin(string username, string userpwd)
{
string sql = string.Format("select * from admin_info where admin_user='******' and admin_pwd='{1}'", username, userpwd);
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
AdminInfo admin = new AdminInfo();
if (dr.Read())
{
admin.AdminId = int.Parse(dr[0].ToString());
admin.Adminname = dr[1].ToString();
admin.Username = username;
admin.Userpwd = userpwd;
}
return(admin);
}
public static List <ScoInfo1> GetAllSco()
{
string sql = "select * form card_sco";
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <ScoInfo1> list = new List <ScoInfo1>();
while (dr.Read())
{
ScoInfo1 sco = new ScoInfo1();
sco.Id = int.Parse(dr[0].ToString());
sco.User = dr[1].ToString();
sco.Sco = dr[2].ToString();
sco.ScoHis = dr[3].ToString();
list.Add(sco);
}
return(list);
}
public static List <AdminInfo> GetALLAdmin()
{
string sql = "select * from admin_info";
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <AdminInfo> list = new List <AdminInfo>();
while (dr.Read())
{
AdminInfo admin = new AdminInfo();
admin.AdminId = int.Parse(dr[0].ToString());
admin.Adminname = dr[1].ToString();
admin.Username = dr[2].ToString();
admin.Userpwd = dr[3].ToString();
list.Add(admin);
}
dr.Close();
return(list);
}
public static float GetAllBuyBkByUser(string username)
{
string sql = string.Format("select sum(buy_price) from buy_bk where buy_from='{0}'", username);
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
if (dr.Read())
{
try
{
return(float.Parse(dr[0].ToString()));
}
catch
{
return(0f);
}
}
dr.Close();
return(0f);
}
public static List <BuyBk> GetAllBuyBkByTime(string begintime, string endtime)
{
string sql = string.Format("select * from buy_bk where buy_time between #{0}# and #{1}#", begintime, endtime);
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <BuyBk> list = new List <BuyBk>();
while (dr.Read())
{
BuyBk by = new BuyBk();
by.Buyid = int.Parse(dr[0].ToString());
by.Buyproduct = dr[1].ToString();
by.Buyprice = dr[2].ToString();
by.Buytime = dr[3].ToString();
by.Count = int.Parse(dr[4].ToString());
by.BuyFrom = dr[5].ToString();
list.Add(by);
}
dr.Close();
return(list);
}
public static List <BuyBk> GetAllBuyBk()
{
string sql = "select * from buy_bk";
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <BuyBk> list = new List <BuyBk>();
while (dr.Read())
{
BuyBk by = new BuyBk();
by.Buyid = int.Parse(dr[0].ToString());
by.Buyproduct = dr[1].ToString();
by.Buyprice = dr[2].ToString();
by.Buytime = dr[3].ToString();
by.Count = int.Parse(dr[4].ToString());
by.BuyFrom = dr[5].ToString();
list.Add(by);
}
dr.Close();
return(list);
}
public static List <Pd_info> getallpd()
{
string sql = "select * from pd_info";
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <Pd_info> list = new List <Pd_info>();
if (dr != null)
{
while (dr.Read())
{
Pd_info pd = new Pd_info();
pd.Pdname = dr[1].ToString();
pd.Pdid = int.Parse(dr[0].ToString());
list.Add(pd);
}
dr.Close();
}
return(list);
}
public static ScoInfo1 GetScorByUser(string username)
{
string sql = string.Format("select * from card_sco where sco_user = '******'", username);
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
if (dr.Read())
{
ScoInfo1 sco = new ScoInfo1();
sco.Id = int.Parse(dr[0].ToString());
sco.User = dr[1].ToString();
sco.ScoHis = dr[3].ToString();
sco.Sco = dr[2].ToString();
return(sco);
}
ScoInfo1 sco1 = new ScoInfo1();
sco1.User = username;
sco1.ScoHis = "0";
sco1.Sco = "0";
AddScor(sco1);
return(sco1);
}
public static List <ProductInfo> GetProductByNum(string productnum)
{
string sql = string.Format("select * from product_info where Product_num = '{0}'", productnum);
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <ProductInfo> list = new List <ProductInfo>();
while (dr.Read())
{
ProductInfo product = new ProductInfo();
product.Productid = int.Parse(dr[0].ToString());
product.Productname = dr[1].ToString();
product.Productprice = float.Parse(dr[2].ToString());
product.Productnum = dr[3].ToString();
product.Producttype = dr[4].ToString();
product.Productpprice = float.Parse(dr[5].ToString());
product.Productaddr = dr[6].ToString();
product.Productpd = dr[7].ToString();
product.Productstata = dr[8].ToString();
product.Productpristata = dr[9].ToString();
product.Productdru = dr[10].ToString();
list.Add(product);
}
return(list);
}