kaoqin.aspx.cs
资源名称:web.rar [点击查看]
上传用户:xrffrp
上传日期:2022-03-25
资源大小:22155k
文件大小:4k
源码类别:
OA系统
开发平台:
ASP/ASPX
- using System;
- using System.Data;
- using System.Configuration;
- using System.Collections;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- using Microsoft.Reporting.WebForms;
- public partial class web_123_kaoqin : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- ReportParameter p = new ReportParameter("report_date",TxtDate.Text);
- ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p });
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- if (check())
- {
- if (TxtDate.Text != "" && Txtdept.Text != "")
- {
- ReportViewer1.Visible = true;
- if (TxtDate.Text.ToString().Length == 7)
- {
- ObjectDataSource1.SelectMethod = "getDepartmentDateM";
- }
- else if (TxtDate.Text.ToString().Length == 10)
- {
- ObjectDataSource1.SelectMethod = "getDepartmentDate";
- }
- else
- {
- ObjectDataSource1.SelectMethod = "getDepartmentDate";
- Response.Write("只可按月。日查詢");
- }
- Parameter p11 = new Parameter("department_id");
- Parameter p22 = new Parameter("date");
- p11.DefaultValue = DepartmentId.Value;
- p22.DefaultValue = TxtDate.Text;
- ObjectDataSource1.SelectParameters.Clear();
- ObjectDataSource1.SelectParameters.Add(p11);
- ObjectDataSource1.SelectParameters.Add(p22);
- ObjectDataSource1.Select();
- ReportViewer1.LocalReport.Refresh();
- ReportViewer1.LocalReport.DisplayName = TxtDate.Text.ToString()+ Txtdept.Text.ToString();
- }
- else
- {
- ReportViewer1.Visible = true;
- if (TxtDate.Text.ToString().Length == 7)
- {
- ObjectDataSource1.SelectMethod = "getDateM";
- }
- else if (TxtDate.Text.ToString().Length == 10)
- {
- ObjectDataSource1.SelectMethod = "getDate";
- }
- else
- {
- ObjectDataSource1.SelectMethod = "getDate";
- Response.Write("只可按月。日查詢");
- }
- Parameter p = new Parameter("date");
- p.DefaultValue = TxtDate.Text;
- ObjectDataSource1.SelectParameters.Clear();
- ObjectDataSource1.SelectParameters.Add(p);
- ObjectDataSource1.Select();
- ReportViewer1.LocalReport.Refresh();
- ReportViewer1.LocalReport.DisplayName = TxtDate.Text.ToString() ;
- }
- }
- else { Response.Write("<script>alert('請選擇日期!')</script>"); TxtDate.Focus(); }
- }
- protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
- {
- if (Calendar1.Visible == true)
- {
- Calendar1.Visible = false;
- }
- else
- {
- Calendar1.Visible = true;
- }
- }
- protected void Calendar1_SelectionChanged(object sender, EventArgs e)
- {
- string year = Calendar1.SelectedDate.Year.ToString();
- string month = Calendar1.SelectedDate.Month.ToString();
- if (month.Length == 1)
- {
- month = "0" + month;
- }
- string day = Calendar1.SelectedDate.Day.ToString();
- if (day.Length == 1)
- {
- day = "0" + day;
- }
- TxtDate.Text = year + "-" + month + "-" + day;
- Calendar1.Visible = false;
- }
- protected bool check()
- {
- if (TxtDate.Text == "")
- {
- return false;
- }
- else { return true; }
- }
- }