/// <summary>
/// existe
/// </summary>
/// <param name="pin"></param>
/// <param name="attTime"></param>
/// <returns></returns>
public bool IsExist(string pin, DateTime attTime)
{
string sql = string.Format(@"
select count(*)
from AttLog
where pin=@PIN and attTime=@AttTime
");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@PIN", pin),
new SQLiteParameter("@AttTime", attTime)
};
int count = Tools.TryConvertToInt32(SqliteHelper.ExecuteScalar(sql, parameters));
if (count <= 0)
{
return(false);
}
return(true);
}
public int DianCai(int orderId, int dishId)
{
string sql = "select count(*) from orderDetailInfo where orderid=@oid and dishid=@did";
SQLiteParameter[] ps =
{
new SQLiteParameter("@oid", orderId),
new SQLiteParameter("@did", dishId)
};
int count = Convert.ToInt32(SqliteHelper.ExecuteScalar(sql, ps));
if (count == 0)
{
//当前订单中没有指定菜品，则进行添加
sql = "insert into orderDetailInfo(orderid,dishid,count) values(@oid,@did,1)";
}
else
{
//当前订单中已经存在此菜品，进行数量更新
sql = "update orderDetailInfo set count=count+1 where orderid=@oid and dishid=@did";
}
return(SqliteHelper.ExecuteNonQuery(sql, ps));
}
