public void gettieude(string ngaychungtu, string userid) { xrLabel1.Text = gen.GetString("select Top 1 CompanyName from Center"); xrLabel2.Text = xrLabel2.Text + "THÁNG " + String.Format("{0:MM}", DateTime.Parse(ngaychungtu)) + " NĂM " + String.Format("{0:yyyy}", DateTime.Parse(ngaychungtu)); xrLabel6.Text = "In lúc: " + String.Format("{0: HH:mm:ss}", DateTime.Now) + " ngày: " + String.Format("{0: dd-MM-yyyy}", DateTime.Now); DataTable temp = gen.GetTable("baocaothuchitien '" + userid + "','" + DateTime.Parse(ngaychungtu).Month + "','" + DateTime.Parse(ngaychungtu).Year + "'"); DataTable dt = new DataTable(); dt.Columns.Add("Thứ", Type.GetType("System.String")); dt.Columns.Add("Ngày", Type.GetType("System.DateTime")); dt.Columns.Add("Tiền mặt U55", Type.GetType("System.Double")); dt.Columns.Add("Ngân hàng U55", Type.GetType("System.Double")); dt.Columns.Add("Tiền mặt U166", Type.GetType("System.Double")); dt.Columns.Add("Ngân hàng U166", Type.GetType("System.Double")); dt.Columns.Add("Tiền mặt Gau166", Type.GetType("System.Double")); dt.Columns.Add("Ngân hàng Gau166", Type.GetType("System.Double")); dt.Columns.Add("Tiền mặt Mar166", Type.GetType("System.Double")); dt.Columns.Add("Ngân hàng Mar166", Type.GetType("System.Double")); dt.Columns.Add("Tiền mặt UTN", Type.GetType("System.Double")); dt.Columns.Add("Ngân hàng UTN", Type.GetType("System.Double")); dt.Columns.Add("Tổng thu", Type.GetType("System.Double")); dt.Columns.Add("Tổng chi", Type.GetType("System.Double")); dt.Columns.Add("Thanh toán", Type.GetType("System.Double")); dt.Columns.Add("Thực nộp 166", Type.GetType("System.Double")); dt.Columns.Add("Thực nộp TN", Type.GetType("System.Double")); int ngay = Int32.Parse(DateTime.DaysInMonth(DateTime.Parse(ngaychungtu).Year, DateTime.Parse(ngaychungtu).Month).ToString()); for (int j = 1; j <= ngay; j++) { string check = "0"; for (int i = 0; i < temp.Rows.Count; i++) { if (j == Int32.Parse(temp.Rows[i][0].ToString())) { DataRow dr = dt.NewRow(); dr[0] = gen.NgayTrongTuan(Int32.Parse(DateTime.Parse(ngaychungtu).Year.ToString()), Int32.Parse(DateTime.Parse(ngaychungtu).Month.ToString()), j); dr[1] = temp.Rows[i][1]; dr[2] = temp.Rows[i][2]; dr[3] = temp.Rows[i][3]; dr[4] = temp.Rows[i][4]; dr[5] = temp.Rows[i][5]; dr[6] = temp.Rows[i][6]; dr[7] = temp.Rows[i][7]; dr[8] = temp.Rows[i][8]; dr[9] = temp.Rows[i][9]; dr[10] = temp.Rows[i][10]; dr[11] = temp.Rows[i][11]; dr[12] = temp.Rows[i][12]; dr[13] = temp.Rows[i][13]; dr[14] = temp.Rows[i][14]; dr[15] = temp.Rows[i][15]; dr[16] = temp.Rows[i][16]; dt.Rows.Add(dr); check = "1"; } } if (check == "0") { DataRow dr = dt.NewRow(); dr[0] = gen.NgayTrongTuan(Int32.Parse(DateTime.Parse(ngaychungtu).Year.ToString()), Int32.Parse(DateTime.Parse(ngaychungtu).Month.ToString()), j); dr[1] = DateTime.Parse(ngaychungtu).Month.ToString() + "/" + j.ToString() + "/" + DateTime.Parse(ngaychungtu).Year.ToString(); dt.Rows.Add(dr); } } DataSource = dt; XRSummary summarytotal1 = new XRSummary(); XRSummary summarytotal2 = new XRSummary(); XRSummary summarytotal3 = new XRSummary(); XRSummary summarytotal4 = new XRSummary(); XRSummary summarytotal5 = new XRSummary(); XRSummary summarytotal6 = new XRSummary(); XRSummary summarytotal7 = new XRSummary(); XRSummary summarytotal8 = new XRSummary(); XRSummary summarytotal9 = new XRSummary(); XRSummary summarytotal10 = new XRSummary(); XRSummary summarytotal11 = new XRSummary(); XRSummary summarytotal12 = new XRSummary(); XRSummary summarytotal13 = new XRSummary(); XRSummary summarytotal14 = new XRSummary(); XRSummary summarytotal15 = new XRSummary(); summarytotal1.Running = SummaryRunning.Report; summarytotal1.IgnoreNullValues = true; summarytotal1.FormatString = "{0:n0}"; xrTableCell43.DataBindings.Add("Text", DataSource, "Tiền mặt U55", "{0:n0}"); xrTableCell43.Summary = summarytotal1; summarytotal2.Running = SummaryRunning.Report; summarytotal2.IgnoreNullValues = true; summarytotal2.FormatString = "{0:n0}"; xrTableCell44.DataBindings.Add("Text", DataSource, "Ngân hàng U55", "{0:n0}"); xrTableCell44.Summary = summarytotal2; summarytotal3.Running = SummaryRunning.Report; summarytotal3.IgnoreNullValues = true; summarytotal3.FormatString = "{0:n0}"; xrTableCell45.DataBindings.Add("Text", DataSource, "Tiền mặt U166", "{0:n0}"); xrTableCell45.Summary = summarytotal3; summarytotal4.Running = SummaryRunning.Report; summarytotal4.IgnoreNullValues = true; summarytotal4.FormatString = "{0:n0}"; xrTableCell46.DataBindings.Add("Text", DataSource, "Ngân hàng U166", "{0:n0}"); xrTableCell46.Summary = summarytotal4; summarytotal5.Running = SummaryRunning.Report; summarytotal5.IgnoreNullValues = true; summarytotal5.FormatString = "{0:n0}"; xrTableCell47.DataBindings.Add("Text", DataSource, "Tiền mặt Gau166", "{0:n0}"); xrTableCell47.Summary = summarytotal5; summarytotal6.Running = SummaryRunning.Report; summarytotal6.IgnoreNullValues = true; summarytotal6.FormatString = "{0:n0}"; xrTableCell48.DataBindings.Add("Text", DataSource, "Ngân hàng Gau166", "{0:n0}"); xrTableCell48.Summary = summarytotal6; summarytotal7.Running = SummaryRunning.Report; summarytotal7.IgnoreNullValues = true; summarytotal7.FormatString = "{0:n0}"; xrTableCell49.DataBindings.Add("Text", DataSource, "Tiền mặt Mar166", "{0:n0}"); xrTableCell49.Summary = summarytotal7; summarytotal8.Running = SummaryRunning.Report; summarytotal8.IgnoreNullValues = true; summarytotal8.FormatString = "{0:n0}"; xrTableCell50.DataBindings.Add("Text", DataSource, "Ngân hàng Mar166", "{0:n0}"); xrTableCell50.Summary = summarytotal8; summarytotal9.Running = SummaryRunning.Report; summarytotal9.IgnoreNullValues = true; summarytotal9.FormatString = "{0:n0}"; xrTableCell51.DataBindings.Add("Text", DataSource, "Tiền mặt UTN", "{0:n0}"); xrTableCell51.Summary = summarytotal9; summarytotal10.Running = SummaryRunning.Report; summarytotal10.IgnoreNullValues = true; summarytotal10.FormatString = "{0:n0}"; xrTableCell52.DataBindings.Add("Text", DataSource, "Ngân hàng UTN", "{0:n0}"); xrTableCell52.Summary = summarytotal10; summarytotal11.Running = SummaryRunning.Report; summarytotal11.IgnoreNullValues = true; summarytotal11.FormatString = "{0:n0}"; xrTableCell53.DataBindings.Add("Text", DataSource, "Tổng thu", "{0:n0}"); xrTableCell53.Summary = summarytotal11; summarytotal12.Running = SummaryRunning.Report; summarytotal12.IgnoreNullValues = true; summarytotal12.FormatString = "{0:n0}"; xrTableCell54.DataBindings.Add("Text", DataSource, "Tổng chi", "{0:n0}"); xrTableCell54.Summary = summarytotal12; summarytotal13.Running = SummaryRunning.Report; summarytotal13.IgnoreNullValues = true; summarytotal13.FormatString = "{0:n0}"; xrTableCell55.DataBindings.Add("Text", DataSource, "Thanh toán", "{0:n0}"); xrTableCell55.Summary = summarytotal13; summarytotal14.Running = SummaryRunning.Report; summarytotal14.IgnoreNullValues = true; summarytotal14.FormatString = "{0:n0}"; xrTableCell56.DataBindings.Add("Text", DataSource, "Thực nộp 166", "{0:n0}"); xrTableCell56.Summary = summarytotal14; summarytotal15.Running = SummaryRunning.Report; summarytotal15.IgnoreNullValues = true; summarytotal15.FormatString = "{0:n0}"; xrTableCell57.DataBindings.Add("Text", DataSource, "Thực nộp TN", "{0:n0}"); xrTableCell57.Summary = summarytotal15; xrTableCell21.DataBindings.Add("Text", DataSource, "Thứ"); xrTableCell23.DataBindings.Add("Text", DataSource, "Ngày", "{0:dd/MM/yyyy}"); xrTableCell24.DataBindings.Add("Text", DataSource, "Tiền mặt U55", "{0:n0}"); xrTableCell26.DataBindings.Add("Text", DataSource, "Ngân hàng U55", "{0:n0}"); xrTableCell27.DataBindings.Add("Text", DataSource, "Tiền mặt U166", "{0:n0}"); xrTableCell28.DataBindings.Add("Text", DataSource, "Ngân hàng U166", "{0:n0}"); xrTableCell29.DataBindings.Add("Text", DataSource, "Tiền mặt Gau166", "{0:n0}"); xrTableCell30.DataBindings.Add("Text", DataSource, "Ngân hàng Gau166", "{0:n0}"); xrTableCell31.DataBindings.Add("Text", DataSource, "Tiền mặt Mar166", "{0:n0}"); xrTableCell32.DataBindings.Add("Text", DataSource, "Ngân hàng Mar166", "{0:n0}"); xrTableCell33.DataBindings.Add("Text", DataSource, "Tiền mặt UTN", "{0:n0}"); xrTableCell34.DataBindings.Add("Text", DataSource, "Ngân hàng UTN", "{0:n0}"); xrTableCell35.DataBindings.Add("Text", DataSource, "Tổng thu", "{0:n0}"); xrTableCell36.DataBindings.Add("Text", DataSource, "Tổng chi", "{0:n0}"); xrTableCell38.DataBindings.Add("Text", DataSource, "Thanh toán", "{0:n0}"); xrTableCell39.DataBindings.Add("Text", DataSource, "Thực nộp 166", "{0:n0}"); xrTableCell40.DataBindings.Add("Text", DataSource, "Thực nộp TN", "{0:n0}"); }