RedictToActioin 傳參數到另一個 Action 的方式

用 TempData 來傳

範例:

XXController.cs

public ActionResult action1 () {
 TempData["message"] = "test123";
 return RedirectToAction("action2");
}

public ActionResult action2 () {
  return View();
}

action2 View(Razor)

<script>
alert(@TempData["message"]);
</script>

ASP.NET MVC 中 使用 AJAX 傳送大量Json 出現 Internal server error 500 問題

只要在 web.config 中加入

<appSettings>
    <add key="aspnet:MaxJsonDeserializerMembers" value="150000" />
</appSettings>

即可

BootStrap Modal 失效 issue

遇到一個奇怪的問題

Modal 在使用過一次 

$('#myModal').modal('show');

$('#myModal').modal('hide');

後, 第二次再使用。 hide 失效

解決方式:

因為 modal 是非同步 function, 故不能同時使用

$('#myModal').modal('show');

$('#myModal').modal('hide');

需要加一層

$('#myModal').modal('show');

$('#LoadingModal').on('shown.bs.modal', function (e) {
    do something...
    $('#myModal').modal('hide');
    $('#myModal').off('shown.bs.modal');//去除绑定, 否則會不斷重覆綁定多次
});

ASP.NET C# 使用BootStrap+Twitter Typeahead 做自動完成

原本的BootStrap 2有 Typeahead 功能, 但在BootStrap 3卻拿掉,

並推薦使用者用 Twitter Typeahead

可是這個的教學使用實在有夠少,

雖然他的官網上已經有教學,

但是有結合BootStrap 3的實在找不太到

所幸我有小小的試出來,做個記錄

先PO上 Twitter Typehead 的 官網, 請自行點擊

本篇著重在和BootStrap的 input-group 功能做結合

先在BootStrap 中加入一個 input-group

<div class="input-group">
    <span class="input-group-addon">Search</span>
    <asp:TextBox ID="txt_Search" runat="server" placeholder="Search" ClientIDMode="Static">
    </asp:TextBox>
</div>

ASP.NET C# 下載 DataTable 轉 XML

using System.Xml;
using System.Web;

轉換一般的XML

public XmlDocument transDataTableToXMLDocument(DataTable dt)
{
    XmlDocument xmlDoc = new XmlDocument();
    xmlDoc.CreateXmlDeclaration("1.0", "utf-8", "yes");

    XmlNode rootNode = xmlDoc.CreateElement("Data");
    if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
    {
        foreach (DataRow dr in dt.Rows)
        {
            XmlNode RowNode = xmlDoc.CreateElement("Row");
            foreach (DataColumn dc in dt.Columns)
            {
                XmlNode ColumnNode = xmlDoc.CreateElement(dc.ColumnName);
                ColumnNode.InnerText = dr[dc.ColumnName].ToString();
                RowNode.AppendChild(ColumnNode);
            }
            rootNode.AppendChild(RowNode);
        }
    }
    xmlDoc.AppendChild(rootNode);

    return xmlDoc;
}

轉換 Excel 格式的 XML

public XmlDocument transDataTableToXMLDocument_ExcelFormat(List<DataTable> dts, List<string> tabNames)
{
    if(!(dts != null && tabNames != null && dts.Count == tabNames.Count)){
        throw new Exception("Number of datatable and tabname are not the same.");
    }
    XmlDocument xmlDoc = new XmlDocument();
    string EXCEL_NS = "urn:schemas-microsoft-com:office:spreadsheet";

    xmlDoc.CreateXmlDeclaration("1.0", "utf-8", "yes");
    xmlDoc.CreateProcessingInstruction("mso-application", "progid=\"Excel.Sheet\"");

    // create a Workbook and setting excel format
    XmlNode WorkbookNode = xmlDoc.CreateElement("Workbook", EXCEL_NS);
    XmlAttribute WorkbookNode_xmlns_ss = xmlDoc.CreateAttribute("xmlns", "ss", "http://www.w3.org/2000/xmlns/");
    WorkbookNode_xmlns_ss.Value = EXCEL_NS;
    WorkbookNode.Attributes.Append(WorkbookNode_xmlns_ss);


    // create Sytles
    XmlNode StylesNode = xmlDoc.CreateElement("Styles", EXCEL_NS);

    // create HeaderStyle
    XmlNode HeaderStyleNode = xmlDoc.CreateElement("Style", EXCEL_NS);
    XmlAttribute HeaderStyleNode_ss_ID = xmlDoc.CreateAttribute("ss", "ID", EXCEL_NS);
    HeaderStyleNode_ss_ID.Value = "HeaderStyle";
    HeaderStyleNode.Attributes.Append(HeaderStyleNode_ss_ID);

    XmlNode AlignmentNode = xmlDoc.CreateElement("Alignment", EXCEL_NS);
    XmlAttribute AlignmentNode_ss_Horizontal = xmlDoc.CreateAttribute("ss", "Horizontal", EXCEL_NS);
    XmlAttribute AlignmentNode_ss_Vertical = xmlDoc.CreateAttribute("ss", "Vertical", EXCEL_NS);
    AlignmentNode_ss_Horizontal.Value = "Center";
    AlignmentNode_ss_Vertical.Value = "Center";
    AlignmentNode.Attributes.Append(AlignmentNode_ss_Horizontal);
    AlignmentNode.Attributes.Append(AlignmentNode_ss_Vertical);
    HeaderStyleNode.AppendChild(AlignmentNode);

    XmlNode FontNode = xmlDoc.CreateElement("Font", EXCEL_NS);
    XmlAttribute FontNode_ss_Bold = xmlDoc.CreateAttribute("ss", "Bold", EXCEL_NS);
    FontNode_ss_Bold.Value = "1";
    FontNode.Attributes.Append(FontNode_ss_Bold);
    HeaderStyleNode.AppendChild(FontNode);

    StylesNode.AppendChild(HeaderStyleNode);

    // create TextStyle
    XmlNode TextStyleNode = xmlDoc.CreateElement("Style", EXCEL_NS);
    XmlAttribute TextStyleNode_ss_ID = xmlDoc.CreateAttribute("ss", "ID", EXCEL_NS);
    TextStyleNode_ss_ID.Value = "TextStyle";
    TextStyleNode.Attributes.Append(TextStyleNode_ss_ID);

    XmlNode TextAlignmentNode = xmlDoc.CreateElement("Alignment", EXCEL_NS);
    XmlAttribute TextAlignmentNode_ss_WrapText = xmlDoc.CreateAttribute("ss", "WrapText", EXCEL_NS);
    TextAlignmentNode_ss_WrapText.Value = "1";
    TextAlignmentNode.Attributes.Append(TextAlignmentNode_ss_WrapText);
    TextStyleNode.AppendChild(TextAlignmentNode);

    StylesNode.AppendChild(TextStyleNode);
    WorkbookNode.AppendChild(StylesNode);

    if (dts != null && dts.Count > 0)
    {
        for (int i = 0; i < dts.Count; i++)
        {
            DataTable dt = dts[i];

            // create Worksheet

            XmlNode WorksheetNode = xmlDoc.CreateElement("Worksheet", EXCEL_NS);
            XmlAttribute WorksheetNode_ss_Name = xmlDoc.CreateAttribute("ss", "Name", EXCEL_NS);
            WorksheetNode_ss_Name.Value = tabNames[i];
            WorksheetNode.Attributes.Append(WorksheetNode_ss_Name);

            XmlNode TableNode = xmlDoc.CreateElement("Table", EXCEL_NS);

            // create column style
            if (dt != null && dt.Columns != null && dt.Columns.Count > 0)
            {
                foreach (DataColumn dc in dt.Columns)
                {
                    XmlNode ColumnNode = xmlDoc.CreateElement("Column", EXCEL_NS);
                    XmlAttribute ColumnNode_ss_Width = xmlDoc.CreateAttribute("ss", "Width", EXCEL_NS);
                    string columnWidth = "100";
                    if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
                    {
                        if (dc.DataType == System.Type.GetType("System.Decimal"))
                        {
                            IEnumerable<decimal> tmp = dt.AsEnumerable().Where(p => p.Field<decimal?>(dc.ColumnName).HasValue)
                                                                .Select(p => p.Field<decimal?>(dc.ColumnName).Value);
                            if (tmp != null && tmp.Count() > 0)
                            {
                                columnWidth = (tmp.Select(p => Convert.ToString(p).Length).Max() * 8).ToString();
                            }
                        }
                        else if (dc.DataType == System.Type.GetType("System.String"))
                        {
                            IEnumerable<string> tmp = dt.AsEnumerable().Where(p => p.Field<string>(dc.ColumnName) != null)
                                                                .Select(p => p.Field<string>(dc.ColumnName));
                            if (tmp != null && tmp.Count() > 0)
                            {
                                columnWidth = (tmp.Select(p => p.Length).Max() * 8).ToString();
                            }
                        }
                        else if (dc.DataType == System.Type.GetType("System.DateTime"))
                        {
                            columnWidth = "160";
                        }
                    }
                    if (((dc.ColumnName.Length) * 8) > Convert.ToInt16(columnWidth))
                    {
                        columnWidth = (dc.ColumnName.Length * 8).ToString();
                    }
                    if (Convert.ToInt16(columnWidth) > 200)
                    {
                        columnWidth = "200";
                    }
                    ColumnNode_ss_Width.Value = columnWidth;
                    ColumnNode.Attributes.Append(ColumnNode_ss_Width);
                    TableNode.AppendChild(ColumnNode);
                }
            }

            // create row header

            XmlNode RowHeaderNode = xmlDoc.CreateElement("Row", EXCEL_NS);
            XmlAttribute RowHeaderNode_ss_StyleID = xmlDoc.CreateAttribute("ss", "StyleID", EXCEL_NS);
            RowHeaderNode_ss_StyleID.Value = "HeaderStyle";
            RowHeaderNode.Attributes.Append(RowHeaderNode_ss_StyleID);

            if (dt != null && dt.Columns != null && dt.Columns.Count > 0)
            {
                foreach (DataColumn dc in dt.Columns)
                {
                    XmlNode CellNode = xmlDoc.CreateElement("Cell", EXCEL_NS);

                    XmlNode DataNode = xmlDoc.CreateElement("Data", EXCEL_NS);
                    XmlAttribute DataNode_ss_Type = xmlDoc.CreateAttribute("ss", "Type", EXCEL_NS);
                    DataNode_ss_Type.Value = "String";
                    DataNode.Attributes.Append(DataNode_ss_Type);
                    DataNode.InnerText = dc.ColumnName;
                    CellNode.AppendChild(DataNode);

                    RowHeaderNode.AppendChild(CellNode);
                }
            }

            TableNode.AppendChild(RowHeaderNode);

            // create row data

            if (dt != null && dt.Rows != null && dt.Rows.Count > 0 && dt.Columns != null && dt.Columns.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    XmlNode RowNode = xmlDoc.CreateElement("Row", EXCEL_NS);

                    XmlAttribute RowNode_ss_StyleID = xmlDoc.CreateAttribute("ss", "StyleID", EXCEL_NS);
                    RowNode_ss_StyleID.Value = "TextStyle";
                    RowNode.Attributes.Append(RowNode_ss_StyleID);

                    foreach (DataColumn dc in dt.Columns)
                    {
                        XmlNode CellNode = xmlDoc.CreateElement("Cell", EXCEL_NS);

                        XmlNode DataNode = xmlDoc.CreateElement("Data", EXCEL_NS);
                        XmlAttribute DataNode_ss_Type = xmlDoc.CreateAttribute("ss", "Type", EXCEL_NS);
                        DataNode_ss_Type.Value = "String";
                        DataNode.Attributes.Append(DataNode_ss_Type);
                        DataNode.InnerText = dr[dc.ColumnName].ToString();
                        CellNode.AppendChild(DataNode);

                        RowNode.AppendChild(CellNode);
                    }

                    TableNode.AppendChild(RowNode);
                }
            }

            WorksheetNode.AppendChild(TableNode);

            WorkbookNode.AppendChild(WorksheetNode);
        }
    }

    xmlDoc.AppendChild(WorkbookNode);

    return xmlDoc;
}

下載XML

public void downloadDataTableToXMLFile(List<DataTable> dts, List<string> tabNames, string fileName)
{
    CommonService cs = new CommonService();
    XmlDocument doc = cs.transDataTableToXMLDocument_ExcelFormat(dts, tabNames);

    MemoryStream ms = new MemoryStream();
    using (XmlWriter writer = XmlWriter.Create(ms))
    {
        doc.WriteTo(writer); // Write to memorystream
    }

    byte[] data = ms.ToArray();
    HttpContext.Current.Response.Clear();
    HttpContext.Current.Response.ClearHeaders();
    HttpContext.Current.Response.ClearContent();
    HttpContext.Current.Response.Expires = 0;
    HttpContext.Current.Response.Buffer = true;
    HttpContext.Current.Response.AddHeader("Content-Disposition",
                        "attachment;filename=" + HttpUtility.UrlEncode(fileName) + ";size=" + data.Length.ToString());
    HttpContext.Current.Response.ContentType = "Application/octet-stream";
    HttpContext.Current.Response.BinaryWrite(data);
    HttpContext.Current.Response.End();
    ms.Flush(); // Probably not needed
    ms.Close();
}

ASP.NET C# 在IE和FireFox中下載檔名正常,但在Chrome中下載檔名會變成XXX.aspx

若原來的只有輸入 attachment 和 filename

HttpContext.Current.Response.AddHeader("Content-Disposition:", "attachment;filename=" + HttpUtility.UrlEncode(fileName));

再加入size變成

HttpContext.Current.Response.AddHeader("Content-Disposition","attachment;filename=" + HttpUtility.UrlEncode(fileName) + ";size=" + data.Length.ToString());

建議advise, recommend, suggest

建議advise, recommend, suggest

advise：通常有權威的人士或上位對下輩建議，
如The police advised us to stay at home.警方建議我們待在家裡。

或某方面的專家做的建議
My lawyer advised me to keep my mouth shut.我的律師建議我閉嘴。

advise通常用於負面的警告，所以千萬別對人說I advise you ...，這樣會讓人覺得你自以為是專家或是權威人士。

/****
常用來advise某人的事件如： 不要吸煙或喝酒等，努力學習，勿亂花費 ( stop smoking or drinking, study hard, spending too much money)。

advise 的用法：advise某人 to 做某事 (勸告或建議某人做某事)， advise against 某事 (勸告或建議某人不要做某事)，advise on 某事 (勸告或建議某人有關某事)。
****/

如果要給正面的建議，可改用recommend，因為它的涵意是「我想要對你有幫助helpful、帶給你好處」

I recommend that you go to a doctor. 我建議你去看醫生。
（有人說I recommend you to go to a doctor.是較不自然的說法。）

/****
常用recommend的事件如 ： 去某餐廳吃飯，購買某件物品，使用某物件或做某事 ( eating in some restaurant, buying something, using or doing something )。

recommend 的用法：recommend某事 (推薦某事)，recommend v~ing 某事 (推薦做某事)，recommend that某人做某事 (推薦某人做某事)。
****/

suggest當作「提議」時，同義詞是propose
I suggest (that) we go for a walk.我提議我們去散步。

當「建議」時，某部份與recommend同義，但常用的句型是
suggest sth (for/as sth)，注意不可像give一樣用suggest sb sth(╳)

Who would you suggest for the job?你會建議誰擔任這個工作？


/****
常用來suggest 某人的事件如 : 主意或計劃，線索 (ideas or plans, clues)。

suggest 的用法和recommend類似。
****/