private void BtnPrint_Click(object sender, EventArgs e) { DataTable dtHead = new DataTable(); dtHead.Columns.Add("CODE", typeof(string)); dtHead.Columns.Add("DATA", typeof(string)); DataColumn[] col = new DataColumn[1]; col[0] = dtHead.Columns[0]; dtHead.PrimaryKey = col; DataRow row = dtHead.NewRow(); row["CODE"] = "DOC_ID"; row["DATA"] = "202009000002"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "USER_NM"; row["DATA"] = "황석환"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "USER_TEL"; row["DATA"] = "010-9409-0715"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "CASH"; row["DATA"] = "□"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "CARD"; row["DATA"] = "■"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "ETC"; row["DATA"] = "□"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "CRT_DT_DOT"; row["DATA"] = "2020.09.07"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "CRT_DT"; row["DATA"] = "2020년 09월 07일"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "COMP_REG_NO"; row["DATA"] = "392-81-01834"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "MASTER_NM"; row["DATA"] = "지문영"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "COMP_NM"; row["DATA"] = "㈜엔조이라이프"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "COMP_USER_NM"; row["DATA"] = "우지현 대표"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "PRJ_NM"; row["DATA"] = "Program Soft 개발"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "ADDR"; row["DATA"] = "청주 서원 충대로1, 농업창업보윤센터 214호"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "TEL"; row["DATA"] = "010-9080-7937"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "FAX"; row["DATA"] = " "; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "COST_TOTAL"; row["DATA"] = ClsSpread.GetPriceNum("11900000"); dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "COST_TOTAL_HAN"; row["DATA"] = ClsSpread.GetPriceNumtoHan("11900000"); dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "LOGO"; row["DATA"] = DTOFactory.BaseDir + "/images/logo.jpg"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "STAMP"; row["DATA"] = DTOFactory.BaseDir + "/images/stamp2.png"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "CMT"; row["DATA"] = "1. 대금 지급조건: 협의에 의함<br>2.유지보수 조건: 요청사항 개발 종료<br>3.Project 담당장: ceo @my-c.kr<br>4.부가세 포함"; dtHead.Rows.Add(row); row = dtHead.NewRow(); row["CODE"] = "COST_TOTAL_2"; string cost = "</span>" + ClsSpread.GetPriceNum("11900000"); for (int cnt = cost.Length; cnt < 23; cnt++) { cost = " " + cost; } row["DATA"] = cost; dtHead.Rows.Add(row); DataTable dtBody = new DataTable(); dtBody.Columns.Add("CLASS", typeof(string)); dtBody.Columns.Add("NO", typeof(string)); dtBody.Columns.Add("PROD_DESC", typeof(string)); dtBody.Columns.Add("QTY", typeof(string)); dtBody.Columns.Add("QTY_CD", typeof(string)); dtBody.Columns.Add("UNIT_COST", typeof(string)); dtBody.Columns.Add("COST", typeof(string)); dtBody.Columns.Add("REMARK", typeof(string)); row = dtBody.NewRow(); row["CLASS"] = "body_list_bold"; row["NO"] = "1"; row["PROD_DESC"] = "H/W"; row["QTY"] = " "; row["UNIT_COST"] = " "; row["COST"] = " "; row["REMARK"] = " "; dtBody.Rows.Add(row); row = dtBody.NewRow(); row["CLASS"] = "body_list"; row["NO"] = " "; row["PROD_DESC"] = "Kit+Board 연동"; row["QTY"] = "1"; row["QTY_CD"] = "SET"; row["UNIT_COST"] = "3,600,000"; cost = "</span>3,600,000"; for (int cnt = cost.Length; cnt < 23; cnt++) { cost = " " + cost; } row["COST"] = "<span style='mso-spacerun:yes'> </span>₩<span style='mso-spacerun:yes'>" + cost; row["REMARK"] = "미니카와 테스트 보드 결합"; dtBody.Rows.Add(row); row = dtBody.NewRow(); row["CLASS"] = "body_list_bold"; row["NO"] = "2"; row["PROD_DESC"] = "S/W"; row["QTY"] = " "; row["UNIT_COST"] = " "; row["COST"] = " "; row["REMARK"] = " "; dtBody.Rows.Add(row); row = dtBody.NewRow(); row["CLASS"] = "body_list"; row["NO"] = " "; row["PROD_DESC"] = "PCB제작"; row["QTY"] = "1"; row["QTY_CD"] = "EA"; row["UNIT_COST"] = "3,300,000"; cost = "</span>3,300,000"; for (int cnt = cost.Length; cnt < 23; cnt++) { cost = " " + cost; } row["COST"] = "<span style='mso-spacerun:yes'> </span>₩<span style='mso-spacerun:yes'>" + cost; row["REMARK"] = "테스트 보드 제작"; dtBody.Rows.Add(row); row = dtBody.NewRow(); row["CLASS"] = "body_list"; row["NO"] = " "; row["PROD_DESC"] = "PCB설계"; row["QTY"] = "1"; row["QTY_CD"] = "EA"; row["UNIT_COST"] = "5,000,000"; cost = "</span>5,000,000"; for (int cnt = cost.Length; cnt < 23; cnt++) { cost = " " + cost; } row["COST"] = "<span style='mso-spacerun:yes'> </span>₩<span style='mso-spacerun:yes'>" + cost; row["REMARK"] = "프로그램 설계"; dtBody.Rows.Add(row); Doc.DocumentText = ClsDocument.GetDocSkin("projectestimate01.html", dtHead, dtBody); }
private void GetInspResult(DataTable dt_Order) { string[] Column = new string[9]; Column[0] = "DOC_ID"; Column[1] = "CRT_DT"; Column[2] = "ORDER_DT"; Column[3] = "COMP_NM"; Column[4] = "ADDR"; Column[5] = "INSP_DT"; Column[6] = "INSP_TEAM"; Column[7] = "INSP_GRADE_NM"; Column[8] = "INSP_NM"; DataTable dt = dt_Order.DefaultView.ToTable(true, Column); DataTable dtDoc = new DataTable(); dtDoc.Columns.Add("CODE", typeof(string)); dtDoc.Columns.Add("DATA", typeof(string)); DataColumn[] col = new DataColumn[1]; col[0] = dtDoc.Columns[0]; dtDoc.PrimaryKey = col; foreach (DataColumn column in dt.Columns) { DataRow row = dtDoc.NewRow(); row["CODE"] = column; row["DATA"] = dt.Rows[0][column].ToString(); dtDoc.Rows.Add(row); } DataRow dr = dtDoc.NewRow(); dr["CODE"] = "IMG"; dr["DATA"] = DTOFactory.BaseDir + "/images/logo.jpg"; dtDoc.Rows.Add(dr); dr = dtDoc.NewRow(); dr["CODE"] = "STAMP"; dr["DATA"] = DTOFactory.BaseDir + "/images/stamp.png"; dtDoc.Rows.Add(dr); dr = dtDoc.NewRow(); dr["CODE"] = "QTY_SUM"; dr["DATA"] = ClsSpread.GetPriceNum(dt_Order.Compute("SUM(QTY)", "").ToString()); dtDoc.Rows.Add(dr); dr = dtDoc.NewRow(); dr["CODE"] = "COST_SUM"; dr["DATA"] = ClsSpread.GetPriceNum(dt_Order.Compute("SUM(COST)", "").ToString()); dtDoc.Rows.Add(dr); DataTable dtBody = new DataTable(); dtBody.Columns.Add("IN_DT", typeof(string)); dtBody.Columns.Add("MODEL_ID", typeof(string)); dtBody.Columns.Add("SPEC_VAL", typeof(string)); dtBody.Columns.Add("UNIT_COST", typeof(string)); dtBody.Columns.Add("IN_USER_NM", typeof(string)); dtBody.Columns.Add("IN_GRADE_NM", typeof(string)); dtBody.Columns.Add("SER_ID", typeof(string)); dtBody.Columns.Add("MODEL_NM", typeof(string)); dtBody.Columns.Add("QTY", typeof(string)); dtBody.Columns.Add("QTY_CD", typeof(string)); dtBody.Columns.Add("COST", typeof(string)); dtBody.Columns.Add("IN_DESC", typeof(string)); for (int i = 0; i < dt_Order.Rows.Count; i++) { DataRow row = dt_Order.Rows[i]; dr = dtBody.NewRow(); foreach (DataColumn column in dtBody.Columns) { if (column.ColumnName.IndexOf("COST") > -1) { dr[column.ColumnName] = ClsSpread.GetPriceNum(row[column.ColumnName].ToString()); } else if ("SER_ID".Equals(column.ColumnName.ToString())) { if (" ".Equals(row[column.ColumnName].ToString())) { dr[column.ColumnName] = row["GRP_ID"].ToString(); } else { dr[column.ColumnName] = row[column.ColumnName].ToString(); } } else { dr[column.ColumnName] = row[column.ColumnName]; } } dtBody.Rows.Add(dr); } Doc.DocumentText = ClsDocument.GetDocSkin("InspectionReport03.html", dtDoc, dtBody); }
private void GetInspResult(DataTable dt_Order) { string[] Column = new string[17]; Column[0] = "DOC_ID"; Column[1] = "USER_NM"; Column[2] = "USER_TEL"; Column[3] = "CASH"; Column[4] = "CARD"; Column[5] = "ETC"; Column[6] = "CRT_DT_DOT"; Column[7] = "CRT_DT"; Column[8] = "COMP_REG_NO"; Column[9] = "MASTER_NM"; Column[10] = "COMP_NM"; Column[11] = "COMP_USER_NM"; Column[12] = "PRJ_NM"; Column[13] = "ADDR"; Column[14] = "TEL"; Column[15] = "FAX"; Column[16] = "CMT"; DataTable dt = dt_Order.DefaultView.ToTable(true, Column); DataTable dtDoc = new DataTable(); dtDoc.Columns.Add("CODE", typeof(string)); dtDoc.Columns.Add("DATA", typeof(string)); DataColumn[] col = new DataColumn[1]; col[0] = dtDoc.Columns[0]; dtDoc.PrimaryKey = col; foreach (DataColumn column in dt.Columns) { DataRow row = dtDoc.NewRow(); row["CODE"] = column; row["DATA"] = dt.Rows[0][column].ToString(); dtDoc.Rows.Add(row); } DataRow dr = dtDoc.NewRow(); dr["CODE"] = "LOGO"; dr["DATA"] = DTOFactory.BaseDir + "/images/logo.jpg"; dtDoc.Rows.Add(dr); dr = dtDoc.NewRow(); dr["CODE"] = "STAMP"; dr["DATA"] = DTOFactory.BaseDir + "/images/stamp2.png"; dtDoc.Rows.Add(dr); string cost_total = dt_Order.Compute("SUM(COST)", "").ToString(); dr = dtDoc.NewRow(); dr["CODE"] = "COST_TOTAL"; dr["DATA"] = ClsSpread.GetPriceNum(cost_total); dtDoc.Rows.Add(dr); dr = dtDoc.NewRow(); dr["CODE"] = "COST_TOTAL_HAN"; dr["DATA"] = ClsSpread.GetPriceNumtoHan(cost_total); dtDoc.Rows.Add(dr); dr = dtDoc.NewRow(); dr["CODE"] = "COST_TOTAL_2"; string cost = "</span>" + ClsSpread.GetPriceNum(cost_total); for (int cnt = cost.Length; cnt < 23; cnt++) { cost = " " + cost; } dr["DATA"] = cost; dtDoc.Rows.Add(dr); DataTable dtBody = new DataTable(); dtBody.Columns.Add("CLASS", typeof(string)); dtBody.Columns.Add("NO", typeof(string)); dtBody.Columns.Add("PROD_DESC", typeof(string)); dtBody.Columns.Add("QTY", typeof(string)); dtBody.Columns.Add("QTY_CD", typeof(string)); dtBody.Columns.Add("UNIT_COST", typeof(string)); dtBody.Columns.Add("COST", typeof(string)); dtBody.Columns.Add("REMARK", typeof(string)); int no = 0; for (int i = 0; i < dt_Order.Rows.Count; i++) { DataRow row = dt_Order.Rows[i]; dr = dtBody.NewRow(); foreach (DataColumn column in dtBody.Columns) { switch (column.ColumnName) { case "CLASS": dr[column.ColumnName] = "0".Equals(row["QTY"].ToString()) ? "body_list_bold" : "body_list"; break; case "NO": dr[column.ColumnName] = "0".Equals(row["QTY"].ToString()) ? (++no).ToString() : " "; break; case "QTY": case "UNIT_COST": dr[column.ColumnName] = "0".Equals(row["QTY"].ToString()) ? " " : row[column.ColumnName].ToString(); break; case "COST": if ("0".Equals(row["QTY"].ToString())) { dr[column.ColumnName] = " "; } else { cost = "</span>" + ClsSpread.GetPriceNum(row[column.ColumnName].ToString()); for (int cnt = cost.Length; cnt < 23; cnt++) { cost = " " + cost; } dr[column.ColumnName] = "<span style='mso-spacerun:yes'> </span>₩<span style='mso-spacerun:yes'>" + cost; } break; default: dr[column.ColumnName] = row[column.ColumnName]; break; } } dtBody.Rows.Add(dr); } Doc.DocumentText = ClsDocument.GetDocSkin("projectestimate01.html", dtDoc, dtBody); }