private string SendThongBaoLuong(string thang_nam, long nv_id) { string[] Ngay_thang = thang_nam.Split('/'); double Ngay_trong_thang = XL_LUONG.Ins.NgayCuoiThang(HelpNumber.ParseInt32(Ngay_thang[0]), HelpNumber.ParseInt32(Ngay_thang[1])).Day - XL_LUONG.Ins.SoNgayChuNhat(HelpNumber.ParseInt32(Ngay_thang[0]), HelpNumber.ParseInt32(Ngay_thang[1])) - (1.0 * XL_LUONG.Ins.SoNgayThuBay(HelpNumber.ParseInt32(Ngay_thang[0]), HelpNumber.ParseInt32(Ngay_thang[1])) / 2); DatabaseFB db = HelpDB.getDatabase(); System.Data.Common.DbCommand cmd = db.GetStoredProcCommand("ST_TINHLUONG_CHITIET"); db.AddInParameter(cmd, "@ITHANG_CHAM_CONG", DbType.String, thang_nam); db.AddInParameter(cmd, "@INHAN_VIEN", DbType.Int64, nv_id); DataSet ds = new DataSet(); db.LoadDataSet(cmd, ds, "ST_TINHLUONG_CHITIET"); foreach (DataRow item in ds.Tables[0].Rows) { item["NGAY_TRONG_THANG"] = Ngay_trong_thang; } DatabaseFB dbS = DABase.getDatabase(); System.Data.Common.DbCommand cmdS = db.GetStoredProcCommand("ST_TINHLUONG_CHITIET_SUB"); DataSet dsS = new DataSet(); dbS.LoadDataSet(cmdS, dsS, "ST_TINHLUONG_CHITIET_SUB"); XRPT_TinhLuong_ChiTiet xr = new XRPT_TinhLuong_ChiTiet(); xr.DataSource = ds; xr.xrSubreport1.ReportSource.DataSource = dsS; xr.xrSubreport2.ReportSource.DataSource = dsS; xr.ShowOne = true; string fileName = FrameworkParams.TEMPLETE_FOLDER + @"\Bang_luong_thang_" + thang_nam.Replace("/", "_") + ".png"; xr.ExportToImage(fileName); return fileName; }
private void barButtonItemInTongHop_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridViewMaster.SelectedRowsCount == 0) return; DataRow row = gridViewMaster.GetDataRow(gridViewMaster.GetSelectedRows()[0]); if (row == null) return; string thang_nam = row["THANG_NAM"].ToString(); long nv_id = HelpNumber.ParseInt64(row["NV_ID"]); string[] Ngay_thang = thang_nam.Split('/'); double Ngay_trong_thang = XL_LUONG.Ins.NgayCuoiThang(HelpNumber.ParseInt32(Ngay_thang[0]), HelpNumber.ParseInt32(Ngay_thang[1])).Day - XL_LUONG.Ins.SoNgayChuNhat(HelpNumber.ParseInt32(Ngay_thang[0]), HelpNumber.ParseInt32(Ngay_thang[1])) - (1.0 * XL_LUONG.Ins.SoNgayThuBay(HelpNumber.ParseInt32(Ngay_thang[0]), HelpNumber.ParseInt32(Ngay_thang[1])) / 2); DatabaseFB db = HelpDB.getDatabase(); System.Data.Common.DbCommand cmd = db.GetStoredProcCommand("ST_TINHLUONG_CHITIET"); db.AddInParameter(cmd, "@ITHANG_CHAM_CONG", DbType.String, thang_nam); db.AddInParameter(cmd, "@INHAN_VIEN", DbType.Int64, nv_id); DataSet ds = new DataSet(); db.LoadDataSet(cmd, ds, "ST_TINHLUONG_CHITIET"); foreach (DataRow item in ds.Tables[0].Rows) { item["NGAY_TRONG_THANG"] = Ngay_trong_thang; } DatabaseFB dbS = DABase.getDatabase(); System.Data.Common.DbCommand cmdS = db.GetStoredProcCommand("ST_TINHLUONG_CHITIET_SUB"); DataSet dsS = new DataSet(); dbS.LoadDataSet(cmdS, dsS, "ST_TINHLUONG_CHITIET_SUB"); XRPT_TinhLuong_ChiTiet xr = new XRPT_TinhLuong_ChiTiet(); xr.DataSource = ds; xr.xrSubreport1.ReportSource.DataSource = dsS; xr.xrSubreport2.ReportSource.DataSource = dsS; xr.ShowPreview(); }