[Ext.Net] 查詢條件中, 日期時間的佈局方式


前台  
<ext:CompositeField ID="CompositeField2" runat="server" FieldLabel="時間">
    <Items>
        <ext:DateField ID="date_start" Vtype="daterange" runat="server" Flex="1">
            <Listeners>
                <Render Handler="this.endDateField = '#{date_end}'" />
            </Listeners>
        </ext:DateField>
        <ext:Label ID="Label2" runat="server" Text="~">
        </ext:Label>
        <ext:DateField ID="date_end" Vtype="daterange" runat="server" Flex="1">
            <Listeners>
                <Render Handler="this.startDateField = '#{date_start}'" />
            </Listeners>
        </ext:DateField>
    </Items>
</ext:CompositeField>
參考網址:

留言

張貼留言

歡迎留言

熱門文章

[C#] 將DataTable轉換成Html格式表格

將DataTable轉換成Html格式表格   using System.Data; using System.Text; protected string ExportDatatableToHtml(DataTable dt) { StringBuilder strHTMLBuilder = new StringBuilder(); strHTMLBuilder.Append("<table border='2px' cellpadding='5'>"); strHTMLBuilder.Append("<tr>"); foreach (DataColumn myColumn in dt.Columns) { strHTMLBuilder.Append("<td>"); strHTMLBuilder.Append(myColumn.ColumnName); strHTMLBuilder.Append("</td>"); } strHTMLBuilder.Append("</tr>"); foreach (DataRow myRow in dt.Rows) { strHTMLBuilder.Append("<tr>"); foreach (DataColumn myColumn in dt.Columns) { strHTMLBuilder.Append("<td>"); strHTMLBuilder.Append(myRow[myColumn.ColumnName].ToString()); strHTMLBuilder.Append("</td>"); } strHTMLBuilder.Append...
閱讀完整內容

[MS SQL] 查詢所有Procedure

  查詢所有Procedure   --MS SQL使用 SELECT name AS ProcedureName, create_date AS 建立時間, modify_date AS 異動時間 FROM sys.procedures WHERE is_ms_shipped = 0 -- 只顯示使用者自訂的預存程序 ORDER BY ProcedureName; --通用版本(尚未測試) SELECT ROUTINE_TYPE, ROUTINE_SCHEMA AS SchemaName, ROUTINE_NAME AS ProcedureName, CREATED AS 建立時間, LAST_ALTERED AS 最後異動時間 FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' -- 只顯示預存程序 ORDER BY ROUTINE_NAME; 參考網址:  By Hao★
閱讀完整內容