Example #1
0
        private void GetTickets_timer_Tick(object sender, EventArgs e)
        {
            DateTime dt = DateTime.Now;

            if (File.Exists(StartupPath + "\\Setup.ini"))
            {
                dt = DateTime.Parse(ini.IniReadValue("Setup", "LastTime"));
            }
            GetTickets ticket = new GetTickets
            {
                query_type = 2,
                start_time = Convert.ToInt32(dt.AddMinutes(-8).AddHours(-8).Subtract(new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds),
                end_time   = Convert.ToInt32(dt.AddMinutes(-2).AddHours(-8).Subtract(new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds)
                             //start_time = Convert.ToInt32(DateTime.Now.AddMinutes(-8).AddHours (-8).Subtract(new DateTime(1970, 1, 1,0,0,0)).TotalSeconds),
                             //end_time = Convert.ToInt32(DateTime.Now.AddMinutes(-2).AddHours(-8).Subtract(new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds)
            };
            var httpWebRequest = (HttpWebRequest)WebRequest.Create(ConfigurationManager.AppSettings["URL"].ToString() + "query_type=" + ticket.query_type + "&start_time=" + ticket.start_time + "&end_time=" + ticket.end_time);

            httpWebRequest.ContentType = "application/json; charset=utf-8";
            httpWebRequest.Method      = "GET";

            var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();

            using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
            {
                var result = streamReader.ReadToEnd();
                label4.Text = result;
                string sql       = "";
                string TK_STATUS = "";
                try
                {
                    GetTicketsResp deserialized = JsonConvert.DeserializeObject <GetTicketsResp>(result);
                    if (deserialized.code == 1 && deserialized.total_items > 0)
                    {
                        using (SqlConnection _con = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString))
                        {
                            _con.Open();
                            foreach (GetTicketsDataResp resp in deserialized.data)
                            {
                                if (!GetDataDB(resp.qrcode, resp.bill_no))
                                {
                                    if (resp.status == "Y")
                                    {
                                        TK_STATUS = "1";
                                    }
                                    else if (resp.status == "U")
                                    {
                                        TK_STATUS = "2";
                                    }
                                    else if (resp.status == "X")
                                    {
                                        TK_STATUS = "X";
                                    }
                                    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.qrcode
                                                        , resp.bill_no
                                                        , resp.product_name.Substring(resp.product_name.IndexOf("】") + 1, resp.product_name.IndexOf("單") - resp.product_name.IndexOf("】") - 1) + "票"
                                                        , Convert.ToInt32(resp.Price)
                                                        , resp.deal_dt
                                                        , "gomaji"
                                                        , TK_STATUS //1:售出  2:已使用  X:作廢
                                                        , ""
                                                        , ""
                                                        , ""
                                                        , ""
                                                        , 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.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.modify_dt
                                                            , resp.status
                                                            , string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now)
                                                            , "udn"
                                                            , resp.qrcode
                                                            , resp.bill_no);
                                        SqlCommand cmd = new SqlCommand(sql, _con);
                                        cmd.ExecuteNonQuery();
                                    }
                                }
                            }
                        }
                    }
                    ini.IniWriteValue("Setup", "LastTime", String.Format("{0:yyyy/MM/dd HH:mm:ss}", DateTime.Now));//儲存最後一次排程的時間
                }
                catch (Exception ex)
                {
                    return;
                }
            }
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            DateTime   dtS    = DateTime.Parse(textBox1.Text.Trim() + " 00:00:00");
            DateTime   dtE    = DateTime.Parse(textBox2.Text.Trim() + " 00:00:00");
            int        days   = new TimeSpan(dtE.Ticks - dtS.Ticks).Days;
            GetTickets ticket = new GetTickets();

            for (int i = 0; i <= days; i++)
            {
                ticket.query_type = 2;
                ticket.start_time = Convert.ToInt32(DateTime.Parse(String.Format("{0:yyyy/MM/dd}", dtS) + " 00:00:00").AddHours(-8).Subtract(new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds);
                ticket.end_time   = Convert.ToInt32(DateTime.Parse(String.Format("{0:yyyy/MM/dd}", dtS) + " 23:59:59").AddHours(-8).Subtract(new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds);
                var httpWebRequest = (HttpWebRequest)WebRequest.Create(ConfigurationManager.AppSettings["URL"].ToString() + "query_type=" + ticket.query_type + "&start_time=" + ticket.start_time + "&end_time=" + ticket.end_time);
                httpWebRequest.ContentType = "application/json; charset=utf-8";
                httpWebRequest.Method      = "GET";

                var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();

                using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
                {
                    var    result    = streamReader.ReadToEnd();
                    string sql       = "";
                    string TK_STATUS = "";
                    try
                    {
                        GetTicketsResp deserialized = JsonConvert.DeserializeObject <GetTicketsResp>(result);
                        if (deserialized.code == 1 && deserialized.total_items > 0)
                        {
                            using (SqlConnection _con = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString))
                            {
                                _con.Open();
                                foreach (GetTicketsDataResp resp in deserialized.data)
                                {
                                    resp.product_name = resp.product_name.Substring(resp.product_name.IndexOf("】") + 1, resp.product_name.IndexOf("單") - resp.product_name.IndexOf("】") - 1) + "票";
                                    if (resp.product_name.Equals("花博預售優惠票"))
                                    {
                                        resp.product_name = "預售優惠票";
                                    }
                                    else if (resp.product_name.Equals("花博預售票"))
                                    {
                                        resp.product_name = "預售全票";
                                    }
                                    if (!GetDataDB(resp.qrcode, resp.bill_no))
                                    {
                                        if (resp.status == "Y")
                                        {
                                            TK_STATUS = "1";
                                        }
                                        else if (resp.status == "U")
                                        {
                                            TK_STATUS = "2";
                                        }
                                        else if (resp.status == "X")
                                        {
                                            TK_STATUS = "X";
                                        }
                                        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.qrcode
                                                            , resp.bill_no
                                                            , resp.product_name
                                                            , Convert.ToInt32(resp.Price)
                                                            , resp.deal_dt
                                                            , "gomaji"
                                                            , TK_STATUS //1:售出  2:已使用  X:作廢
                                                            , ""
                                                            , ""
                                                            , ""
                                                            , ""
                                                            , 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.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.modify_dt
                                                                , resp.status
                                                                , string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now)
                                                                , "udn"
                                                                , resp.qrcode
                                                                , resp.bill_no);
                                            SqlCommand cmd = new SqlCommand(sql, _con);
                                            cmd.ExecuteNonQuery();
                                        }
                                    }
                                }
                            }
                        }
                        dtS = dtS.AddDays(1);
                        writeLog.Write_Log("GetTickets " + ticket.start_time + " ~ " + ticket.end_time + ": ErrCode = " + deserialized.code + " , RowCount = " + deserialized.total_items);
                    }
                    catch (Exception ex)
                    {
                        return;
                    }
                }
            }
            label10.Visible = true;
            ini.IniWriteValue("Setup", "LastTime", String.Format("{0:yyyy/MM/dd}", dtS) + " 00:00:00");//儲存最後一次排程的時間
        }