public List <Receipt> GetList(string whereClause, object filters = null) { /* * SELECT cart_id, zone_id FROM qr_codes.autogen.cart_data WHERE time >= '2019-06-11T11:54:17Z' AND time <= '2019-06-11T19:10:27Z' AND cart_id = 3" */ //string query = "SELECT cart_id, zone_id, time FROM qr_codes.autogen.cart_data\n"; //using (var connection = new SqlConnection(_connectionString)) //{ // var result = connection.Query<Receipt>(query + whereClause, filters); // return result.AsList(); //} //var serialNumber = "F2EA2B0CDFF"; ////var queryTemplate = "SELECT cart_id, zone_id, time FROM qr_codes.autogen.cart_data WHERE \"serialNumber\" = @SerialNumber"; //var queryTemplate = "SELECT cart_id, zone_id, time FROM qr_codes.autogen.cart_data"; //var response = influxDbClient.Client.QueryAsync( // queryTemplate: queryTemplate, // parameters: new // { // @cart_id = serialNumber // }, // dbName: "qr_codes" //).Result; /* * { * public int CartId { get; set; } * public List<ShoppingList> ShoppingList { get; set; } * public int TotalSpending { get; set; } * public DateTime TimeStamp { get; set; } * * } * public class ShoppingList * { * public int ZoneId { get; set; } * public int ShopAmount { get; set; } * } */ return(ReceiptUtil.GetReceips()); }
private void btnPrint_Click(object sender, EventArgs e) { if (!validator.Validate()) return; ReceiptUtil ru = new ReceiptUtil() { city = String.Format("{0} - {1}", cbCity.Text, cbState.Text), cpf_cnpj = tfDocument.EditValue.ToString(), date = tfDate.DateTime, emitter = tfEmitter.EditValue.ToString(), number = Convert.ToInt64(tfNumber.EditValue), receive_to = tfReceiveTo.EditValue.ToString(), reference = tfReference.EditValue.ToString(), value = Convert.ToDecimal(tfValue.EditValue), double_print = ckDouble.Checked }; ru.Print(); }
private void btnPrint_Click(object sender, EventArgs e) { if (!validator.Validate()) { return; } ReceiptUtil ru = new ReceiptUtil() { city = String.Format("{0} - {1}", cbCity.Text, cbState.Text), cpf_cnpj = tfDocument.EditValue.ToString(), date = tfDate.DateTime, emitter = tfEmitter.EditValue.ToString(), number = Convert.ToInt64(tfNumber.EditValue), receive_to = tfReceiveTo.EditValue.ToString(), reference = tfReference.EditValue.ToString(), value = Convert.ToDecimal(tfValue.EditValue), double_print = ckDouble.Checked }; ru.Print(); }