开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
report.aspx.cs
资源名称：web.rar　[点击查看]
上传用户：xrffrp
上传日期：2022-03-25
资源大小：22155k
文件大小：6k
源码类别：

OA系统

开发平台：

ASP/ASPX

report.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  4. using Microsoft.Reporting.WebForms;
  5. using System.Configuration;
  6. using System.Collections;
  7. using System.Web;
  8. using System.Web.Security;
  9. using System.Web.UI;
  10. using System.Web.UI.WebControls;
  11. using System.Web.UI.WebControls.WebParts;
  12. using System.Web.UI.HtmlControls;
  13. using CrystalDecisions.CrystalReports.Engine;
  15. public partial class web_pos_report : System.Web.UI.Page
  16. {
  17.     protected void Page_Load(object sender, EventArgs e)
  18.     {
  20.     }
  21.    /* protected void Button1_Click(object sender, EventArgs e)
  22.     {
  23.         string year = DropDownList1.SelectedItem.ToString();
  24.         string month = DropDownList2.SelectedItem.ToString();
  25.         string date = "";
  26.         if (month.Length == 1)
  27.         {
  28.             month = "0" + month;
  29.         }
  30.         date = year + "-" + month;
  31.         SqlConnection conn = dbConnection.getConnection();
  32.         conn.Open();
  33.         DataSet DataSet2 = new DataSet();
  34.         DataTable DataTable1 = new DataTable();
  35.         DataTable1.Columns.Add("date", typeof(string));
  36.         DataTable1.Columns.Add("shop", typeof(string));
  37.         DataTable1.Columns.Add("money", typeof(double));
  38.         SqlCommand sqlcom = new SqlCommand("select NO,name from POS_SHOP", conn);
  39.         SqlDataReader dr = sqlcom.ExecuteReader();
  40.         if (dr.HasRows)
  41.         {
  42.             while (dr.Read())
  43.             {
  44.                 SqlConnection conn1 = dbConnection.getConnection();
  45.                 conn1.Open();
  46.                 SqlCommand sqlcom1 = new SqlCommand("select DATE,QTY*UNITPRICE as money from CTI where SUBSTRING(DATE,0,8)='" + date + "' and shop='" + dr["NO"].ToString() + "'", conn1);
  47.                 SqlDataReader dr1 = sqlcom1.ExecuteReader();
  48.                 if (dr1.HasRows)
  49.                 {
  50.                     while (dr1.Read())
  51.                     {
  52.                         DataRow row = DataTable1.NewRow();
  53.                         row["shop"] = dr["name"].ToString();
  54.                         row["date"] = dr1["DATE"].ToString();
  55.                         row["money"] = Convert.ToInt32(dr1["money"]);
  56.                         DataTable1.Rows.Add(row);
  57.                     }
  58.                 }
  59.                 dr1.Close();
  60.                 conn1.Close();
  61.             }
  62.         }
  63.         DataSet2.Tables.Add(DataTable1);
  64.         dr.Close();
  65.         conn.Close();
  66.         
  67.         CrystalReportSource1.ReportDocument.Load(Server.MapPath("~/web/pos/CrystalReport.rpt"));
  68.         CrystalReportSource1.ReportDocument.SetDataSource(DataSet2);
  69.         CrystalReportSource1.DataBind();
  70.         CrystalReportViewer1.ReportSource = CrystalReportSource1;
  71.         CrystalReportViewer1.DataBind();
  72.         CrystalReportViewer1.Visible = true;
  73.     }*/
  74.     protected void Button1_Click(object sender, EventArgs e)
  75.     {
  76.         string year = DropDownList1.SelectedItem.ToString();
  77.         string month = DropDownList2.SelectedItem.ToString();
  78.         string date = "";
  79.         if (month.Length == 1)
  80.         {
  81.             month = "0" + month;
  82.         }
  83.         date = year + "-" + month;
  84.         SqlConnection conn = dbConnection.getConnection();
  85.         conn.Open();
  86.         DataSet4 ds = new DataSet4();
  87.         SqlCommand sqlcom = new SqlCommand("select NO,name from POS_SHOP", conn);
  88.         SqlDataReader dr = sqlcom.ExecuteReader();
  89.         if (dr.HasRows)
  90.         {
  91.             while (dr.Read())
  92.             {
  93.                 SqlConnection conn1 = dbConnection.getConnection();
  94.                 conn1.Open();
  95.                 SqlCommand sqlcom1 = new SqlCommand("select distinct DATE from CTI where SUBSTRING(DATE,0,8)='" + date + "' order by DATE", conn1);
  96.                 SqlDataReader dr1 = sqlcom1.ExecuteReader();
  97.                 if (dr1.HasRows)
  98.                 {
  99.                     while (dr1.Read())
  100.                     {
  101.                          DataRow row = ds.CTI.NewRow();
  102.                             row["shop"] = dr["name"].ToString();
  103.                             row["date"] = dr1["DATE"].ToString();
  104.                         SqlConnection conn2 = dbConnection.getConnection();
  105.                         conn2.Open();
  106.                         SqlCommand sqlcom2 = new SqlCommand("select sum(QTY*UNITPRICE) as money from CTI where DATE='" + dr1["DATE"] + "' and shop='" + dr["NO"].ToString() + "'", conn2);
  107.                         SqlDataReader dr2 = sqlcom2.ExecuteReader();
  108.                         if (dr2.HasRows)
  109.                         {
  110.                             while (dr2.Read())
  111.                             {
  112.                                 if (!dr2["money"].ToString().Equals(""))
  113.                                 {
  114.                                     row["QTY*UNITPRICE"] = Convert.ToInt32(dr2["money"]);
  115.                                 }
  116.                                 else
  117.                                 {
  118.                                     row["QTY*UNITPRICE"] = 0;
  119.                                 }
  120.                             }
  121.                         }
  122.                         ds.CTI.Rows.Add(row);
  123.                         dr2.Close();
  124.                         conn2.Close();
  125.                     }
  126.                 }
  127.                 dr1.Close();
  128.                 conn1.Close();
  129.             }
  130.         }
  131.         dr.Close();
  132.         conn.Close();
  134.         CrystalReportSource1.ReportDocument.Load(Server.MapPath("~/web/pos/CrystalReport.rpt"));
  135.         CrystalReportSource1.ReportDocument.SetDataSource(ds);
  136.         CrystalReportSource1.DataBind();
  137.         CrystalReportViewer1.ReportSource = CrystalReportSource1;
  138.         CrystalReportViewer1.DataBind();
  139.         CrystalReportViewer1.Visible = true;
  140.        
  141.     }
  142. }