1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12public partial class WebFiles_Attendece_Edit_Attendece_rule : System.Web.UI.Page
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16        string connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
17        SqlConnection Sqlconn = new SqlConnection(connstr);
18        SqlCommand cmm = new SqlCommand("select * from Tb_attendece_rule",Sqlconn);
19        SqlDataReader read;
20        Sqlconn.Open();
21        read=cmm.ExecuteReader();
22        if (read.Read())
23        ...{
24            TextBox1.Text = read[0].ToString().Split(':')[0];
25            TextBox2.Text = read[0].ToString().Split(':')[1];
26            TextBox3.Text = read[0].ToString().Split(':')[2];
27            TextBox4.Text = read[1].ToString().Split(':')[0];
28            TextBox5.Text = read[1].ToString().Split(':')[1];
29            TextBox6.Text = read[1].ToString().Split(':')[2];
30            TextBox7.Text = read[2].ToString().Split(':')[0];
31            TextBox8.Text = read[2].ToString().Split(':')[1];
32            TextBox9.Text = read[2].ToString().Split(':')[2];
33            TextBox10.Text = read[3].ToString().Split(':')[0];
34            TextBox11.Text = read[3].ToString().Split(':')[1];
35            TextBox12.Text = read[3].ToString().Split(':')[2];
36        }
37        read.Close();
38        Sqlconn.Close();
39    }
40    protected void BtnOK_Click(object sender, EventArgs e)
41    ...{
42        if ((string)Session["Name"] != "")
43        ...{
44            if ((string)Session["role"] == "管理员")
45            ...{
46                string sql= "Update Tb_attendece_rule set Onwork_Ahead='" 
47                    +TextBox1.Text.ToString().Trim()+":"
48                    +TextBox2.Text.ToString().Trim()+":"
49                    +TextBox3.Text.ToString().Trim()+ "',Onwork_Normal='" 
50                    +TextBox4.Text.ToString().Trim()+":"
51                    +TextBox5.Text.ToString().Trim()+":"
52                    +TextBox6.Text.ToString().Trim()+ "',Offwork_Delay='"
53                    +TextBox7.Text.ToString().Trim()+":"
54                    +TextBox8.Text.ToString().Trim()+":"
55                    +TextBox9.Text.ToString().Trim()+ "',Offwork_Normal='" 
56                    +TextBox10.Text.ToString().Trim()+":"
57                    +TextBox11.Text.ToString().Trim()+":"
58                    +TextBox12.Text.ToString().Trim()+ "'";
59                string connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
60                SqlConnection Sqlconn = new SqlConnection(connstr);
61                Sqlconn.Open();
62                SqlCommand sc = new SqlCommand(sql, Sqlconn);
63                sc.ExecuteNonQuery();
64                lbMessage.Text = "设置成功!";
65                Sqlconn.Close();
66            }
67            else
68            ...{
69                Response.Write("<script>alert('只有管理员才可以进行此操作!')</script>");
70            }
71        }
72        else
73        ...{
74            Response.Redirect("Default.aspx"); ;
75        }
76    }
77
78}
79