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 PrepareProjectMasterBL()
{
this._prepareProjectMasterDA = new PrepareProjectMasterDA();
}