private void button1_Click(object sender, EventArgs e)
{
FuctionPack F = new FuctionPack();
//string[] in_params = { "deviceId", "channelId" };
//string[] in_values = { "1", "1" };
F.table_name = "cTicketWhiteList";
//F.in_params = in_params;
//F.in_value = in_values;
//F.extra_script = "order by in_cnt desc";
DataTable result = new DataTable();
F.GetDBData(ref result);
}
private void GetAllProducts()
{
DateTime indbT = DateTime.Now;
FuctionPack F = new FuctionPack();
DataTable DT = new DataTable();
GetDataDB(ref DT);
for (int i = 0; i < DT.Rows.Count; i++)
{
string RequestApi = string.Format("http://localhost:50199/api/qrcode?QR_code='{0}'&QR_time='{1:yyyyMMdd}'", DT.Rows[i]["TK_QRCODE"].ToString(), DT.Rows[i]["TK_USED_DT"].ToString());
F.GetApiData(RequestApi);
updatedb(F.obj, indbT, DT.Rows[i]["TK_QRCODE"].ToString(), DT.Rows[i]["TK_USED_DT"].ToString());
}
}
private void GetAllProducts()
{
FuctionPack F = new FuctionPack();
string beginT = string.Format("{0:yyyy/MM/dd HH:00:00}", DateTime.Now);
string endT = string.Format("{0:yyyy/MM/dd HH:00:00}", DateTime.Now.AddHours(1));
string RequestApi = string.Empty;
string Pro_code = (string)checkBox1.Text.ToString();
string Pro_code2 = (string)checkBox2.Text.ToString();
if (checkBox2.Checked == true)
{
RequestApi = string.Format("http://localhost:54191/api/tic?Products_Code={0}|{1}&Orders_STIME={2}&Orders_ETIME={3}", Pro_code, Pro_code2, beginT, endT);
}
else
{
RequestApi = string.Format("http://localhost:54191/api/tic?Products_Code={0}&Orders_STIME={1}&Orders_ETIME={2}", Pro_code, beginT, endT);
}
DateTime indbT = DateTime.Now;
F.GetApiData(RequestApi);
insertdb(F.obj, indbT);
}