protected void Page_Load(object sender, EventArgs e) { conn = new Connection(); string connectionstring = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString; conn.Open(connectionstring); Rs1 = new Recordset(); Rs2 = new Recordset(); Rs3 = new Recordset(); Rs4 = new Recordset(); StationID = Request["StationID"]; UserID = Session["UserID"]; SecLevel = Session["SecLevel"]; Barcode = Request["Barcode"]; ProductType = Request["ProductType"]; CarPlate = Request["CarPlate"]; Response.Write(StationID); Response.Write(UserID); Response.Write(SecLevel); Response.End(); iMessage = null; Rs1.Open(("Exec Checkrange '" + Barcode + "'"), conn, (nce.adodb.CursorType)3, (nce.adodb.LockType)1); //Response.write ("Exec Checkrange '"&Barcode&"'") //Response.end if (Rs1.Eof) { Message = "Check Range ���ҥ��� - §��L��!"; Response.Redirect("CouponVerification.aspx?Message=" + Message); } else { if (Convert.ToDateTime(Rs1.Fields["Expiry_Date"].Value) < DateTime.Parse(Convert.ToString(DateTime.Now))) { Message = "���ҥ��� - §��L��!"; Response.Redirect("CouponVerification.aspx?Message=" + Message); } } Rs1.Close(); Rs1 = null; Rs2.Open(("Exec CheckCouponExist '" + Barcode + "'"), conn, (nce.adodb.CursorType)3, (nce.adodb.LockType)1); //Response.write ("Exec CheckCouponExist '"&Barcode&"'") iCount = Rs2.Fields["iCount"].Value; Rs2.Close(); Rs2 = null; if (Convert.ToInt32(iCount) > 0) { Message = "���ҥ��� - ���ƨϥ�!"; } else { Session.Add("SecLevel", SecLevel); Session.Add("UserID", UserID); Session.Add("StationID", StationID); Response.Redirect("Insert.aspx?ProductType=" + ProductType + "&Barcode=" + Barcode + "&CarPlate=" + CarPlate); } Session.Add("SecLevel", SecLevel); Session.Add("UserID", UserID); Session.Add("StationID", StationID); Response.Redirect("CouponVerification.aspx?Message=" + Message + "&Coupon_Number=" + Convert.ToString(Coupon_Number)); }
protected void Page_Load(object sender, EventArgs e) { conn = new Connection(); string connectionstring = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString; conn.Open(connectionstring); UserID = Request["UserID"]; Password = Request["Password"]; if (Session["StationID"] != null) { StationID = Session["StationID"].ToString(); } Rs1 = new Recordset(); Rs1.Open(("Exec CheckLoginPwd '" + UserID + "', '" + Password + "' "), conn, (nce.adodb.CursorType)3, (nce.adodb.LockType)1); if (!(Rs1.Eof)) { Session.Add("SecLevel", Rs1.Fields["SecLevel"].Value); Session.Add("UserID", UserID); Session.Add("StationID", StationID); Response.Redirect("CouponVerification.aspx"); } else { Response.Redirect("Default.aspx?Message=Fail"); } }
public static Connection getConnection() { if (connection == null) { connection = new Connection("127.0.0.1"); } return connection; }
static void Main(string[] args) { Thread.Sleep(200); const string serverUrl = "http://localhost:5000/echo/"; var connection = new Connection(serverUrl); connection.StateChanged += OnConnectionStateChanged; try { connection.Start().Wait(); } catch(AggregateException ex) { throw ex.Flatten(); } Console.ReadKey(); }
protected void Page_Load(object sender, EventArgs e) { try { conn = new Connection(); string connectionstring = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString; conn.Open(connectionstring); UserID = (Request["UserID"]).Trim(); Level = (Request["SecLevel"]).Trim(); StationID = (Request["StationID"]).Trim(); UserID = (Request["UserID"]).TrimEnd(); SDay = Request["SDay"]; SMonth = Request["SMonth"]; SYear = Request["SYear"]; NDay = Request["NDay"]; NMonth = Request["NMonth"]; NYear = Request["NYear"]; // Search_Date = Strings.FormatDateTime(new DateTime(Convert.ToInt32(SYear), Convert.ToInt32(SMonth), Convert.ToInt32(SDay)), (DateFormat)2); //Search_NDate = Strings.FormatDateTime(new DateTime(Convert.ToInt32(NYear), Convert.ToInt32(NMonth), Convert.ToInt32(NDay)), (DateFormat)2); Search_Date = SDay + "/" + SMonth + "/" + SYear; Search_NDate = NDay + "/" + NMonth + "/" + NYear; fsql = "select * from MasterCoupon where RequestedID = " + StationID + " and Present_Date >= Convert(datetime, '" + Search_Date + "', 105) " + " and Present_Date < DATEADD(dd,DATEDIFF(dd,0, Convert(datetime, '" + Search_NDate + "', 105)),0) + 1 " + " order by id desc"; //response.write fsql //response.end RS1 = conn.Execute(fsql); Response.ContentType = "text/csv"; //Today = Strings.FormatDateTime(DateTime.Now, (DateFormat)2); Today = DateTime.Now.ToString("dd-MM-yyyy"); Response.AddHeader("Content-Disposition", "attachment;filename=§¨é¬ö¿ý(" + Today + ").csv"); Write_CSV_From_Recordset(RS1); } catch (Exception ex) { } }
public Tank(Parser parser) { connection = new Connection(parser); }
public static void setConnection(string IPAddress) { connection = new Connection(IPAddress); }
public Tank() { connection = new Connection (); }
private void Connection_Disconnect(Connection Sender, DisconnectMessage Message) { // If the server disconnects, close the window Dispatcher.Invoke((Action)Close); }