public static LoaiDanhMuc getFromReader(IDataReader rd)
{
var Item = new LoaiDanhMuc();
if (rd.FieldExists("LDM_ID"))
{
Item.ID = (Guid)(rd["LDM_ID"]);
}
if (rd.FieldExists("LDM_Ten"))
{
Item.Ten = (String)(rd["LDM_Ten"]);
}
if (rd.FieldExists("LDM_Ma"))
{
Item.Ma = (String)(rd["LDM_Ma"]);
}
if (rd.FieldExists("LDM_KyHieu"))
{
Item.KyHieu = (String)(rd["LDM_KyHieu"]);
}
if (rd.FieldExists("LDM_RowId"))
{
Item.RowId = (Guid)(rd["LDM_RowId"]);
}
if (rd.FieldExists("LDM_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["LDM_NgayTao"]);
}
if (rd.FieldExists("LDM_NguoiTao"))
{
Item.NguoiTao = (String)(rd["LDM_NguoiTao"]);
}
if (rd.FieldExists("LDM_NgayCapNhat"))
{
Item.NgayCapNhat = (DateTime)(rd["LDM_NgayCapNhat"]);
}
if (rd.FieldExists("LDM_ThuTu"))
{
Item.ThuTu = (Int32)(rd["LDM_ThuTu"]);
}
if (rd.FieldExists("LDM_NguoiSua"))
{
Item.NguoiSua = (String)(rd["LDM_NguoiSua"]);
}
if (rd.FieldExists("LDM_Deleted"))
{
Item.Deleted = (Boolean)(rd["LDM_Deleted"]);
}
return(Item);
}
public static LoaiDanhMuc SelectById(Guid LDM_ID)
{
var Item = new LoaiDanhMuc();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("LDM_ID", LDM_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLoaiDanhMuc_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static LoaiDanhMuc Insert(LoaiDanhMuc item)
{
var Item = new LoaiDanhMuc();
var obj = new SqlParameter[11];
obj[0] = new SqlParameter("LDM_ID", item.ID);
obj[1] = new SqlParameter("LDM_Ten", item.Ten);
obj[2] = new SqlParameter("LDM_Ma", item.Ma);
obj[3] = new SqlParameter("LDM_KyHieu", item.KyHieu);
obj[4] = new SqlParameter("LDM_RowId", item.RowId);
if (item.NgayTao > DateTime.MinValue)
{
obj[5] = new SqlParameter("LDM_NgayTao", item.NgayTao);
}
else
{
obj[5] = new SqlParameter("LDM_NgayTao", DBNull.Value);
}
obj[6] = new SqlParameter("LDM_NguoiTao", item.NguoiTao);
if (item.NgayCapNhat > DateTime.MinValue)
{
obj[7] = new SqlParameter("LDM_NgayCapNhat", item.NgayCapNhat);
}
else
{
obj[7] = new SqlParameter("LDM_NgayCapNhat", DBNull.Value);
}
obj[8] = new SqlParameter("LDM_ThuTu", item.ThuTu);
obj[9] = new SqlParameter("LDM_NguoiSua", item.NguoiSua);
obj[10] = new SqlParameter("LDM_Deleted", item.Deleted);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLoaiDanhMuc_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
