//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; }