public static BanHang_ChiPhiChiTiet Insert(BanHang_ChiPhiChiTiet item)
{
var Item = new BanHang_ChiPhiChiTiet();
var obj = new SqlParameter[11];
obj[0] = new SqlParameter("CPCT_ID", item.ID);
obj[1] = new SqlParameter("CPCT_BHCP_ID", item.BHCP_ID);
obj[2] = new SqlParameter("CPCT_HH_ID", item.HH_ID);
obj[3] = new SqlParameter("CPCT_Xuat", item.Xuat);
obj[4] = new SqlParameter("CPCT_XuatGia", item.XuatGia);
obj[5] = new SqlParameter("CPCT_XuatTien", item.XuatTien);
obj[6] = new SqlParameter("CPCT_Nhap", item.Nhap);
obj[7] = new SqlParameter("CPCT_NhapGia", item.NhapGia);
obj[8] = new SqlParameter("CPCT_NhapTien", item.NhapTien);
obj[9] = new SqlParameter("CPCT_HeThong", item.HeThong);
obj[10] = new SqlParameter("CPCT_Username", item.Username);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_ChiPhiChiTiet_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static BanHang_ChiPhiChiTiet getFromReader(IDataReader rd)
{
var Item = new BanHang_ChiPhiChiTiet();
if (rd.FieldExists("CPCT_ID"))
{
Item.ID = (Int64)(rd["CPCT_ID"]);
}
if (rd.FieldExists("CPCT_BHCP_ID"))
{
Item.BHCP_ID = (Int64)(rd["CPCT_BHCP_ID"]);
}
if (rd.FieldExists("CPCT_HH_ID"))
{
Item.HH_ID = (Guid)(rd["CPCT_HH_ID"]);
}
if (rd.FieldExists("CPCT_Xuat"))
{
Item.Xuat = (Double)(rd["CPCT_Xuat"]);
}
if (rd.FieldExists("CPCT_XuatGia"))
{
Item.XuatGia = (Double)(rd["CPCT_XuatGia"]);
}
if (rd.FieldExists("CPCT_XuatTien"))
{
Item.XuatTien = (Double)(rd["CPCT_XuatTien"]);
}
if (rd.FieldExists("CPCT_Nhap"))
{
Item.Nhap = (Double)(rd["CPCT_Nhap"]);
}
if (rd.FieldExists("CPCT_NhapGia"))
{
Item.NhapGia = (Double)(rd["CPCT_NhapGia"]);
}
if (rd.FieldExists("CPCT_NhapTien"))
{
Item.NhapTien = (Double)(rd["CPCT_NhapTien"]);
}
if (rd.FieldExists("CPCT_HeThong"))
{
Item.HeThong = (Boolean)(rd["CPCT_HeThong"]);
}
if (rd.FieldExists("CPCT_Username"))
{
Item.Username = (String)(rd["CPCT_Username"]);
}
if (rd.FieldExists("HH_Ten"))
{
Item.HH_Ten = (String)(rd["HH_Ten"]);
}
if (rd.FieldExists("HH_DonVi_Ten"))
{
Item.HH_DonVi_Ten = (String)(rd["HH_DonVi_Ten"]);
}
return(Item);
}
public static BanHang_ChiPhiChiTiet SelectById(Int64 CPCT_ID)
{
var Item = new BanHang_ChiPhiChiTiet();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("CPCT_ID", CPCT_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_ChiPhiChiTiet_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
