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

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



                          sTx += "<th>ใช้</th>";
                          sTx += "<th>ไม่ใช้</th>";
                          sTx += "</tr>";

                          decimal dAmt;
                          decimal dPPU;
                          decimal dTotal = 0M;
                          string sBGColor;

                          for (int i = 0; i < ds.RecordCount(); i++)
                          {   sTmp = ds.showFieldValue("DtlID", i);
                             if (checkVersion(ds.showFieldValue("ItemStandardID", i),
                  ds.showFieldValue("FiscalYear", i), ds.showFieldValue("Version", i)) == "t")

                                  sBGColor = "";
                              else
                                  sBGColor = " bgcolor='LightCoral'";
                              sTx += "<tr valign=top" + sBGColor + ">";

                              sTx += "<td>" + (i + 1).ToString() + "</td>";
                              sTx += "<td>" + ds.showFieldValue("ItemType", i) + "</td>";
                              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) != "")
   261   262   263   264   265   266   267   268   269   270   271