kaoqinguanli_add.aspx.cs

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

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

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;

public partial class kaoqinguanli_add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		if (!IsPostBack)
        {
			
			int nianfeni = 0; for (nianfeni = DateTime.Now.Year; nianfeni >= DateTime.Now.Year - 5; nianfeni--){nianfen.Items.Add(nianfeni.ToString().Trim());}
			int yuefeni = 0; for (yuefeni = 1; yuefeni <= 12; yuefeni++){yuefen.Items.Add(yuefeni.ToString().Trim());}
			kaoqinleibie.Items.Add("请假"); kaoqinleibie.Items.Add("迟到"); kaoqinleibie.Items.Add("早退"); kaoqinleibie.Items.Add("旷工"); kaoqinleibie.Items.Add("休假"); 
			
			
            tianjiaren.Text = Session["username"].ToString().Trim();tianjiaren.ReadOnly = true;
			gonghao.Items.Add("请选择");
			
			addxiala("yuangongxinxi","gonghao","gonghao");
			 
			
			
			
           
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
		
        string sql;
		
		
		
		
		
        sql="insert into kaoqinguanli(gonghao,xingming,xingbie,bumen,zhiwei,nianfen,yuefen,kaoqinleibie,tianshu,tianjiaren) values('"+gonghao.Text.ToString().Trim()+"','"+xingming.Text.ToString().Trim()+"','"+xingbie.Text.ToString().Trim()+"','"+bumen.Text.ToString().Trim()+"','"+zhiwei.Text.ToString().Trim()+"','"+nianfen.Text.ToString().Trim()+"','"+yuefen.Text.ToString().Trim()+"','"+kaoqinleibie.Text.ToString().Trim()+"','"+tianshu.Text.ToString().Trim()+"','"+tianjiaren.Text.ToString().Trim()+"') ";
        int result;
        result = new Class1().hsgexucute(sql);
        if (result == 1)
        {
            Response.Write("<script>javascript:alert('添加成功');</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('系统错误，请检查数据库设置问题');</script>");
        }
    }
	
	
	private void addxiala(string ntable, string nzd,string nkjm)
    {