文件操作 - MissingReport.aspx.cs

文件: E:\HostingSpaces\kimblycr\guard.kimbly.in\wwwroot\MissingReport.aspx.cs

编辑文件内容

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class MissingReport : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            txtSDate.Text = DateTime.Today.ToString("dd-MMM-yy");
        }
    }
    protected void BtnSearch_Click(object sender, ImageClickEventArgs e)
    {
        Repeater1.DataSource = SqlDataSource5;
        Repeater1.DataBind();
    }
    protected void DDLSites_SelectedIndexChanged(object sender, EventArgs e)
    {
        DDLRoutes.DataBind();
    }
    protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        //Label lblShift = 
    }
    public DataTable GetChildData(object ObjShiftID)
    {
        SelectClass sel = new SelectClass();
        int ShiftID = (int)ObjShiftID;
        DataTable dt = sel.GetShiftRouteDetails(Convert.ToInt32(DDLSites.SelectedValue), ShiftID);
        return dt;
    }
    public DataTable GetGridData(object ObjShiftID, object ObjRouteID, object STime, object ETime, object Count)
    {
        SelectClass sel = new SelectClass();
        int ShiftID = (int)ObjShiftID;
        int RouteID = (int)ObjRouteID;
        DataTable dt = sel.GetCheckPointInRoute(Convert.ToInt32(DDLSites.SelectedValue), RouteID);
        string chip;
        DataTable dt2 = new DataTable();
        dt2.Columns.Add("CheckPoint");
        dt2.Columns.Add("Missing");
        int Ccount = 0;
        int count = (int)Count;
        DateTime dat = Convert.ToDateTime(txtSDate.Text);
        string stime = STime.ToString();
        string etime = ETime.ToString();
        foreach (DataRow dr in dt.Rows)
        {
            chip = dr["Chip"].ToString();
            Ccount = sel.CountTransForChip(dat, stime, etime, chip);
            if (Ccount < count)
            {
                DataRow dr2 = dt2.NewRow();
                dr2[0] = dr["Name"].ToString();
                dr2[1] = Convert.ToString(count - Ccount);
                dt2.Rows.Add(dr2);
            }
        }
        return dt2;
    }
}

文件操作 - MissingReport.aspx.cs

文件: E:\HostingSpaces\kimblycr\guard.kimbly.in\wwwroot\MissingReport.aspx.cs

编辑文件内容

修改文件时间

删除文件