DBHelper查询、新增、字体颜色

删除

td><%#Eval("OperatorType").ToString() == "1" ? "<span class='gren'>正常打卡</span>"
: Eval("OperatorType").ToString() == "2" ? "<span class='blue'>打卡异常</span>":"<span class='red'>打卡失败</span>"%></td>

新增

方法：public bool Addemd(employee employee)
        {
            string sql = $"insert into employee values('{employee.EmployeeName}','{employee.EmployeeSex}'" +
                $",'{employee.EmployeeBirthday}','{employee.OperatorTime}','{employee.OperatorType}')";
            return DBHelper.Execount(sql);
        }
视图层：<p>姓名：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></p>
            <p>性别：<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></p>
            <p>生日：<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></p>
            <p>状态：<asp:RadioButton ID="RadioButton1" runat="server" GroupName="end" Text="正常打卡" />
                    <asp:RadioButton ID="RadioButton2" runat="server" GroupName="end"  Text="无效打卡"/>
                    <asp:RadioButton ID="RadioButton3" runat="server" GroupName="end" Text="申请补卡" /></p>
            <asp:Button ID="Button1" runat="server" Text="增加" OnClick="Button1_Click" />

代码：
int end = 0;
            if (RadioButton1.Checked)
            {
                end += 1;
            }
            else if (RadioButton2.Checked)
            {
                end += 2;
            }
            else
            {
                end += 3;
            }
            DateTime date = DateTime.Parse(DateTime.Now.ToString());
            employee yee = new employee(this.TextBox1.Text, TextBox2.Text,DateTime.Parse(TextBox3.Text),date,end);
            if (manager.AddEnd(yee))
            {
                Response.Redirect("zhu.aspx?msg=新增成功");
            }

字体颜色

td><%#Eval("OperatorType").ToString() == "1" ? "<span class='gren'>正常打卡</span>"
: Eval("OperatorType").ToString() == "2" ? "<span class='blue'>打卡异常</span>"
:"<span class='red'>打卡失败</span>"%></td>