public void ToInfo(ref TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo, DataRow dr)
{
pTC_DanhSachMienGiam_ChiTietInfo.TC_DanhSachMienGiam_ChiTietID = int.Parse(dr[pTC_DanhSachMienGiam_ChiTietInfo.strTC_DanhSachMienGiam_ChiTietID].ToString());
pTC_DanhSachMienGiam_ChiTietInfo.IDTC_DanhSachMienGiam = int.Parse(dr[pTC_DanhSachMienGiam_ChiTietInfo.strIDTC_DanhSachMienGiam].ToString());
pTC_DanhSachMienGiam_ChiTietInfo.Thang = int.Parse(dr[pTC_DanhSachMienGiam_ChiTietInfo.strThang].ToString());
pTC_DanhSachMienGiam_ChiTietInfo.SoTien = float.Parse(dr[pTC_DanhSachMienGiam_ChiTietInfo.strSoTien].ToString());
}
public void ToDataRow(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo, ref DataRow dr)
{
dr[pTC_DanhSachMienGiam_ChiTietInfo.strTC_DanhSachMienGiam_ChiTietID] = pTC_DanhSachMienGiam_ChiTietInfo.TC_DanhSachMienGiam_ChiTietID;
dr[pTC_DanhSachMienGiam_ChiTietInfo.strIDTC_DanhSachMienGiam] = pTC_DanhSachMienGiam_ChiTietInfo.IDTC_DanhSachMienGiam;
dr[pTC_DanhSachMienGiam_ChiTietInfo.strThang] = pTC_DanhSachMienGiam_ChiTietInfo.Thang;
dr[pTC_DanhSachMienGiam_ChiTietInfo.strSoTien] = pTC_DanhSachMienGiam_ChiTietInfo.SoTien;
}
public void Delete(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DanhSachMienGiam_ChiTietID", SqlDbType.Int, pTC_DanhSachMienGiam_ChiTietInfo.TC_DanhSachMienGiam_ChiTietID));
RunProcedure("sp_TC_DanhSachMienGiam_ChiTiet_Delete", colParam);
}
public DataTable Get(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DanhSachMienGiam_ChiTietID", SqlDbType.Int, pTC_DanhSachMienGiam_ChiTietInfo.TC_DanhSachMienGiam_ChiTietID));
return(RunProcedureGet("sp_TC_DanhSachMienGiam_ChiTiet_Get", colParam));
}
public int Add(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo)
{
int ID = 0;
ID = oDTC_DanhSachMienGiam_ChiTiet.Add(pTC_DanhSachMienGiam_ChiTietInfo);
mErrorMessage = oDTC_DanhSachMienGiam_ChiTiet.ErrorMessages;
mErrorNumber = oDTC_DanhSachMienGiam_ChiTiet.ErrorNumber;
return(ID);
}
public void Update(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDTC_DanhSachMienGiam", SqlDbType.Int, pTC_DanhSachMienGiam_ChiTietInfo.IDTC_DanhSachMienGiam));
colParam.Add(CreateParam("@Thang", SqlDbType.Int, pTC_DanhSachMienGiam_ChiTietInfo.Thang));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_DanhSachMienGiam_ChiTietInfo.SoTien));
colParam.Add(CreateParam("@TC_DanhSachMienGiam_ChiTietID", SqlDbType.Int, pTC_DanhSachMienGiam_ChiTietInfo.TC_DanhSachMienGiam_ChiTietID));
RunProcedure("sp_TC_DanhSachMienGiam_ChiTiet_Update", colParam);
}
public int Add(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDTC_DanhSachMienGiam", SqlDbType.Int, pTC_DanhSachMienGiam_ChiTietInfo.IDTC_DanhSachMienGiam));
colParam.Add(CreateParam("@Thang", SqlDbType.Int, pTC_DanhSachMienGiam_ChiTietInfo.Thang));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_DanhSachMienGiam_ChiTietInfo.SoTien));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_DanhSachMienGiam_ChiTiet_Add", colParam));
}
public frmDanhSachMienGiam()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_DoiTuongMienGiamInfo = new DM_DoiTuongMienGiamInfo();
oBDM_DoiTuongMienGiam = new cBDM_DoiTuongMienGiam();
pTC_DanhSachMienGiamInfo = new TC_DanhSachMienGiamInfo();
oBTC_DanhSachMienGiam = new cBTC_DanhSachMienGiam();
pTC_LoaiThuChiInfo = new TC_LoaiThuChiInfo();
oBTC_LoaiThuChi = new cBTC_LoaiThuChi();
oBTC_DanhSachMienGiam_ChiTiet = new cBTC_DanhSachMienGiam_ChiTiet();
pTC_DanhSachMienGiam_ChiTietInfo = new TC_DanhSachMienGiam_ChiTietInfo();
}
public List <TC_DanhSachMienGiam_ChiTietInfo> GetList(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo)
{
List <TC_DanhSachMienGiam_ChiTietInfo> oTC_DanhSachMienGiam_ChiTietInfoList = new List <TC_DanhSachMienGiam_ChiTietInfo>();
DataTable dtb = Get(pTC_DanhSachMienGiam_ChiTietInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_DanhSachMienGiam_ChiTietInfo = new TC_DanhSachMienGiam_ChiTietInfo();
oTC_DanhSachMienGiam_ChiTietInfo.TC_DanhSachMienGiam_ChiTietID = int.Parse(dtb.Rows[i]["TC_DanhSachMienGiam_ChiTietID"].ToString());
oTC_DanhSachMienGiam_ChiTietInfo.IDTC_DanhSachMienGiam = int.Parse(dtb.Rows[i]["IDTC_DanhSachMienGiam"].ToString());
oTC_DanhSachMienGiam_ChiTietInfo.Thang = int.Parse(dtb.Rows[i]["Thang"].ToString());
oTC_DanhSachMienGiam_ChiTietInfo.SoTien = float.Parse(dtb.Rows[i]["SoTien"].ToString());
oTC_DanhSachMienGiam_ChiTietInfoList.Add(oTC_DanhSachMienGiam_ChiTietInfo);
}
}
return(oTC_DanhSachMienGiam_ChiTietInfoList);
}
public void Delete(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo)
{
oDTC_DanhSachMienGiam_ChiTiet.Delete(pTC_DanhSachMienGiam_ChiTietInfo);
mErrorMessage = oDTC_DanhSachMienGiam_ChiTiet.ErrorMessages;
mErrorNumber = oDTC_DanhSachMienGiam_ChiTiet.ErrorNumber;
}
public DataTable Get(TC_DanhSachMienGiam_ChiTietInfo pTC_DanhSachMienGiam_ChiTietInfo)
{
return(oDTC_DanhSachMienGiam_ChiTiet.Get(pTC_DanhSachMienGiam_ChiTietInfo));
}
