public List <FixturePartWarehouseDTO> DoAllExportWarehouseReprot(FixturePartWarehouseDTO searchModel)
{
var query = from D in DataContext.Fixture_Warehouse_Storage
join M in DataContext.Fixture_Warehouse
on D.Fixture_Warehouse_UID equals M.Fixture_Warehouse_UID
select new FixturePartWarehouseDTO
{
Fixture_Warehouse_Storage_UID = D.Fixture_Warehouse_Storage_UID,
Fixture_Warehouse_UID = M.Fixture_Warehouse_UID,
Fixture_Warehouse_ID = M.Fixture_Warehouse_ID,
Fixture_Warehouse_Name = M.Fixture_Warehouse_Name,
Rack_ID = D.Rack_ID,
Storage_ID = D.Storage_ID,
Remarks = D.Remarks,
Is_Enable = D.Is_Enable,
Createder = D.System_Users.User_Name,
Created_Date = D.Created_Date,
Created_UID = D.Created_UID,
Modifier = D.System_Users1.User_Name,
Modified_Date = D.Modified_Date,
Modified_UID = D.Modified_UID,
Plant = D.System_Organization.Organization_Name,
BG_Organization = D.System_Organization1.Organization_Name,
FunPlant_Organization = D.System_Organization2.Organization_Name,
Plant_Organization_UID = D.Plant_Organization_UID,
BG_Organization_UID = D.BG_Organization_UID,
FunPlant_Organization_UID = D.FunPlant_Organization_UID
};
var query1 = from M in DataContext.Fixture_Warehouse
select new FixturePartWarehouseDTO
{
Fixture_Warehouse_Storage_UID = 0,
Fixture_Warehouse_UID = M.Fixture_Warehouse_UID,
Fixture_Warehouse_ID = M.Fixture_Warehouse_ID,
Fixture_Warehouse_Name = M.Fixture_Warehouse_Name,
Rack_ID = null,
Storage_ID = null,
Remarks = M.Remarks,
Is_Enable = M.Is_Enable,
Createder = M.System_Users.User_Name,
Created_Date = M.Created_Date,
Created_UID = M.Created_UID,
Modifier = M.System_Users1.User_Name,
Modified_Date = M.Modified_Date,
Modified_UID = M.Modified_UID,
Plant = M.System_Organization.Organization_Name,
BG_Organization = M.System_Organization1.Organization_Name,
FunPlant_Organization = M.System_Organization2.Organization_Name,
Plant_Organization_UID = M.Plant_Organization_UID,
BG_Organization_UID = M.BG_Organization_UID,
FunPlant_Organization_UID = M.FunPlant_Organization_UID
};
query = query.Union(query1);
if (searchModel.Plant_Organization_UID != 0)
{
query = query.Where(m => m.Plant_Organization_UID == searchModel.Plant_Organization_UID);
}
if (searchModel.BG_Organization_UID != 0)
{
query = query.Where(m => m.BG_Organization_UID == searchModel.BG_Organization_UID);
}
if (searchModel.FunPlant_Organization_UID != 0 && searchModel.FunPlant_Organization_UID != null)
{
query = query.Where(m => m.FunPlant_Organization_UID == searchModel.FunPlant_Organization_UID);
}
if (!string.IsNullOrWhiteSpace(searchModel.Fixture_Warehouse_ID))
{
query = query.Where(m => m.Fixture_Warehouse_ID == searchModel.Fixture_Warehouse_ID);
}
if (!string.IsNullOrWhiteSpace(searchModel.Rack_ID))
{
query = query.Where(m => m.Rack_ID == searchModel.Rack_ID);
}
if (!string.IsNullOrWhiteSpace(searchModel.Storage_ID))
{
query = query.Where(m => m.Storage_ID == searchModel.Storage_ID);
}
if (!string.IsNullOrWhiteSpace(searchModel.Fixture_Warehouse_Name))
{
query = query.Where(m => m.Fixture_Warehouse_Name == searchModel.Fixture_Warehouse_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.Remarks))
{
query = query.Where(m => m.Remarks == searchModel.Remarks);
}
//if (searchModel.Is_Enable !=null)
// query = query.Where(m => m.Is_Enable == searchModel.Is_Enable);
return(query.ToList());
}
public IQueryable <FixturePartWarehouseDTO> GetInfo(FixturePartWarehouseDTO searchModel, Page page, out int totalcount)
{
//var query = from D in DataContext.Fixture_Warehouse_Storage
// join M in DataContext.Fixture_Warehouse
// on D.Fixture_Warehouse_UID equals M.Fixture_Warehouse_UID
// join cuser in DataContext.System_Users
// on D.Modified_UID equals cuser.Account_UID
// join user in DataContext.System_Users
// on D.Modified_UID equals user.Account_UID
// join plantorg in DataContext.System_Organization on
// M.Plant_Organization_UID equals plantorg.Organization_UID
// join bgorg in DataContext.System_Organization on
// M.BG_Organization_UID equals bgorg.Organization_UID
// join funplantorg in DataContext.System_Organization on
// M.FunPlant_Organization_UID equals funplantorg.Organization_UID
// select new FixturePartWarehouseDTO
// {
// Fixture_Warehouse_Storage_UID = D.Fixture_Warehouse_Storage_UID,
// Fixture_Warehouse_UID = M.Fixture_Warehouse_UID,
// Fixture_Warehouse_ID = M.Fixture_Warehouse_ID,
// Fixture_Warehouse_Name = M.Fixture_Warehouse_Name,
// Rack_ID = D.Rack_ID,
// Storage_ID = D.Storage_ID,
// Remarks = D.Remarks,
// Is_Enable=D.Is_Enable,
// Createder= cuser.User_Name,
// Created_Date=D.Created_Date,
// Created_UID=D.Created_UID,
// Modifier = user.User_Name,
// Modified_Date = D.Modified_Date,
// Modified_UID=D.Modified_UID,
// Plant=plantorg.Organization_Name,
// BG_Organization = bgorg.Organization_Name,
// FunPlant_Organization = funplantorg.Organization_Name,
// Plant_Organization_UID= D.Plant_Organization_UID,
// BG_Organization_UID = D.BG_Organization_UID,
// FunPlant_Organization_UID = D.FunPlant_Organization_UID
// };
//var query = from M in DataContext.Fixture_Warehouse
// join cuser in DataContext.System_Users
// on M.Modified_UID equals cuser.Account_UID
// join user in DataContext.System_Users on
// M.Modified_UID equals user.Account_UID
// join plantorg in DataContext.System_Organization on
// M.Plant_Organization_UID equals plantorg.Organization_UID
// join bgorg in DataContext.System_Organization on
// M.BG_Organization_UID equals bgorg.Organization_UID
// //join funplantorg in DataContext.System_Organization on
// //M.FunPlant_Organization_UID equals funplantorg.Organization_UID
// select new FixturePartWarehouseDTO
// {
// Fixture_Warehouse_Storage_UID = 0,
// Fixture_Warehouse_UID = M.Fixture_Warehouse_UID,
// Fixture_Warehouse_ID = M.Fixture_Warehouse_ID,
// Fixture_Warehouse_Name = M.Fixture_Warehouse_Name,
// Rack_ID = null,
// Storage_ID =null,
// Remarks = M.Remarks,
// Is_Enable = M.Is_Enable,
// Createder = cuser.User_Name,
// Created_Date = M.Created_Date,
// Created_UID = M.Created_UID,
// Modifier = user.User_Name,
// Modified_Date = M.Modified_Date,
// Modified_UID = M.Modified_UID,
// Plant = plantorg.Organization_Name,
// BG_Organization = bgorg.Organization_Name,
// //FunPlant_Organization = funplantorg.Organization_Name,
// Plant_Organization_UID = M.Plant_Organization_UID,
// BG_Organization_UID = M.BG_Organization_UID,
// FunPlant_Organization_UID = M.FunPlant_Organization_UID
// };
//query = query.Union(query1);
var query = from M in DataContext.Fixture_Warehouse
select new FixturePartWarehouseDTO
{
Fixture_Warehouse_Storage_UID = 0,
Fixture_Warehouse_UID = M.Fixture_Warehouse_UID,
Fixture_Warehouse_ID = M.Fixture_Warehouse_ID,
Fixture_Warehouse_Name = M.Fixture_Warehouse_Name,
Rack_ID = null,
Storage_ID = null,
Remarks = M.Remarks,
Is_Enable = M.Is_Enable,
Createder = M.System_Users.User_Name,
Created_Date = M.Created_Date,
Created_UID = M.Created_UID,
Modifier = M.System_Users1.User_Name,
Modified_Date = M.Modified_Date,
Modified_UID = M.Modified_UID,
Plant = M.System_Organization.Organization_Name,
BG_Organization = M.System_Organization1.Organization_Name,
FunPlant_Organization = M.System_Organization2.Organization_Name,
Plant_Organization_UID = M.Plant_Organization_UID,
BG_Organization_UID = M.BG_Organization_UID,
FunPlant_Organization_UID = M.FunPlant_Organization_UID
};
if (searchModel.Plant_Organization_UID != 0)
{
query = query.Where(m => m.Plant_Organization_UID == searchModel.Plant_Organization_UID);
}
if (searchModel.BG_Organization_UID != 0)
{
query = query.Where(m => m.BG_Organization_UID == searchModel.BG_Organization_UID);
}
if (searchModel.FunPlant_Organization_UID != null && searchModel.FunPlant_Organization_UID != 0)
{
query = query.Where(m => m.FunPlant_Organization_UID == searchModel.FunPlant_Organization_UID);
}
if (!string.IsNullOrWhiteSpace(searchModel.Fixture_Warehouse_ID))
{
query = query.Where(m => m.Fixture_Warehouse_ID == searchModel.Fixture_Warehouse_ID);
}
if (!string.IsNullOrWhiteSpace(searchModel.Fixture_Warehouse_Name))
{
query = query.Where(m => m.Fixture_Warehouse_Name == searchModel.Fixture_Warehouse_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.Remarks))
{
query = query.Where(m => m.Fixture_Warehouse_Name == searchModel.Remarks);
}
if (searchModel.Is_Enable != null)
{
query = query.Where(m => m.Is_Enable == searchModel.Is_Enable);
}
//if (!string.IsNullOrWhiteSpace(searchModel.Rack_ID))
// query = query.Where(m => m.Rack_ID == searchModel.Rack_ID);
//if (!string.IsNullOrWhiteSpace(searchModel.Storage_ID))
// query = query.Where(m => m.Storage_ID == searchModel.Storage_ID);
//query = query.Where(m => m.Rack_ID == "" || m.Rack_ID == null);
totalcount = query.Count();
query = query.OrderByDescending(m => m.Modified_Date).GetPage(page);
return(query);
}
