gerenkaihu.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class gerenkaihu : System.Web.UI.Page
{
    sqlConn conn = new sqlConn();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string id = Request.QueryString["id"].ToString().Trim();
            string sql = "select * from danwei where ID=" + id + "";
            DataSet result = new DataSet();
            
            result = conn.hsggetdata(sql);
            this.danweizhanghao.Text = result.Tables[0].Rows[0]["danweizhanghao"].ToString();
            this.mingcheng.Text = result.Tables[0].Rows[0]["mingcheng"].ToString();
            this.danweibili.Text = result.Tables[0].Rows[0]["danweibili"].ToString();
            this.gerenbili.Text = result.Tables[0].Rows[0]["gerenbili"].ToString();
        }
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        string xingming = this.xingming.Text;
        string gerenzhanghao = this.gerenzhanghao.Text;
        string shoujihaoma = this.shoujihaoma.Text;
        string leixing = this.DropDownList1.Text;
        string zhengjianhao = this.zhengjianhao.Text;
        string jishu = this.jishu.Text;
        string jiner = this.jiner.Text;
        string danweizhanghao = this.danweizhanghao.Text;
        string strsql1 = " select * from geren where gerenzhanghao='" + gerenzhanghao + "'";
        DataSet ds = conn.hsggetdata(strsql1);
        if (ds.Tables[0].Rows.Count > 0)
        {
            Response.Write("<script>javascript:alert('个人账号已经存在，不能重复添加');</script>");
            return;
        }
        string strsql = "Insert into geren(gerenzhanghao,xingming,shoujihaoma,zhengjianleixing,zhengjianhao,jishu,jiner,danweizhanghao)values(";
        strsql += " '" + gerenzhanghao + "','" + xingming + "','" + shoujihaoma + "','" + leixing + "','" + zhengjianhao + "'," + jishu + "," + jiner + ",'" + danweizhanghao + "')";

        int result;
        result = conn.hsgexucute(strsql);
        if (result == 1)
        {
            Response.Write("<script language=javascript>alert('开户成功！');location='danweilist.aspx'</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('系统错误，请检查数据库的连接');</script>");
        }
    }
    protected void jishu_TextChanged(object sender, EventArgs e)
    {
        if (this.jishu.Text != "")