public List <FixturePartCreateboundStatuDTO> GetFixtureStatuDTO()
{
List <FixturePartCreateboundStatuDTO> fixtureStatuDTOs = new List <FixturePartCreateboundStatuDTO>();
List <Enumeration> enumerationItems = DataContext.Enumeration.Where(o => o.Enum_Type == "FixturePartCreateboundStatus").ToList();
foreach (var item in enumerationItems)
{
FixturePartCreateboundStatuDTO fixtureStatuDTO = new FixturePartCreateboundStatuDTO();
fixtureStatuDTO.Status_UID = item.Enum_UID;
fixtureStatuDTO.Status = item.Enum_Value;
fixtureStatuDTOs.Add(fixtureStatuDTO);
}
return(fixtureStatuDTOs);
}
public string DeleteBound(int Fixture_Storage_Inbound_UID)
{
string result = "";
using (var trans = DataContext.Database.BeginTransaction())
{
try
{
// var sql = string.Format(@"DELETE FROM Fixture_Storage_Inbound WHERE Fixture_Storage_Inbound_UID={0}", Fixture_Storage_Inbound_UID);
List <FixturePartCreateboundStatuDTO> fixtureStatuDTOs = GetFixtureStatuDTO();
FixturePartCreateboundStatuDTO fixtureStatus = fixtureStatuDTOs.FirstOrDefault(o => o.Status == "已删除");
var sql = string.Format(@"UPDATE [dbo].[Fixture_Storage_Outbound_M] SET [Status_UID] = {0} WHERE Fixture_Storage_Outbound_M_UID={1}", fixtureStatus.Status_UID, Fixture_Storage_Inbound_UID);
DataContext.Database.ExecuteSqlCommand(sql);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
result = "Error:" + ex.Message;
}
return(result);
}
}
public IQueryable <Fixture_Storage_TransferDTO> QueryStorageTransfers(Fixture_Storage_TransferDTO searchModel, Page page, out int totalcount)
{
var query = from M in DataContext.Fixture_Storage_Transfer
select new Fixture_Storage_TransferDTO
{
Fixture_Storage_Transfer_UID = M.Fixture_Storage_Transfer_UID,
Fixture_Storage_Transfer_ID = M.Fixture_Storage_Transfer_ID,
Fixture_Part_UID = M.Fixture_Part_UID,
Out_Fixture_Warehouse_Storage_UID = M.Out_Fixture_Warehouse_Storage_UID,
In_Fixture_Warehouse_Storage_UID = M.In_Fixture_Warehouse_Storage_UID,
Transfer_Qty = M.Transfer_Qty,
Applicant_UID = M.Applicant_UID,
Applicant_Date = M.Applicant_Date,
Applicant = M.System_Users.User_Name,
Status_UID = M.Status_UID,
Approver_UID = M.Approver_UID,
Approver = M.System_Users1.User_Name,
Approver_Date = M.Approver_Date,
Out_Storage_ID = M.Fixture_Warehouse_Storage.Storage_ID,
Out_Rack_ID = M.Fixture_Warehouse_Storage.Rack_ID,
Out_Fixture_Warehouse_ID = M.Fixture_Warehouse_Storage.Fixture_Warehouse.Fixture_Warehouse_ID,
Out_Fixture_Warehouse_Name = M.Fixture_Warehouse_Storage.Fixture_Warehouse.Fixture_Warehouse_Name,
In_Storage_ID = M.Fixture_Warehouse_Storage1.Storage_ID,
In_Rack_ID = M.Fixture_Warehouse_Storage1.Rack_ID,
In_Fixture_Warehouse_ID = M.Fixture_Warehouse_Storage1.Fixture_Warehouse.Fixture_Warehouse_ID,
In_Fixture_Warehouse_Name = M.Fixture_Warehouse_Storage1.Fixture_Warehouse.Fixture_Warehouse_Name,
Part_ID = M.Fixture_Part.Part_ID,
Part_Name = M.Fixture_Part.Part_Name,
Part_Spec = M.Fixture_Part.Part_Spec,
Status = M.Enumeration.Enum_Value,
Plant_Organization_UID = M.Fixture_Part.Plant_Organization_UID,
Plant = M.Fixture_Part.System_Organization.Organization_Name,
BG_Organization_UID = M.Fixture_Part.BG_Organization_UID,
BG_Organization = M.Fixture_Part.System_Organization1.Organization_Name,
FunPlant_Organization_UID = M.Fixture_Part.FunPlant_Organization_UID,
FunPlant_Organization = M.Fixture_Part.System_Organization2.Organization_Name,
};
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.Part_ID))
{
query = query.Where(m => m.Part_ID == searchModel.Part_ID);
}
if (!string.IsNullOrWhiteSpace(searchModel.Part_Name))
{
query = query.Where(m => m.Part_Name == searchModel.Part_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.Part_Spec))
{
query = query.Where(m => m.Part_Spec == searchModel.Part_Spec);
}
if (!string.IsNullOrWhiteSpace(searchModel.Approver))
{
query = query.Where(m => m.Approver == searchModel.Approver);
}
if (!string.IsNullOrWhiteSpace(searchModel.Applicant))
{
query = query.Where(m => m.Applicant == searchModel.Applicant);
}
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 (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 (searchModel.Out_Fixture_Warehouse_Storage_UID != 0)
{
query = query.Where(m => m.Out_Fixture_Warehouse_Storage_UID == searchModel.Out_Fixture_Warehouse_Storage_UID);
}
if (searchModel.In_Fixture_Warehouse_Storage_UID != 0)
{
query = query.Where(m => m.In_Fixture_Warehouse_Storage_UID == searchModel.In_Fixture_Warehouse_Storage_UID);
}
if (searchModel.Status_UID != 0)
{
query = query.Where(m => m.Status_UID == searchModel.Status_UID);
}
if (searchModel.Status_UID == 0)
{
List <FixturePartCreateboundStatuDTO> fixtureStatuDTOs = GetFixtureStatuDTO();
FixturePartCreateboundStatuDTO fixtureStatus = fixtureStatuDTOs.FirstOrDefault(o => o.Status == "已删除");
query = query.Where(m => m.Status_UID != fixtureStatus.Status_UID);
}
totalcount = query.Count();
query = query.OrderByDescending(m => m.Applicant_Date).GetPage(page);
return(query);
}
public IQueryable <FixtureStorageCheckDTO> GetInfo(FixtureStorageCheckDTO searchModel, Page page, out int totalcount)
{
var query = from M in DataContext.Fixture_Storage_Check
select new FixtureStorageCheckDTO
{
Fixture_Storage_Check_UID = M.Fixture_Storage_Check_UID,
Fixture_Storage_Check_ID = M.Fixture_Storage_Check_ID,
Fixture_Part_UID = M.Fixture_Part_UID,
Fixture_Warehouse_Storage_UID = M.Fixture_Warehouse_Storage_UID,
Old_Inventory_Qty = M.Old_Inventory_Qty,
Check_Qty = M.Check_Qty,
Check_Status_UID = M.Check_Status_UID,
Applicant_UID = M.Applicant_UID,
Applicant_Date = M.Applicant_Date,
Status_UID = M.Status_UID,
Approve_UID = M.Approve_UID,
Approve_Date = M.Approve_Date,
Storage_ID = M.Fixture_Warehouse_Storage.Storage_ID,
Rack_ID = M.Fixture_Warehouse_Storage.Rack_ID,
Fixture_Warehouse_ID = M.Fixture_Warehouse_Storage.Fixture_Warehouse.Fixture_Warehouse_ID,
Fixture_Warehouse_Name = M.Fixture_Warehouse_Storage.Fixture_Warehouse.Fixture_Warehouse_Name,
Part_ID = M.Fixture_Part.Part_ID,
Part_Name = M.Fixture_Part.Part_Name,
Part_Spec = M.Fixture_Part.Part_Spec,
Plant_Organization_UID = M.Fixture_Part.Plant_Organization_UID,
Plant = M.Fixture_Part.System_Organization.Organization_Name,
BG_Organization_UID = M.Fixture_Part.BG_Organization_UID,
BG_Organization = M.Fixture_Part.System_Organization1.Organization_Name,
FunPlant_Organization_UID = M.Fixture_Part.FunPlant_Organization_UID,
FunPlant_Organization = M.Fixture_Part.System_Organization2.Organization_Name,
Applicant = M.System_Users.User_Name,
Approve = M.System_Users1.User_Name,
Check_Status = M.Enumeration.Enum_Value,
Status = M.Enumeration1.Enum_Value
};
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.Part_ID))
{
query = query.Where(m => m.Part_ID.Contains(searchModel.Part_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.Part_Name))
{
query = query.Where(m => m.Part_Name.Contains(searchModel.Part_Name));
}
if (!string.IsNullOrWhiteSpace(searchModel.Part_Spec))
{
query = query.Where(m => m.Part_Spec.Contains(searchModel.Part_Spec));
}
if (!string.IsNullOrWhiteSpace(searchModel.Fixture_Warehouse_ID))
{
query = query.Where(m => m.Fixture_Warehouse_ID.Contains(searchModel.Fixture_Warehouse_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.Rack_ID))
{
query = query.Where(m => m.Rack_ID.Contains(searchModel.Rack_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.Storage_ID))
{
query = query.Where(m => m.Storage_ID.Contains(searchModel.Storage_ID));
}
if (!string.IsNullOrWhiteSpace(searchModel.Applicant))
{
query = query.Where(m => m.Applicant.Contains(searchModel.Applicant));
}
if (!string.IsNullOrWhiteSpace(searchModel.Approve))
{
query = query.Where(m => m.Approve.Contains(searchModel.Approve));
}
if (searchModel.Status_UID != 0)
{
query = query.Where(m => m.Status_UID == searchModel.Status_UID);
}
if (searchModel.Status_UID == 0)
{
List <FixturePartCreateboundStatuDTO> fixtureStatuDTOs = GetFixtureStatuDTO();
FixturePartCreateboundStatuDTO fixtureStatus = fixtureStatuDTOs.FirstOrDefault(o => o.Status == "已删除");
query = query.Where(m => m.Status_UID != fixtureStatus.Status_UID);
}
totalcount = query.Count();
query = query.OrderByDescending(m => m.Applicant_Date).GetPage(page);
return(query);
}
