Exemplo n.º 1
0
        public static XuatNhap SelectByDraff(SqlConnection con)
        {
            var Item = new XuatNhap();

            using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblXuatNhapChiTiet_Select_SelectDraff_linhnx"))
            {
                while (rd.Read())
                {
                    Item = getFromReader(rd);
                }
            }
            return(Item);
        }
Exemplo n.º 2
0
        public static XuatNhap SelectTvDv(Guid TVDV_ID)
        {
            var Item = new XuatNhap();
            var obj  = new SqlParameter[1];

            obj[0] = new SqlParameter("TVDV_ID", TVDV_ID);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblXuatNhap_Select_SelectByTvDvId_linhnx", obj))
            {
                while (rd.Read())
                {
                    Item = getFromReader(rd);
                }
            }
            return(Item);
        }
Exemplo n.º 3
0
        public static XuatNhap SelectByDraff(bool xuat)
        {
            var Item = new XuatNhap();
            var obj  = new SqlParameter[3];

            obj[0] = new SqlParameter("Xuat", xuat);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblXuatNhapChiTiet_Select_SelectDraff_linhnx", obj))
            {
                while (rd.Read())
                {
                    Item = getFromReader(rd);
                }
            }
            return(Item);
        }
Exemplo n.º 4
0
        public static XuatNhap getFromReader(IDataReader rd)
        {
            var Item = new XuatNhap();

            if (rd.FieldExists("XN_ID"))
            {
                Item.ID = (Guid)(rd["XN_ID"]);
            }
            if (rd.FieldExists("XN_GH_ID"))
            {
                Item.GH_ID = (Guid)(rd["XN_GH_ID"]);
            }
            if (rd.FieldExists("XN_LOAI_ID"))
            {
                Item.LOAI_ID = (Guid)(rd["XN_LOAI_ID"]);
            }
            if (rd.FieldExists("XN_Ma"))
            {
                Item.Ma = (String)(rd["XN_Ma"]);
            }
            if (rd.FieldExists("XN_KH_ID"))
            {
                Item.KH_ID = (Guid)(rd["XN_KH_ID"]);
            }
            if (rd.FieldExists("XN_NgayHoaDon"))
            {
                Item.NgayHoaDon = (DateTime)(rd["XN_NgayHoaDon"]);
            }
            if (rd.FieldExists("XN_NhanVien"))
            {
                Item.NhanVien = (String)(rd["XN_NhanVien"]);
            }
            if (rd.FieldExists("XN_CongTienHang"))
            {
                Item.CongTienHang = (Double)(rd["XN_CongTienHang"]);
            }
            if (rd.FieldExists("XN_DienGiai"))
            {
                Item.DienGiai = (String)(rd["XN_DienGiai"]);
            }
            if (rd.FieldExists("XN_VAT"))
            {
                Item.VAT = (Double)(rd["XN_VAT"]);
            }
            if (rd.FieldExists("XN_ThanhToan"))
            {
                Item.ThanhToan = (Double)(rd["XN_ThanhToan"]);
            }
            if (rd.FieldExists("XN_ConNo"))
            {
                Item.ConNo = (Double)(rd["XN_ConNo"]);
            }
            if (rd.FieldExists("XN_ChietKhau"))
            {
                Item.ChietKhau = (Double)(rd["XN_ChietKhau"]);
            }
            if (rd.FieldExists("XN_NgayTao"))
            {
                Item.NgayTao = (DateTime)(rd["XN_NgayTao"]);
            }
            if (rd.FieldExists("XN_NguoiTao"))
            {
                Item.NguoiTao = (String)(rd["XN_NguoiTao"]);
            }
            if (rd.FieldExists("XN_NgayCapNhat"))
            {
                Item.NgayCapNhat = (DateTime)(rd["XN_NgayCapNhat"]);
            }
            if (rd.FieldExists("XN_NguoiCapNhat"))
            {
                Item.NguoiCapNhat = (String)(rd["XN_NguoiCapNhat"]);
            }
            if (rd.FieldExists("XN_GhiChu"))
            {
                Item.GhiChu = (String)(rd["XN_GhiChu"]);
            }
            if (rd.FieldExists("KH_Ten"))
            {
                Item.KH_Ten = (String)(rd["KH_Ten"]);
            }

            if (rd.FieldExists("LOAI_Ten"))
            {
                Item.LOAI_Ten = (String)(rd["LOAI_Ten"]);
            }
            if (rd.FieldExists("XN_KHO_ID"))
            {
                Item.KHO_ID = (Guid)(rd["XN_KHO_ID"]);
            }
            if (rd.FieldExists("XN_KHO_Ten"))
            {
                Item.KHO_Ten = (String)(rd["XN_KHO_Ten"]);
            }
            if (rd.FieldExists("XN_Xuat"))
            {
                Item.Xuat = (Boolean)(rd["XN_Xuat"]);
            }
            if (rd.FieldExists("XN_TV_ID"))
            {
                Item.TVDV_ID = (Guid)(rd["XN_TVDV_ID"]);
            }
            if (rd.FieldExists("XN_DauKy"))
            {
                Item.DauKy = (Boolean)(rd["XN_DauKy"]);
            }
            if (rd.FieldExists("XN_NoiBo"))
            {
                Item.NoiBo = (Boolean)(rd["XN_NoiBo"]);
            }
            if (rd.FieldExists("XN_ChuyenDoi"))
            {
                Item.ChuyenDoi = (Boolean)(rd["XN_ChuyenDoi"]);
            }
            if (rd.FieldExists("XN_TuVanVien"))
            {
                Item.TuVanVien = (String)(rd["XN_TuVanVien"]);
            }
            Item._ThuChi = ThuChiDal.getFromReader(rd);
            return(Item);
        }
Exemplo n.º 5
0
        public static XuatNhap Update(XuatNhap item)
        {
            var Item = new XuatNhap();
            var obj  = new SqlParameter[25];

            obj[0] = new SqlParameter("XN_ID", item.ID);
            obj[1] = new SqlParameter("XN_GH_ID", item.GH_ID);
            obj[2] = new SqlParameter("XN_LOAI_ID", item.LOAI_ID);
            obj[3] = new SqlParameter("XN_Ma", item.Ma);
            obj[4] = new SqlParameter("XN_KH_ID", item.KH_ID);
            if (item.NgayHoaDon > DateTime.MinValue)
            {
                obj[5] = new SqlParameter("XN_NgayHoaDon", item.NgayHoaDon);
            }
            else
            {
                obj[5] = new SqlParameter("XN_NgayHoaDon", DBNull.Value);
            }
            obj[6]  = new SqlParameter("XN_NhanVien", item.NhanVien);
            obj[7]  = new SqlParameter("XN_CongTienHang", item.CongTienHang);
            obj[8]  = new SqlParameter("XN_DienGiai", item.DienGiai);
            obj[9]  = new SqlParameter("XN_VAT", item.VAT);
            obj[10] = new SqlParameter("XN_ThanhToan", item.ThanhToan);
            obj[11] = new SqlParameter("XN_ConNo", item.ConNo);
            obj[12] = new SqlParameter("XN_ChietKhau", item.ChietKhau);
            if (item.NgayTao > DateTime.MinValue)
            {
                obj[13] = new SqlParameter("XN_NgayTao", item.NgayTao);
            }
            else
            {
                obj[13] = new SqlParameter("XN_NgayTao", DBNull.Value);
            }
            obj[14] = new SqlParameter("XN_NguoiTao", item.NguoiTao);
            if (item.NgayCapNhat > DateTime.MinValue)
            {
                obj[15] = new SqlParameter("XN_NgayCapNhat", item.NgayCapNhat);
            }
            else
            {
                obj[15] = new SqlParameter("XN_NgayCapNhat", DBNull.Value);
            }
            obj[16] = new SqlParameter("XN_NguoiCapNhat", item.NguoiCapNhat);
            obj[17] = new SqlParameter("XN_GhiChu", item.GhiChu);
            obj[18] = new SqlParameter("XN_KHO_ID", item.KHO_ID);
            obj[19] = new SqlParameter("XN_Xuat", item.Xuat);
            obj[20] = new SqlParameter("XN_TVDV_ID", item.TVDV_ID);
            obj[21] = new SqlParameter("XN_DauKy", item.DauKy);
            obj[22] = new SqlParameter("XN_NoiBo", item.NoiBo);
            obj[23] = new SqlParameter("XN_ChuyenDoi", item.ChuyenDoi);
            obj[24] = new SqlParameter("XN_TuVanVien", item.TuVanVien);

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblXuatNhap_Update_UpdateNormal_linhnx", obj))
            {
                while (rd.Read())
                {
                    Item = getFromReader(rd);
                }
            }
            return(Item);
        }