public PXN_Header PXN_Header_GetMasterDetailData(DataRow PXN_Header_Row, DataTable KHMau_LAB_dt)
{
PXN_Header _pXN_Header = new PXN_Header();
//MessageBox.Show("SoPXN : " + PXN_Header_Row["SoPXN"].ToString());
_pXN_Header.ID = int.Parse(PXN_Header_Row["ID"].ToString());
_pXN_Header.SoPXN = PXN_Header_Row["SoPXN"].ToString();
_pXN_Header.PXNDescription = PXN_Header_Row["PXNDescription"].ToString();
_pXN_Header.CoSoGuiMau = PXN_Header_Row["CoSoGuiMau"].ToString();
_pXN_Header.MaCoSoGuiMau = PXN_Header_Row["MaCoSoGuiMau"].ToString();
_pXN_Header.TenCoSoGuiMau = PXN_Header_Row["TenCoSoGuiMau"].ToString();
_pXN_Header.DCCoSoGuiMau = PXN_Header_Row["DCCoSoGuiMau"].ToString();
_pXN_Header.PhoneCoSoGuiMau = PXN_Header_Row["PhoneCoSoGuiMau"].ToString();
_pXN_Header.FaxCoSoGuiMau = PXN_Header_Row["FaxCoSoGuiMau"].ToString();
_pXN_Header.EmailCoSoGuiMau = PXN_Header_Row["EmailCoSoGuiMau"].ToString();
_pXN_Header.MSTCoSoGuiMau = PXN_Header_Row["MSTCoSoGuiMau"].ToString();
_pXN_Header.CoSoLayMau = PXN_Header_Row["CoSoLayMau"].ToString();
_pXN_Header.MaCoSoLayMau = PXN_Header_Row["MaCoSoLayMau"].ToString();
_pXN_Header.TenCoSoLayMau = PXN_Header_Row["TenCoSoLayMau"].ToString();
_pXN_Header.DCCoSoLayMau = PXN_Header_Row["DCCoSoLayMau"].ToString();
_pXN_Header.PhoneCoSoLayMau = PXN_Header_Row["PhoneCoSoLayMau"].ToString();
_pXN_Header.FaxCoSoLayMau = PXN_Header_Row["FaxCoSoLayMau"].ToString();
_pXN_Header.EmailCoSoLayMau = PXN_Header_Row["EmailCoSoLayMau"].ToString();
_pXN_Header.CreatedDate = DateTime.Parse(PXN_Header_Row["CreatedDate"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
_pXN_Header.CreatedBy = PXN_Header_Row["CreatedBy"].ToString();
_pXN_Header.Note = PXN_Header_Row["Note"].ToString();
_pXN_Header.Locked = PXN_Header_Row["Locked"].ToString() == "True" ? true : false;
if (_pXN_Header.NgayNhanMau == DateTime.MinValue)
{
_pXN_Header.NgayNhanMau = DateTime.Parse("2019-01-01");
}
else
{
DateTime.Parse(PXN_Header_Row["NgayNhanMau"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
}
//_pXN_Header.NgayDuKienTra = DateTime.MinValue ? DateTime.Parse("2019-01-01") : DateTime.Parse(PXN_Header_Row["NgayDuKienTra"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
// _pXN_Header.NgayCoKetQua = DateTime.MinValue ? DateTime.Parse("2019-01-01") : DateTime.Parse(PXN_Header_Row["NgayCoKetQua"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
// _pXN_Header.NgayTraKetQua = DateTime.MinValue ? DateTime.Parse("2019-01-01") : DateTime.Parse(PXN_Header_Row["NgayTraKetQua"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
_pXN_Header.KHMau = PXN_Header_Row["KHMau"].ToString();
//_pXN_Header.Khac = PXN_Header_Row["Khac"].ToString();
_pXN_Header.PTNThucHien = PXN_Header_Row["PTNThucHien"].ToString() == "True" ? true : false;
_pXN_Header.LoaiXN = PXN_Header_Row["LoaiXN"].ToString();
_pXN_Header.NgonNgu = PXN_Header_Row["NgonNgu"].ToString();
_pXN_Header.SendMail = PXN_Header_Row["SendMail"].ToString();
_pXN_Header.DichTeDan = PXN_Header_Row["DichTeDan"].ToString() == "True" ? true : false;
if (PXN_Header_Row["CUSTCODE_ID"].ToString() == string.Empty)
{
_pXN_Header.CUSTCODE_ID = 0;
}
else
{
_pXN_Header.CUSTCODE_ID = int.Parse(PXN_Header_Row["CUSTCODE_ID"].ToString());
}
if (PXN_Header_Row["EMPCode_ID"].ToString() == string.Empty)
{
_pXN_Header.EMPCode_ID = 0;
}
else
{
_pXN_Header.EMPCode_ID = int.Parse(PXN_Header_Row["EMPCode_ID"].ToString());
}
_pXN_Header.DaXuatHoaDon = PXN_Header_Row["DaXuatHoaDon"].ToString() == "True" ? true : false;
if (string.IsNullOrEmpty(PXN_Header_Row["NgayXuatHoaDon"].ToString()))
{
_pXN_Header.NgayXuatHoaDon = DateTime.Parse("2019-01-01");
}
else
{
_pXN_Header.NgayXuatHoaDon = DateTime.Parse(PXN_Header_Row["NgayXuatHoaDon"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
}
_pXN_Header.SoHoaDon = PXN_Header_Row["SoHoaDon"].ToString();
_pXN_Header.DaThuTien = PXN_Header_Row["DaThuTien"].ToString() == "True" ? true : false;
if (string.IsNullOrEmpty(PXN_Header_Row["NgayThuTien"].ToString()))
{
_pXN_Header.NgayThuTien = DateTime.Parse("2019-01-01");
}
else
{
_pXN_Header.NgayThuTien = DateTime.Parse(PXN_Header_Row["NgayThuTien"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
}
if (PXN_Header_Row["SoTienHoaDon"].ToString() == string.Empty)
{
_pXN_Header.SoTienHoaDon = 0;
}
else
{
_pXN_Header.SoTienHoaDon = float.Parse(PXN_Header_Row["SoTienHoaDon"].ToString());
}
_pXN_Header.TraTruoc = PXN_Header_Row["TraTruoc"].ToString() == "True" ? true : false;
if (string.IsNullOrEmpty(PXN_Header_Row["NgayTraTruoc"].ToString()))
{
_pXN_Header.NgayTraTruoc = DateTime.Parse("2019-01-01");
}
else
{
_pXN_Header.NgayTraTruoc = DateTime.Parse(PXN_Header_Row["NgayTraTruoc"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
}
if (PXN_Header_Row["SoTienTraTruoc"].ToString() == string.Empty)
{
_pXN_Header.SoTienTraTruoc = 0;
}
else
{
_pXN_Header.SoTienTraTruoc = float.Parse(PXN_Header_Row["SoTienTraTruoc"].ToString());
}
if (PXN_Header_Row["SoTienDaThu"].ToString() == string.Empty)
{
_pXN_Header.SoTienDaThu = 0;
}
else
{
_pXN_Header.SoTienDaThu = float.Parse(PXN_Header_Row["SoTienDaThu"].ToString());
}
_pXN_Header.NoiDungHoaDon = PXN_Header_Row["NoiDungHoaDon"].ToString();
_pXN_Header.NoiDungTraTruoc = PXN_Header_Row["NoiDungTraTruoc"].ToString();
if (string.IsNullOrEmpty(PXN_Header_Row["DonViXuatHoaDon_ID"].ToString()))
{
_pXN_Header.DonViXuatHoaDon_ID = 0;
}
else
{
_pXN_Header.DonViXuatHoaDon_ID = int.Parse(PXN_Header_Row["DonViXuatHoaDon_ID"].ToString());
}
//_pXN_Header.NgayGiaoMau = DateTime.Parse(PXN_Header_Row["NgayGiaoMau"].ToString(), CultureInfo.CreateSpecificCulture("en-GB"));
_pXN_Header.NguoiGiaoMau = PXN_Header_Row["NguoiGiaoMau"].ToString();
_pXN_Header.GiaoMau = PXN_Header_Row["GiaoMau"].ToString() == "True" ? true : false;
List <KHMau_LAB> List_KHMau_LAB = new List <KHMau_LAB>();
foreach (DataRow KHMau_LAB_Row in KHMau_LAB_dt.Rows)
{
//MessageBox.Show("KHMau : " + KHMau_LAB_Row["KHMau"].ToString());
List_KHMau_LAB.Add
(
new KHMau_LAB()
{
//ID = int.Parse(KHMau_LAB_Row["ID"].ToString()),
//SoPXN = KHMau_LAB_Row["SoPXN"].ToString(),
KHMau = KHMau_LAB_Row["KHMau"].ToString(),
//KHMau_GiaoMau = KHMau_LAB_Row["KHMau_GiaoMau"].ToString(),
//KHMau_KhachHang = KHMau_LAB_Row["KHMau_KhachHang"].ToString(),
SoLuongKHMau = KHMau_LAB_Row["SoLuongKHMau"].ToString(),
DonViKHMau = KHMau_LAB_Row["DonViKHMau"].ToString(),
//PhuongPhapBaoQuan = KHMau_LAB_Row["PhuongPhapBaoQuan"].ToString(),
//VitriLuuKHMau = KHMau_LAB_Row["VitriLuuKHMau"].ToString(),
//NgayLuuKHMau = DateTime.Parse(KHMau_LAB_Row["NgayLuuKHMau"].ToString(), CultureInfo.CreateSpecificCulture("en-GB")),
//NhanVienLuuKHMau = KHMau_LAB_Row["NhanVienLuuKHMau"].ToString(),
//NgayHuyKHMau = DateTime.Parse(KHMau_LAB_Row["NgayHuyKHMau"].ToString(), CultureInfo.CreateSpecificCulture("en-GB")),
//TaiLieuHuyKHMau = KHMau_LAB_Row["TaiLieuHuyKHMau"].ToString(),
//NhanVienHuyKHMau = KHMau_LAB_Row["NhanVienHuyKHMau"].ToString(),
//TrangThaiKHMau = KHMau_LAB_Row["TrangThaiKHMau"].ToString() == "True" ? true : false,
//SoLuongHuyKHMau = KHMau_LAB_Row["SoLuongHuyKHMau"].ToString(),
//CreatedDate = DateTime.Parse(KHMau_LAB_Row["CreatedDate"].ToString(), CultureInfo.CreateSpecificCulture("en-GB")),
//CreatedBy = KHMau_LAB_Row["CreatedBy"].ToString(),
//Note = KHMau_LAB_Row["Note"].ToString(),
//Locked = KHMau_LAB_Row["Locked"].ToString() == "True" ? true : false,
NgayLayMau = DateTime.Parse(KHMau_LAB_Row["NgayLayMau"].ToString(), CultureInfo.CreateSpecificCulture("en-GB")),
LoaiDVMauNuoc = KHMau_LAB_Row["LoaiDVMauNuoc"].ToString(),
LoaiMauGui = KHMau_LAB_Row["LoaiMauGui"].ToString(),
TTMauGui = KHMau_LAB_Row["TTMauGui"].ToString(),
VTLayMauDayChuong = KHMau_LAB_Row["VTLayMauDayChuong"].ToString(),
GioLayMauTuoi = KHMau_LAB_Row["GioLayMauTuoi"].ToString(),
Khac = KHMau_LAB_Row["Khac"].ToString(),
SoLuongKHMauKhongDat = KHMau_LAB_Row["SoLuongKHMauKhongDat"].ToString(),
LiDoKHMauKhongDat = KHMau_LAB_Row["LiDoKHMauKhongDat"].ToString(),
MotaMau = KHMau_LAB_Row["MotaMau"].ToString(),
//BanGiaoMauStatus = KHMau_LAB_Row["BanGiaoMauStatus"].ToString() == "True" ? true : false,
//NguoiNhanBanGiaoMau = KHMau_LAB_Row["NguoiNhanBanGiaoMau"].ToString(),
//NguoiGiaoBanGiaoMau = KHMau_LAB_Row["NguoiGiaoBanGiaoMau"].ToString(),
//NgayBanGiaoMau = DateTime.Parse(KHMau_LAB_Row["NgayBanGiaoMau"].ToString(), CultureInfo.CreateSpecificCulture("en-GB")),
//LuuMau = KHMau_LAB_Row["LuuMau"].ToString() == "True" ? true : false,
//HuyMau = KHMau_LAB_Row["HuyMau"].ToString() == "True" ? true : false
}
);
}
_pXN_Header.KHMau_LABs = List_KHMau_LAB;
return(_pXN_Header);
}
public void PXN_HeaderBUS_DELETE(PXN_Header OBJ)
{
DAO.PXN_HeaderDAO_DELETE(OBJ);
}
public void PXN_HeaderBUS_INSERT(PXN_Header OBJ)
{
DAO.PXN_HeaderDAO_INSERT(OBJ);
}
public void PXN_HeaderBUS_UPDATE(PXN_Header OBJ)
{
DAO.PXN_HeaderDAO_UPDATE(OBJ);
}
