departManagement/addNewDepart.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.Xml.Linq;

namespace Eclipse.HRM.UI.departManagement
{
    public partial class addNewDepart : PageBase
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            
        }

        private bool CheckBeforeInsert()
        {
            //带*号的不能为空
            if (TextBox2 == null)
                return false;
            //时间合法
            else
            return true;
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            if (CheckBeforeInsert())
            {
                string name = TextBox2.Text.ToString();
                string phone = TextBox3.Text.ToString();
                string m_id = TextBox4.Text.ToString();
                string addr = TextBox5.Text.ToString();
                string bank = TextBox6.Text.ToString();
                string b_id = TextBox7.Text.ToString();

                string sql = "insert into departmentlist(D_name,D_phone,manager_ID,D_addr,D_bank,D_logname,D_status) values('"
                    + name + "','" + phone + "','" + m_id + "','" + addr + "','" + bank + "','" + b_id + "','1')";

                if (DBhelper.ExeQuery(sql))  //插入成功
                {
                    
                    string sqlText = "select max(D_ID) as max from departmentlist";
                    DataTable dt = DBhelper.GetDataTable(sqlText);
                    string s = dt.Rows[0]["max"].ToString();
                    
                    this.ClientScript.RegisterStartupScript(this.GetType(), "insertSuccess", "alert('插入成功!您所添加的部门号为"+s+"')", true);
                    
                }
                else //插入失败  
                {
                    this.ClientScript.RegisterStartupScript(this.GetType(), "insertError", "alert('插入数据失败。')", true);
                }