コード例 #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        DataView dv = (DataView)DetailsSelect.Select(DataSourceSelectArguments.Empty);

        if (dv == null)
        {
            Response.Redirect("/404.aspx");
        }
        else
        {
            int      a = 0;
            string   b = "", c = "", d = "", h = "";
            Double   f = 0;
            DateTime g;

            a = (int)dv.Table.Rows[0][0];      //rno
            b = (string)dv.Table.Rows[0][1];   //rxno
            c = (string)dv.Table.Rows[0][2];   //payortb
            d = (string)dv.Table.Rows[0][3];   //partic
            f = (Double)dv.Table.Rows[0][4];   //amnt
            h = (string)dv.Table.Rows[0][5];   //recby
            g = (DateTime)dv.Table.Rows[0][6]; //ddate


            rno.Text     = a.ToString();
            rxno.Text    = b;
            payortb.Text = c;
            partic.Text  = d;
            amnt.Text    = f.ToString("n2");
            recby.Text   = h;
            ddate.Text   = g.ToLongDateString();
        }
    }
コード例 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        DataView dv1 = (DataView)ExpensesSelect.Select(DataSourceSelectArguments.Empty);

        if (dv1.Table.Rows[0][0] is DBNull)
        {
            oe = 0;
        }
        else
        {
            oe = (Double)dv1.Table.Rows[0][0];
        }
        if (dv1.Table.Rows[0][1] is DBNull)
        {
            pb = 0;
        }
        else
        {
            pb = (Double)dv1.Table.Rows[0][1];
        }
        vr = (Double)dv1.Table.Rows[0][2];


        DataView dv2 = (DataView)Amenity.Select(DataSourceSelectArguments.Empty);
        DataView dv3 = (DataView)Facility.Select(DataSourceSelectArguments.Empty);
        DataView dv4 = (DataView)Misc.Select(DataSourceSelectArguments.Empty);

        if (dv2.Table.Rows[0][0] is DBNull)
        {
            amntyex = 0;
        }
        else
        {
            amntyex = (Double)dv2.Table.Rows[0][0];
        }
        if (dv3.Table.Rows[0][0] is DBNull)
        {
            facex = 0;
        }
        else
        {
            facex = (Double)dv3.Table.Rows[0][0];
        }
        if (dv4.Table.Rows[0][0] is DBNull)
        {
            miscex = 0;
        }
        else
        {
            miscex = (Double)dv4.Table.Rows[0][0];
        }

        Label6.Text  = vr.ToString("n2");
        Label7.Text  = amntyex.ToString("n2");
        Label8.Text  = facex.ToString("n2");
        Label9.Text  = miscex.ToString("n2");
        Label10.Text = oe.ToString("n2");
        Label11.Text = pb.ToString("n2");


        total        = oe + pb + vr + amntyex + facex + miscex;
        Label12.Text = total.ToString("n2");
        Label2.Text  = DateTime.Now.ToLongDateString();
        DataView dv5 = (DataView)DetailsSelect.Select(DataSourceSelectArguments.Empty);
        string   vn, en, cn, cc;
        DateTime ddate;
        TimeSpan st, et;

        vn             = (string)dv5.Table.Rows[0][0];
        ddate          = (DateTime)dv5.Table.Rows[0][1];
        st             = (TimeSpan)dv5.Table.Rows[0][2];
        et             = (TimeSpan)dv5.Table.Rows[0][3];
        en             = (string)dv5.Table.Rows[0][4];
        cn             = (string)dv5.Table.Rows[0][5];
        cc             = (string)dv5.Table.Rows[0][6];
        Venue.Text     = vn;
        EventDate.Text = ddate.ToLongDateString();


        StartTime.Text = ConvertMode(st.ToString());
        EndTime.Text   = ConvertMode(et.ToString());
        EventName.Text = en;
        Label3.Text    = cn;
        Label4.Text    = cc;
    }
コード例 #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        DataView dvx = (DataView)sumamnty.Select(DataSourceSelectArguments.Empty);
        Double   tl  = (Double)dvx.Table.Rows[0][0];

        Label7.Text = tl.ToString("n2");

        DataView dvy = (DataView)sumfac.Select(DataSourceSelectArguments.Empty);
        Double   tl1 = (Double)dvy.Table.Rows[0][0];

        Label8.Text = tl1.ToString("n2");

        DataView dvz = (DataView)summisc.Select(DataSourceSelectArguments.Empty);
        Double   tl2 = (Double)dvz.Table.Rows[0][0];

        Label9.Text = tl2.ToString("n2");

        DataView dmg = (DataView)dmgSum.Select(DataSourceSelectArguments.Empty);
        Double   dgs = (Double)dmg.Table.Rows[0][0];

        Label10.Text = dgs.ToString("n2");

        DataView acum = (DataView)Accum.Select(DataSourceSelectArguments.Empty);
        Double   w    = (Double)acum.Table.Rows[0][0];

        Label6.Text = w.ToString("n2");

        x = Convert.ToDouble(Label7.Text);
        y = Convert.ToDouble(Label8.Text);
        z = Convert.ToDouble(Label9.Text);


        total        = x + y + z + w + dgs;
        Label12.Text = total.ToString("n2");
        Label2.Text  = DateTime.Now.ToLongDateString();
        DataView PBD = (DataView)PB.Select(DataSourceSelectArguments.Empty);
        Double   P   = (Double)PBD.Table.Rows[0][0];

        P = P - total;
        if (P >= 0)
        {
            Label14.Text = "Refundable Amount ";
            Label13.Text = P.ToString("n2");
        }
        else
        {
            P            = Math.Abs(P);
            Label13.Text = P.ToString("n2");
            Label14.Text = "Remaining Balance";
        }
        DataView dv5 = (DataView)DetailsSelect.Select(DataSourceSelectArguments.Empty);
        string   vn, en, cn, cc;
        DateTime ddate;
        TimeSpan st, et;

        vn             = (string)dv5.Table.Rows[0][0];
        ddate          = (DateTime)dv5.Table.Rows[0][1];
        st             = (TimeSpan)dv5.Table.Rows[0][2];
        et             = (TimeSpan)dv5.Table.Rows[0][3];
        en             = (string)dv5.Table.Rows[0][4];
        cn             = (string)dv5.Table.Rows[0][5];
        cc             = (string)dv5.Table.Rows[0][6];
        Venue.Text     = vn;
        EventDate.Text = ddate.ToLongDateString();


        StartTime.Text = ConvertMode(st.ToString());
        EndTime.Text   = ConvertMode(et.ToString());
        EventName.Text = en;
        Label3.Text    = cn;
        Label4.Text    = cc;
    }