示例#1
0
 public void ToDataRow(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo, ref DataRow dr)
 {
     dr[pTC_DanhSachTroCap_ChiTietInfo.strTC_DanhSachTroCap_ChiTietID] = pTC_DanhSachTroCap_ChiTietInfo.TC_DanhSachTroCap_ChiTietID;
     dr[pTC_DanhSachTroCap_ChiTietInfo.strIDTC_DanhSachTroCap]         = pTC_DanhSachTroCap_ChiTietInfo.IDTC_DanhSachTroCap;
     dr[pTC_DanhSachTroCap_ChiTietInfo.strThang]  = pTC_DanhSachTroCap_ChiTietInfo.Thang;
     dr[pTC_DanhSachTroCap_ChiTietInfo.strSoTien] = pTC_DanhSachTroCap_ChiTietInfo.SoTien;
 }
示例#2
0
 public void ToInfo(ref TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo, DataRow dr)
 {
     pTC_DanhSachTroCap_ChiTietInfo.TC_DanhSachTroCap_ChiTietID = int.Parse(dr[pTC_DanhSachTroCap_ChiTietInfo.strTC_DanhSachTroCap_ChiTietID].ToString());
     pTC_DanhSachTroCap_ChiTietInfo.IDTC_DanhSachTroCap         = int.Parse(dr[pTC_DanhSachTroCap_ChiTietInfo.strIDTC_DanhSachTroCap].ToString());
     pTC_DanhSachTroCap_ChiTietInfo.Thang  = int.Parse(dr[pTC_DanhSachTroCap_ChiTietInfo.strThang].ToString());
     pTC_DanhSachTroCap_ChiTietInfo.SoTien = float.Parse(dr[pTC_DanhSachTroCap_ChiTietInfo.strSoTien].ToString());
 }
示例#3
0
        public void Delete(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@TC_DanhSachTroCap_ChiTietID", SqlDbType.Int, pTC_DanhSachTroCap_ChiTietInfo.TC_DanhSachTroCap_ChiTietID));

            RunProcedure("sp_TC_DanhSachTroCap_ChiTiet_Delete", colParam);
        }
示例#4
0
        public DataTable Get(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@TC_DanhSachTroCap_ChiTietID", SqlDbType.Int, pTC_DanhSachTroCap_ChiTietInfo.TC_DanhSachTroCap_ChiTietID));

            return(RunProcedureGet("sp_TC_DanhSachTroCap_ChiTiet_Get", colParam));
        }
示例#5
0
        public int Add(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo)
        {
            int ID = 0;

            ID            = oDTC_DanhSachTroCap_ChiTiet.Add(pTC_DanhSachTroCap_ChiTietInfo);
            mErrorMessage = oDTC_DanhSachTroCap_ChiTiet.ErrorMessages;
            mErrorNumber  = oDTC_DanhSachTroCap_ChiTiet.ErrorNumber;
            return(ID);
        }
示例#6
0
 public frmDanhSachTroCap()
 {
     InitializeComponent();
     oBDM_Lop = new cBDM_Lop();
     pDM_DoiTuongTroCapInfo         = new DM_DoiTuongTroCapInfo();
     oBDM_DoiTuongTroCap            = new cBDM_DoiTuongTroCap();
     pTC_DanhSachTroCapInfo         = new TC_DanhSachTroCapInfo();
     oBTC_DanhSachTroCap            = new cBTC_DanhSachTroCap();
     pTC_DanhSachTroCap_ChiTietInfo = new TC_DanhSachTroCap_ChiTietInfo();
     oBTC_DanhSachTroCap_ChiTiet    = new cBTC_DanhSachTroCap_ChiTiet();
 }
示例#7
0
        public void Update(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@IDTC_DanhSachTroCap", SqlDbType.Int, pTC_DanhSachTroCap_ChiTietInfo.IDTC_DanhSachTroCap));
            colParam.Add(CreateParam("@Thang", SqlDbType.Int, pTC_DanhSachTroCap_ChiTietInfo.Thang));
            colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_DanhSachTroCap_ChiTietInfo.SoTien));
            colParam.Add(CreateParam("@TC_DanhSachTroCap_ChiTietID", SqlDbType.Int, pTC_DanhSachTroCap_ChiTietInfo.TC_DanhSachTroCap_ChiTietID));

            RunProcedure("sp_TC_DanhSachTroCap_ChiTiet_Update", colParam);
        }
示例#8
0
        public int Add(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@IDTC_DanhSachTroCap", SqlDbType.Int, pTC_DanhSachTroCap_ChiTietInfo.IDTC_DanhSachTroCap));
            colParam.Add(CreateParam("@Thang", SqlDbType.Int, pTC_DanhSachTroCap_ChiTietInfo.Thang));
            colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_DanhSachTroCap_ChiTietInfo.SoTien));
            colParam.Add(CreateParamOut("@ID", SqlDbType.Int));

            return((int)RunProcedureOut("sp_TC_DanhSachTroCap_ChiTiet_Add", colParam));
        }
示例#9
0
        public List <TC_DanhSachTroCap_ChiTietInfo> GetList(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo)
        {
            List <TC_DanhSachTroCap_ChiTietInfo> oTC_DanhSachTroCap_ChiTietInfoList = new List <TC_DanhSachTroCap_ChiTietInfo>();
            DataTable dtb = Get(pTC_DanhSachTroCap_ChiTietInfo);

            if (dtb != null)
            {
                for (int i = 0; i < dtb.Rows.Count; i++)
                {
                    oTC_DanhSachTroCap_ChiTietInfo = new TC_DanhSachTroCap_ChiTietInfo();

                    oTC_DanhSachTroCap_ChiTietInfo.TC_DanhSachTroCap_ChiTietID = int.Parse(dtb.Rows[i]["TC_DanhSachTroCap_ChiTietID"].ToString());
                    oTC_DanhSachTroCap_ChiTietInfo.IDTC_DanhSachTroCap         = int.Parse(dtb.Rows[i]["IDTC_DanhSachTroCap"].ToString());
                    oTC_DanhSachTroCap_ChiTietInfo.Thang  = int.Parse(dtb.Rows[i]["Thang"].ToString());
                    oTC_DanhSachTroCap_ChiTietInfo.SoTien = float.Parse(dtb.Rows[i]["SoTien"].ToString());

                    oTC_DanhSachTroCap_ChiTietInfoList.Add(oTC_DanhSachTroCap_ChiTietInfo);
                }
            }
            return(oTC_DanhSachTroCap_ChiTietInfoList);
        }
示例#10
0
 public void Delete(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo)
 {
     oDTC_DanhSachTroCap_ChiTiet.Delete(pTC_DanhSachTroCap_ChiTietInfo);
     mErrorMessage = oDTC_DanhSachTroCap_ChiTiet.ErrorMessages;
     mErrorNumber  = oDTC_DanhSachTroCap_ChiTiet.ErrorNumber;
 }
示例#11
0
 public DataTable Get(TC_DanhSachTroCap_ChiTietInfo pTC_DanhSachTroCap_ChiTietInfo)
 {
     return(oDTC_DanhSachTroCap_ChiTiet.Get(pTC_DanhSachTroCap_ChiTietInfo));
 }