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);
}
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);
}
protected override void Setup(ClsSysCurrentUser CurrentUser, string TableName, string ViewName = "", string CacheTableName = "")
{
base.Setup(CurrentUser, TableName, ViewName, CacheTableName);
this.mObj_Document = new ClsDocument(this.mCurrentUser);
}
