I wanna play a game.

Donma Hsu donma

I wanna play a game.

Yesterday I wrote down the code. I bet I could be your hero. I am a mighty little programmer.

donma / NPOI_COLOR_CELL_PART1.cs

Created August 7, 2018 09:06

NPOI Font Color Part Code 1

	//綠色的Style
	NPOI.SS.UserModel.IFont fontG = workbook.CreateFont();
	fontG.Color = NPOI.SS.UserModel.IndexedColors.Green.Index;
	var styleG = workbook.CreateCellStyle();
	styleG.SetFont(fontG);

	//紅色的Style
	NPOI.SS.UserModel.IFont fontR = workbook.CreateFont();
	fontR.Color = NPOI.SS.UserModel.IndexedColors.Red.Index;
	var styleR = workbook.CreateCellStyle();

donma / NPOI_COLOR_CELL_PART2.cs

Created August 7, 2018 09:07

NPOI Font Color Part Code 2

	for (var i = 1; i <= 20; i++)
	{

	sheetReportResult.CreateRow(i).CreateCell(0).SetCellValue("用戶" + i);


	if (i== 5)
	{
	var cell = sheetReportResult.GetRow(i).CreateCell(1);
	cell.CellStyle = styleR;

donma / NPOI_COLOR_FONT.cs

Created August 7, 2018 09:09

NPOI Font Color Code

	var workbook = new HSSFWorkbook();
	var sheetReportResult = workbook.CreateSheet("報表結果");


	//綠色的Style
	NPOI.SS.UserModel.IFont fontG = workbook.CreateFont();
	fontG.Color = NPOI.SS.UserModel.IndexedColors.Green.Index;
	var styleG = workbook.CreateCellStyle();
	styleG.SetFont(fontG);

donma / decimaltostring.cs

Created August 27, 2018 05:23

decimal to string comma.

	decimal t1 = 123456.12345M;
	decimal t2 = 123456.12345M;
	decimal t3 = 12345678901234.123456789M;

	Console.WriteLine(t1.ToString("#,###,###.###"));
	//123,456.123


	Console.WriteLine(t2.ToString("#,###,###.####"));
	//123,456.1235

donma / GetMoneyString.cs

Created August 27, 2018 05:33

	public static string GetMoneyString(decimal number)
	{
	if (number.ToString().Contains("."))
	{
	var format = "#,###,###,####.";
	var tmpDot = number.ToString().Split('.')[1];
	for (var i = 0; i < tmpDot.Length; i++) {
	format += "#";
	}
	return number.ToString(format);

donma / GetWeekOfYearCalendarWeekRule.cs

Last active August 28, 2018 06:49

About CalendarWeekRule

	Console.WriteLine("2021-01-01");

	Console.WriteLine("CalendarWeekRule.FirstDay :" + new GregorianCalendar().GetWeekOfYear(new DateTime(2021, 01, 01), CalendarWeekRule.FirstDay, DayOfWeek.Monday));
	Console.WriteLine(("CalendarWeekRule.FirstFourDayWeek :" + new GregorianCalendar().GetWeekOfYear(new DateTime(2021, 01, 01), CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday)));
	Console.WriteLine(("CalendarWeekRule.FirstFullWeek :" + new GregorianCalendar().GetWeekOfYear(new DateTime(2021, 01, 01), CalendarWeekRule.FirstFullWeek, DayOfWeek.Monday)));
	//Result
	//2021-01-01
	//CalendarWeekRule.FirstDay :1
	//CalendarWeekRule.FirstFourDayWeek :53
	//CalendarWeekRule.FirstFullWeek :52

donma / ethsimplesdk1.cs

Last active November 9, 2018 02:43

C# Etherscan Simple SDK get Block Number

	var service = new EtherscanParse.TrasactionAgent(YOUR_TOKEN);

	var info = service.GetTrasactionInfo(TXID);
	Console.WriteLine("Gas Limit:" + Convert.ToInt32(info.result.gas, 16).ToString());
	Console.WriteLine("Gas Price:" + ((decimal)Int64.Parse(info.result.gasPrice.Replace("0x", ""), NumberStyles.AllowHexSpecifier) / 1000000000000000000).ToString(""));

	Console.WriteLine("From:"+info.result.from);
	Console.WriteLine("To:" + info.result.to);

	Console.WriteLine("hash(TXID):" + info.result.hash);

donma / ethsimplesdk2.cs

Created November 9, 2018 02:44

C# Etherscan Simple SDK get Block confirm

	var brInfo= service.GetBlockrewardWalletInfo(Convert.ToInt32(info.result.blockNumber, 16).ToString(), TEST_WALLET_ADDRESS);

	Console.WriteLine("\r\n Wallet Data : \r\n");
	Console.WriteLine("\r\n-----------------------------------------");

	foreach (var wt in brInfo.result) {

	Console.WriteLine("Source :"+JsonConvert.SerializeObject(wt));
	Console.WriteLine("");
	Console.WriteLine("TimeStamp:"+ ConvertTimestampToDateTime(double.Parse(wt.timeStamp)).ToString("yyyy-MM-dd HH:mm:ss"));

donma / ethsimplesdk2.cs

Created November 9, 2018 02:44

C# Etherscan Simple SDK get Block confirm

	var brInfo= service.GetBlockrewardWalletInfo(Convert.ToInt32(info.result.blockNumber, 16).ToString(), TEST_WALLET_ADDRESS);

	Console.WriteLine("\r\n Wallet Data : \r\n");
	Console.WriteLine("\r\n-----------------------------------------");

	foreach (var wt in brInfo.result) {

	Console.WriteLine("Source :"+JsonConvert.SerializeObject(wt));
	Console.WriteLine("");
	Console.WriteLine("TimeStamp:"+ ConvertTimestampToDateTime(double.Parse(wt.timeStamp)).ToString("yyyy-MM-dd HH:mm:ss"));

donma / chartjs.scale.tooltip.yaxis-comma.js

Created January 4, 2019 06:50

Chart.js Line Chart Y Axis Comma Sign