Exemplo n.º 1
0
    private void SetInitialRow_ItemRateDtls()
    {
        try
        {
            DataTable dt = new DataTable();
            DataRow   dr;
            dt.Columns.Add("#", typeof(int));
            dt.Columns.Add("PONo", typeof(string));
            dt.Columns.Add("PODate", typeof(string));
            dt.Columns.Add("ItemCode", typeof(string));
            dt.Columns.Add("ItemName", typeof(string));
            dt.Columns.Add("OrderQuantity", typeof(string));
            dt.Columns.Add("Rate", typeof(string));
            dt.Columns.Add("Amount", typeof(string));
            dt.Columns.Add("Location", typeof(string));
            dt.Columns.Add("PORate", typeof(string));
            dt.Columns.Add("RateDiff", typeof(string));


            dr = dt.NewRow();

            dr["#"]             = 0;
            dr["PONo"]          = "";
            dr["PODate"]        = "";
            dr["ItemCode"]      = "";
            dr["ItemName"]      = "";
            dr["OrderQuantity"] = "";
            dr["Rate"]          = "";
            dr["Amount"]        = "";
            dr["Location"]      = "";
            dr["PORate"]        = "";
            dr["RateDiff"]      = "";

            dt.Rows.Add(dr);

            ViewState["CurrentTableItemRateDtls"] = dt;
            GrdItemWiseRate.DataSource            = dt;
            GrdItemWiseRate.DataBind();
        }

        catch (Exception ex) { throw new Exception(ex.Message); }
    }
Exemplo n.º 2
0
 public void BindPurchaseOrderLastRatesDetails(string Cond, Decimal NewRate)
 {
     try
     {
         Ds = Obj_EditPO.GetRateCompare(Cond, NewRate, 0, out StrError);
         //Ds = Obj_EditPO.GetRateCompare(Cond, 0,0, out StrError);
         if (Ds.Tables.Count > 0 && Ds.Tables[0].Rows.Count > 0)
         {
             GrdItemWiseRate.DataSource = Ds.Tables[0];
             GrdItemWiseRate.DataBind();
         }
         else
         {
             GrdItemWiseRate.DataSource = null;
             GrdItemWiseRate.DataBind();
             SetInitialRow_ItemRateDtls();
         }
     }
     catch (Exception ex) { throw new Exception(ex.Message); }
 }