コード例 #1
0
ファイル: MaintainRecordDA.cs プロジェクト: Klutzdon/PBIMSN
 public MaintainRecord_mtr_Info InsertRecord(MaintainRecord_mtr_Info reasonInfo)
 {
     try
     {
         Insert(reasonInfo);
     }
     catch
     {
         throw;
     }
     return reasonInfo;
 }
コード例 #2
0
ファイル: MaintainRecordDA.cs プロジェクト: Klutzdon/PBIMSN
        public List<MaintainRecord_mtr_Info> SearchRecord(MaintainRecord_mtr_Info searchInfo)
        {
            if (searchInfo == null)
            {
                return null;
            }

            try
            {
                List<MaintainRecord_mtr_Info> listRes = new List<MaintainRecord_mtr_Info>();

                StringBuilder strSql = new StringBuilder();
                List<SQLiteParameter> listParam = new List<SQLiteParameter>();
                Dictionary<string, object> Dic = new Dictionary<string, object>();

                strSql.Append(" from MaintainRecord_mtr_Info where 1=1 ");

                if (searchInfo.mtr_lDeleted != null)
                {
                    strSql.AppendLine(" and mtr_lDeleted = :mtr_lDeleted ");
                    Dic.Add("mtr_lDeleted", false);
                }

                if (searchInfo.mtr_iPlanID != null)
                {
                    strSql.AppendLine(" and mtr_iPlanID = :mtr_iPlanID ");
                    Dic.Add("mtr_iPlanID", searchInfo.mtr_iPlanID);
                }

                //listRes = (List<MaintainRecord_mtr_Info>)ExcuteHQL<MaintainRecord_mtr_Info>(strSql.ToString());

                listRes = (List<MaintainRecord_mtr_Info>)FindEntities<MaintainRecord_mtr_Info>(strSql.ToString(), Dic);

                if (searchInfo.mtr_dAddDate.HasValue)
                {
                     listRes.RemoveAll(r => r.mtr_dAddDate.Value.Date != searchInfo.mtr_dAddDate.Value.Date);
                }

                return listRes;
            }
            catch
            {
                throw;
            }
        }
コード例 #3
0
ファイル: MaintainRecordBL.cs プロジェクト: Klutzdon/PBIMSN
 public List<MaintainRecord_mtr_Info> SearchRecord(MaintainRecord_mtr_Info searchInfo)
 {
     throw new NotImplementedException();
 }
コード例 #4
0
ファイル: MaximoHelper.cs プロジェクト: Klutzdon/PBIMSN
        /// <summary>
        /// 保存保存部件清单
        /// </summary>
        /// <param name="p_objMOMInfo"></param>
        /// <param name="p_objMaintainInfo"></param>
        /// <param name="p_lisEquipments"></param>
        /// <returns></returns>
        /// <remarks>(NO:0005078) Add By Leothlink TonyWu On 07/18/2014</remarks>
        public static bool SaveMaintainEquipments(MaintainOperationMaster_mom_Info p_objMOMInfo, MaintainRecord_mtr_Info p_objMaintainInfo, List<MaintainEquipmentMapping_mem_Info> p_lisEquipments)
        {
            List<MaintainOperation> l_lisInsert = new List<MaintainOperation>();

            try
            {
                if (p_lisEquipments.Count > 0)
                {
                    foreach (var l_objEquipment in p_lisEquipments)
                    {
                        MaintainOperation l_objItem = new MaintainOperation()
                        {
                            AddBy = l_objEquipment.mem_cAddBy,
                            AddTime = DateTime.Now,
                            Duration = p_objMOMInfo.mom_iCompleteTime.ToString(),
                            EndTime = p_objMaintainInfo.mtr_dEndTime,
                            EquipNumber = l_objEquipment.mem_cEquipmentNum,
                            IsActive = true,
                            OperationCode = p_objMOMInfo.mom_cOperationCode,
                            OperationName = p_objMOMInfo.mom_cOperationName,
                            OperationType = p_objMOMInfo.mom_cOperationType,
                            ParentEquipNumber = l_objEquipment.mem_cPreEquipmentNum,
                            RecordId = l_objEquipment.mem_cRecordID,
                            StandardFile = p_objMOMInfo.mom_cStandardFilePath,
                            StartTime = p_objMaintainInfo.mtr_dBeginTime,
                            MtrId = p_objMaintainInfo.mtr_RecordID,
                            MtrPlanId = p_objMaintainInfo.mtr_iPlanID == null ? 0 : p_objMaintainInfo.mtr_iPlanID.Value
                        };

                        l_lisInsert.Add(l_objItem);
                    }
                }
                else
                {
                    MaintainOperation l_objItem = new MaintainOperation()
                    {
                        AddBy = "SYSTEM",
                        AddTime = DateTime.Now,
                        Duration = p_objMOMInfo.mom_iCompleteTime.ToString(),
                        EndTime = p_objMaintainInfo.mtr_dEndTime,
                        EquipNumber = "",
                        IsActive = true,
                        OperationCode = p_objMOMInfo.mom_cOperationCode,
                        OperationName = p_objMOMInfo.mom_cOperationName,
                        OperationType = p_objMOMInfo.mom_cOperationType,
                        ParentEquipNumber = "",
                        RecordId = Guid.Empty,
                        StandardFile = p_objMOMInfo.mom_cStandardFilePath,
                        StartTime = p_objMaintainInfo.mtr_dBeginTime,
                        MtrId = p_objMaintainInfo.mtr_RecordID,
                        MtrPlanId = p_objMaintainInfo.mtr_iPlanID == null ? 0 : p_objMaintainInfo.mtr_iPlanID.Value
                    };

                    l_lisInsert.Add(l_objItem);
                }

                _MaximoServiceWS.SaveMaintainList(p_objMaintainInfo.mtr_RecordID, l_lisInsert.ToArray());

                return true;
            }
            catch
            {
                return false;
            }
        }
コード例 #5
0
ファイル: MaintainRecordDA.cs プロジェクト: Klutzdon/PBIMSN
 public MaintainRecord_mtr_Info UpdateRecord(MaintainRecord_mtr_Info reasonInfo)
 {
     try
     {
         Update(reasonInfo);
     }
     catch
     {
         throw;
     }
     return null;
 }