public void ToDataRow(TC_BienLaiThuTien_ChiTietInfo pTC_BienLaiThuTien_ChiTietInfo, ref DataRow dr)
{
dr[pTC_BienLaiThuTien_ChiTietInfo.strTC_BienLaiThuTien_ChiTietID] = pTC_BienLaiThuTien_ChiTietInfo.TC_BienLaiThuTien_ChiTietID;
dr[pTC_BienLaiThuTien_ChiTietInfo.strIDTC_BienLaiThuTien] = pTC_BienLaiThuTien_ChiTietInfo.IDTC_BienLaiThuTien;
dr[pTC_BienLaiThuTien_ChiTietInfo.strIDTC_LoaiThuChi] = pTC_BienLaiThuTien_ChiTietInfo.IDTC_LoaiThuChi;
dr[pTC_BienLaiThuTien_ChiTietInfo.strIDTC_DinhMucThuSinhVien] = pTC_BienLaiThuTien_ChiTietInfo.IDTC_DinhMucThuSinhVien;
dr[pTC_BienLaiThuTien_ChiTietInfo.strLanThu] = pTC_BienLaiThuTien_ChiTietInfo.LanThu;
dr[pTC_BienLaiThuTien_ChiTietInfo.strNoiDung] = pTC_BienLaiThuTien_ChiTietInfo.NoiDung;
dr[pTC_BienLaiThuTien_ChiTietInfo.strSoTien] = pTC_BienLaiThuTien_ChiTietInfo.SoTien;
}
public dlgBienLaiThuTienNhapHoc(DataRow mdr, bool mSua)
{
InitializeComponent();
oBSV_SinhVienNhapTruong = new cBSV_SinhVienNhapTruong();
pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo();
oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien();
pTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo();
oBTC_BienLaiThuTien_ChiTiet = new cBTC_BienLaiThuTien_ChiTiet();
oBTC_DinhMucThuSinhVien = new cBTC_DinhMucThuSinhVien();
pSV_SinhVienNhapTruongInfo = new SV_SinhVienNhapTruongInfo();
dtpNgay.EditValue = DateTime.Now;
Sua = mSua;
dr = mdr;
}
public void Update(TC_BienLaiThuTien_ChiTietInfo pTC_BienLaiThuTien_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDTC_BienLaiThuTien", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.IDTC_BienLaiThuTien));
colParam.Add(CreateParam("@IDTC_LoaiThuChi", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.IDTC_LoaiThuChi));
colParam.Add(CreateParam("@IDTC_DinhMucThuSinhVien", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.IDTC_DinhMucThuSinhVien));
colParam.Add(CreateParam("@LanThu", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.LanThu));
colParam.Add(CreateParam("@NoiDung", SqlDbType.NVarChar, pTC_BienLaiThuTien_ChiTietInfo.NoiDung));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_BienLaiThuTien_ChiTietInfo.SoTien));
colParam.Add(CreateParam("@TC_BienLaiThuTien_ChiTietID", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.TC_BienLaiThuTien_ChiTietID));
RunProcedure("sp_TC_BienLaiThuTien_ChiTiet_Update", colParam);
}
public int Add(TC_BienLaiThuTien_ChiTietInfo pTC_BienLaiThuTien_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDTC_BienLaiThuTien", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.IDTC_BienLaiThuTien));
colParam.Add(CreateParam("@IDTC_LoaiThuChi", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.IDTC_LoaiThuChi));
colParam.Add(CreateParam("@IDTC_DinhMucThuSinhVien", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.IDTC_DinhMucThuSinhVien));
colParam.Add(CreateParam("@LanThu", SqlDbType.Int, pTC_BienLaiThuTien_ChiTietInfo.LanThu));
colParam.Add(CreateParam("@NoiDung", SqlDbType.NVarChar, pTC_BienLaiThuTien_ChiTietInfo.NoiDung));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_BienLaiThuTien_ChiTietInfo.SoTien));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_BienLaiThuTien_ChiTiet_Add", colParam));
}
public dlgBienLaiThuTienChiTiet(int _IDTC_BienLaiThuTien, bool mSua, string _MaSinhVien)
{
InitializeComponent();
oBSV_SinhVien = new cBSV_SinhVien();
pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo();
oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien();
pTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo();
oBTC_BienLaiThuTien_ChiTiet = new cBTC_BienLaiThuTien_ChiTiet();
oBTC_DinhMucThuSinhVien = new cBTC_DinhMucThuSinhVien();
pSV_SinhVienInfo = new SV_SinhVienInfo();
dtpNgay.EditValue = DateTime.Now;
Sua = mSua;
IDTC_BienLaiThuTien = _IDTC_BienLaiThuTien;
MaSinhVien = _MaSinhVien;
chkInKhiLuu.Checked = Properties.Settings.Default.TC_InKhiLuu;
}
private void LapBienLaiThuTien(DataTable dtDinhMuc, int IDSV_SinhVien)
{
// Them bien lai thu tien
pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo();
pTC_BienLaiThuTienInfo.GhiChu = "";
pTC_BienLaiThuTienInfo.HocKy = Program.HocKy;
pTC_BienLaiThuTienInfo.IDDM_NamHoc = Program.IDNamHoc;
pTC_BienLaiThuTienInfo.IDHT_NguoiThu = Program.objUserCurrent.HT_UserID;
pTC_BienLaiThuTienInfo.IDSV_SinhVien = IDSV_SinhVien;
pTC_BienLaiThuTienInfo.IDDM_Lop = pDM_LopInfo.DM_LopID;
pTC_BienLaiThuTienInfo.NgayThu = DateTime.Now;
pTC_BienLaiThuTienInfo.NoiDung = "THU TIỀN HỌC KỲ " + Program.HocKy.ToString() + " NĂM HỌC " + Program.NamHoc;
pTC_BienLaiThuTienInfo.PhieuThu = true;
pTC_BienLaiThuTienInfo.Printed = false;
pTC_BienLaiThuTienInfo.SoPhieu = GetSoPhieu(Program.HocKy, Program.IDNamHoc, IDSV_SinhVien, pDM_LopInfo.IDDM_DiaDiem);
//dtDinhMuc.Columns[3].
pTC_BienLaiThuTienInfo.SoTien = SumColumnValue(dtDinhMuc, "SoTien");
pTC_BienLaiThuTienInfo.SoTienBangChu = clsStrHelper.ReadMoney(pTC_BienLaiThuTienInfo.SoTien) + " đồng";
pTC_BienLaiThuTienInfo.PhieuHuy = false;
pTC_BienLaiThuTienInfo.NgayHuy = DateTime.Parse("1/1/1900");
int intTC_BienLaiThuTienID = oBTC_BienLaiThuTien.Add(pTC_BienLaiThuTienInfo);
// them bien lai thu tien chi tiet
foreach (DataRow mdr in dtDinhMuc.Rows)
{
if (float.Parse("0" + mdr["SoTien"].ToString()) > 0 && mdr["TC_LoaiThuChiID"].ToString() != "")
{
pTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo();
pTC_BienLaiThuTien_ChiTietInfo.IDTC_BienLaiThuTien = intTC_BienLaiThuTienID;
pTC_BienLaiThuTien_ChiTietInfo.IDTC_DinhMucThuSinhVien = int.Parse("0" + mdr["IDTC_DinhMucThuSinhVien"].ToString());
pTC_BienLaiThuTien_ChiTietInfo.IDTC_LoaiThuChi = int.Parse(mdr["TC_LoaiThuChiID"].ToString());
pTC_BienLaiThuTien_ChiTietInfo.LanThu = int.Parse("0" + mdr["LanThu"].ToString());
pTC_BienLaiThuTien_ChiTietInfo.NoiDung = mdr["NoiDung"].ToString();
pTC_BienLaiThuTien_ChiTietInfo.SoTien = float.Parse("0" + mdr["SoTien"].ToString());
oBTC_BienLaiThuTien_ChiTiet.Add(pTC_BienLaiThuTien_ChiTietInfo);
}
}
}
public List <TC_BienLaiThuTien_ChiTietInfo> GetList(TC_BienLaiThuTien_ChiTietInfo pTC_BienLaiThuTien_ChiTietInfo)
{
List <TC_BienLaiThuTien_ChiTietInfo> oTC_BienLaiThuTien_ChiTietInfoList = new List <TC_BienLaiThuTien_ChiTietInfo>();
DataTable dtb = Get(pTC_BienLaiThuTien_ChiTietInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo();
oTC_BienLaiThuTien_ChiTietInfo.TC_BienLaiThuTien_ChiTietID = int.Parse(dtb.Rows[i]["TC_BienLaiThuTien_ChiTietID"].ToString());
oTC_BienLaiThuTien_ChiTietInfo.IDTC_BienLaiThuTien = int.Parse(dtb.Rows[i]["IDTC_BienLaiThuTien"].ToString());
oTC_BienLaiThuTien_ChiTietInfo.IDTC_LoaiThuChi = int.Parse(dtb.Rows[i]["IDTC_LoaiThuChi"].ToString());
oTC_BienLaiThuTien_ChiTietInfo.IDTC_DinhMucThuSinhVien = int.Parse(dtb.Rows[i]["IDTC_DinhMucThuSinhVien"].ToString());
oTC_BienLaiThuTien_ChiTietInfo.LanThu = int.Parse(dtb.Rows[i]["LanThu"].ToString());
oTC_BienLaiThuTien_ChiTietInfo.NoiDung = dtb.Rows[i]["NoiDung"].ToString();
oTC_BienLaiThuTien_ChiTietInfo.SoTien = double.Parse(dtb.Rows[i]["SoTien"].ToString());
oTC_BienLaiThuTien_ChiTietInfoList.Add(oTC_BienLaiThuTien_ChiTietInfo);
}
}
return(oTC_BienLaiThuTien_ChiTietInfoList);
}
public void Delete(TC_BienLaiThuTien_ChiTietInfo pTC_BienLaiThuTien_ChiTietInfo)
{
oDTC_BienLaiThuTien_ChiTiet.Delete(pTC_BienLaiThuTien_ChiTietInfo);
mErrorMessage = oDTC_BienLaiThuTien_ChiTiet.ErrorMessages;
mErrorNumber = oDTC_BienLaiThuTien_ChiTiet.ErrorNumber;
}
public DataTable Get(TC_BienLaiThuTien_ChiTietInfo pTC_BienLaiThuTien_ChiTietInfo)
{
return(oDTC_BienLaiThuTien_ChiTiet.Get(pTC_BienLaiThuTien_ChiTietInfo));
}
