private void GetData() { if (!Mgr.CheckLogin(this, 3)) { return; } string s = "SELECT d1.rkey ,d2.employeecode as 工号, d2.chinesename as 姓名, "; s += " (case reqstate when 0 then '未提交' when 1 then '已提交' when 2 then '已审核' when 3 then '退回' end) as 状态, reqinfo as 备注, reqperson as 提交人,"; s += " reqtime as 提交时间, (case reqtype when 0 then '补卡' when 1 then '请假' when 2 then '修改工时' end ) as 类型, req_cardtime as 时间, req_starttime as 始,"; s += " req_endtime as 终, zbhour as 正班, jbhour as 加班, dealperson as 受理人, dealtime as 受理时间 , d1.Cardno, d1.employeeid , d1.AskForLeaveRK, d3.LeaveType"; s += " FROM Req d1 INNER JOIN employeemsg d2 ON d1.employeeid = d2.rkey "; s += " LEFT JOIN AskForLeave d3 ON d1.AskForLeaveRK = d3.RKey "; s += " WHERE Reqtime BETWEEN " + Mgr.QuoteStr(BeginTime.Text) + " AND "; s += " dateadd(day,2," + Mgr.QuoteStr(EndTime.Text) + ") " + " AND ReqState = " + cbx_type.SelectedValue.ToString( ); if (!string.IsNullOrEmpty(tbxEmployID.Text)) { if (!Mgr.CheckInt(tbxEmployID.Text)) { Mgr.ShowAlert(this, "工号只能是数字!"); return; } s += " AND d2.employeecode=" + tbxEmployID.Text; } s += " ORDER BY 工号"; DBBase db = new DBBase( ); DataTable tb = new DataTable( ); tb = db.SqlOpen(s); ReqDataView.DataSource = tb; ReqDataView.DataBind( ); }
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, "添加失败"); } }
private bool DealReq(int n, int rn) { string s = ""; switch (n) { case 0: string cardtime = ReqDataView.Rows[rn].Cells[10].Text; string tmp = Convert.ToDateTime(cardtime).ToString("yyyy-MM-dd"); s = "INSERT INTO OriginalCheckData VALUES(" + Mgr.QuoteStr(ReqDataView.DataKeys[rn].Values[1].ToString()) + ","; s += Mgr.QuoteStr(cardtime) + "," + Mgr.QuoteStr(tmp) + ",'00:00:00',0," + ReqDataView.DataKeys[rn].Values[2].ToString( ); s += ",0,0,0, '手工补卡')"; break; case 1: string btime = ReqDataView.Rows[rn].Cells[11].Text; string etime = ReqDataView.Rows[rn].Cells[12].Text; string lr = ReqDataView.Rows[rn].Cells[6].Text; s = " INSERT INTO AskLeaveRegister VALUES(" + ReqDataView.DataKeys[rn].Values[2].ToString( ) + "," + ReqDataView.DataKeys[rn].Values[3].ToString( ) + ","; s += Mgr.QuoteStr(btime) + "," + Mgr.QuoteStr(btime) + "," + Mgr.QuoteStr(etime) + "," + Mgr.QuoteStr(etime) + "," + Session["RKey"].ToString( ) + ","; s += Mgr.QuoteStr(lr) + ", '手工请假' , getdate(),1)"; break; case 2: string rwt = ReqDataView.Rows[rn].Cells[13].Text; string rot = ReqDataView.Rows[rn].Cells[14].Text; string cd = ReqDataView.Rows[rn].Cells[10].Text; s = "UPDATE Onoffdutydata SET locked=1,SumCN = 0,SumCT=0,SumZN=0,SumZT=0,SumKN=0,SumKT=0 ,YTNote='修改工时', RWT = " + rwt.ToString( ) + ", ROT=" + rot.ToString( ); s += " WHERE checkdate=" + Mgr.QuoteStr(cd) + " AND employeeid=" + Mgr.QuoteStr(ReqDataView.DataKeys[rn].Values[2].ToString( )); break; default: return(false); break; } DBBase db = new DBBase( ); if (db.SqlExec(s) <= 0) { //errstr += "第 " + rn.ToString( ) + " 条 处理失败!!\\n"; return(false); } else { //errstr += "第 " + rn.ToString( ) + " 条 处理成功!!\\n"; s = "UPDATE Req SET Reqstate = 2, Dealtime=getdate(), dealPerson=" + Mgr.QuoteStr(Session["USER_FULL_NAME"].ToString( )) + " WHERE RKey = " + ReqDataView.DataKeys[rn].Values[0].ToString( ); db.SqlExec(s); return(true); } }
private void GetData() { if (!Mgr.CheckLogin(this, 2)) { return; } string s = "SELECT d1.rkey ,d2.employeecode as 工号, d2.chinesename as 姓名, "; s += " (case reqstate when 0 then '未提交' when 1 then '已提交' when 2 then '已审核' when 3 then '退回' end) as 状态, reqinfo as 备注, reqperson as 提交人,"; s += " reqtime as 提交时间, (case reqtype when 0 then '补卡' when 1 then '请假' when 2 then '修改工时' end ) as 类型, req_cardtime as 时间, req_starttime as 始,"; s += " req_endtime as 终, zbhour as 正班, jbhour as 加班, dealperson as 受理人, dealtime as 受理时间 "; s += " FROM Req d1 INNER JOIN employeemsg d2 ON d1.employeeid = d2.rkey "; s += " WHERE ReqPerson = " + Mgr.QuoteStr(Session["USER_FULL_NAME"].ToString( )) + " AND Reqtime BETWEEN " + Mgr.QuoteStr(BeginTime.Text) + " AND "; s += " dateadd(day,2," + Mgr.QuoteStr(EndTime.Text) + ") " + " AND ReqState = " + cbx_type.SelectedValue.ToString( ); s += " ORDER BY Reqtime"; DBBase db = new DBBase( ); DataTable tb = new DataTable( ); tb = db.SqlOpen(s); ReqDataView.DataSource = tb; ReqDataView.DataBind( ); }
protected void Button1_Click(object sender, EventArgs e) { DBBase db = new DBBase( ); string s = ""; DataTable dt = new DataTable( ); switch (SelectType.SelectedIndex) { case 0: if (!Mgr.CheckStr(GH.Text)) { Mgr.ShowAlert(this, "工号不正确"); return; } s = "select departmentname AS '部门名字', employeecode AS '工号', chinesename AS '姓名',ondutytime AS '入职日期',qualified as '休假资格',year_s3 as '年假产生年',year_s1 AS '休假年',shouldhav AS '年假天数', h_used AS '已休天数',h_left AS '剩余天数' from dbo.V_employee_yearholiday "; s += " WHERE employeecode = " + GH.Text; s += " AND year_s1 = " + Mgr.QuoteStr(Convert.ToDateTime(YearTime.Text).Year.ToString( )); s += " order By employeecode ASC"; dt = db.SqlOpen(s); GridView1.DataSource = dt; GridView1.DataBind( ); break; case 1: s = "select departmentname AS '部门名字', employeecode AS '工号', chinesename AS '姓名',ondutytime AS '入职日期',qualified as '休假资格',year_s3 as '年假产生年',year_s1 AS '休假年',shouldhav AS '年假天数', h_used AS '已休天数',h_left AS '剩余天数' from dbo.V_employee_yearholiday "; s += " WHERE departmentname = " + Mgr.QuoteStr(cbx_depart.SelectedItem.Text); s += " AND year_s1 = " + Mgr.QuoteStr(Convert.ToDateTime(YearTime.Text).Year.ToString( )); s += " order By employeecode ASC"; dt = db.SqlOpen(s); GridView1.DataSource = dt; GridView1.DataBind( ); break; default: break; } }
private bool checkuser(string username, string usercode) { string s = "SELECT Rkey,chinesename, employeecode , Cardno FROM employeemsg WHERE chinesename=" + Mgr.QuoteStr(username) + " AND employeecode=" + Mgr.QuoteStr(usercode); DBBase db = new DBBase( ); DataTable dt = new DataTable( ); dt = db.SqlOpen(s); if (dt.Rows.Count > 0) { Cardno = dt.Rows[0]["Cardno"].ToString( ); rkey = dt.Rows[0]["Rkey"].ToString( ); return(true); } return(false); }