kaoqin.aspx.cs
上传用户:xrffrp
上传日期:2022-03-25
资源大小:22155k
文件大小:4k
源码类别:

OA系统

开发平台:

ASP/ASPX

  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using Microsoft.Reporting.WebForms;
  12. public partial class web_123_kaoqin : System.Web.UI.Page
  13. {
  14.     protected void Page_Load(object sender, EventArgs e)
  15.     {
  16.         ReportParameter p = new ReportParameter("report_date",TxtDate.Text);
  17.         ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p });
  18.     }
  19.     protected void Button1_Click(object sender, EventArgs e)
  20.     {
  21.         if (check())
  22.         {
  23.             if (TxtDate.Text != "" && Txtdept.Text != "")
  24.             {
  25.                 ReportViewer1.Visible = true;
  26.                 if (TxtDate.Text.ToString().Length == 7)
  27.                 {
  28.                     ObjectDataSource1.SelectMethod = "getDepartmentDateM";
  29.                 }
  30.                 else if (TxtDate.Text.ToString().Length == 10)
  31.                 {
  32.                     ObjectDataSource1.SelectMethod = "getDepartmentDate";
  33.                 }
  34.                 else 
  35.                 {
  36.                     ObjectDataSource1.SelectMethod = "getDepartmentDate";
  37.                     Response.Write("只可按月。日查詢");
  38.                 }
  39.                 Parameter p11 = new Parameter("department_id");
  40.                 Parameter p22 = new Parameter("date");
  41.                 p11.DefaultValue = DepartmentId.Value;
  42.                 p22.DefaultValue = TxtDate.Text;
  43.                 ObjectDataSource1.SelectParameters.Clear();
  44.                 ObjectDataSource1.SelectParameters.Add(p11);
  45.                 ObjectDataSource1.SelectParameters.Add(p22);
  46.                 ObjectDataSource1.Select();
  47.                 ReportViewer1.LocalReport.Refresh();
  48.                 ReportViewer1.LocalReport.DisplayName = TxtDate.Text.ToString()+ Txtdept.Text.ToString();
  49.                 
  50.             }
  51.             else
  52.             {
  53.                 ReportViewer1.Visible = true;
  54.                 if (TxtDate.Text.ToString().Length == 7)
  55.                 {
  56.                     ObjectDataSource1.SelectMethod = "getDateM";
  57.                 }
  58.                 else if (TxtDate.Text.ToString().Length == 10)
  59.                 {
  60.                     ObjectDataSource1.SelectMethod = "getDate";
  61.                }
  62.                 else 
  63.                 {
  64.                     ObjectDataSource1.SelectMethod = "getDate";
  65.                     Response.Write("只可按月。日查詢");
  66.                 }
  67.                     
  68.                 Parameter p = new Parameter("date");
  69.                 p.DefaultValue = TxtDate.Text;
  70.                 ObjectDataSource1.SelectParameters.Clear();
  71.                 ObjectDataSource1.SelectParameters.Add(p);
  72.                 ObjectDataSource1.Select();
  73.                 ReportViewer1.LocalReport.Refresh();
  74.                
  75.                 ReportViewer1.LocalReport.DisplayName = TxtDate.Text.ToString() ;
  76.                
  77.             }
  78.         }
  79.         else { Response.Write("<script>alert('請選擇日期!')</script>"); TxtDate.Focus(); }
  80.     }
  81.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  82.     {
  83.         if (Calendar1.Visible == true)
  84.         {
  85.             Calendar1.Visible = false;
  86.         }
  87.         else
  88.         {
  89.             Calendar1.Visible = true;
  90.         }
  91.     }
  92.     protected void Calendar1_SelectionChanged(object sender, EventArgs e)
  93.     {
  94.         string year = Calendar1.SelectedDate.Year.ToString();
  95.         string month = Calendar1.SelectedDate.Month.ToString();
  96.         if (month.Length == 1)
  97.         {
  98.             month = "0" + month;
  99.         }
  100.         string day = Calendar1.SelectedDate.Day.ToString();
  101.         if (day.Length == 1)
  102.         {
  103.             day = "0" + day;
  104.         }
  105.         TxtDate.Text = year + "-" + month + "-" + day;
  106.         Calendar1.Visible = false;
  107.     }
  108.     protected bool check() 
  109.     {
  110.         if (TxtDate.Text == "")
  111.         {           
  112.             return false;
  113.         }
  114.         else { return true; }
  115.     }
  116.    
  117. }