protected bool CheckInsertGameLog(string IDNo, string Ball) { if (CheckTimeout.IsEbankEnd()) { return(true); } else { string IP; IP = "[" + Request.ServerVariables["REMOTE_ADDR"] + "]"; if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != "") { IP += "[" + Request.ServerVariables["HTTP_X_FORWARDED_FOR"] + "]"; } ConnectionStringSettings connSettings = ConfigurationManager.ConnectionStrings["ConnString"]; SqlConnection conn = new SqlConnection(connSettings.ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand("usp_InsertMember", conn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parm_IDNo = new SqlParameter("@ID", SqlDbType.VarChar, 50); SqlParameter parm_Times = new SqlParameter("@Times", SqlDbType.Int); SqlParameter parm_IP = new SqlParameter("@IP", SqlDbType.VarChar, 40); parm_IDNo.Value = IDNo; parm_Times.Value = Int16.Parse(Ball); parm_IP.Value = IP.Replace("[]", ""); cmd.Parameters.Add(parm_IDNo); cmd.Parameters.Add(parm_Times); cmd.Parameters.Add(parm_IP); //Response.Write("ID=" + IDNo + "<BR>"); //Response.Write("Ball=" + Int16.Parse(Ball).ToString() + "<BR>"); //Response.Write("IP=" + IP + "<BR>"); string ReturnValue = cmd.ExecuteScalar().ToString(); //Response.Write("ReturnValue=" + ReturnValue + "<BR>"); cmd.Dispose(); conn.Close(); conn.Dispose(); if (ReturnValue == "y") { return(true); } else { return(false); } } }