private void Reqsub(int n) { if (!checkuser(tbx_EmpName.Text, tbx_EmpID.Text)) { Mgr.ShowAlert(this, "姓名工号不匹配"); return; } string s = " "; switch (cbx_ReqType.SelectedIndex) { //补卡 case 0: if (!Mgr.CheckDate(tbx_time1.Text)) { Mgr.ShowAlert(this, "时间格式错误"); return; } s = "INSERT INTO Req VALUES(" + rkey.ToString( ) + ", " + Mgr.QuoteStr(Cardno.ToString( )) + ", getdate(), " + Mgr.QuoteStr(Session["USER_FULL_NAME"].ToString( )) + "," + Mgr.QuoteStr(tbx_ReqNote.Text) + "," + n.ToString() + "," + cbx_ReqType.SelectedValue.ToString( ) + ",null,null,null,null," + Mgr.QuoteStr(tbx_time1.Text) + ",null,null,null)"; break; //请假 case 1: if (!Mgr.CheckDate(tbx_time1.Text) || !Mgr.CheckDate(tbx_time2.Text)) { Mgr.ShowAlert(this, "时间格式错误"); return; } s = "INSERT INTO Req VALUES(" + rkey.ToString( ) + ", " + Mgr.QuoteStr(Cardno.ToString( )) + ", getdate(), " + Mgr.QuoteStr(Session["USER_FULL_NAME"].ToString( )) + "," + Mgr.QuoteStr(tbx_ReqNote.Text) + "," + n.ToString( ) + "," + cbx_ReqType.SelectedValue.ToString( ) + ",null,null," + Mgr.QuoteStr(tbx_time1.Text) + "," + Mgr.QuoteStr(tbx_time2.Text) + ",null,null,null," + cbx_RestType.SelectedValue.ToString( ) + ")"; break; //手动修改工时 case 2: if (!Mgr.CheckDate(tbx_date.Text)) { Mgr.ShowAlert(this, "日期格式不正确"); return; } if (!Mgr.CheckDoule(tbx_ZB.Text) || !Mgr.CheckDoule(tbx_JB.Text)) { Mgr.ShowAlert(this, "工时不正确"); return; } s = "INSERT INTO Req VALUES(" + rkey.ToString( ) + ", " + Mgr.QuoteStr(Cardno.ToString( )) + ", getdate(), " + Mgr.QuoteStr(Session["USER_FULL_NAME"].ToString( )) + "," + Mgr.QuoteStr(tbx_ReqNote.Text) + "," + n.ToString( ) + "," + cbx_ReqType.SelectedValue.ToString( ) + ",null,null,null,null," + Mgr.QuoteStr(tbx_date.Text) + "," + tbx_ZB.Text.ToString( ) + "," + tbx_JB.Text.ToString( ) + ",null)"; break; } DBBase db = new DBBase( ); if (db.SqlExec(s) == 1) { Mgr.ShowAlert(this, "添加成功"); Response.Write("<script>window.location.href='ReqSubmit.aspx'</script>"); } else { Mgr.ShowAlert(this, "添加失败"); } }