755 lines
45 KiB
Plaintext
755 lines
45 KiB
Plaintext
<%@ Control Language="C#" AutoEventWireup="true"
|
|
CodeFile="fmRowk.ascx.cs" Inherits="forms_worker_fmRowk" %>
|
|
<%@ Register Assembly="WNET" Namespace="Wellan.Web.UI"
|
|
TagPrefix="cc1" %>
|
|
<cc1:WLabel ID="WLabel1" runat="server"
|
|
CssClass="pageTitle" TextMessageId="FMROWK.NAME"></cc1:WLabel>
|
|
<asp:CustomValidator ID="cvMessage"
|
|
runat="server" Display="None"></asp:CustomValidator>
|
|
<table>
|
|
<tr>
|
|
<td align="right">
|
|
<cc1:WLabel ID="WLabel6" runat="server" TextMessageId="">年度：</cc1:WLabel></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtYY" runat="server" Columns="4"
|
|
CssClass="textInput1" MaxLength="4"></asp:TextBox><cc1:WButton
|
|
ID="btnYY" runat="server" AccessKey="Y"
|
|
CssClass="button" OnClick="btnYY_Click"
|
|
Text="Y.確定" /></td>
|
|
<td class="dataEditCell"></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right">
|
|
<cc1:WLabel ID="WLabel3" runat="server"
|
|
TextMessageId="">專案：</cc1:WLabel></td>
|
|
<td class="dataEditCell">
|
|
<cc1:WDropDownList ID="ddlROPYN"
|
|
runat="server" CssClass="textInput1"
|
|
DataTextField="BPPYM" DataValueField="BPPYN"
|
|
Width="500px">
|
|
</cc1:WDropDownList></td>
|
|
<td class="dataEditCell">
|
|
<cc1:WButton ID="Next" runat="server"
|
|
AccessKey="J" CausesValidation="False"
|
|
CssClass="button" OnClick="Next_Click"
|
|
Text="J.選擇專案" UseSubmitBehavior="False" /></td>
|
|
</tr>
|
|
</table>
|
|
<asp:MultiView ID="MultiView1"
|
|
runat="server" ActiveViewIndex="1">
|
|
<asp:View ID="SearchView" runat="server">
|
|
<cc1:WButton ID="btnSearch" runat="server"
|
|
AccessKey="F" CssClass="button"
|
|
OnClick="btnSearch_Click" Text="F.查詢"
|
|
TextMessageId="F.+SEARCH"></cc1:WButton>
|
|
<cc1:WButton ID="btnInsert" runat="server"
|
|
AccessKey="I" CssClass="button"
|
|
OnClick="btnInsert_Click" Text="I.新增"
|
|
TextMessageId="I.+INSERT"></cc1:WButton>
|
|
<cc1:WButton ID="btnCancel" runat="server"
|
|
AccessKey="C" CssClass="button"
|
|
OnClick="btnCancel_Click" Text="C.取消"
|
|
TextMessageId="C.+CANCEL"></cc1:WButton>
|
|
<table>
|
|
<tr>
|
|
<td colspan="1" style="height: 0px; width: 100px"></td>
|
|
<td colspan="1" style="height: 0px; width: 110px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="text-align: right">
|
|
<cc1:WLabel ID="lbROENO" runat="server"
|
|
TextMessageId="ROWK.ROENO+:"></cc1:WLabel>
|
|
</td>
|
|
<td>
|
|
<asp:TextBox ID="txtROENO" runat="server"
|
|
CssClass="textInput"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td style="text-align: right">
|
|
<cc1:WLabel ID="lbROYMM" runat="server"
|
|
TextMessageId="ROWK.ROYMM+:"></cc1:WLabel>
|
|
</td>
|
|
<td>
|
|
<asp:TextBox ID="txtROYMM" runat="server"
|
|
CssClass="textInput"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</asp:View>
|
|
<asp:View ID="EditView" runat="server">
|
|
<asp:SqlDataSource ID="dsROWKGrid"
|
|
runat="server" ConflictDetection="CompareAllValues"
|
|
ConnectionString="Data Source=(local);Initial Catalog=THINKYU_WEB;Persist Security Info=True;User ID=sa"
|
|
ProviderName="System.Data.SqlClient"
|
|
SelectCommand="SELECT * FROM ROWK WHERE 1=0"></asp:SqlDataSource>
|
|
<asp:SqlDataSource ID="dsROWKForm"
|
|
runat="server" ConflictDetection="CompareAllValues"
|
|
DeleteCommand="DELETE ROWK
|
|
WHERE ROENO=@OLD_ROENO
|
|
AND ROYMM=@OLD_ROYMM
|
|
AND APPNO = @OLD_APPNO"
|
|
InsertCommand="INSERT INTO ROWK
|
|
(ROENO, ROYMM, ROPYN, ROT01, ROT02, ROT03, ROT04, ROT05, ROA01, ROA02, ROA03, ROA05, TRDAT, TRMOD, TRUSR, APPNO)
|
|
VALUES
|
|
(@ROENO, @ROYMM, @ROPYN, @ROT01 * 60, @ROT02 * 60, @ROT03 * 60, @ROT04 * 60, @ROT05 * 60, @ROA01, @ROA02, @ROA03, @ROA05, GETDATE(), 'INSERT', @TRUSR, 1)"
|
|
OldValuesParameterFormatString="OLD_{0}"
|
|
SelectCommand="SELECT * FROM ROWK WHERE ROENO=@ROENO AND ROYMM=@ROYMM"
|
|
UpdateCommand="UPDATE ROWK SET
|
|
ROENO = @ROENO,
|
|
ROYMM = @ROYMM,
|
|
ROT01 = @ROT01 * 60,
|
|
ROT02 = @ROT02 * 60,
|
|
ROT03 = @ROT03 * 60,
|
|
ROT04 = @ROT04 * 60,
|
|
ROT05 = @ROT05 * 60,
|
|
ROA01 = @ROA01,
|
|
ROA02 = @ROA02,
|
|
ROA03 = @ROA03,
|
|
ROA05 = @ROA05,
|
|
TRDAT = GETDATE(),
|
|
TRMOD = 'UPDATE',
|
|
TRUSR = @TRUSR,
|
|
APPNO = APPNO + 1
|
|
WHERE ROENO=@OLD_ROENO
|
|
AND ROYMM=@OLD_ROYMM
|
|
AND APPNO = @OLD_APPNO"
|
|
ConnectionString="Data Source=(local);Initial Catalog=THINKYU_WEB;Persist Security Info=True;User ID=sa"
|
|
ProviderName="System.Data.SqlClient">
|
|
<SelectParameters>
|
|
<asp:ControlParameter ControlID="gvROWK"
|
|
Name="ROENO" PropertyName="SelectedDataKey["ROENO"]" />
|
|
<asp:ControlParameter ControlID="gvROWK"
|
|
Name="ROYMM" PropertyName="SelectedDataKey["ROYMM"]" />
|
|
</SelectParameters>
|
|
<DeleteParameters>
|
|
<asp:Parameter Name="OLD_ROENO" />
|
|
<asp:Parameter Name="OLD_ROYMM" />
|
|
<asp:Parameter Name="OLD_APPNO" />
|
|
</DeleteParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="ROENO" />
|
|
<asp:Parameter Name="ROYMM" />
|
|
<asp:Parameter Name="ROT01" />
|
|
<asp:Parameter Name="ROT02" />
|
|
<asp:Parameter Name="ROT03" />
|
|
<asp:Parameter Name="ROT04" />
|
|
<asp:Parameter Name="ROT05" />
|
|
<asp:Parameter Name="ROA01" />
|
|
<asp:Parameter Name="ROA02" />
|
|
<asp:Parameter Name="ROA03" />
|
|
<asp:Parameter Name="ROA05" />
|
|
<asp:SessionParameter DefaultValue=""
|
|
Name="TRUSR" SessionField="W_CUSR" />
|
|
<asp:Parameter Name="OLD_ROENO" />
|
|
<asp:Parameter Name="OLD_ROYMM" />
|
|
<asp:Parameter Name="OLD_APPNO" />
|
|
</UpdateParameters>
|
|
<InsertParameters>
|
|
<asp:Parameter Name="ROENO" />
|
|
<asp:Parameter Name="ROYMM" />
|
|
<asp:Parameter Name="ROPYN" />
|
|
<asp:Parameter Name="ROT01" />
|
|
<asp:Parameter Name="ROT02" />
|
|
<asp:Parameter Name="ROT03" />
|
|
<asp:Parameter Name="ROT04" />
|
|
<asp:Parameter Name="ROT05" />
|
|
<asp:Parameter Name="ROA01" />
|
|
<asp:Parameter Name="ROA02" />
|
|
<asp:Parameter Name="ROA03" />
|
|
<asp:Parameter Name="ROA05" />
|
|
<asp:SessionParameter DefaultValue=""
|
|
Name="TRUSR" SessionField="W_CUSR" />
|
|
</InsertParameters>
|
|
</asp:SqlDataSource>
|
|
|
|
<asp:FormView ID="fvROWK" runat="server"
|
|
DataKeyNames="ROENO,ROYMM,APPNO"
|
|
DataSourceID="dsROWKForm">
|
|
<ItemTemplate>
|
|
<cc1:WButton ID="btnInsert" runat="server"
|
|
AccessKey="I" CommandName="New"
|
|
CssClass="button" Text="I.新增"
|
|
TextMessageId="I.+INSERT"></cc1:WButton>
|
|
<cc1:WButton ID="btnEdit" runat="server"
|
|
AccessKey="M" CommandName="Edit"
|
|
CssClass="button" Text="M.更正"
|
|
TextMessageId="M.+UPDATE"></cc1:WButton>
|
|
<cc1:WButton ID="btnDelete" runat="server"
|
|
AccessKey="T" CommandName="Delete"
|
|
CssClass="button" OnClientClick="return confirm(msgConfirmDelete);"
|
|
Text="T.刪除" TextMessageId="T.+DELETE"></cc1:WButton>
|
|
<cc1:WButton ID="btnSearch" runat="server"
|
|
AccessKey="F" CommandName="Search"
|
|
CssClass="button" Text="F.查詢"
|
|
TextMessageId="F.+SEARCH"></cc1:WButton>
|
|
<table border="0" cellpadding="2"
|
|
cellspacing="2" width="1" style="table-layout: fixed">
|
|
<tr>
|
|
<td colspan="1" style="height: 0px; width: 100px"></td>
|
|
<td colspan="1" style="height: 0px; width: 120px"></td>
|
|
<td colspan="1" style="height: 0px; width: 100px"></td>
|
|
<td colspan="1" style="height: 0px; width: 120px"></td>
|
|
<td colspan="1" style="height: 0px; width: 140px"></td>
|
|
<td colspan="1" style="height: 0px; width: 120px"></td>
|
|
<td colspan="1" style="height: 0px; width: 100px"></td>
|
|
<td colspan="1" style="height: 0px; width: 120px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="1" align="right">
|
|
<cc1:WLabel ID="lbROWK_ROENOLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROENO+:">員工編號:</cc1:WLabel>
|
|
</td>
|
|
<td colspan="1" class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROENO" runat="server"
|
|
Text='<%# Bind("ROENO", "{0:c}") %>'
|
|
CssClass="textInput"></asp:Label>
|
|
</td>
|
|
<td class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROENOX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPSN", Eval("ROENO", "{0:c}"), "BPNME", "") %>'></asp:Label>
|
|
</td>
|
|
<td colspan="1" align="right">
|
|
<cc1:WLabel ID="lbROWK_ROPYNLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROPYN+:">專案年度編號:</cc1:WLabel>
|
|
</td>
|
|
<td colspan="1" class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROPYN" runat="server"
|
|
Text='<%# Bind("ROPYN", "{0:c}") %>'
|
|
CssClass="textInput"></asp:Label>
|
|
</td>
|
|
<td colspan="3" class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROPYNX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPAA", Eval("ROPYN", "{0:c}"), "BPPYM", "") %>'></asp:Label>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROYMMLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROYMM+:">月份:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_ROYMM" runat="server"
|
|
Text='<%# Bind("ROYMM", "{0:yyyyMM}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT01Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT01+:">前二加班時數:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_ROT01" runat="server"
|
|
Text='<%# Bind("ROT01", "{0:##0.##}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT02Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT02+:">後二加班時數:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_ROT02" runat="server"
|
|
Text='<%# Bind("ROT02", "{0:##0.##}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
<td colspan="1" align="right">
|
|
<cc1:WLabel ID="WLabel7"
|
|
runat="server" CssClass="controlLabel">超過8小時加班時數:</cc1:WLabel></td>
|
|
<td colspan="1" class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROT05" runat="server"
|
|
Text='<%# Bind("ROT05", "{0:##,##0}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT03Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT03+:">假日加班時數:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_ROT03" runat="server"
|
|
Text='<%# Bind("ROT03", "{0:##0.##}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="1" align="right">
|
|
<cc1:WLabel ID="lbROWK_ROA01Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROA01+:">前二加班費:</cc1:WLabel></td>
|
|
<td colspan="1" class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROA01" runat="server"
|
|
Text='<%# Bind("ROA01", "{0:##,##0}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
<td colspan="1" align="right">
|
|
<cc1:WLabel ID="lbROWK_ROA02Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROA02+:">後二加班費:</cc1:WLabel></td>
|
|
<td colspan="1" class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROA02" runat="server"
|
|
Text='<%# Bind("ROA02", "{0:##,##0}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
<td colspan="1" align="right">
|
|
<cc1:WLabel ID="WLabel5"
|
|
runat="server" CssClass="controlLabel">超過8小時加班費:</cc1:WLabel></td>
|
|
<td colspan="1" class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROA05" runat="server"
|
|
Text='<%# Bind("ROA05", "{0:##,##0}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
<td colspan="1" align="right">
|
|
<cc1:WLabel ID="lbROWK_ROA03Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROA03+:">假日加班費:</cc1:WLabel></td>
|
|
<td colspan="1" class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROA03" runat="server"
|
|
Text='<%# Bind("ROA03", "{0:##,##0}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT04Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT04+:">申請補休時數:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_ROT04" runat="server"
|
|
Text='<%# Bind("ROT04", "{0:##0.##}") %>'
|
|
CssClass="textInput"></asp:Label></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="WLabel2" runat="server"
|
|
CssClass="controlLabel" TextMessageId="">合計加班時數:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_RPT99" runat="server"
|
|
CssClass="textInput" Text='<%# String.Format("{0:###,##0.##}", Convert.ToInt32(Eval("ROT01")) + Convert.ToInt32(Eval("ROT02")) + Convert.ToInt32(Eval("ROT03"))) %>'></asp:Label>
|
|
</td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="WLabel4" runat="server"
|
|
CssClass="controlLabel" TextMessageId="">合計加班費:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_ROA99" runat="server"
|
|
CssClass="textInput" Text='<%# String.Format("{0:###,##0}", Convert.ToInt32(Eval("ROA01")) + Convert.ToInt32(Eval("ROA02")) + Convert.ToInt32(Eval("ROA03"))) %>'></asp:Label>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</ItemTemplate>
|
|
<EditItemTemplate>
|
|
<cc1:WButton ID="btnSave" runat="server"
|
|
AccessKey="S" CommandName="Update"
|
|
CssClass="button" OnClientClick="return confirm(msgConfirmSave);"
|
|
Text="S.存檔" TextMessageId="S.+SAVE"></cc1:WButton>
|
|
<cc1:WButton ID="btnCancel" runat="server"
|
|
AccessKey="C" CommandName="Cancel"
|
|
CssClass="button" OnClientClick="return confirm(msgConfirmCancel);"
|
|
Text="C.取消" TextMessageId="C.+CANCEL"></cc1:WButton>
|
|
<asp:RequiredFieldValidator ID="rfvROENO"
|
|
runat="server" ControlToValidate="txtROWK_ROENO"
|
|
Display="None" ErrorMessage="請輸入人員編號"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROYMM"
|
|
runat="server" ControlToValidate="txtROWK_ROYMM"
|
|
Display="None" ErrorMessage="請輸入月份"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT01"
|
|
runat="server" ControlToValidate="txtROWK_ROT01"
|
|
Display="None" ErrorMessage="請輸入前二加班時數"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT02"
|
|
runat="server" ControlToValidate="txtROWK_ROT02"
|
|
Display="None" ErrorMessage="請輸入後二加班時數"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT03"
|
|
runat="server" ControlToValidate="txtROWK_ROT03"
|
|
Display="None" ErrorMessage="請輸入假日加班時數"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT04"
|
|
runat="server" ControlToValidate="txtROWK_ROT04"
|
|
Display="None" ErrorMessage="請輸入申請補休時數"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT05"
|
|
runat="server" ControlToValidate="txtROWK_ROT05"
|
|
Display="None" ErrorMessage="請輸入超過8小時加班時數"></asp:RequiredFieldValidator>
|
|
<asp:CustomValidator ID="cvROENO"
|
|
runat="server" ControlToValidate="txtROWK_ROENO"
|
|
Display="None" ErrorMessage="員工編號不存在"
|
|
OnServerValidate="cvROENO_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROYMM"
|
|
runat="server" ControlToValidate="txtROWK_ROYMM"
|
|
Display="None" ErrorMessage="請輸入作業年度內的月份"
|
|
OnServerValidate="cvROYMM_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT01"
|
|
runat="server" ControlToValidate="txtROWK_ROT01"
|
|
Display="None" ErrorMessage="前二加班時數請輸入數字"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT02"
|
|
runat="server" ControlToValidate="txtROWK_ROT02"
|
|
Display="None" ErrorMessage="後二加班時數請輸入數字"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT03"
|
|
runat="server" ControlToValidate="txtROWK_ROT03"
|
|
Display="None" ErrorMessage="假日加班時數請輸入數字"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT04"
|
|
runat="server" ControlToValidate="txtROWK_ROT04"
|
|
Display="None" ErrorMessage="申請補休時數請輸入數字"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT05"
|
|
runat="server" ControlToValidate="txtROWK_ROT05"
|
|
Display="None" ErrorMessage="超過8小時加班時數請輸入數字"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<table border="0" cellpadding="2"
|
|
cellspacing="2" style="table-layout: fixed"
|
|
width="1">
|
|
<tr>
|
|
<td colspan="1" style="width: 100px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 100px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 140px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 100px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROENOLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROENO+:">員工編號:</cc1:WLabel>
|
|
</td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<table border="0" cellpadding="0"
|
|
cellspacing="0" style="width: 100%; height: 100%">
|
|
<tr>
|
|
<td width="100">
|
|
<asp:TextBox ID="txtROWK_ROENO"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="10" Text='<%# Bind("ROENO", "{0:c}") %>'></asp:TextBox>
|
|
</td>
|
|
<td>
|
|
<asp:ImageButton ID="btnROWK_ROENO_WQRY"
|
|
runat="server" ImageUrl="~/picture/pickup.gif" />
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
<td class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROENOX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPSN", Eval("ROENO", "{0:c}"), "BPNME", "") %>'></asp:Label>
|
|
</td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROPYNLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROPYN+:">專案年度編號:</cc1:WLabel>
|
|
</td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_ROPYN" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("ROPYN", "{0:c}") %>'></asp:Label></td>
|
|
<td class="dataDisplayCell" colspan="3">
|
|
<asp:Label ID="lbROWK_ROPYNX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPAA", Eval("ROPYN", "{0:c}"), "BPPYM", "") %>'></asp:Label>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROYMMLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROYMM+:">月份:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROYMM"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROYMM", "{0:yyyyMM}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT01Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT01+:">前二加班時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT01"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT01", "{0}") %>'></asp:TextBox></td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT02Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT02+:">後二加班時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT02"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT02", "{0}") %>'></asp:TextBox></td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT05Label"
|
|
runat="server" CssClass="controlLabel">超過8小時加班時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT05"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT05", "{0}") %>'></asp:TextBox></td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT03Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT03+:">假日加班時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT03"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT03", "{0}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT04Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT04+:">申請補休時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT04"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT04", "{0}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
</table>
|
|
<asp:HiddenField ID="rfROWK_APPNO"
|
|
runat="server" Value='<%# Bind("APPNO", "{0}") %>' />
|
|
</EditItemTemplate>
|
|
<InsertItemTemplate>
|
|
<cc1:WButton ID="btnSave" runat="server"
|
|
AccessKey="S" CommandName="Insert"
|
|
CssClass="button" OnClientClick="return confirm(msgConfirmSave);"
|
|
Text="S.存檔" TextMessageId="S.+SAVE"></cc1:WButton>
|
|
<cc1:WButton ID="btnCancel" runat="server"
|
|
AccessKey="C" CommandName="Cancel"
|
|
CssClass="button" OnClientClick="return confirm(msgConfirmCancel);"
|
|
Text="C.取消" TextMessageId="C.+CANCEL"></cc1:WButton>
|
|
<asp:RequiredFieldValidator ID="rfvROENO"
|
|
runat="server" ErrorMessage="請輸入人員編號"
|
|
Display="None" ControlToValidate="txtROWK_ROENO"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROYMM"
|
|
runat="server" ErrorMessage="請輸入月份"
|
|
Display="None" ControlToValidate="txtROWK_ROYMM"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT01"
|
|
runat="server" ErrorMessage="請輸入前二加班時數"
|
|
Display="None" ControlToValidate="txtROWK_ROT01"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT02"
|
|
runat="server" ErrorMessage="請輸入後二加班時數"
|
|
Display="None" ControlToValidate="txtROWK_ROT02"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT03"
|
|
runat="server" ErrorMessage="請輸入假日加班時數"
|
|
Display="None" ControlToValidate="txtROWK_ROT03"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT04"
|
|
runat="server" ControlToValidate="txtROWK_ROT04"
|
|
Display="None" ErrorMessage="請輸入申請補休時數"></asp:RequiredFieldValidator>
|
|
<asp:RequiredFieldValidator ID="rfvROT05"
|
|
runat="server" ControlToValidate="txtROWK_ROT05"
|
|
Display="None" ErrorMessage="請輸入超過8小時加班時數"></asp:RequiredFieldValidator>
|
|
<asp:CustomValidator ID="cvROENO"
|
|
runat="server" ErrorMessage="員工編號不存在"
|
|
Display="None" ControlToValidate="txtROWK_ROENO"
|
|
OnServerValidate="cvROENO_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROYMM"
|
|
runat="server" ErrorMessage="請輸入作業年度內的月份"
|
|
Display="None" ControlToValidate="txtROWK_ROYMM"
|
|
OnServerValidate="cvROYMM_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT01"
|
|
runat="server" ErrorMessage="前二加班時數請輸入數字"
|
|
Display="None" ControlToValidate="txtROWK_ROT01"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT02"
|
|
runat="server" ErrorMessage="後二加班時數請輸入數字"
|
|
Display="None" ControlToValidate="txtROWK_ROT02"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT03"
|
|
runat="server" ErrorMessage="假日加班時數請輸入數字"
|
|
Display="None" ControlToValidate="txtROWK_ROT03"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT04"
|
|
runat="server" ControlToValidate="txtROWK_ROT04"
|
|
Display="None" ErrorMessage="申請補休時數請輸入數字"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<asp:CustomValidator ID="cvROT05"
|
|
runat="server" ControlToValidate="txtROWK_ROT05"
|
|
Display="None" ErrorMessage="超過8小時加班時數請輸入數字"
|
|
OnServerValidate="cvROT01_ServerValidate"></asp:CustomValidator>
|
|
<table border="0" cellpadding="2"
|
|
cellspacing="2" style="table-layout: fixed"
|
|
width="1">
|
|
<tr>
|
|
<td colspan="1" style="width: 100px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 100px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 140px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 100px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROENOLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROENO+:">員工編號:</cc1:WLabel>
|
|
</td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<table border="0" cellpadding="0"
|
|
cellspacing="0" style="width: 100%; height: 100%">
|
|
<tr>
|
|
<td width="100">
|
|
<asp:TextBox ID="txtROWK_ROENO"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="10" Text='<%# Bind("ROENO", "{0:c}") %>'></asp:TextBox>
|
|
</td>
|
|
<td>
|
|
<asp:ImageButton ID="btnROWK_ROENO_WQRY"
|
|
runat="server" ImageUrl="~/picture/pickup.gif" />
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
<td class="dataDisplayCell">
|
|
<asp:Label ID="lbROWK_ROENOX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPSN", Eval("ROENO", "{0:c}"), "BPNME", "") %>'></asp:Label>
|
|
</td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROPYNLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROPYN+:">專案年度編號:</cc1:WLabel>
|
|
</td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbROWK_ROPYN" runat="server"
|
|
CssClass="textInput" Text='<%# _ROPYN %>'></asp:Label></td>
|
|
<td class="dataDisplayCell" colspan="3">
|
|
<asp:Label ID="lbROWK_ROPYNX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPAA", _ROPYN, "BPPYM", "") %>'></asp:Label>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROYMMLabel"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROYMM+:">月份:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROYMM"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROYMM", "{0:yyyyMM}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT01Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT01+:">前二加班時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT01"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT01", "{0}") %>'></asp:TextBox></td>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT02Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT02+:">後二加班時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT02"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT02", "{0}") %>'></asp:TextBox></td>
|
|
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT05Label"
|
|
runat="server" CssClass="controlLabel">超過8小時加班時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT05"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT05", "{0}") %>'></asp:TextBox></td>
|
|
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT03Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT03+:">假日加班時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT03"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT03", "{0}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbROWK_ROT04Label"
|
|
runat="server" CssClass="controlLabel"
|
|
TextMessageId="ROWK.ROT04+:">申請補休時數:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtROWK_ROT04"
|
|
runat="server" CssClass="textInput"
|
|
MaxLength="8" Text='<%# Bind("ROT04", "{0}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
</table>
|
|
</InsertItemTemplate>
|
|
</asp:FormView>
|
|
|
|
<asp:GridView ID="gvROWK" runat="server"
|
|
AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="ROENO,ROYMM"
|
|
DataSourceID="dsROWKGrid">
|
|
<Columns>
|
|
<asp:CommandField SelectText=""
|
|
ShowSelectButton="True">
|
|
<ItemStyle Font-Bold="True" Font-Underline="False"
|
|
ForeColor="Orange" />
|
|
</asp:CommandField>
|
|
<asp:BoundField DataField="ROYMM"
|
|
DataFormatString="{0:yyyyMM}"
|
|
HeaderText="ROYMM" HtmlEncode="False"
|
|
ReadOnly="True" SortExpression="ROYMM"
|
|
AccessibleHeaderText="ROWK.ROYMM" />
|
|
<asp:TemplateField HeaderText="ROENO"
|
|
SortExpression="ROENO" AccessibleHeaderText="ROWK.ROENO">
|
|
<ItemTemplate>
|
|
<asp:Label ID="Label1" runat="server"
|
|
CssClass="textInput1" Text='<%# Bind("ROENO") %>'></asp:Label>
|
|
<asp:Label ID="lbROWK_ROENOX" runat="server"
|
|
CssClass="textInput1" Text='<%# GetLookup("BPSN", Eval("ROENO", "{0:c}"), "BPNME", "") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</asp:TemplateField>
|
|
<asp:BoundField DataField="ROT01"
|
|
AccessibleHeaderText="ROWK.ROT01"
|
|
HtmlEncode="False" DataFormatString="{0:##0}"
|
|
HeaderText="ROT01" SortExpression="ROT01">
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:BoundField>
|
|
<asp:BoundField DataField="ROT02"
|
|
AccessibleHeaderText="ROWK.ROT02"
|
|
HtmlEncode="False" DataFormatString="{0:##0}"
|
|
HeaderText="ROT02" SortExpression="ROT02">
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:BoundField>
|
|
<asp:BoundField DataField="ROT03"
|
|
AccessibleHeaderText="ROWK.ROT03"
|
|
HtmlEncode="False" DataFormatString="{0:##0}"
|
|
HeaderText="ROT03" SortExpression="ROT03">
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:BoundField>
|
|
<asp:TemplateField HeaderText="合計加班時數">
|
|
<ItemTemplate>
|
|
<asp:Label ID="lbROWK_RPT99" runat="server"
|
|
CssClass="textInput" Text='<%# String.Format("{0:###,##0}", Convert.ToInt32(Eval("ROT01")) + Convert.ToInt32(Eval("ROT02")) + Convert.ToInt32(Eval("ROT03"))) %>'></asp:Label>
|
|
</ItemTemplate>
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:TemplateField>
|
|
<asp:BoundField DataField="ROT04"
|
|
AccessibleHeaderText="ROWK.ROT04"
|
|
HtmlEncode="False" DataFormatString="{0:##0}"
|
|
HeaderText="ROT04" SortExpression="ROT04">
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:BoundField>
|
|
<asp:BoundField DataField="ROA01"
|
|
AccessibleHeaderText="ROWK.ROA01"
|
|
HtmlEncode="False" DataFormatString="{0:##,##0}"
|
|
HeaderText="ROA01" SortExpression="ROA01">
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:BoundField>
|
|
<asp:BoundField DataField="ROA02"
|
|
AccessibleHeaderText="ROWK.ROA02"
|
|
HtmlEncode="False" DataFormatString="{0:##,##0}"
|
|
HeaderText="ROA02" SortExpression="ROA02">
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:BoundField>
|
|
<asp:BoundField DataField="ROA03"
|
|
AccessibleHeaderText="ROWK.ROA03"
|
|
HtmlEncode="False" DataFormatString="{0:##,##0}"
|
|
HeaderText="ROA03" SortExpression="ROA03">
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:BoundField>
|
|
<asp:TemplateField HeaderText="合計加班費">
|
|
<ItemTemplate>
|
|
<asp:Label ID="lbROWK_ROA99" runat="server"
|
|
CssClass="textInput" Text='<%# String.Format("{0:###,##0}", Convert.ToInt32(Eval("ROA01")) + Convert.ToInt32(Eval("ROA02")) + Convert.ToInt32(Eval("ROA03"))) %>'></asp:Label>
|
|
</ItemTemplate>
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:TemplateField>
|
|
</Columns>
|
|
<PagerTemplate>
|
|
<cc1:WGridViewPager ID="GridView1Pager" runat="server"></cc1:WGridViewPager>
|
|
</PagerTemplate>
|
|
</asp:GridView>
|
|
|
|
</asp:View>
|
|
</asp:MultiView>
|