コード例 #1
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        clsMachineryUsage obj = new clsMachineryUsage();

        obj.SiteID     = Convert.ToInt32(ddlSite.SelectedValue);
        obj.Shift      = Convert.ToInt32(ddlShift.SelectedValue);
        obj.EntryDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString();
        obj.Op         = 12;
        obj.MachineryUsage(obj);
        double TotalFuelUsed = 0;

        foreach (GridViewRow dr in grd.Rows)
        {
            Label       lblMachine         = dr.FindControl("lblMachine") as Label;
            HiddenField hdSiteMachineID    = dr.FindControl("hdSiteMachineID") as HiddenField;
            TextBox     txtOpenKMReading   = dr.FindControl("txtOpenKMReading") as TextBox;
            TextBox     txtCloseKMReading  = dr.FindControl("txtCloseKMReading") as TextBox;
            Label       lblTotalKMReading  = dr.FindControl("lblTotalKMReading") as Label;
            TextBox     txtOpenHReading    = dr.FindControl("txtOpenHReading") as TextBox;
            TextBox     txtOpenMReading    = dr.FindControl("txtOpenMReading") as TextBox;
            TextBox     txtCloseHReading   = dr.FindControl("txtCloseHReading") as TextBox;
            TextBox     txtCloseMReading   = dr.FindControl("txtCloseMReading") as TextBox;
            Label       lblTotalHRReading  = dr.FindControl("lblTotalHRReading") as Label;
            TextBox     txtOpenHSDReading  = dr.FindControl("txtOpenHSDReading") as TextBox;
            TextBox     txtHSDIssue        = dr.FindControl("txtHSDIssue") as TextBox;
            TextBox     txtCloseHSDReading = dr.FindControl("txtCloseHSDReading") as TextBox;
            Label       lblTotalHSDReading = dr.FindControl("lblTotalHSDReading") as Label;
            CheckBox    chkBreakdown       = dr.FindControl("chkBreakdown") as CheckBox;
            CheckBox    chkIdle            = dr.FindControl("chkIdle") as CheckBox;
            TextBox     txtDriver          = dr.FindControl("txtDriver") as TextBox;
            TextBox     txtRemarks         = dr.FindControl("txtRemarks") as TextBox;
            obj.SiteMachineID   = Convert.ToInt32(hdSiteMachineID.Value);
            obj.OpenKMReading   = Convert.ToDouble(txtOpenKMReading.Text);
            obj.CloseKMReading  = Convert.ToDouble(txtCloseKMReading.Text);
            obj.TotalKMReading  = Convert.ToDouble(lblTotalKMReading.Text);
            obj.OpenHRReading   = txtOpenHReading.Text + ":" + txtOpenMReading.Text;
            obj.CloseHRReading  = txtCloseHReading.Text + ":" + txtCloseMReading.Text;
            obj.TotalHRReading  = lblTotalHRReading.Text;
            obj.OpenHSDReading  = Convert.ToDouble(txtOpenHSDReading.Text);
            obj.CloseHSDReading = Convert.ToDouble(txtCloseHSDReading.Text);
            obj.HSDIssue        = Convert.ToDouble(txtHSDIssue.Text);
            TotalFuelUsed       = TotalFuelUsed + Convert.ToDouble(txtHSDIssue.Text);
            obj.TotalHSDReading = Convert.ToDouble(lblTotalHSDReading.Text);
            if (chkBreakdown.Checked == true)
            {
                obj.Breakdown = 1;
            }
            if (chkIdle.Checked == true)
            {
                obj.Idle = 1;
            }
            obj.DriverName = txtDriver.Text;
            obj.Remarks    = txtRemarks.Text;
            obj.Status     = 1;
            obj.EnteredBy  = Convert.ToInt32(Request.Cookies["User"].Value);
            obj.Op         = 1;
            obj.MachineryUsage(obj);
            if (chkBreakdown.Checked == true)
            {
                clsSiteMachines obSM = new clsSiteMachines();
                obSM.ID     = Convert.ToInt32(hdSiteMachineID.Value);
                obSM.Op     = 2;
                obSM.Status = 3;
                try { obSM.UpdateDate = txtDate.Text; }
                catch { }
                obSM.SiteMachines(obSM);
                clsMachineDamage obMD = new clsMachineDamage();
                obMD.SiteID        = Convert.ToInt32(ddlSite.SelectedValue);
                obMD.SiteMachineID = Convert.ToInt32(hdSiteMachineID.Value);
                obMD.EntryDate1    = Convert.ToDateTime(txtDate.Text).ToShortDateString();
                obMD.Remarks       = "Entry From Daily Progress Report";
                obMD.Op            = 1;
                obMD.MachineDamage(obMD);
            }
            else
            {
                if (chkIdle.Checked == true)
                {
                    clsSiteMachines obSM = new clsSiteMachines();
                    obSM.ID     = Convert.ToInt32(hdSiteMachineID.Value);
                    obSM.Op     = 2;
                    obSM.Status = 2;
                    try { obSM.UpdateDate = txtDate.Text; }
                    catch { }
                    obSM.SiteMachines(obSM);
                }
                else
                {
                    clsSiteMachines obSM = new clsSiteMachines();
                    obSM.ID     = Convert.ToInt32(hdSiteMachineID.Value);
                    obSM.Op     = 2;
                    obSM.Status = 1;
                    try { obSM.UpdateDate = txtDate.Text; }
                    catch { }
                    obSM.SiteMachines(obSM);
                }
            }
        }
        clsSiteFuelIssue obSFI = new clsSiteFuelIssue();

        obSFI.SiteID = Convert.ToInt32(ddlSite.SelectedValue);
        try { obSFI.IssueDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString(); }
        catch { }
        obSFI.InAmount  = Convert.ToDouble(txtFuelIssued.Text);
        obSFI.OutAmount = TotalFuelUsed;
        obSFI.Balance   = Convert.ToDouble(txtFuelBalance.Text);
        obSFI.Rate      = 0;
        obSFI.Total     = 0;
        obSFI.Remarks   = "Entry from Daily Progress Report";
        obSFI.Op        = 1;
        obSFI.SiteFuelIssue(obSFI);
        LoadMachines();
        LoadFuel();
    }