public IHttpActionResult QueryStorageTransferByUidAPI(int Storage_Transfer_UID)
{
var dto = storageManageService.QueryStorageTransferSingle(Storage_Transfer_UID);
var result = new StorageTransferDTO
{
Storage_Transfer_UID = dto[0].Storage_Transfer_UID,
PartType_UID = dto[0].PartType_UID,
PartType = dto[0].PartType,
Material_Uid = dto[0].Material_Uid,
Out_Warehouse_Storage_UID = dto[0].Out_Warehouse_Storage_UID,
In_Warehouse_Storage_UID = dto[0].In_Warehouse_Storage_UID,
Transfer_Qty = dto[0].Transfer_Qty,
Material_Id = dto[0].Material_Id,
Material_Name = dto[0].Material_Name,
Material_Types = dto[0].Material_Types,
Out_Warehouse_ID = dto[0].Out_Warehouse_ID,
Out_Rack_ID = dto[0].Out_Rack_ID,
Out_Storage_ID = dto[0].Out_Storage_ID,
In_Warehouse_ID = dto[0].In_Warehouse_ID,
In_Rack_ID = dto[0].In_Rack_ID,
In_Storage_ID = dto[0].In_Storage_ID,
Transfer_Type = dto[0].Transfer_Type,
Status = dto[0].Status
};
return(Ok(result));
}
public IHttpActionResult DoAllExportStorageTransferReprotAPI(StorageTransferDTO search)
{
var result = storageManageService.DoAllExportStorageTransferReprot(search);
return(Ok(result));
}
public string AddOrEditStorageTransferAPI(StorageTransferDTO dto)
{
return(storageManageService.AddOrEditStorageTransfer(dto));
}
public IQueryable <StorageTransferDTO> GetInfo(StorageTransferDTO searchModel, Page page, out int totalcount)
{
var query = from M in DataContext.Storage_Transfer
join statusenum in DataContext.Enumeration on
M.Status_UID equals statusenum.Enum_UID
join mat in DataContext.Material_Info on
M.Material_UID equals mat.Material_Uid
join outwarst in DataContext.Warehouse_Storage on
M.Out_Warehouse_Storage_UID equals outwarst.Warehouse_Storage_UID
join outwar in DataContext.Warehouse on
outwarst.Warehouse_UID equals outwar.Warehouse_UID
join inwarst in DataContext.Warehouse_Storage on
M.In_Warehouse_Storage_UID equals inwarst.Warehouse_Storage_UID
join inwar in DataContext.Warehouse on
inwarst.Warehouse_UID equals inwar.Warehouse_UID
join typeenum in DataContext.Enumeration on
M.PartType_UID equals typeenum.Enum_UID
join appuser in DataContext.System_Users on
M.Applicant_UID equals appuser.Account_UID
join apruser in DataContext.System_Users on
M.Approver_UID equals apruser.Account_UID
select new StorageTransferDTO
{
Storage_Transfer_UID = M.Storage_Transfer_UID,
Storage_Transfer_ID = M.Storage_Transfer_ID,
Status = statusenum.Enum_Value,
Material_Id = mat.Material_Id,
Material_Name = mat.Material_Name,
Material_Types = mat.Material_Types,
Out_Warehouse_ID = outwar.Warehouse_ID,
Out_Rack_ID = outwarst.Rack_ID,
Out_Storage_ID = outwarst.Storage_ID,
Out_BG_Organization_UID = outwar.BG_Organization_UID,
Out_BG_Organization = outwar.System_Organization.Organization_Name,
Out_FunPlant_Organization_UID = outwar.FunPlant_Organization_UID,
Out_FunPlant_Organization = outwar.System_Organization1.Organization_Name,
In_Warehouse_ID = inwar.Warehouse_ID,
In_Rack_ID = inwarst.Rack_ID,
In_Storage_ID = inwarst.Storage_ID,
In_BG_Organization_UID = inwar.BG_Organization_UID,
In_BG_Organization = inwar.System_Organization.Organization_Name,
In_FunPlant_Organization_UID = inwar.FunPlant_Organization_UID,
In_FunPlant_Organization = inwar.System_Organization1.Organization_Name,
Transfer_Qty = M.Transfer_Qty,
Transfer_Type = typeenum.Enum_Value,
ApplicantUser = appuser.User_Name,
Applicant_Date = M.Applicant_Date,
ApproverUser = apruser.User_Name,
Approver_Date = M.Approver_Date,
Status_UID = M.Status_UID,
Out_Warehouse_Storage_UID = M.Out_Warehouse_Storage_UID,
In_Warehouse_Storage_UID = M.In_Warehouse_Storage_UID,
BG_Organization_UID = inwar.BG_Organization_UID
};
if (!string.IsNullOrWhiteSpace(searchModel.Storage_Transfer_ID))
{
query = query.Where(m => m.Storage_Transfer_ID.Contains(searchModel.Storage_Transfer_ID));
}
if (searchModel.Status_UID != 0)
{
query = query.Where(m => m.Status_UID == searchModel.Status_UID);
}
else
{
//fky2017/11/13
//query = query.Where(m => m.Status_UID !=392);
query = query.Where(m => m.Status_UID != 420);
}
if (!string.IsNullOrWhiteSpace(searchModel.ApplicantUser))
{
query = query.Where(m => m.ApplicantUser.Contains(searchModel.ApplicantUser));
}
if (searchModel.Applicant_Date.Year != 1)
{
DateTime nextday = searchModel.Applicant_Date.AddDays(1);
query = query.Where(m => m.Applicant_Date >= searchModel.Applicant_Date & m.Applicant_Date < nextday);
}
if (!string.IsNullOrWhiteSpace(searchModel.ApproverUser))
{
query = query.Where(m => m.ApproverUser.Contains(searchModel.ApproverUser));
}
if (searchModel.Approver_Date.Year != 1)
{
DateTime nextday = searchModel.Approver_Date.AddDays(1);
query = query.Where(m => m.Approver_Date >= searchModel.Approver_Date & m.Applicant_Date < nextday);
}
if (!string.IsNullOrWhiteSpace(searchModel.Material_Id))
{
query = query.Where(m => m.Material_Id.Contains(searchModel.Material_Id));
}
if (!string.IsNullOrWhiteSpace(searchModel.Material_Name))
{
query = query.Where(m => m.Material_Name.Contains(searchModel.Material_Name));
}
if (!string.IsNullOrWhiteSpace(searchModel.Material_Types))
{
query = query.Where(m => m.Material_Types.Contains(searchModel.Material_Types));
}
if (!string.IsNullOrWhiteSpace(searchModel.Out_Warehouse_ID))
{
query = query.Where(m => m.Out_Warehouse_ID.Contains(searchModel.Out_Warehouse_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.Out_Rack_ID))
{
query = query.Where(m => m.Out_Rack_ID.Contains(searchModel.Out_Rack_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.Out_Storage_ID))
{
query = query.Where(m => m.Out_Storage_ID.Contains(searchModel.Out_Storage_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.In_Warehouse_ID))
{
query = query.Where(m => m.In_Warehouse_ID.Contains(searchModel.In_Warehouse_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.In_Rack_ID))
{
query = query.Where(m => m.In_Rack_ID.Contains(searchModel.In_Rack_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.In_Storage_ID))
{
query = query.Where(m => m.In_Storage_ID.Contains(searchModel.In_Storage_ID));
}
if (searchModel.Out_Warehouse_Storage_UID != 0)
{
query = query.Where(m => m.Out_Warehouse_Storage_UID == searchModel.Out_Warehouse_Storage_UID);
}
if (searchModel.In_Warehouse_Storage_UID != 0)
{
query = query.Where(m => m.In_Warehouse_Storage_UID == searchModel.In_Warehouse_Storage_UID);
}
List <int> Plant_UIDs = GetOpType(searchModel.Plant_UID).Select(o => o.Organization_UID).ToList();
if (Plant_UIDs.Count > 0)
{
query = query.Where(m => Plant_UIDs.Contains(m.BG_Organization_UID));
}
totalcount = query.Count();
query = query.OrderByDescending(m => m.Applicant_Date).GetPage(page);
return(query);
}
