private void GetTicketCount_API_Start_btn_Click(object sender, EventArgs e) { string Products_Code = string.Empty; if (checkBox3.Checked && !checkBox4.Checked) { Products_Code += checkBox3.Text; } if (checkBox3.Checked && checkBox4.Checked) { Products_Code += checkBox3.Text + "|" + checkBox4.Text; } if (!checkBox3.Checked && checkBox4.Checked) { Products_Code += checkBox4.Text; } if (!checkBox3.Checked && !checkBox4.Checked) { MessageBox.Show("請勾選商品代碼"); return; } GetTicketCount ticket = new GetTicketCount { Products_Code = Products_Code, Orders_STIME = textBox1.Text, Orders_ETIME = textBox2.Text, }; string ResponseData = Svc.GetTicketCount("[" + JsonConvert.SerializeObject(ticket) + "]"); var deserialized = JsonConvert.DeserializeObject <IEnumerable <GetTicketCountResp> >(ResponseData); foreach (GetTicketCountResp resp in deserialized) { TotalCount_lbl.Text = resp.TotalCount.ToString(); BlockCount_lbl.Text = resp.BlockCount.ToString(); } }
private void button1_Click(object sender, EventArgs e) { if (!checkBox1.Checked && !checkBox2.Checked) { MessageBox.Show("請勾選商品代碼"); return; } string Products_Code = string.Empty; if (checkBox1.Checked && !checkBox2.Checked) { Products_Code += checkBox1.Text; } else if (checkBox1.Checked && checkBox2.Checked) { Products_Code += checkBox1.Text + "|" + checkBox2.Text; } else if (!checkBox1.Checked && checkBox2.Checked) { Products_Code += checkBox2.Text; } GetTicketData ticket = new GetTicketData(); int blocks = 0; GetTicketCount ticketCount = new GetTicketCount { Products_Code = Products_Code, Orders_STIME = textBox1.Text.Trim() + " 00:00:00", Orders_ETIME = textBox2.Text.Trim() + " 23:59:59", }; string ResponseDataCount = Svc.GetTicketCount("[" + JsonConvert.SerializeObject(ticketCount) + "]"); var deserializedCount = JsonConvert.DeserializeObject <IEnumerable <GetTicketCountResp> >(ResponseDataCount); foreach (GetTicketCountResp resp in deserializedCount) { blocks = resp.BlockCount; } for (int i = 1; i <= blocks; i++) { ticket.Products_Code = Products_Code; ticket.Orders_STIME = textBox1.Text.Trim() + " 00:00:00"; ticket.Orders_ETIME = textBox2.Text.Trim() + " 23:59:59"; ticket.Block = i; string ResponseData = Svc.GetTicketData("[" + JsonConvert.SerializeObject(ticket) + "]"); string sql = ""; try { var deserialized = JsonConvert.DeserializeObject <IEnumerable <GetTicketDataResp> >(ResponseData); using (SqlConnection _con = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) { _con.Open(); foreach (GetTicketDataResp resp in deserialized) { string TK_STATUS = string.Empty; if (!GetDataDB(resp.QR_Code, resp.Orders_No)) { if (resp.Order_Type == "R") { TK_STATUS = "X"; } else { TK_STATUS = "1"; } sql = string.Format(@"insert into cTicketWhitelist (TK_QRCODE ,TK_ORDERNO ,TK_PRICETYPES ,TK_PRICE ,TK_ORDERDT ,TK_PLACE ,TK_STATUS ,TK_USED_DT ,TK_END_DT ,TK_FEEDBACK ,TK_FEEDBACKMEMO ,CREATEDT ,CREATEID ,MODIFYDT ,MODIFYID) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')" , resp.QR_Code , resp.Orders_No , resp.PriceTypes , Convert.ToInt32(resp.Price) , resp.Order_datetime , "ibon" , TK_STATUS , "" , "" , "" , "" , string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now) , "admin" , null , null); SqlCommand cmd = new SqlCommand(sql, _con); cmd.ExecuteNonQuery(); } else { if (resp.Order_Type == "R") { TK_STATUS = "X"; sql = string.Format(@"update cTicketWhitelist set TK_ORDERDT='{0}', TK_STATUS='{1}', MODIFYDT='{2}', MODIFYID='{3}' where TK_QRCODE='{4}' and TK_ORDERNO='{5}' and TK_STATUS<>'X'" , resp.Order_datetime , TK_STATUS , string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now) , "admin" , resp.QR_Code , resp.Orders_No); SqlCommand cmd = new SqlCommand(sql, _con); cmd.ExecuteNonQuery(); } } } } } catch (Exception ex) { return; } } }