Page 274 - ระบบบริหารจัดการงบประมาณด้านเทคโนโลยีสารสนเทศและการสื่อสาร กรมพัฒนาที่ดิน

ห้องสมุดกรมพัฒนาที่ดิน
ง-19

sTx += "<td>" + ds.showFieldValue("ItemName", i) + "</td>";
sTx += "<td align=right>" + Convert.ToInt32(ds.showFieldValue("Amount",
i)).ToString("#,##0") + "</td>";

sTx += "<td align=right>" + Convert.ToDecimal(ds.showFieldValue("PricePerUnit",
i)).ToString("#,##0.00") + "</td>";
dAmt = Convert.ToDecimal(ds.showFieldValue("Amount", i));
dPPU = Convert.ToDecimal(ds.showFieldValue("PricePerUnit", i));

sTx += "<td align=right>" + (dAmt * dPPU).ToString("#,##0.00") + "</td>";
dTotal += dAmt * dPPU;
if (ds.showFieldValue("ItemStandardID", i) != "")
{ sTx += "<td align=center>/</td>";

sTx += "<td> </td>";
}
else
{ sTx += "<td> </td>";

sTx += "<td align=center>/</td>";
}
sTmp = ds.showFieldValue("NonStandardReason",
i).Replace(Convert.ToChar(10).ToString(), "<br>");

if (sTmp == "n/a" && ds.showFieldValue("ItemStandardID", i) != "")
sTmp = " ";
sTx += "<td>" + sTmp + "</td>";

sTx += "</tr>";
}
sTx += "<tr>";
sTx += "<th colspan=5>รวม</th>";
sTx += "<th>" + dTotal.ToString("#,##0.00") + "</th>"; dGrandTotal += dTotal;

sTx += "<th colspan=3> </th>";
sTx += "</tr>";
sTx += "</table>";

return sTx; }
protected string show45(string sFormID)
{ string sTx = "";
string sSql;

DbMgt table = new DbMgt(str);
sSql = "Select FormID, DtlID, ExpenseDtl, ExpenseCalc, Expense from formSetICTDev45
where FormID = '" + sFormID + "'";