public static HangHoaCollection SelectAll()
{
var List = new HangHoaCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_HangHoa_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static HangHoaCollection SelectByPhienLamViec(long PLV_ID)
{
var List = new HangHoaCollection();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("PLV_ID", PLV_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblHangHoa_Select_SelectByPhienLamViec_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
protected override void OnLoad(EventArgs e)
{
#region variables
var ID = Request["ID"];
var DM_ID = Request["DM_ID"];
var Ma = Request["Ma"];
var MoTa = Request["MoTa"];
var NoiDung = Request["NoiDung"];
var CongDung = Request["CongDung"];
var CachDung = Request["CachDung"];
var CacBuoc = Request["CacBuoc"];
var DV_ID = Request["DV_ID"];
var GiaNhap = Request["GiaNhap"];
var GiaXuat = Request["GiaXuat"];
var TonDinhMuc = Request["TonDinhMuc"];
var Anh = Request["Anh"];
var NgayTao = Request["NgayTao"];
var NgayCapNhat = Request["NgayCapNhat"];
var NguoiTao = Request["NguoiTao"];
var NguoiCapNhat = Request["NguoiCapNhat"];
var Active = Request["Active"];
var KhuyenMai = Request["KhuyenMai"];
var DuaLenWeb = Request["DuaLenWeb"];
#endregion
switch (subAct)
{
case "get":
var hangHoaList = new HangHoaCollection()
{
new HangHoa() {Active = true, Anh = string.Empty, CacBuoc = string.Empty, DM_ID = Guid.NewGuid(),DuaLenWeb = true, DV_ID = Guid.NewGuid(), GiaNhap = 1000, GiaXuat = 1200,HetHang = false, ID = Guid.NewGuid()}
};
break;
default:
break;
}
base.OnLoad(e);
}
public static HangHoaCollection TimNhanh(string q, int Top)
{
var List = new HangHoaCollection();
var obj = new SqlParameter[2];
obj[0] = new SqlParameter("Top", Top);
if (!string.IsNullOrEmpty(q))
{
obj[1] = new SqlParameter("q", q);
}
else
{
obj[1] = new SqlParameter("q", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblHangHoa_Select_TimNhanh_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static HangHoaCollection SelectTopLienQuan(string ID, string Top, SqlConnection con)
{
var list = new HangHoaCollection();
var obj = new SqlParameter[2];
obj[0] = new SqlParameter("Top", Top);
if (!string.IsNullOrEmpty(ID))
{
obj[1] = new SqlParameter("ID", ID);
}
else
{
obj[1] = new SqlParameter("ID", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblHangHoa_Select_SelectTopLienQuan_linhnx", obj))
{
while (rd.Read())
{
list.Add(getFromReader(rd));
}
}
return(list);
}
public static HangHoaCollection SelectTopByDmMa(string DM_Ma, string Top)
{
var list = new HangHoaCollection();
var obj = new SqlParameter[2];
obj[0] = new SqlParameter("Top", Top);
if (!string.IsNullOrEmpty(DM_Ma))
{
obj[1] = new SqlParameter("DM_Ma", DM_Ma);
}
else
{
obj[1] = new SqlParameter("DM_Ma", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblHangHoa_Select_SelectTopByDmMa_linhnx", obj))
{
while (rd.Read())
{
list.Add(getFromReader(rd));
}
}
return(list);
}
