示例#1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {
                dbConnection  dbcon = new dbConnection();
                clsDataSourse db    = new clsDataSourse();
                startdate.Value = dbcon.getindiantime().AddDays(-3).ToString("dd-MMM-yyyy");
                enddate.Value   = dbcon.getindiantime().AddDays(-3).ToString("dd-MMM-yyyy");
                //if (Request.QueryString["sdate"] != null)
                //{
                //    startdate.Value = Request.QueryString["sdate"];
                //}
                //if (Request.QueryString["edate"] != null)
                //{
                //    enddate.Value = Request.QueryString["edate"];
                //}
                DataTable dt = db.JobCardPaymentV6(false, false, false, false, false, false, startdate.Value, enddate.Value,
                                                   false, false, false, false, false, false, false, false, false, false);

                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
        }
        catch (Exception aa)
        {
        }
    }
示例#2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (!IsPostBack)
         {
             int WorkshopId = 0;
             int.TryParse(Request.Cookies["TUser"]["WorkshopId"], out WorkshopId);
             dbConnection  dbcon = new dbConnection();
             clsDataSourse db    = new clsDataSourse();
             startdate.Value = dbcon.getindiantime().ToString("dd-MMM-yyyy");
             enddate.Value   = dbcon.getindiantime().ToString("dd-MMM-yyyy");
             if (Request.QueryString["sdate"] != null)
             {
                 startdate.Value = Request.QueryString["sdate"];
             }
             if (Request.QueryString["edate"] != null)
             {
                 enddate.Value = Request.QueryString["edate"];
             }
             DataTable dt = db.CarInList(startdate.Value, enddate.Value, false, WorkshopId.ToString());
             GridView1.DataSource = dt;
             GridView1.DataBind();
         }
     }
     catch (Exception aa)
     {
     }
 }
示例#3
0
 protected void Button1_Click(object sender, EventArgs e)
 {
     try
     {
         dbConnection  dbcon = new dbConnection();
         clsDataSourse db    = new clsDataSourse();
         DataTable     dt    = db.JobCardPaymentV6(false, false, true, true, true, true, startdate.Value, enddate.Value,
                                                   false, false, false, false, false, false, false, false, false, false);
         GridView1.DataSource = dt;
         GridView1.DataBind();
         startdate.Value = DateTime.Parse(startdate.Value).ToString("dd-MMM-yyyy");
         enddate.Value   = DateTime.Parse(enddate.Value).ToString("dd-MMM-yyyy");
     }
     catch (Exception aa)
     {
     }
 }
示例#4
0
 protected void Button1_Click(object sender, EventArgs e)
 {
     try
     {
         int WorkshopId = 0;
         int.TryParse(Request.Cookies["TUser"]["WorkshopId"], out WorkshopId);
         dbConnection  dbcon = new dbConnection();
         clsDataSourse db    = new clsDataSourse();
         DataTable     dt    = db.CarInList(startdate.Value, enddate.Value, false, WorkshopId.ToString());
         GridView1.DataSource = dt;
         GridView1.DataBind();
         startdate.Value = DateTime.Parse(startdate.Value).ToString("dd-MMM-yyyy");
         enddate.Value   = DateTime.Parse(enddate.Value).ToString("dd-MMM-yyyy");
     }
     catch (Exception aa)
     {
     }
 }