sryang
b66279e5fa
- RsajDAC 新增 SelectPage/SelectCount - dsRSAJGrid 改 ObjectDataSource；Search/Selected 調整
662 lines
38 KiB
Plaintext
662 lines
38 KiB
Plaintext
<%@ Control Language="C#" AutoEventWireup="true"
|
|
CodeFile="fmRsaj.ascx.cs" Inherits="forms_worker_fmRsaj" %>
|
|
<%@ Register Assembly="WNET" Namespace="Wellan.Web.UI"
|
|
TagPrefix="cc1" %>
|
|
<cc1:WLabel ID="WLabel1" runat="server" CssClass="pageTitle"
|
|
TextMessageId="FMRSAJ.NAME"></cc1:WLabel>
|
|
<asp:CustomValidator ID="cvMessage" runat="server"
|
|
Display="None"></asp:CustomValidator>
|
|
<asp:ObjectDataSource ID="dsRSAJGrid" runat="server"
|
|
TypeName="RsajDAC" SelectMethod="SelectPage" SelectCountMethod="SelectCount"
|
|
EnablePaging="true" OnSelected="dsRSAJGrid_Selected">
|
|
<SelectParameters>
|
|
<asp:Parameter Name="RSENO" Type="String" />
|
|
<asp:Parameter Name="RSPYN" Type="String" />
|
|
</SelectParameters>
|
|
</asp:ObjectDataSource>
|
|
<asp:SqlDataSource ID="dsRSAJForm" runat="server"
|
|
ConflictDetection="CompareAllValues" SelectCommand="SELECT * FROM RSAJ WHERE RSREN = @RSREN"
|
|
DeleteCommand="DELETE RSAJ WHERE RSREN = @OLD_RSREN AND APPNO = @OLD_APPNO"
|
|
InsertCommand="INSERT INTO RSAJ
|
|
(RSREN, RSENO, RSPYN, RSYMM, RSAMT, RSDOC, APPNO, TRDAT, TRMOD, TRUSR)
|
|
VALUES
|
|
(@RSREN, @RSENO, @RSITM, @RSPYN, @RSYMM, @RSAMT, @RSDOC, 1, GETDATE(), 'INSERT', @TRUSR)"
|
|
UpdateCommand="UPDATE RSAJ SET RSENO = @RSENO, RSPYN = @RSPYN, RSYMM = @RSYMM, RSAMT = @RSAMT, RSDOC = @RSDOC, APPNO = APPNO + 1, TRDAT = GETDATE(), TRMOD = 'UPDATE', TRUSR = @TRUSR WHERE RSREN = @OLD_RSREN AND APPNO = @OLD_APPNO"
|
|
OldValuesParameterFormatString="OLD_{0}"
|
|
OnInserting="dsRSAJForm_Inserting" OnUpdating="dsRSAJForm_Updating"
|
|
OnDeleted="dsRSAJForm_Deleted" ConnectionString="Data Source=(local);Initial Catalog=THINKYU_WEB;Persist Security Info=True;User ID=sa"
|
|
ProviderName="System.Data.SqlClient">
|
|
<SelectParameters>
|
|
<asp:ControlParameter ControlID="RSAJGrid"
|
|
Name="RSREN" PropertyName="SelectedDataKey["RSREN"]" />
|
|
</SelectParameters>
|
|
<DeleteParameters>
|
|
<asp:Parameter Name="OLD_RSREN" />
|
|
<asp:Parameter Name="OLD_APPNO" />
|
|
</DeleteParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="RSENO" />
|
|
<asp:Parameter Name="RSPYN" />
|
|
<asp:Parameter Name="RSYMM" />
|
|
<asp:Parameter Name="RSAMT" />
|
|
<asp:Parameter Name="RSDOC" />
|
|
<asp:SessionParameter DefaultValue="" Name="TRUSR"
|
|
SessionField="W_CUSR" />
|
|
<asp:Parameter Name="OLD_RSREN" />
|
|
<asp:Parameter Name="OLD_APPNO" />
|
|
</UpdateParameters>
|
|
<InsertParameters>
|
|
<asp:Parameter Name="RSREN" />
|
|
<asp:Parameter Name="RSENO" />
|
|
<asp:Parameter Name="RSPYN" />
|
|
<asp:Parameter Name="RSYMM" />
|
|
<asp:Parameter Name="RSAMT" />
|
|
<asp:Parameter Name="RSDOC" />
|
|
<asp:SessionParameter DefaultValue="" Name="TRUSR"
|
|
SessionField="W_CUSR" />
|
|
</InsertParameters>
|
|
</asp:SqlDataSource>
|
|
<asp:SqlDataSource ID="dsRSAJ_RSENO" runat="server"
|
|
ProviderName="System.Data.SqlClient">
|
|
<SelectParameters>
|
|
<asp:Parameter Name="RSPYN" />
|
|
<asp:Parameter Name="YYMM1" />
|
|
<asp:Parameter Name="YYMM2" />
|
|
<asp:Parameter Name="YYMM3" />
|
|
<asp:Parameter Name="YYMM4" />
|
|
</SelectParameters>
|
|
</asp:SqlDataSource>
|
|
<table border="0" cellpadding="0" cellspacing="2">
|
|
<tr>
|
|
<td colspan="1" style="width: 50px; height: 0px"></td>
|
|
<td colspan="1" style="height: 0px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="text-align: right">
|
|
<cc1:WLabel ID="lbBPIDN" runat="server" TextMessageId="">年月：</cc1:WLabel>
|
|
</td>
|
|
<td nowrap="nowrap">
|
|
<asp:TextBox ID="txtYYMM" runat="server"
|
|
Columns="5" CssClass="textInput1" MaxLength="5"></asp:TextBox>
|
|
<cc1:WButton ID="btnRSYMM" runat="server"
|
|
AccessKey="Y" CssClass="button" Text="Y.確定"
|
|
OnClick="btnSSMS_Click"></cc1:WButton></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="text-align: right">
|
|
<cc1:WLabel ID="WLabel3" runat="server" TextMessageId="">專案：</cc1:WLabel></td>
|
|
<td nowrap="nowrap">
|
|
<cc1:WDropDownList ID="ddlRSPYN" runat="server"
|
|
CssClass="textInput1" DataTextField="BPPYM"
|
|
DataValueField="BPPYN" Width="500px">
|
|
</cc1:WDropDownList>
|
|
<cc1:WButton ID="Next" runat="server" AccessKey="J"
|
|
CssClass="button" OnClick="Next_Click"
|
|
Text="J.選擇專案" CausesValidation="False"
|
|
UseSubmitBehavior="False" /></td>
|
|
</tr>
|
|
</table>
|
|
<asp:MultiView ID="MultiView1" runat="server"
|
|
ActiveViewIndex="1" Visible="False">
|
|
<asp:View ID="SearchView" runat="server">
|
|
<cc1:WButton ID="btnSearch" runat="server"
|
|
TextMessageId="F.+SEARCH" CssClass="button"
|
|
OnClick="btnSearch_Click" Text="F.查詢" AccessKey="F" />
|
|
<cc1:WButton ID="btnCancel" runat="server"
|
|
TextMessageId="C.+CANCEL" CssClass="button"
|
|
OnClick="btnCancel_Click" Text="C.取消" AccessKey="C" />
|
|
<table style="table-layout: fixed">
|
|
<tr>
|
|
<td colspan="1" style="height: 0px; width: 70px"></td>
|
|
<td colspan="1" style="height: 0px; width: 110px"></td>
|
|
<td colspan="1" style="height: 0px; width: 150px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td style="text-align: right">
|
|
<cc1:WLabel ID="lbRSENO" runat="server" Text="人員編號:"
|
|
TextMessageId="RSAJ.RSENO+:"></cc1:WLabel>
|
|
</td>
|
|
<td>
|
|
<table border="0" cellpadding="0" cellspacing="0"
|
|
width="100%">
|
|
<tr>
|
|
<td width="100">
|
|
<asp:TextBox ID="txtRSENO" runat="server"
|
|
CssClass="textInput"></asp:TextBox>
|
|
</td>
|
|
<td>
|
|
<asp:ImageButton ID="btnRSAJ_RSENO_WQRY"
|
|
runat="server" ImageUrl="~/picture/pickup.gif" />
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
<td>
|
|
<asp:TextBox ID="txtRSENOX" runat="server"
|
|
CssClass="textInput"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<cc1:WLabel ID="lbMessage" runat="server"
|
|
EnableViewState="False" ForeColor="Red"
|
|
TextMessageId="" Visible="False"></cc1:WLabel>
|
|
</asp:View>
|
|
<asp:View ID="InsertView" runat="server">
|
|
<cc1:WButton ID="btnSave1" runat="server"
|
|
AccessKey="S" CssClass="button" OnClick="btnSave1_Click"
|
|
OnClientClick="return confirm(msgConfirmSave);"
|
|
Text="S.存檔" />
|
|
<cc1:WButton ID="btnCancel1" runat="server"
|
|
AccessKey="C" CssClass="button" OnClick="btnCancel1_Click"
|
|
OnClientClick="return confirm(msgConfirmCancel);"
|
|
Text="C.調整明細" />
|
|
<cc1:WButton ID="btnClear1" runat="server"
|
|
AccessKey="Z" CssClass="button" OnClientClick='if (confirm("是否確定清除畫面上輸入之全部資料？")) ClearInputs(999);return false;'
|
|
Text="Z.清除" UseSubmitBehavior="False" /><table
|
|
id="Table2" border="0" cellpadding="2"
|
|
cellspacing="2" style="table-layout: fixed"
|
|
width="1">
|
|
<tr>
|
|
<td align="center" colspan="1" style="width: 24px; height: 0px"></td>
|
|
<td colspan="1" style="width: 34px; height: 0px"></td>
|
|
<td colspan="1" style="width: 80px; height: 0px"></td>
|
|
<td colspan="1" style="width: 250px; height: 0px"></td>
|
|
<td colspan="1" style="width: 80px; height: 0px"></td>
|
|
<td colspan="1" style="width: 200px; height: 0px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" class="dataEditCell" colspan="1"></td>
|
|
<td class="dataEditCell" colspan="1"></td>
|
|
<td class="dataDisplayCell">
|
|
<cc1:WLabel ID="lbRSAJ_RSYMMLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="">年月</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSENOLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSENO">人員編號</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSAMTLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSAMT">金額</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSDOCLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSDOC">備註</cc1:WLabel></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">1</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_01" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(0);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_01" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<cc1:WDropDownList ID="ddlRSAJ_RSENO_01" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</cc1:WDropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_01" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_01" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">2</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_02" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(1);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_02" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<asp:DropDownList ID="ddlRSAJ_RSENO_02" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</asp:DropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_02" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_02" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">3</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_03" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(2);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_03" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<asp:DropDownList ID="ddlRSAJ_RSENO_03" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</asp:DropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_03" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_03" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">4</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_04" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(3);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_04" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<asp:DropDownList ID="ddlRSAJ_RSENO_04" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</asp:DropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_04" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_04" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">5</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_05" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(4);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_05" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<asp:DropDownList ID="ddlRSAJ_RSENO_05" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</asp:DropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_05" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_05" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">6</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_06" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(5);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_06" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<asp:DropDownList ID="ddlRSAJ_RSENO_06" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</asp:DropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_06" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_06" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">7</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_07" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(6);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_07" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<asp:DropDownList ID="ddlRSAJ_RSENO_07" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</asp:DropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_07" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_07" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">8</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_08" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(7);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_08" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<asp:DropDownList ID="ddlRSAJ_RSENO_08" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</asp:DropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_08" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_08" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">9</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_09" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(8);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_09" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<asp:DropDownList ID="ddlRSAJ_RSENO_09" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</asp:DropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_09" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_09" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center" colspan="1">10</td>
|
|
<td colspan="1">
|
|
<cc1:WButton ID="btnClear_10" runat="server"
|
|
CssClass="button1" OnClientClick="ClearInputs(9);return false;"
|
|
Text="清" UseSubmitBehavior="False" Width="34px" /></td>
|
|
<td class="dataEditCell">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM_10" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td colspan="1">
|
|
<cc1:WDropDownList ID="ddlRSAJ_RSENO_10" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO">
|
|
</cc1:WDropDownList></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT_10" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text=""></asp:TextBox></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC_10" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text=""></asp:TextBox></td>
|
|
</tr>
|
|
</table>
|
|
</asp:View>
|
|
<asp:View ID="EditView" runat="server">
|
|
<asp:FormView ID="RSAJForm" runat="server"
|
|
DataSourceID="dsRSAJForm"
|
|
OnDataBinding="RSAJForm_DataBinding"
|
|
OnDataBound="RSAJForm_DataBound"
|
|
OnItemCommand="RSAJForm_ItemCommand"
|
|
OnItemDeleted="RSAJForm_ItemDeleted"
|
|
OnItemInserted="RSAJForm_ItemInserted"
|
|
OnItemUpdated="RSAJForm_ItemUpdated"
|
|
OnModeChanged="RSAJForm_ModeChanged"
|
|
OnModeChanging="RSAJForm_ModeChanging"
|
|
OnItemUpdating="RSAJForm_ItemUpdating"
|
|
OnItemInserting="RSAJForm_ItemInserting">
|
|
<EditItemTemplate>
|
|
<cc1:WButton ID="btnSave" runat="server"
|
|
AccessKey="S" CommandName="Update" CssClass="button"
|
|
OnClientClick="return confirm(msgConfirmSave);"
|
|
Text="S.存檔" TextMessageId="S.+SAVE" />
|
|
<cc1:WButton ID="btnCancel" runat="server"
|
|
AccessKey="C" CommandName="Cancel" CssClass="button"
|
|
OnClientClick="return confirm(msgConfirmCancel);"
|
|
Text="C.取消" TextMessageId="C.+CANCEL" />
|
|
<table border="0" cellpadding="2" cellspacing="2"
|
|
style="table-layout: fixed" width="1">
|
|
<tr>
|
|
<td colspan="1" style="width: 90px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 90px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 90px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 90px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSRENLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSREN+:">單號:</cc1:WLabel>
|
|
</td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbRSAJ_RSREN" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("RSREN", "{0:c}") %>' /></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSPYNLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSPYN+:">專案年度編號:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbRSAJ_RSPYN" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("RSPYN", "{0:c}") %>'></asp:Label></td>
|
|
<td class="dataDisplayCell" colspan="3">
|
|
<asp:Label ID="lbRSAJ_RSPYNX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPAA", Eval("RSPYN", "{0:c}"), "BPPYM", "") %>'></asp:Label></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSYMMLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSYMM+:">年月:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSYMM" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text='<%# Bind("RSYMM", "{0:yyyyMM}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSENOLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSENO+:">人員編號:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<cc1:WDropDownList ID="ddlRSAJ_RSENO_10" runat="server"
|
|
CssClass="textInput" DataSourceID="dsRSAJ_RSENO"
|
|
DataTextField="BPNME" DataValueField="BPENO"
|
|
SelectedValue='<%# Bind("RSENO") %>'>
|
|
</cc1:WDropDownList></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSAMTLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSAMT+:">金額:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="1">
|
|
<asp:TextBox ID="txtRSAJ_RSAMT" runat="server"
|
|
CssClass="textInput" MaxLength="8" Text='<%# Bind("RSAMT", "{0:#######0}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSDOCLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSDOC+:">備註:</cc1:WLabel></td>
|
|
<td class="dataEditCell" colspan="4">
|
|
<asp:TextBox ID="txtRSAJ_RSDOC" runat="server"
|
|
CssClass="textInput" MaxLength="70" Text='<%# Bind("RSDOC", "{0:c}") %>'></asp:TextBox></td>
|
|
</tr>
|
|
</table>
|
|
<asp:HiddenField ID="hfRSAJ_APPNO" runat="server"
|
|
Value='<%# Bind("APPNO") %>' />
|
|
</EditItemTemplate>
|
|
<InsertItemTemplate>
|
|
</InsertItemTemplate>
|
|
<ItemTemplate>
|
|
<cc1:WButton ID="btnInsert" runat="server"
|
|
AccessKey="I" CommandName="APPEND" CssClass="button"
|
|
Text="I.新增" TextMessageId="I.+INSERT" />
|
|
<cc1:WButton ID="btnEdit" runat="server"
|
|
AccessKey="M" CommandName="Edit" CssClass="button"
|
|
Text="M.更正" TextMessageId="M.+UPDATE" />
|
|
<cc1:WButton ID="btnDelete" runat="server"
|
|
AccessKey="T" CommandName="Delete" CssClass="button"
|
|
OnClientClick="return confirm(msgConfirmDelete);"
|
|
Text="T.刪除" TextMessageId="T.+DELETE" />
|
|
<cc1:WButton ID="btnSearch" runat="server"
|
|
AccessKey="F" CommandName="Search" CssClass="button"
|
|
Text="F.查詢" TextMessageId="F.+SEARCH" />
|
|
<table border="0" cellpadding="2" cellspacing="2"
|
|
style="table-layout: fixed" width="1">
|
|
<tr>
|
|
<td colspan="1" style="width: 90px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 90px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 90px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
<td colspan="1" style="width: 90px; height: 0px"></td>
|
|
<td colspan="1" style="width: 120px; height: 0px"></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSRENLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSREN+:">單號:</cc1:WLabel>
|
|
</td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbRSAJ_RSREN" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("RSREN", "{0:c}") %>' />
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSPYNLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSPYN+:">專案年度編號:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbRSAJ_RSPYN" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("RSPYN", "{0:c}") %>'></asp:Label></td>
|
|
<td class="dataDisplayCell" colspan="3">
|
|
<asp:Label ID="lbRSAJ_RSPYNX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPAA", Eval("RSPYN", "{0:c}"), "BPPYM", "") %>'></asp:Label></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSYMMLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSYMM+:">年月:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbRSAJ_RSYMM" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("RSYMM", "{0:yyyyMM}") %>'></asp:Label></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSENOLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSENO+:">人員編號:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbRSAJ_RSENO" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("RSENO", "{0:c}") %>'></asp:Label></td>
|
|
<td class="dataDisplayCell" colspan="3">
|
|
<asp:Label ID="lbRSAJ_RSENOX" runat="server"
|
|
CssClass="textInput" Text='<%# GetLookup("BPSN", Eval("RSENO", "{0:c}"), "BPNME", "") %>'></asp:Label></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSAMTLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSAMT+:">金額:</cc1:WLabel>
|
|
</td>
|
|
<td class="dataDisplayCell" colspan="1">
|
|
<asp:Label ID="lbRSAJ_RSAMT" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("RSAMT", "{0:###,###,###,###,##0.####}") %>'></asp:Label>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" colspan="1">
|
|
<cc1:WLabel ID="lbRSAJ_RSDOCLabel" runat="server"
|
|
CssClass="controlLabel" TextMessageId="RSAJ.RSDOC+:">備註:</cc1:WLabel></td>
|
|
<td class="dataDisplayCell" colspan="4">
|
|
<asp:Label ID="lbRSAJ_RSDOC" runat="server"
|
|
CssClass="textInput" Text='<%# Bind("RSDOC", "{0:c}") %>'></asp:Label></td>
|
|
</tr>
|
|
</table>
|
|
<asp:HiddenField ID="hfRSAJ_APPNO" runat="server"
|
|
Value='<%# Bind("APPNO") %>' />
|
|
</ItemTemplate>
|
|
<EmptyDataTemplate>
|
|
<cc1:WButton ID="btnInsert" runat="server"
|
|
AccessKey="I" CommandName="APPEND" CssClass="button"
|
|
Text="I.新增" TextMessageId="I.+INSERT" /><br />
|
|
無資料
|
|
</EmptyDataTemplate>
|
|
</asp:FormView>
|
|
<asp:GridView ID="RSAJGrid" runat="server"
|
|
DataSourceID="dsRSAJGrid" DataKeyNames="RSREN,RSPYN"
|
|
AutoGenerateColumns="False" AllowPaging="True"
|
|
OnDataBound="RSAJGrid_DataBound" OnPageIndexChanged="RSAJGrid_PageIndexChanged"
|
|
OnSelectedIndexChanged="RSAJGrid_SelectedIndexChanged"
|
|
OnRowDataBound="RSAJGrid_RowDataBound">
|
|
<Columns>
|
|
<asp:CommandField SelectText="" ShowSelectButton="True">
|
|
<ItemStyle Font-Bold="True" Font-Underline="False"
|
|
ForeColor="Orange" />
|
|
</asp:CommandField>
|
|
<asp:BoundField AccessibleHeaderText="RSAJ.RSREN"
|
|
DataField="RSREN" HeaderText="RSREN" ReadOnly="True"
|
|
SortExpression="RSREN" />
|
|
<asp:TemplateField AccessibleHeaderText="RSAJ.RSPYN"
|
|
HeaderText="RSPYN" SortExpression="RSPYN">
|
|
<ItemTemplate>
|
|
<asp:Label ID="Label1" runat="server" Text='<%# Bind("RSPYN") %>'></asp:Label>
|
|
<asp:Label ID="lbRSAJ_RSPYNX" runat="server"
|
|
Text='<%# GetLookup("BPAA", Eval("RSPYN", "{0:c}"), "BPPYM", "") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</asp:TemplateField>
|
|
<asp:BoundField AccessibleHeaderText="RSAJ.RSYMM"
|
|
DataField="RSYMM" DataFormatString="{0:yyyyMM}"
|
|
HeaderText="RSYMM" HtmlEncode="False" SortExpression="RSYMM" />
|
|
<asp:TemplateField AccessibleHeaderText="RSAJ.RSENO"
|
|
HeaderText="RSENO" SortExpression="RSENO">
|
|
<ItemTemplate>
|
|
<asp:Label ID="Label2" runat="server" Text='<%# Bind("RSENO") %>'></asp:Label>
|
|
<asp:Label ID="lbRSAJ_RSENOX" runat="server"
|
|
Text='<%# GetLookup("BPSN", Eval("RSENO", "{0:c}"), "BPNME", "") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</asp:TemplateField>
|
|
<asp:BoundField AccessibleHeaderText="RSAJ.RSAMT"
|
|
DataField="RSAMT" DataFormatString="{0:##,###,##0}"
|
|
HeaderText="RSAMT" HtmlEncode="False" SortExpression="RSAMT">
|
|
<ItemStyle HorizontalAlign="Right" />
|
|
</asp:BoundField>
|
|
<asp:BoundField AccessibleHeaderText="RSAJ.RSDOC"
|
|
DataField="RSDOC" HeaderText="RSDOC" SortExpression="RSDOC" />
|
|
</Columns>
|
|
<PagerTemplate>
|
|
<cc1:WGridViewPager ID="GridView1Pager" runat="server" on />
|
|
</PagerTemplate>
|
|
</asp:GridView>
|
|
</asp:View>
|
|
</asp:MultiView>
|
|
|
|
<script type="text/javascript">
|
|
<!--
|
|
function ClearInputs(index)
|
|
{
|
|
if (index == 999)
|
|
{
|
|
for (i = 0; i < RSYMMIds.length; i++)
|
|
{
|
|
ClearInput(i);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
ClearInput(index);
|
|
}
|
|
}
|
|
|
|
function ClearInput(index)
|
|
{
|
|
var RSYMM = document.getElementById(RSYMMIds[index]);
|
|
var RSAMT = document.getElementById(RSAMTIds[index]);
|
|
var RSDOC = document.getElementById(RSDOCIds[index]);
|
|
RSYMM.value = "";
|
|
RSAMT.value = "";
|
|
RSDOC.value = "";
|
|
}
|
|
-->
|
|
</script>
|
|
|