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