public List <ManagerInfo> GetList(ManagerInfo mi) { //构造集合对象 List <ManagerInfo> list = new List <ManagerInfo>(); //构造sql语句 string sql = "select * from ManagerInfo "; List <SQLiteParameter> listP = new List <SQLiteParameter>(); //拼接查询条件 if (mi != null) { sql += "where MName=@name and MPwd=@pwd"; listP.Add(new SQLiteParameter("@name", mi.MName)); listP.Add(new SQLiteParameter("@pwd", Md5Helper.GetMd5(mi.MPwd))); } //执行查询,获取数据 DataTable dt = SqliteHelper.GteList(sql, listP.ToArray()); //遍历数据表中的行,将数据转存到集合中 foreach (DataRow row in dt.Rows) { list.Add(new ManagerInfo() { MId = Convert.ToInt32(row["MId"]), MName = row["MName"].ToString(), MPwd = row["MPwd"].ToString(), MType = Convert.ToInt32(row["MType"]) }); } //返回数据 return(list); }
public List <TableInfo> GetList(TableInfo ti) { string sql = "select ti.*,hi.HTitle as HallTitle from TableInfo ti" + " inner join HallInfo hi" + " on ti.THallId=hi.HId " + " where ti.TIsDelete=0"; List <SQLiteParameter> listP = new List <SQLiteParameter>(); if (ti.THallId > 0) { sql += " and ti.THallId=@hid"; listP.Add(new SQLiteParameter("@hid", ti.THallId)); } if (ti.IsFreeSearch > -1) { sql += " and ti.TIsFree=@isFree"; listP.Add(new SQLiteParameter("@isFree", ti.IsFreeSearch)); } sql += " order by ti.TId desc"; DataTable dt = SqliteHelper.GteList(sql, listP.ToArray()); List <TableInfo> list = new List <TableInfo>(); foreach (DataRow row in dt.Rows) { list.Add(new TableInfo() { TId = Convert.ToInt32(row["TId"]), TTitle = row["TTitle"].ToString(), THallId = Convert.ToInt32(row["THallId"]), HallTitle = row["HallTitle"].ToString(), TIsFree = Convert.ToBoolean(row["TIsFree"]) }); } return(list); }
public List <DishTypeInfo> GetList() { string sql = "select * from DishTypeInfo where DIsDelete=0"; DataTable dt = SqliteHelper.GteList(sql); List <DishTypeInfo> list = new List <DishTypeInfo>(); foreach (DataRow row in dt.Rows) { list.Add(new DishTypeInfo() { DId = Convert.ToInt32(row["DId"]), DTitle = row["DTitle"].ToString() }); } return(list); }
public List <HallInfo> GetList() { string sql = "select * from HallInfo where HIsDelete=0"; DataTable dt = SqliteHelper.GteList(sql); List <HallInfo> list = new List <HallInfo>(); foreach (DataRow row in dt.Rows) { list.Add(new HallInfo { HId = Convert.ToInt32(row["HId"]), HTitle = row["HTitle"].ToString() }); } return(list); }
public List <MemberTypeInfo> GetList() { string sql = "select * from MemberTypeInfo where MIsDelete=0"; DataTable dt = SqliteHelper.GteList(sql); List <MemberTypeInfo> list = new List <MemberTypeInfo>(); foreach (DataRow row in dt.Rows) { list.Add(new MemberTypeInfo() { MId = Convert.ToInt32(row["MId"]), MTitle = row["MTitle"].ToString(), MDiscount = Convert.ToDecimal(row["MDiscount"]) }); } return(list); }
public List <MemberInfo> GetList(MemberInfo mi) { //连接查询 string sql = "select mi.*,mti.MTitle,mti.MDiscount from MemberInfo mi" + " inner join MemberTypeInfo mti " + "on mi.MTypeId=mti.MId " + "where mi.MIsDelete=0"; List <SQLiteParameter> listP = new List <SQLiteParameter>(); if (mi.MId > 0) { sql += " and mi.MId=@mid"; listP.Add(new SQLiteParameter("@mid", mi.MId)); } if (!string.IsNullOrEmpty(mi.MName)) { sql += " and mi.MName like @name"; listP.Add(new SQLiteParameter("@name", "%" + mi.MName + "%")); } if (!string.IsNullOrEmpty(mi.MPhone)) { sql += " and mi.MPhone like @phone"; listP.Add(new SQLiteParameter("@phone", "%" + mi.MPhone + "%")); } DataTable dt = SqliteHelper.GteList(sql, listP.ToArray()); List <MemberInfo> list = new List <MemberInfo>(); foreach (DataRow row in dt.Rows) { list.Add(new MemberInfo() { MId = Convert.ToInt32(row["MId"]), MName = row["MName"].ToString(), MMoney = Convert.ToDecimal(row["MMoney"]), MPhone = row["MPhone"].ToString(), MTypeId = Convert.ToInt32(row["MTypeId"]), TypeTitle = row["MTitle"].ToString(), TypeDiscount = Convert.ToDecimal(row["MDiscount"]) }); } return(list); }
public List <OrderDetailInfo> GetOrderDetail(int orderId) { string sql = "select odi.*,di.DTitle,di.DPrice from OrderDetailInfo odi" + " inner join DishInfo di" + " on odi.DishId=di.Did" + " where odi.OrderId=@oid"; SQLiteParameter ps = new SQLiteParameter("@oid", orderId); DataTable dt = SqliteHelper.GteList(sql, ps); List <OrderDetailInfo> list = new List <OrderDetailInfo>(); foreach (DataRow row in dt.Rows) { list.Add(new OrderDetailInfo() { OId = Convert.ToInt32(row["OId"]), OrderId = orderId, DishId = Convert.ToInt32(row["DishId"]), Count = Convert.ToInt32(row["Count"]), DishTitle = row["DTitle"].ToString(), DishPrice = Convert.ToDecimal(row["DPrice"]) }); } return(list); }
public List <DishInfo> GetList(DishInfo di) { string sql = "select di.*,dti.DTitle as TyPeTitle from DishInfo di" + " inner join DishTypeInfo dti" + " on di.DTypeId=dti.DId" + " where di.DIsDelete=0"; List <SQLiteParameter> listP = new List <SQLiteParameter>(); if (!string.IsNullOrEmpty(di.DTitle)) { sql += " and di.DTitle like @title"; listP.Add(new SQLiteParameter("@title", "%" + di.DTitle + "%")); } if (di.DTypeId > 0) { sql += " and di.DTypeId like @tid"; listP.Add(new SQLiteParameter("@tid", "%" + di.DTypeId + "%")); } if (!string.IsNullOrEmpty(di.DChar)) { sql += " and di.Dchar like @dchar"; listP.Add(new SQLiteParameter("@dchar", "%" + di.DChar + "%")); } sql += " order by di.DId desc"; DataTable dt = SqliteHelper.GteList(sql, listP.ToArray()); List <DishInfo> list = new List <DishInfo>(); foreach (DataRow row in dt.Rows) { list.Add(new DishInfo() { DId = Convert.ToInt32(row["DId"]), DTitle = row["DTitle"].ToString(), DTypeId = Convert.ToInt32(row["DTypeId"]), DChar = row["DChar"].ToString(), DPrice = Convert.ToDecimal(row["DPrice"]), TypeTitle = row["TypeTitle"].ToString() }); } return(list); }