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, "添加失败");
}
}
