App_Code/liuyan.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// liuyanban 的摘要说明
/// </summary>
public class liuyan
{
    private static SqlConnection _con;
	public static  SqlConnection getCon()
    {
        if (_con == null)
        {
            _con = new SqlConnection(ConfigurationManager.ConnectionStrings["getcon"].ConnectionString);

        }
        return _con;
    }
    public static void insert(string sub, string fbr, string mail, string qq, string phone,string ip, string address, string home, string img, string text)
    {
        getCon();
        _con.Open();
        string str = "insert into message(m_name,m_subject,m_content,m_phone,m_add,m_qq,m_mail,m_http,m_face,m_ip,m_datetime) values(@name,@sub,@ct,@ph,@add,@qq,@mail,@http,@face,@ip,@date)";

        SqlCommand com = new SqlCommand(str,_con);
        com.Parameters.Add("@name",SqlDbType.VarChar).Value=fbr;
        com.Parameters.Add("@sub", SqlDbType.VarChar).Value = sub;
        com.Parameters.Add("@ct", SqlDbType.Text).Value = text;
        com.Parameters.Add("@ph", SqlDbType.VarChar).Value = phone;
        com.Parameters.Add("@add", SqlDbType.VarChar).Value = address;
        com.Parameters.Add("@qq", SqlDbType.VarChar).Value = qq;
        com.Parameters.Add("@mail", SqlDbType.VarChar).Value = mail;
        com.Parameters.Add("@http", SqlDbType.VarChar).Value = home;
        com.Parameters.Add("@face", SqlDbType.VarChar).Value = img;
        com.Parameters.Add("@ip", SqlDbType.VarChar).Value = ip;
        com.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Now.ToString();
        try
        {
            com.ExecuteNonQuery();
        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            _con.Close();
        }

    }
    public static DataSet sel()
    {
        getCon();