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);
}
