コード例 #1
0
    protected void FvInspectionIternary_DataBound(object sender, EventArgs e)
    {
        string Mode = String.Empty;
        switch (FvInspectionIternary.CurrentMode)
        {
            case FormViewMode.Edit:
                Mode = "Upd";
                break;
            case FormViewMode.Insert:
                Mode = "Ins";
                break;
            case FormViewMode.ReadOnly:
                Mode = "Itm";
                break;
            default:
                break;
        }

        // Get the Yearly Schedule Id
        Guid ScheduleId = new Guid(fldScheduleId.Value);
        // Get the Monthly schedule details for the selected Schedule
        Inspection objInspection = new Inspection();
        DataTable dtScheduleDetails = objInspection.GetYearlyInspectionDetailsById(ScheduleId);
        DropDownList ddlInspectionMonth = ((DropDownList)FvInspectionIternary.FindControl("ddlMonth" + Mode));

        GvInspectionDetails.DataSource = dtScheduleDetails;
        GvInspectionDetails.DataBind();
        if (dtScheduleDetails.Rows.Count > 0)
        {
            //int year= (int)dtScheduleDetails.Rows[0]["Year"];
            //Label lblYear = (Label)FvInspectionIternary.FindControl("lblYear" + Mode);
            //if (lblYear != null)
            //    lblYear.Text = Convert.ToString(year);

            //PopCalendar popInspectingDate = (PopCalendar)FvInspectionIternary.FindControl("popInspectingDate" + Mode);

            //RangeFrom DateFrom = new RangeFrom();
            //RangeTo DateTo = new RangeTo();

            //DateFrom.Date = new DateTime(year, ddlInspectionMonth.SelectedIndex, 01);
            //DateTo.Date = new DateTime(year, ddlInspectionMonth.SelectedIndex, DateTime.DaysInMonth(year, ddlInspectionMonth.SelectedIndex));

            //if (popInspectingDate != null){
                //popInspectingDate.From = DateFrom;
                //popInspectingDate.To = DateTo;
            //}
            ddlInspectionMonth.SelectedIndex = Convert.ToInt32(dtScheduleDetails.Rows[0]["Month"]);
        }
    }
コード例 #2
0
 protected void GvYearlyInspection_SelectedIndexChanged(object sender, EventArgs e)
 {
     // Get the Yearly Schedule Id
     Guid ScheduleId = (Guid)GvYearlyInspection.SelectedDataKey.Value;
     fldScheduleId.Value = Convert.ToString(ScheduleId);
     // Get the Monthly schedule details for the selected Schedule
     Inspection objInspection = new Inspection();
     DataTable dtScheduleDetails = objInspection.GetYearlyInspectionDetailsById(ScheduleId);
     DataTable dtOfficeDetails = new Inspection().GetMonthlyInspectionScheduleByDetailScheduleId(ScheduleId);
     string officeNames = "";
     // Get the selected Offices
     if (dtScheduleDetails.Rows.Count > 0)
     {
         foreach (DataRow drScheduleDetail in dtScheduleDetails.Rows)
         {
             officeNames = "";
             DataRow[] drOfficeDetail = dtOfficeDetails.Select("DetailScheduleId='" + drScheduleDetail["DetailScheduleId"].ToString() + "'");
             for (int i = 0; i < drOfficeDetail.Length; i++)
             {
                 officeNames += Convert.ToString(drOfficeDetail[i]["OfficeName"]) + ", ";
             }
             // Remove the coma at the end of the string
             if (officeNames.Length > 2)
             {
                 officeNames = officeNames.Substring(0, officeNames.Length - 2);
             }
             drScheduleDetail["OfficeName"] = officeNames;
         }
         GvInspectionDetails.DataSource = dtScheduleDetails;
         GvInspectionDetails.DataBind();
     }
     //DropDownList ddlInspectionMonth = ((DropDownList)FvInspectionIternary.FindControl("ddlMonth" + Mode));
 }
コード例 #3
0
    protected void FvYearlySchedule_DataBound(object sender, EventArgs e)
    {
        if (FvYearlySchedule.CurrentMode == FormViewMode.Edit)
        {
            // Get the Yearly Schedule Id
            Guid ScheduleId = (Guid)GvYearlyInspection.SelectedDataKey.Values["ScheduleId"];
            // Get the Monthly schedule details for the selected Schedule
            Inspection objInspection = new Inspection();
            DataTable dtScheduleDetails = objInspection.GetYearlyInspectionDetailsById(ScheduleId);
            DataTable dtOfficeDetails = new Inspection().GetMonthlyInspectionScheduleByDetailScheduleId(ScheduleId);
            string officeNames = "";
            // Get the selected Offices
            if (dtScheduleDetails.Rows.Count > 0)
            {
                foreach (DataRow drScheduleDetail in dtScheduleDetails.Rows)
                {
                    officeNames = "";
                    DataRow[] drOfficeDetail = dtOfficeDetails.Select("DetailScheduleId='" + drScheduleDetail["DetailScheduleId"].ToString() + "'");
                    for (int i = 0; i < drOfficeDetail.Length; i++)
                    {
                        officeNames += Convert.ToString(drOfficeDetail[i]["OfficeName"]) + ", ";
                    }
                    // Remove the coma at the end of the string
                    if (officeNames.Length > 2)
                    {
                        officeNames = officeNames.Substring(0, officeNames.Length - 2);
                    }
                    drScheduleDetail["OfficeName"] = officeNames;
                }

                ViewState["ScheduleDetails"] = dtScheduleDetails;
                ViewState["SelectedOffices"] = dtOfficeDetails;

                GridView grd = (GridView)FvYearlySchedule.FindControl("GvInspectionDetailsUpd");
                grd.DataSource = dtScheduleDetails;
                grd.SelectedIndex = -1;
                grd.DataBind();
            }
        }
    }