public static XuatNhapChiTiet Update(XuatNhapChiTiet item) { var Item = new XuatNhapChiTiet(); var obj = new SqlParameter[18]; obj[0] = new SqlParameter("XNCT_ID", item.ID); obj[1] = new SqlParameter("XNCT_XN_ID", item.XN_ID); obj[2] = new SqlParameter("XNCT_HH_ID", item.HH_ID); obj[3] = new SqlParameter("XNCT_DV_ID", item.DV_ID); obj[4] = new SqlParameter("XNCT_SoLuong", item.SoLuong); obj[5] = new SqlParameter("XNCT_DonGia", item.DonGia); obj[6] = new SqlParameter("XNCT_Tong", item.Tong); obj[7] = new SqlParameter("XNCT_VAT", item.VAT); obj[8] = new SqlParameter("XNCT_CKTyLe", item.CKTyLe); obj[9] = new SqlParameter("XNCT_CKTien", item.CKTien); if (item.NgayTao > DateTime.MinValue) { obj[10] = new SqlParameter("XNCT_NgayTao", item.NgayTao); } else { obj[10] = new SqlParameter("XNCT_NgayTao", DBNull.Value); } obj[11] = new SqlParameter("XNCT_NguoiTao", item.NguoiTao); if (item.NgayCapNhat > DateTime.MinValue) { obj[12] = new SqlParameter("XNCT_NgayCapNhat", item.NgayCapNhat); } else { obj[12] = new SqlParameter("XNCT_NgayCapNhat", DBNull.Value); } obj[13] = new SqlParameter("XNCT_NguoiCapNhat", item.NguoiCapNhat); obj[14] = new SqlParameter("XNCT_GhiChu", item.GhiChu); obj[15] = new SqlParameter("XNCT_Draff", item.Draff); if (item.DraffDate > DateTime.MinValue) { obj[16] = new SqlParameter("XNCT_DraffDate", item.DraffDate); } else { obj[16] = new SqlParameter("XNCT_DraffDate", DBNull.Value); } obj[17] = new SqlParameter("XNCT_KH_ID", item.KH_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblXuatNhapChiTiet_Update_UpdateNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static XuatNhapChiTiet SelectById(Guid XNCT_ID) { var Item = new XuatNhapChiTiet(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("XNCT_ID", XNCT_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblXuatNhapChiTiet_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static XuatNhapChiTiet getFromReader(IDataReader rd) { var Item = new XuatNhapChiTiet(); if (rd.FieldExists("XNCT_ID")) { Item.ID = (Guid)(rd["XNCT_ID"]); } if (rd.FieldExists("XNCT_XN_ID")) { Item.XN_ID = (Guid)(rd["XNCT_XN_ID"]); } if (rd.FieldExists("XNCT_HH_ID")) { Item.HH_ID = (Guid)(rd["XNCT_HH_ID"]); } if (rd.FieldExists("XNCT_DV_ID")) { Item.DV_ID = (Guid)(rd["XNCT_DV_ID"]); } if (rd.FieldExists("XNCT_SoLuong")) { Item.SoLuong = (Double)(rd["XNCT_SoLuong"]); } if (rd.FieldExists("XNCT_DonGia")) { Item.DonGia = (Double)(rd["XNCT_DonGia"]); } if (rd.FieldExists("XNCT_Tong")) { Item.Tong = (Double)(rd["XNCT_Tong"]); } if (rd.FieldExists("XNCT_VAT")) { Item.VAT = (Double)(rd["XNCT_VAT"]); } if (rd.FieldExists("XNCT_CKTyLe")) { Item.CKTyLe = (Double)(rd["XNCT_CKTyLe"]); } if (rd.FieldExists("XNCT_CKTien")) { Item.CKTien = (Double)(rd["XNCT_CKTien"]); } if (rd.FieldExists("XNCT_NgayTao")) { Item.NgayTao = (DateTime)(rd["XNCT_NgayTao"]); } if (rd.FieldExists("XNCT_NguoiTao")) { Item.NguoiTao = (String)(rd["XNCT_NguoiTao"]); } if (rd.FieldExists("XNCT_NgayCapNhat")) { Item.NgayCapNhat = (DateTime)(rd["XNCT_NgayCapNhat"]); } if (rd.FieldExists("XNCT_NguoiCapNhat")) { Item.NguoiCapNhat = (String)(rd["XNCT_NguoiCapNhat"]); } if (rd.FieldExists("XNCT_GhiChu")) { Item.GhiChu = (String)(rd["XNCT_GhiChu"]); } if (rd.FieldExists("XNCT_Draff")) { Item.Draff = (Boolean)(rd["XNCT_Draff"]); } if (rd.FieldExists("XNCT_DraffDate")) { Item.DraffDate = (DateTime)(rd["XNCT_DraffDate"]); } if (rd.FieldExists("HH_Ten")) { Item.HH_Ten = (String)(rd["HH_Ten"]); } if (rd.FieldExists("DV_Ten")) { Item.DV_Ten = (String)(rd["DV_Ten"]); } if (rd.FieldExists("XNCT_KH_ID")) { Item.KH_ID = (Guid)(rd["XNCT_KH_ID"]); } if (rd.FieldExists("KH_Ten")) { Item.KH_Ten = (String)(rd["KH_Ten"]); } if (rd.FieldExists("HH_Ma")) { Item.HH_Ma = (String)(rd["HH_Ma"]); } Item._XuatNhap = XuatNhapDal.getFromReader(rd); Item._HangHoa = HangHoaDal.getFromReader(rd); return(Item); }