MyLearn

2020年3月31日星期二

讓ASP.NET網站在開發除錯時期擁有WEB.CONFIG文件轉換功能

ref:
https://blog.kkbruce.net/2016/09/enabling-xml-document-transforms-for-all-asp-net-web-by-develop-time.html#.XoP1KGMzbRY

2020年3月27日星期五

[EF]DB char? mapping to EF string

Equals('') or Equals("")

linq pad4
使用 Equals('0')

c#
Equals("0")
或是
PSex[0]=='0'

ref:
https://stackoverflow.com/questions/6760765/how-do-i-map-a-char-property-using-the-entity-framework-4-1-code-only-fluent-a

2020年3月17日星期二

[JS]子字串包含

const string = "foo";
const substring = "oo";

console.log(string.includes(substring));

=======================================================

ie support

var string = "foo";
var substring = "oo";

console.log(string.indexOf(substring) !== -1);

https://stackoverflow.com/questions/1789945/how-to-check-whether-a-string-contains-a-substring-in-javascript

2020年3月11日星期三

var ws2 = wb.Worksheets.Add(title + "列表與紀錄");

mRStr = "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";
mRStr += "\r\n";
mRStr +="bbbbbbbbbbbbbbbbbbb";

ws2.Cell(ws2_r_idx, ws2_c_idx).Value = mRStr;
ws2.Cell(ws2_r_idx, ws2_c_idx).Style.Alignment.WrapText = true;

ws2.Rows().AdjustToContents();
ws2.Columns().AdjustToContents();

ref:
http://byeblou.blogspot.com/2018/11/c-excel-closedxml.html