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();
}
