protected void UltraWebGridKQM_InitializeLayout(object sender, LayoutEventArgs e) { int i; string str = ""; string time = ""; OTMTotalQryModel modelMonthTotal = new OTMTotalQryModel(); OTMTotalQryBll bllOTMQry = new OTMTotalQryBll(); modelMonthTotal.BillNo = this.HiddenBillNo.Value; DataTable dt_monthtotal = bllOTMQry.GetOTMQryList(modelMonthTotal); if (dt_monthtotal.Rows.Count > 0) { str = dt_monthtotal.Rows[0]["YearMonth"].ToString(); time = (str.Substring(0, 4) + "/" + str.Substring(4, 2)).ToString(); } DateTime YearMonth = Convert.ToDateTime(time + "/01"); if (this.HiddenYearMonth.Value.Length == 0) { this.HiddenYearMonth.Value = YearMonth.ToString(); foreach (UltraGridColumn c in e.Layout.Bands[0].Columns) { c.Header.RowLayoutColumnInfo.OriginY = 1; } ColumnHeader ch = new ColumnHeader(true) { Caption = Resources.ControlText.gvApplyHours }; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 8; ch.RowLayoutColumnInfo.SpanX = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ColumnHeader ch2 = new ColumnHeader(true) { Caption = Resources.ControlText.gvRelSalaryHours }; ch2.RowLayoutColumnInfo.OriginY = 0; ch2.RowLayoutColumnInfo.OriginX = 11; ch2.RowLayoutColumnInfo.SpanX = 3; ch2.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch2); ColumnHeader ch3 = new ColumnHeader(true) { Caption = Resources.ControlText.gvSpecApplyHours }; ch3.RowLayoutColumnInfo.OriginY = 0; ch3.RowLayoutColumnInfo.OriginX = 14; ch3.RowLayoutColumnInfo.SpanX = 3; ch3.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch3); ColumnHeader ch4 = new ColumnHeader(true) { Caption = Resources.ControlText.gvSpecrelSalary }; ch4.RowLayoutColumnInfo.OriginY = 0; ch4.RowLayoutColumnInfo.OriginX = 17; ch4.RowLayoutColumnInfo.SpanX = 3; ch4.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch4); for (i = 1; i < 0x20; i++) { ColumnHeader chr = new ColumnHeader(true) { Caption = i.ToString() }; chr.RowLayoutColumnInfo.OriginY = 0; chr.RowLayoutColumnInfo.OriginX = i + 0x19; chr.RowLayoutColumnInfo.SpanX = 1; chr.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(chr); } ch = e.Layout.Bands[0].Columns.FromKey("CheckBoxAll").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("DISSIGNRMARK").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("WorkNo").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("LocalName").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("BuName").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("DName").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("OverTimeType").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("G2Remain").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("MAdjust1").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("MRelAdjust").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("AdvanceAdjust").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; ch = e.Layout.Bands[0].Columns.FromKey("RestAdjust").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; } else { HiddenYearMonth.Value = dt_monthtotal.Rows[0]["YearMonth"].ToString().Replace("/", ""); //this.HiddenYearMonth.Value = this.txtYearMonth.Text.Replace("/", ""); } YearMonth = Convert.ToDateTime(HiddenYearMonth.Value); string FromKeyName = ""; for (i = 1; i < 0x20; i++) { FromKeyName = "Day" + i.ToString(); e.Layout.Bands[0].Columns.FromKey(FromKeyName).Header.Caption = this.GetWeek(YearMonth.AddDays((double)(i - 1))); if (this.isHoliday(i, YearMonth)) { e.Layout.Rows.Band.Columns[e.Layout.Bands[0].Columns.FromKey(FromKeyName).Index].CellStyle.BackColor = Color.DarkKhaki; } else { e.Layout.Rows.Band.Columns[e.Layout.Bands[0].Columns.FromKey(FromKeyName).Index].CellStyle.BackColor = Color.White; } } }
protected void btnAuditAll_Click(object sender, EventArgs e) { string YearMonth = this.txtYearMonth.Text.Replace("/", ""); string YearMonthNow = DateTime.Now.ToString("yyyyMM"); logmodel.ProcessFlag = "update"; if (YearMonth.Equals(YearMonthNow)) { Page.ClientScript.RegisterStartupScript(GetType(), "show", "alert('" + Message.NoDataAudit + "')", true); } else { for (int i = 0; i < dt.Rows.Count; i++) { string status = "2"; string sqlDep = base.SqlDep; model.Approver = CurrentUserInfo.Personcode; string workNo = dt.Rows[i]["WorkNo"].ToString(); string yearMonth = dt.Rows[i]["YearMonth"].ToString(); int flag = bllOTMQry.UpdateMonthTal(workNo, yearMonth, status, model, logmodel); } model = new OTMTotalQryModel(); DataUIBind(); this.ProcessFlag.Value = ""; } }
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; } }
protected void pager_PageChanged(object sender, EventArgs e) { model = PageHelper.GetModel<OTMTotalQryModel>(pnlContent.Controls); DataUIBind(); this.txtBatchEmployeeNo.Text = ""; }
protected void btnSpecQuery_Click(object sender, EventArgs e) { this.QueryFlag.Value = "Spec"; this.OTMmsg.Text = "(" + Resources.ControlText.btnSpecQuery + ")"; model = PageHelper.GetModel<OTMTotalQryModel>(pnlContent.Controls); pager.CurrentPageIndex = 1; DataUIBind(); this.txtBatchEmployeeNo.Text = ""; this.OTMmsg.Text = ""; }
protected void btnSave_Click(object sender, EventArgs e) { if (this.UltraWebGridOTMMonthTotal.Rows.Count != 0) { int i; int intDeleteOk = 0; int intDeleteError = 0; logmodel.ProcessFlag = "update"; TemplatedColumn tcol = (TemplatedColumn)this.UltraWebGridOTMMonthTotal.Bands[0].Columns[0]; for (i = 0; i < this.UltraWebGridOTMMonthTotal.Rows.Count; i++) { if (((tcol.CellItems[i] as CellItem).FindControl("CheckBoxCell") as CheckBox).Checked) { string workNo = this.UltraWebGridOTMMonthTotal.Rows[i].Cells.FromKey("WorkNo").Text.Trim(); string yearMonth = this.UltraWebGridOTMMonthTotal.Rows[i].Cells.FromKey("YearMonth").Text.Trim(); string status = "2"; //model.ApproveDate = Convert.ToDateTime(txtApproveDate.Text.ToString()); model.Approver = txtApprover.Text.ToString(); int flag = bllOTMQry.UpdateMonthTal(workNo, yearMonth, status, model, logmodel); if (flag == 1) { intDeleteOk++; } else { intDeleteError++; } } } if ((intDeleteOk + intDeleteError) > 0) { string alertText = Message.AuditSucccess + ":" + intDeleteOk + "," + Message.AuditFaile + ":" + intDeleteError; Page.ClientScript.RegisterStartupScript(GetType(), "show", "alert('" + alertText + "')", true); } model = new OTMTotalQryModel(); DataUIBind(); this.ProcessFlag.Value = ""; } }
protected void btnQuery_Click(object sender, EventArgs e) { this.QueryFlag.Value = "All"; model = PageHelper.GetModel<OTMTotalQryModel>(pnlContent.Controls); pager.CurrentPageIndex = 1; DataUIBind(); this.txtBatchEmployeeNo.Text = ""; }
protected void btnBatchCancelAudit_Click(object sender, EventArgs e) { logmodel.ProcessFlag = "update"; for (int i = 0; i < dt.Rows.Count; i++) { string status = "0"; string workNo = dt.Rows[i]["WorkNo"].ToString(); string yearMonth = dt.Rows[i]["YearMonth"].ToString(); model.Approver = ""; model.ApproveDate = null; int flag = bllOTMQry.UpdateMonthTal(workNo, yearMonth, status, model, logmodel); } model = new OTMTotalQryModel(); DataUIBind(); this.ProcessFlag.Value = ""; }