Web_ScienceManage/ApplyInfo.aspx.cs

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

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;
using DAL;
using Model;


public partial class ApplyInfo : System.Web.UI.Page
{
    public static string connectionString = ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString;
    public Users users = new Users();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Users"] != null)
        {
            users = (Users)Session["Users"];
        }
        else
        {
            users = new Users();
            Response.Write("<script>parent.window.location.href='login.aspx'</script>");
        }
        if (!this.Page.IsPostBack)
        {
            string sql = "SELECT  * FROM InvestProject where investId=" + Request.QueryString["tzid"] + "";
            DataTable dt = DBHelper.GetDataSet(sql);


            lblProjectName.Text = dt.Rows[0]["xmmc"].ToString();
          
     
        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        //插入
        string strsql = " insert into ApplyInfo(userid,xmid,sqje,lxr,lxdh,entertime) values(" + users.UserId + ",'" + Request.QueryString["tzid"] + "','" + txtSqje.Value.Trim() + "','" + txtLxr.Value.Trim() + "','" + txtLxdh.Value.Trim() + "','" + DateTime.Now + "')";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {

            using (SqlCommand cmd = new SqlCommand(strsql, connection))
            {
                try
                {
                    connection.Open();
                    int rows = cmd.ExecuteNonQuery();
                    this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('申请成功！');window.close();</script>");
                    return;
                }
                catch