public Entities.BCDTTheoThoiGian[] Select(int thang, int nam) { Sql = new Constants.Sql(); dtttg = new Constants.BCDTTheoThoiGian(); string sql = Sql.BCDTTheoThang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("@Thang", SqlDbType.Int).Value = thang; cmd.Parameters.Add("@Nam", SqlDbType.Int).Value = nam; SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //Insert Category into ArrayList ArrayList arr = new ArrayList(); while (dr.Read()) { Entities.BCDTTheoThoiGian bcdttg1 = new Entities.BCDTTheoThoiGian(); bcdttg1.MaHDBanHang = dr[dtttg.MaHDBanHang].ToString(); bcdttg1.NgayBan = Convert.ToDateTime(dr[dtttg.NgayBan].ToString()); bcdttg1.ThanhToanNgay = float.Parse(dr[dtttg.ThanhToanNgay].ToString()); bcdttg1.ThanhToanKhiLapPhieu = double.Parse(dr[dtttg.ThanhToanKhiLapPhieu].ToString()); bcdttg1.TongTienThanhToan = double.Parse(dr["TongTienThanhToan"].ToString()); arr.Add(bcdttg1); } int n = arr.Count; if (n == 0) { return(null); } Entities.BCDTTheoThoiGian[] arrC = new Entities.BCDTTheoThoiGian[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.BCDTTheoThoiGian)arr[i]; } //Giai phong bo nho arr = null; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return(arrC); }
public Entities.BCDTTheoThoiGian[] Select(int thang, int nam) { Sql = new Constants.Sql(); dtttg = new Constants.BCDTTheoThoiGian(); string sql = Sql.BCDTTheoThang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("@Thang", SqlDbType.Int).Value = thang; cmd.Parameters.Add("@Nam", SqlDbType.Int).Value = nam; SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //Insert Category into ArrayList ArrayList arr = new ArrayList(); while (dr.Read()) { Entities.BCDTTheoThoiGian bcdttg1 = new Entities.BCDTTheoThoiGian(); bcdttg1.MaHDBanHang = dr[dtttg.MaHDBanHang].ToString(); bcdttg1.NgayBan = Convert.ToDateTime(dr[dtttg.NgayBan].ToString()); bcdttg1.ThanhToanNgay = float.Parse(dr[dtttg.ThanhToanNgay].ToString()); bcdttg1.ThanhToanKhiLapPhieu = double.Parse(dr[dtttg.ThanhToanKhiLapPhieu].ToString()); bcdttg1.TongTienThanhToan = double.Parse(dr["TongTienThanhToan"].ToString()); arr.Add(bcdttg1); } int n = arr.Count; if (n == 0) return null; Entities.BCDTTheoThoiGian[] arrC = new Entities.BCDTTheoThoiGian[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.BCDTTheoThoiGian)arr[i]; } //Giai phong bo nho arr = null; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return arrC; }
public frmBaoCaorpt(DateTime Truoc, DateTime Sau, bool isView, string path, string hanhDong) { try { InitializeComponent(); CongTy(); cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.BCDTTheoThoiGian ctxh = new Entities.BCDTTheoThoiGian("SelectTheoKhoang", Truoc, Sau); Entities.BCDTTheoThoiGian[] pt1 = new Entities.BCDTTheoThoiGian[1]; clientstrem = cl.SerializeObj(this.client1, "BCDTTheoThoiGian", ctxh); pt1 = (Entities.BCDTTheoThoiGian[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) { MessageBox.Show("Không có dữ liệu", "Hệ thống cảnh báo"); return; } else { GUI.Report.rptBCDoanhThuTheoThoiGian report = new GUI.Report.rptBCDoanhThuTheoThoiGian(); report.SetDataSource(pt1); crvReport.ReportSource = report; report.SetParameterValue("TenCongTy", CT.TenCongTy); report.SetParameterValue("DiaChiCongTy", CT.DiaChi); report.SetParameterValue("DienThoai", CT.SoDienThoai); report.SetParameterValue("FaxCongTy", CT.Fax); report.SetParameterValue("Web", CT.Website); report.SetParameterValue("TenBaoCao", "Báo Cáo Doanh Thu Theo Khoảng Thời Gian"); report.SetParameterValue("NgayTao", new Common.Utilities().XuLy(2, DateServer.Date().ToShortDateString())); report.SetParameterValue("MaNhanVien", Common.Utilities.User.TenNhanVien); report.SetParameterValue("Email", CT.Email); report.SetParameterValue("Tu", new Common.Utilities().XuLy(2, Truoc.ToShortDateString())); report.SetParameterValue("Den", new Common.Utilities().XuLy(2, Sau.ToShortDateString())); if (isView) crvReport.Show(); else { switch (hanhDong) { case "Excel": new Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.Excel); break; case "Word": new Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.WordForWindows); break; case "PDF": new Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.PortableDocFormat); break; } } } } catch { } }
public frmBaoCaorpt(int Thang, int Nam) { try { InitializeComponent(); CongTy(); cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.BCDTTheoThoiGian ctxh = new Entities.BCDTTheoThoiGian("SelectTheoThang", Thang, Nam); Entities.BCDTTheoThoiGian[] pt1 = new Entities.BCDTTheoThoiGian[1]; clientstrem = cl.SerializeObj(this.client1, "BCDTTheoThoiGian", ctxh); pt1 = (Entities.BCDTTheoThoiGian[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) { MessageBox.Show("Không có dữ liệu", "Hệ thống cảnh báo"); return; } else { GUI.Report.rptBCDoanhThuTheoThoiGian report = new GUI.Report.rptBCDoanhThuTheoThoiGian(); report.SetDataSource(pt1); crvReport.ReportSource = report; report.SetParameterValue("TenCongTy", CT.TenCongTy); report.SetParameterValue("DiaChiCongTy", CT.DiaChi); report.SetParameterValue("DienThoai", CT.SoDienThoai); report.SetParameterValue("FaxCongTy", CT.Fax); report.SetParameterValue("Web", CT.Website); report.SetParameterValue("TenBaoCao", "Báo Cáo Doanh Thu Theo Tháng " + Thang + "/" + Nam); report.SetParameterValue("NgayTao", new Common.Utilities().XuLy(2, DateServer.Date().ToShortDateString())); report.SetParameterValue("MaNhanVien", Common.Utilities.User.TenNhanVien); report.SetParameterValue("Email", CT.Email); report.SetParameterValue("Tu", ""); report.SetParameterValue("Den", ""); crvReport.Show(); } } catch { } }