public List <GetAll_DS_PhieuXuatKho_Result> GetAllDSPhieuXuatKho(DataDSXuatKho data)
{
string FromDate = data.tungay;
string ToDate = data.denngay;
var query = db.Database.SqlQuery <GetAll_DS_PhieuXuatKho_Result>("GetAll_DS_PhieuXuatKho @tungay,@denngay, @macongty", new SqlParameter("tungay", FromDate), new SqlParameter("denngay", ToDate), new SqlParameter("macongty", "HOPLONG"));
//var resultDSXuatKho = query.ToList();
return(query.ToList());
}
public List <GetAll_PhieuNhapKho_Result> GetAllDSPhieuNhapKho(int sotrang, DataDSXuatKho data)
{
if (data.tungay == "" && data.denngay == "")
{
var query = db.Database.SqlQuery <GetAll_PhieuNhapKho_Result>("GetAll_PhieuNhapKho @macongty,@sotrang", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("sotrang", sotrang));
resultDSNhap = query.ToList();
}
else
{
DateTime FromDate = xlnt.Xulydatetime(data.tungay);
DateTime ToDate = xlnt.Xulydatetime(data.denngay);
var query = db.Database.SqlQuery <GetAll_PhieuNhapKho_Result>("GetAll_PhieuNhapKho_WithDate @macongty,@tungay,@denngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("tungay", FromDate), new SqlParameter("denngay", ToDate));
resultDSNhap = query.ToList();
return(resultDSNhap);
}
return(resultDSNhap);
}
public List <GetAll_List_XuatHang_Result> GetListXuatHang(bool isadmin, string username, DataDSXuatKho data)
{
if (data.ngay == null && data.tukhoa == null)
{
var query = db.Database.SqlQuery <GetAll_List_XuatHang_Result>("GetAll_List_XuatHang @macongty,@isadmin,@username,@tukhoa,@ngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("isadmin", isadmin), new SqlParameter("username", username), new SqlParameter("tukhoa", DBNull.Value), new SqlParameter("ngay", DBNull.Value));
resultDSXuatKho = query.ToList();
}
if (data.ngay == null && data.tukhoa != null)
{
var query = db.Database.SqlQuery <GetAll_List_XuatHang_Result>("GetAll_List_XuatHang @macongty,@isadmin,@username,@tukhoa,@ngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("isadmin", isadmin), new SqlParameter("username", username), new SqlParameter("tukhoa", data.tukhoa), new SqlParameter("ngay", DBNull.Value));
resultDSXuatKho = query.ToList();
}
if (data.ngay != null && data.tukhoa == null)
{
DateTime ngay1 = xlnt.Xulydatetime(data.ngay);
var query = db.Database.SqlQuery <GetAll_List_XuatHang_Result>("GetAll_List_XuatHang @macongty,@isadmin,@username,@tukhoa,@ngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("isadmin", isadmin), new SqlParameter("username", username), new SqlParameter("tukhoa", DBNull.Value), new SqlParameter("ngay", ngay1));
resultDSXuatKho = query.ToList();
}
if (data.ngay != null && data.tukhoa != null)
{
DateTime ngay = xlnt.Xulydatetime(data.ngay);
var query = db.Database.SqlQuery <GetAll_List_XuatHang_Result>("GetAll_List_XuatHang @macongty,@isadmin,@username,@tukhoa,@ngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("isadmin", isadmin), new SqlParameter("username", username), new SqlParameter("tukhoa", data.tukhoa), new SqlParameter("ngay", ngay));
resultDSXuatKho = query.ToList();
}
return(resultDSXuatKho);
}
