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;
}
}
}
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;
}
}
