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);
}
