public static BanHang_ChiPhi Update(BanHang_ChiPhi item)
{
var Item = new BanHang_ChiPhi();
var obj = new SqlParameter[5];
obj[0] = new SqlParameter("BHCP_ID", item.ID);
obj[1] = new SqlParameter("BHCP_PLV_ID", item.PLV_ID);
obj[2] = new SqlParameter("BHCP_Tong", item.Tong);
if (item.Ngay > DateTime.MinValue)
{
obj[3] = new SqlParameter("BHCP_Ngay", item.Ngay);
}
else
{
obj[3] = new SqlParameter("BHCP_Ngay", DBNull.Value);
}
obj[4] = new SqlParameter("BHCP_Username", item.Username);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_ChiPhi_Update_UpdateNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static BanHang_ChiPhi getFromReader(IDataReader rd)
{
var Item = new BanHang_ChiPhi();
if (rd.FieldExists("BHCP_ID"))
{
Item.ID = (Int64)(rd["BHCP_ID"]);
}
if (rd.FieldExists("BHCP_PLV_ID"))
{
Item.PLV_ID = (Int64)(rd["BHCP_PLV_ID"]);
}
if (rd.FieldExists("BHCP_Tong"))
{
Item.Tong = (Double)(rd["BHCP_Tong"]);
}
if (rd.FieldExists("BHCP_Ngay"))
{
Item.Ngay = (DateTime)(rd["BHCP_Ngay"]);
}
if (rd.FieldExists("BHCP_Username"))
{
Item.Username = (String)(rd["BHCP_Username"]);
}
return(Item);
}
public static BanHang_ChiPhi SelectByPLVId(SqlConnection con, Int64 PLV_ID)
{
var Item = new BanHang_ChiPhi();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("PLV_ID", PLV_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblBanHang_ChiPhi_Select_SelectByPLVId_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
