System/Sys_National_Add.aspx.cs

（完整代码） 2KB 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class System_Sys_Natinal_Add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    #region 添加数据
    protected void Button1_Click(object sender, EventArgs e)
    {
        string user = Common.UrnHtml(txt_code.Text);
        string sql = "select * from X_National where X_National_Code='" + user + "'";

        if (!DB.isExists(sql))
        {
            string sql2 = "insert into X_National(X_National_Name,X_National_Sex,X_National_Nation,X_National_Birth,X_National_IsHOH,X_National_HOH_Code,X_National_Number,X_National_Building,X_National_Stree_Num,X_National_HOHs,X_National_Graduation,X_National_Politics,X_National_Work_Date,X_National_Native_Place,X_National_Unit,X_National_Join_Date,X_National_Addr,X_National_Unit_Tel,X_National_Home_Tel,X_National_Pho,X_National_Code,X_National_Content)";
            sql2 += "values('"+txt_name.Text+"','"+DropDownList_Sex.SelectedValue+"','"+txt_national.Text+"','"+txt_birth.Text+"','"+DropDownList_IsHOH.SelectedValue+"','"+txt_hoh_code.Text+"','"+txt_num.Text+"','"+txt_building.Text+"','"+txt_stree_num.Text+"','"+txt_hohs.Text+"','"+txt_graduation.Text+"','"+txt_politics.Text+"','"+txt_work_date.Text+"','"+txt_native_place.Text+"','"+txt_unit.Text+"','"+txt_tohere.Text+"','"+txt_hoh_addr.Text+"','"+txt_unit_tel.Text+"','"+txt_home_tel.Text+"','"+txt_pho.Text+"','"+txt_code.Text+"','"+txt_content.Text+"')";
            try
            {
                SqlConnection cn = DB.OpenConnection();
                SqlCommand cmd = new SqlCommand(sql2, cn);
                cmd.ExecuteNonQuery();
                cn.Close();
                cn.Dispose();
                Common.ShowMessage(this.Page, "添加成功！", "");

            }
            catch (Exception ex)
            {
               // Response.Write(ex);
                Common.ShowMessage(this.Page, "服务器繁忙，添加失败！", "");
            }
        }
        else
        {
            Common.ShowMessage(this.Page, "该人员信息已经存在！", "");
        }
    }
    #endregion
}

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。