public List<MachinePrepareItem_mpit_Info> GetPrepareProjectsByProjectID(string ProjectID)
{
List<MachinePrepareItem_mpit_Info> returnList = null;
try
{
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IEnumerable<MachinePrepareItem_mpit> searchDatas = from t in db.MachinePrepareItem_mpit
where t.mpit_lIsDeleted == false
//orderby t.mpit_PIPFID
select t;
searchDatas = searchDatas.Where(w => w.mpit_PIPFID.ToString().ToUpper().Trim().Equals(ProjectID.Trim().ToUpper()));
Master.MachineMasterDA machineDA = new DAL.SqlDAL.HBPMS.Master.MachineMasterDA();
PrepareProjectMasterDA PPDA = new PrepareProjectMasterDA();
if (searchDatas != null && searchDatas.Count() > 0)
{
returnList = new List<MachinePrepareItem_mpit_Info>();
foreach (MachinePrepareItem_mpit item in searchDatas)
{
MachinePrepareItem_mpit_Info info = Common.General.CopyObjectValue<MachinePrepareItem_mpit, MachinePrepareItem_mpit_Info>(item);
info.MachineItem = machineDA.GetMachineItem(info.mpit_cDCMPID.Trim());
info.PrepareProjectItem = PPDA.GetPPItems(info.mpit_PIPFID);
info.ppmSeq = info.PrepareProjectItem.ppm_iSeq;
returnList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
catch (Exception Ex)
{
throw Ex;
}
return returnList;
}
public List<MachinePrepareItem_mpit_Info> SearchRecords(Model.IModel.IModelObject searchCondition)
{
List<MachinePrepareItem_mpit_Info> returnList = null;
if (searchCondition != null)
{
MachinePrepareItem_mpit_Info query = searchCondition as MachinePrepareItem_mpit_Info;
try
{
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IEnumerable<MachinePrepareItem_mpit > searchDatas = from t in db.MachinePrepareItem_mpit
where t.mpit_lIsDeleted==false
orderby t.mpit_PIPFID
select t;
Master.MachineMasterDA machineDA = new DAL.SqlDAL.HBPMS.Master.MachineMasterDA();
PrepareProjectMasterDA PPDA = new PrepareProjectMasterDA();
if (searchDatas != null && searchDatas.Count() > 0)
{
returnList = new List<MachinePrepareItem_mpit_Info>();
foreach (MachinePrepareItem_mpit item in searchDatas)
{
MachinePrepareItem_mpit_Info info = Common.General.CopyObjectValue<MachinePrepareItem_mpit , MachinePrepareItem_mpit_Info>(item);
info.MachineItem = machineDA.GetMachineItem(info.mpit_cDCMPID.Trim());
info.PrepareProjectItem = PPDA.GetPPItems(info.mpit_PIPFID);
info.ppmSeq = info.PrepareProjectItem.ppm_iSeq;
returnList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
return returnList;
}
public List<MachineStopReasonProfile_msrp_Info> GetStopReasonByReasonID(int ReasonID)
{
List<MachineStopReasonProfile_msrp_Info> returnList = null;
try
{
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
IEnumerable<MachineStopReasonProfile_msrp> searchDatas = from t in db.MachineStopReasonProfile_msrp
where t.msrp_lIsDeleted == false
//orderby t.mpit_PIPFID
select t;
searchDatas = searchDatas.Where(w => w.msrp_iSRPFID ==ReasonID );
Master.MachineMasterDA machineDA = new DAL.SqlDAL.HBPMS.Master.MachineMasterDA();
StopReasonDA stopReadDA = new StopReasonDA();
if (searchDatas != null && searchDatas.Count() > 0)
{
returnList = new List<MachineStopReasonProfile_msrp_Info>();
foreach (MachineStopReasonProfile_msrp item in searchDatas)
{
MachineStopReasonProfile_msrp_Info info = Common.General.CopyObjectValue<MachineStopReasonProfile_msrp, MachineStopReasonProfile_msrp_Info>(item);
info.MachineItem = machineDA.GetMachineItem(info.msrp_cMachineID .Trim());
info.StopReasonItem = stopReadDA.DisplayRecord(ReasonID);
info.mtrSeq = info.StopReasonItem.srm_iSeq;
returnList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
catch (Exception Ex)
{
throw Ex;
}
return returnList;
}
