private void GetSelectData()
{
DBBase db = new DBBase( );
if (!Mgr.CheckDate(BeginTime.Text) || !Mgr.CheckDate(EndTime.Text))
{
Mgr.ShowAlert(this, "时间格式不正确");
return;
}
string s = "SELECT top 100 d2.chinesename AS 姓名,d2.employeecode AS 工号, d1.CheckDate AS 日期, d1.OnDutytime1 AS 签到1 , d1.OffDutytime1 AS 签退1, d1.OnDutytime2 AS 签到2 , d1.OffDutytime2 AS 签退2,d1.OnDutytime3 AS 签到3 , d1.OffDutytime3 AS 签退3, d1.YTNote AS 异常, d1.RWT AS 正班 , d1.ROT AS 加班 , d1.SWT AS 需正, d1.OWT AS 需加 FROM OnOffDutyData d1 ";
s += "INNER JOIN employeemsg d2 ON d1.EmployeeID = d2.Rkey ";
s += " LEFT JOIN class d4 ON d1.ClassID = d4.RKey ";
s += " LEFT JOIN resttypemsg d3 ON d1.RestType = d3.rkey ";
s += " INNER JOIN datadepartment d5 ON d2.departmentid = d5.RKey ";
s += " WHERE d1.CheckDate BETWEEN " + Mgr.QuoteStr(BeginTime.Text) + " AND " + Mgr.QuoteStr(EndTime.Text);
if (!string.IsNullOrEmpty(tbx_GH.Text))
{
s += " AND d2.employeecode = " + Mgr.QuoteStr(tbx_GH.Text);
}
s += " AND d5.RKey=" + cbx_depart.SelectedValue.ToString( );
DataTable dt = new DataTable( );
dt = db.SqlOpen(s);
NaturalView.DataSource = dt;
NaturalView.DataBind();
}
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, "添加失败");
}
}
