//public StopReasonMaster_srm_Info SearchRecord_Sqlite(int iRecordID)
//{
// throw new NotImplementedException();
//}
public bool AdjustSequency(int recordID, int level)
{
try
{
//Add by ximonliang 2015-05-21
StopReasonDA DAL = new StopReasonDA();
var selectItem = _IStopReasonDA.DisplayRecord(recordID) as StopReasonMaster_srm_Info;
if (level > 0)
{
DataBaseCommandInfo commandInfo = new DataBaseCommandInfo();
commandInfo.KeyInfoList.Add(new DataBaseCommandKeyInfo() { KeyValue = recordID.ToString() });
//Add by ximonliang 2015-05-21
//var prevItem = _IStopReasonDA.GetRecord_Previous(commandInfo);
var prevItem = DAL.GetTypeRecord_Previous(commandInfo);
selectItem.srm_iSeq = prevItem.srm_iSeq;
_IStopReasonDA.UpdateRecord(selectItem);
prevItem.srm_iSeq = selectItem.srm_iSeq + 1;
_IStopReasonDA.UpdateRecord(prevItem);
return true;
}
else if (level < 0)
{
DataBaseCommandInfo commandInfo = new DataBaseCommandInfo();
commandInfo.KeyInfoList.Add(new DataBaseCommandKeyInfo() { KeyValue = recordID.ToString() });
//Add by ximonliang 2015-05-21
//var nextItem = _IStopReasonDA.GetRecord_Next(commandInfo);
var nextItem = DAL.GetTypeRecord_Next(commandInfo);
selectItem.srm_iSeq = nextItem.srm_iSeq;
_IStopReasonDA.UpdateRecord(selectItem);
nextItem.srm_iSeq = selectItem.srm_iSeq - 1;
_IStopReasonDA.UpdateRecord(nextItem);
return true;
}
return false;
}
catch
{
return false;
}
}
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;
}
