public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string WorkNo = context.Request.QueryString["WorkNo"];
string KQDate = context.Request.QueryString["KQDate"];
string ShiftNo = context.Request.QueryString["ShiftNo"];
string sResult = "";
Bll_AbnormalAttendanceHandle bll_abnormal = new Bll_AbnormalAttendanceHandle();
DataTable dt_Card = new DataTable();
dt_Card = bll_abnormal.GetBellCardData(WorkNo, KQDate, ShiftNo);
sResult = "<table cellspacing=0 cellpadding=0 width=100%>";
sResult += "<tr>";
sResult += "<td class=td_label align=center height=25 width=20>No</td>";
sResult += "<td class=td_label height=25 width=60>" + Message.WorkNo + "</td>";
sResult += "<td class=td_label height=25 width=70>" + Message.LocalName + "</td>";
sResult += "<td class=td_label height=25 width=140>" + Message.CardTime + "</td>";
sResult += "<td class=td_label height=25 width=90>" + Message.BellNo + "</td>";
sResult += "<td class=td_label height=25 width=140>" + Message.ReadTime + "</td>";
sResult += "<td class=td_label height=25 width=80>" + Message.CardNo + "</td>";
sResult += "</tr>";
if (dt_Card != null && dt_Card.Rows.Count > 0)
{
for (int i = 0; i <dt_Card.Rows.Count; i++)
{
string temp_WorkNo = dt_Card.Rows[i]["WORKNO"].ToString();
string temp_LocalName = dt_Card.Rows[i]["LOCALNAME"].ToString();
string temp_CardTime = dt_Card.Rows[i]["CARDTIME"].ToString();
string temp_BellNo = dt_Card.Rows[i]["BELLNO"].ToString();
string temp_ReadTime = dt_Card.Rows[i]["READTIME"].ToString();
string temp_CardNo = dt_Card.Rows[i]["CARDNO"].ToString();
sResult += "<tr>";
sResult += "<td class=td_label align=center height=25>" + (i+1).ToString() + "</td>";
sResult += "<td class=td_label height=25>" + temp_WorkNo + "</td>";
sResult += "<td class=td_label height=25>" + temp_LocalName + "</td>";
sResult += "<td class=td_label height=25>" + temp_CardTime + "</td>";
sResult += "<td class=td_label height=25>" + temp_BellNo + "</td>";
sResult += "<td class=td_label height=25>" + temp_ReadTime + "</td>";
sResult += "<td class=td_label height=25>" + temp_CardNo + "</td>";
sResult += "</tr>";
}
}
sResult += "</table>";
context.Response.Write(sResult);
}
//考勤異常簽核單KQE
protected void UltraWebGridKQE_DataBound(object sender, EventArgs e)
{
string WorkNo = "", KqDate = "";
Bll_AbnormalAttendanceHandle bll_getExcep = new Bll_AbnormalAttendanceHandle();
for (int i = 0; i < UltraWebGridKQE.Rows.Count; i++)
{
WorkNo = UltraWebGridKQE.Rows[i].Cells.FromKey("WorkNo").Value == null ? "" : UltraWebGridKQE.Rows[i].Cells.FromKey("WorkNo").Text;
KqDate = UltraWebGridKQE.Rows[i].Cells.FromKey("KQDate").Value == null ? "" : Convert.ToDateTime(UltraWebGridKQE.Rows[i].Cells.FromKey("KQDate").Text).ToString("yyyy/MM/dd");
UltraWebGridKQE.Rows[i].Cells.FromKey("ExcepTionQty").Value = bll_getExcep.GetExceptionqty(WorkNo, KqDate);
}
}
private void Query(string BillNo)
{
string condition = "";
//抓取簽核流程
condition = "and a.BillNo ='" + BillNo + "'";
this.dataSet = bll.GetAuditDataByCondition(condition);
UltraWebGridStatus.DataSource = this.dataSet.Tables["WFM_AuditStatus"].DefaultView;
UltraWebGridStatus.DataBind();
//獲取表頭基本信息
switch (this.HiddenBillTypeNo.Value)
{
//case "KQMLeaveApply"://請假申請簽核單OTE
case "HolidayApplyC"://Holiday (<=5 day) HAC
case "HolidayApplyD"://Holiday (>5 day) HAD
case "HolidayApplyH"://Other leave HAH
case "ExEvection"://國外出差申請簽核單OTE
case "ExEvectionCancel"://國外銷差申請簽核單ERC
case "CEMVacReportRequest"://述職/休假申請簽核單VRN
case "InEvection"://國內出差申請簽核單
case "InEvectionCancel"://國內銷差申請簽核單
case "ETMCurriculaPlan"://課程規劃簽核單ECP
//condition = "SELECT * FROM (select (case when (select BillTypeCode From BFW_BillType c Where c.BillTypeNo=substr(a.BillNo,0,3))='KQMLeaveApply' " +
// "then (select BillTypeName From BFW_BillType c Where c.BillTypeNo=substr(a.BillNo,0,3))||'-'|| " +
// "(select LVTypeName from KQM_LeaveType c where c.LVTypeCode= " +
// "(select LVTypeCode from kqm_leaveapply d where d.BillNo=a.BillNo and rownum=1)) " +
// "else (select BillTypeName From BFW_BillType c Where c.BillTypeCode=a.BillTypeCode) end) BillTypeName " +
// "from WFM_Bill a " +
// "Where a.BillNo ='" + BillNo + "')";
//this.labelBillTypeName.Text = ((eBFW.Sys.ServiceLocator)Session["serviceLocator"]).GetFunctionData().GetValue(condition);
break;
default:
condition = "and a.BillNo ='" + BillNo + "'";
this.tempDataTable = bll.GetDataByCondition_Bill(condition).Tables["WFM_Bill"];
if (this.tempDataTable.Rows.Count > 0)
{
this.textBoxOrgName.Text = bll.GetAllDept(tempDataTable.Rows[0]["OrgCode"].ToString(), true);
this.HiddenOrgCode.Value = tempDataTable.Rows[0]["OrgCode"].ToString();
this.textBoxApplyMan.Text = tempDataTable.Rows[0]["ApplyManName"].ToString();
if (tempDataTable.Rows[0]["ApplyDate"].ToString().Length > 0)
{
this.textBoxApplyDate.Text = string.Format("{0:" + System.Convert.ToString("yyyy/MM/dd") + "}", Convert.ToDateTime(tempDataTable.Rows[0]["ApplyDate"].ToString()));
}
this.labelBillTypeName.Text = tempDataTable.Rows[0]["BillTypeName"].ToString();
}
else
{
Response.Write("<script type='text/javascript'>alert('" + Message.wfm_message_billdeleted + "');window.close();</script>");
return;
}
break;
}
string inWorkNum = "0", AdvanceNum = "0", LeaveNum = "0", Percent = "0";
switch (this.HiddenBillTypeNo.Value)
{
case "LeaveTypeA"://辭職申請簽核單LVA
case "LeaveTypeB"://自離申請簽核單LVB
case "ExEvection"://國外出差申請簽核單OTE
case "ExEvectionCancel"://國外銷差申請簽核單ERC
case "CEMVacReportRequest"://述職/休假申請簽核單VRN
case "InEvection"://國內出差申請簽核單
case "InEvectionCancel"://國內銷差申請簽核單
case "ETMCurriculaPlan"://課程規劃簽核單ECP
case "SCMRequire"://鞋櫃申請單SCM
case "OrgMove"://調動申請MVB
break;
default:
//今日在職人數
condition = "select count(1) from GDS_ATT_EMPLOYEE a where a.flag='Local' and a.Status='0' " +
"and a.DCode in (SELECT DepCode FROM GDS_SC_DEPARTMENT START WITH " +
"depcode='" + this.HiddenOrgCode.Value + "' CONNECT BY PRIOR depcode = parentdepcode) ";
inWorkNum = bll.GetValue(condition);
//今日加班預報人數
condition = "select count(1) from GDS_ATT_ADVANCEAPPLY a, GDS_ATT_EMPLOYEE b " +
"where a.WorkNo=b.WorkNo and a.OTDate=trunc(sysdate) and b.flag='Local' and b.Status='0' " +
"AND b.DCode in (SELECT DepCode FROM GDS_SC_DEPARTMENT START WITH " +
"depcode='" + this.HiddenOrgCode.Value + "' CONNECT BY PRIOR depcode = parentdepcode) ";
AdvanceNum = bll.GetValue(condition);
//今日請假人數
condition = "select count(1) from GDS_ATT_LEAVEAPPLY a, GDS_ATT_EMPLOYEE b " +
"where a.WorkNo=b.WorkNo and a.StartDate>=trunc(sysdate) and a.EndDate<=trunc(sysdate) " +
"and b.flag='Local' and b.Status='0' " +
"AND b.DCode in (SELECT DepCode FROM GDS_SC_DEPARTMENT START WITH " +
"depcode='" + this.HiddenOrgCode.Value + "' CONNECT BY PRIOR depcode = parentdepcode) ";
LeaveNum = bll.GetValue(condition);
break;
}
switch (this.HiddenBillTypeNo.Value)
{
case "D001"://加班預報簽核單OTA 需要做的操作
case "OTMProjectApply":
string isProject = bll.GetValue("Select nvl(Max(isProject),'N') from GDS_ATT_ADVANCEAPPLY where billno='" + BillNo + "' and rownum<=1");
if (isProject.Equals("Y"))
{
//this.labelBillTypeName.Text = ((eBFW.Sys.ServiceLocator)Session["serviceLocator"]).GetFunctionData().GetValue("Select BillTypeName From Bfw_BillType Where BillTypeCode='OTMAdvanceApplyG3'");
this.HiddenisProject.Value = isProject;
}
else
{
this.UltraWebGridOTA.Bands[0].Columns.FromKey("CheckBoxISPay").Hidden = true;
}
condition = "";
condition += "and a.BillNo ='" + BillNo + "'";
if (!this.HiddenSFlag.Value.Equals("Y"))
{
condition += " and a.Status='1'";
}
this.dataSet = bll.GetDataByCondition(condition);
UltraWebGridOTA.Visible = true;
UltraWebGridOTA.DataSource = this.dataSet.Tables["OTM_AdvanceApply"].DefaultView;
UltraWebGridOTA.DataBind();
try
{
Percent = Convert.ToString(System.Math.Round(Convert.ToDecimal(AdvanceNum) / Convert.ToDecimal(inWorkNum) * 100, 0));
}
catch (System.Exception)
{ }
this.labelMessage.Text = Message.wfm_inworknum + inWorkNum + "；" +
Message.wfm_advancenum + AdvanceNum + "；" +
Message.wfm_leavenum + LeaveNum + "；" +
Message.wfm_advancepercent + Percent + "%；" +
Message.wfm_billauditcount + this.dataSet.Tables["OTM_AdvanceApply"].Rows.Count.ToString();
break;
case "KQMApplyOut"://外出申請簽核單KQT 需要做的操作
KQMEvectionApplyBll bllKQTOut = new KQMEvectionApplyBll();
KQMEvectionApplyModel modelKQTOut = new KQMEvectionApplyModel();
modelKQTOut.BillNo = BillNo;
//condition += "and a.BillNo ='" + BillNo + "'";
DataTable dt = bllKQTOut.GetEvectionList(modelKQTOut);
UltraWebGridKQT.Visible = true;
UltraWebGridKQT.DataSource = dt.DefaultView;
UltraWebGridKQT.DataBind();
this.labelMessage.Text = Message.wfm_inworknum + inWorkNum + "；" +
Message.wfm_advancenum + AdvanceNum + "；" +
Message.wfm_leavenum + LeaveNum + "；" +
Message.wfm_advancepercent + Percent + "%；" +
Message.wfm_billauditcount + dt.Rows.Count.ToString();
break;
case "D002":
KQMLeaveApplyExportBll kqmLeaveApply = new KQMLeaveApplyExportBll();
LeaveApplyViewModel leaveApplyViewModel = new LeaveApplyViewModel();
leaveApplyViewModel.BillNo = BillNo;
DataTable dtLeaveApply = kqmLeaveApply.getLeaveApply(leaveApplyViewModel);
UltraWebGridLeaveApply.Visible = true;
UltraWebGridLeaveApply.DataSource = dtLeaveApply;
UltraWebGridLeaveApply.DataBind();
this.labelMessage.Text = Message.wfm_inworknum + inWorkNum + "；" +
Message.wfm_advancenum + AdvanceNum + "；" +
Message.wfm_leavenum + LeaveNum + "；" +
Message.wfm_advancepercent + Percent + "%；" +
Message.wfm_billauditcount + dtLeaveApply.Rows.Count.ToString();
break;
case "KQMException"://考勤異常簽核單KQE
string Status = "";
condition = "";
condition += "and a.BillNo ='" + BillNo + "'";
if (!this.HiddenSFlag.Value.Equals("Y"))
{
Status = "4";
}
Bll_AbnormalAttendanceHandle bll_signabnormal = new Bll_AbnormalAttendanceHandle();
DataTable dt_signabnormal = bll_signabnormal.GetSignAbnormalAttendanceInfo(BillNo, Status);
UltraWebGridKQE.DataSource = dt_signabnormal;
UltraWebGridKQE.DataBind();
UltraWebGridKQE.Visible = true;
this.labelMessage.Text = Message.wfm_inworknum + inWorkNum + "；" + Message.wfm_leavenum + LeaveNum + "；" + Message.wfm_billauditcount + dt_signabnormal.Rows.Count.ToString();
break;
case "KQMMonthTotal"://外出申請簽核單KQT 需要做的操作
OTMTotalQryModel modelMonthTotal = new OTMTotalQryModel();
OTMTotalQryBll bllOTMQry = new OTMTotalQryBll();
modelMonthTotal.BillNo = BillNo;
DataTable dt_monthtotal = bllOTMQry.GetOTMQryList(modelMonthTotal);
UltraWebGridKQM.Visible = true;
UltraWebGridKQM.DataSource = dt_monthtotal.DefaultView;
UltraWebGridKQM.DataBind();
this.labelMessage.Text = Message.wfm_inworknum + inWorkNum + "；" +
Message.wfm_advancenum + AdvanceNum + "；" +
Message.wfm_leavenum + LeaveNum + "；" +
Message.wfm_advancepercent + Percent + "%；" +
Message.wfm_billauditcount + dt_monthtotal.Rows.Count.ToString();
break;
#region 免卡人員加班
case "KQMOTMA": //免卡人員加班TMA
Status = "";
condition = "";
condition += "and a.BillNo ='" + BillNo + "'";
if (!this.HiddenSFlag.Value.Equals("Y"))
{
Status = "1";
}
OTMActivityApplyBll activityApplyBll = new OTMActivityApplyBll();
DataTable tmaTB = activityApplyBll.getAuditBillInfoByBillNo(condition, Status);// bll_signabnormal.GetSignAbnormalAttendanceInfo(BillNo, Status);
UltraWebGridTMA.DataSource = tmaTB;
UltraWebGridTMA.DataBind();
UltraWebGridTMA.Visible = true;
this.labelMessage.Text = Message.wfm_inworknum + inWorkNum + "；" + Message.wfm_leavenum + LeaveNum + "；" + Message.wfm_billauditcount + tmaTB.Rows.Count.ToString();
break;
#endregion
#region 未刷補卡
case "KQMMakeup": //未刷補卡
Status = "";
condition = "";
condition += "and a.BillNo ='" + BillNo + "'";
if (!this.HiddenSFlag.Value.Equals("Y"))
{
condition += " and a.Status='1' ";
}
// Bll_AbnormalAttendanceHandle bll_signabnormal = new Bll_AbnormalAttendanceHandle();
// OTMActivityApplyBll KQMMakeupBll = new OTMActivityApplyBll();
WorkFlowCardMakeupBll cardMakeupBll = new WorkFlowCardMakeupBll();
int totalCount = 0;
DataTable tmaKQMMakeupTB = cardMakeupBll.getCardMakeupList(condition, 1, Int32.MaxValue, out totalCount);
// DataTable tmaKQMMakeupTB = new DataTable();// bll_signabnormal.GetSignAbnormalAttendanceInfo(BillNo, Status);
UltraWebGridKQU.DataSource = tmaKQMMakeupTB;
UltraWebGridKQU.DataBind();
UltraWebGridKQU.Visible = true;
this.labelMessage.Text = Message.wfm_inworknum + inWorkNum + "；" + Message.wfm_leavenum + LeaveNum + "；" + Message.wfm_billauditcount + tmaKQMMakeupTB.Rows.Count.ToString();
break;
#endregion
default:
break;
}
}
