Hubert的部落格

using NPOI.SS.UserModel;

using NPOI.XSSF.UserModel;

using NPOI.HSSF.UserModel;

public class ExcelExport

{

    /// <summary>

    /// 讀取Excel Sheet Name

    /// </summary>

    /// <param name="DataSource"></param>

    /// <returns></returns>

    public List<string> ReadSheetName(string DataSource)

    {

        try

        {

            List<string> result = new List<string>();

            using (FileStream fs = new FileStream(DataSource, FileMode.Open))

            {

                IWorkbook wb;

                if (DataSource.Contains(".xlsx"))

                    wb = new XSSFWorkbook(fs);

                else

                    wb = new HSSFWorkbook(fs);

                var sheets = new List<ISheet>();

                for (int i = 0; i < wb.NumberOfSheets; i++)

                    sheets.Add(wb.GetSheetAt(i));

                foreach (var sheet in sheets)

                {

                    result.Add(sheet.SheetName);

                }

            }

            return result;

        }

        catch (Exception)

        {

            return new List<string>();

        }

    }

}

//HTML

<asp:TextBox ID="txtImputItem" runat="server"></asp:TextBox>

<a onclick="AddGroup()">Insert</a>

<asp:ListBox ID="List1" runat="server"></asp:ListBox>

//Script

<script type="text/javascript">

    function AddGroup() {

        var name = $('#<%=txtImputItem.ClientID %>').val();

        $('#<%=List1.ClientID %>').append('<option value="' + name + '">' + name + '</option>');

        $('#<%=txtImputItem.ClientID %>').val('');

        GetGroupList();

    }

</script>

<script type="text/javascript">

    $(document).ready(CheckDay());

    function CheckDay() {

        var start = $('#<%=txbStartDate.ClientID%>').val();

        var end = $('#<%=txbDutDate.ClientID%>').val();

        var _s = new Date(Date.parse($('#<%=txbStartDate.ClientID%>').val()));

        var _e = new Date(Date.parse($('#<%=txbDutDate.ClientID%>').val()));

        var now = new Date();

        var today = new Date(Date.parse(now.getFullYear() + "/" + (now.getMonth()+1) + "/" + now.getDate()));

        var total = (_e - _s) / (1000 * 60 * 60 * 24);

        var has = (_e - today) / (1000 * 60 * 60 * 24);

        //因為我只要顯示天數，所以我把小數點都捨去

         var showmsg = '使用天數:' + Math.floor(total) + ' 剩餘天數:' + Math.floor(has);

        $('#<%=lblDays.ClientID%>').html(showmsg);

    }

</script>

 1: using System;

 2: using System.Collections.Generic;

 3: using System.Linq;

 4: using System.Net;

 5: using System.Net.Http;

 6: using System.Web.Http;

 7:  

 8: namespace WebApiTest.Controllers

 9: {

 10:     public class APITestController : ApiController

 11:     {

 12:         // GET api/apitest

 13:         public IEnumerable<string> Get()

 14:         {

 15:             return new string[] { "value1", "value2" };

 16:         }

 17:  

 18:         // GET api/apitest/5

 19:         public string Get(int id)

 20:         {

 21:             return "value";

 22:         }

 23:  

 24:         // POST api/apitest

 25:         public string Post([FromBody]string value)

 26:         {

 27:             return "ok";

 28:         }

 29:  

 30:         // PUT api/apitest/5

 31:         public void Put(int id, [FromBody]string value)

 32:         {

 33:         }

 34:  

 35:         // DELETE api/apitest/5

 36:         public void Delete(int id)

 37:         {

 38:         }

 39:     }

 40: }

 1: protected void EntityDataSource1_Updating(object sender, EntityDataSourceChangingEventArgs e)

 2: {

 3:     var entry = e.Context.ObjectStateManager.GetObjectStateEntry(e.Entity);

 4:     if (entry.CurrentValues["FieldName"].ToString() == "1")

 5:         entry.CurrentValues.SetDateTime(15, DateTime.Now.Date);

 6:     else if (entry.CurrentValues["FieldName"].ToString() == "2")

 7:         entry.CurrentValues.SetDateTime(16, DateTime.Now.Date);

 8: }