/// <summary> /// SelectInfo /// </summary> /// <param name="id"></param> /// <returns></returns> public InspectionModeInfo SelectInfo(long id) { CodeItemInfo codeItemInfo = dal.GetInfo(id); if (codeItemInfo == null) { throw new Exception("MC:0x00000084");///数据错误 } InspectionModeInfo inspectionModeInfo = new InspectionModeInfo(); inspectionModeInfo.Id = codeItemInfo.Id; inspectionModeInfo.ItemName = codeItemInfo.ItemName; inspectionModeInfo.ItemValue = codeItemInfo.ItemValue.GetValueOrDefault(); inspectionModeInfo.Comments = codeItemInfo.Comments; inspectionModeInfo.ValidFlag = codeItemInfo.ValidFlag.GetValueOrDefault(); inspectionModeInfo.CreateUser = codeItemInfo.CreateUser; inspectionModeInfo.CreateDate = codeItemInfo.CreateDate.GetValueOrDefault(); return(inspectionModeInfo); }
/// <summary> /// InsertInfo /// </summary> /// <param name="info"></param> /// <returns></returns> public bool InsertInfo(InspectionModeInfo info) { int cnt = dal.GetCounts("[ITEM_NAME] = N'" + info.ItemName + "' and [CODE_FID] = N'" + codeFid + "'"); if (cnt > 0) { throw new Exception("MC:0x00000327");///贸易方式不能重复 } CodeItemInfo codeItemInfo = new CodeItemInfo(); codeItemInfo.Fid = Guid.NewGuid(); codeItemInfo.ItemName = info.ItemName; codeItemInfo.ItemValue = dal.GetMaxValue(Guid.Parse(codeFid)) + 10; codeItemInfo.Comments = info.Comments; codeItemInfo.CodeFid = Guid.Parse(codeFid); codeItemInfo.ValidFlag = true; codeItemInfo.CreateUser = info.CreateUser; codeItemInfo.CreateDate = info.CreateDate; return(dal.Add(codeItemInfo) > 0 ? true : false); }
/// <summary> /// GetListByPage /// </summary> /// <param name="textWhere"></param> /// <param name="textOrder"></param> /// <param name="pageIndex"></param> /// <param name="pageRow"></param> /// <param name="dataCount"></param> /// <returns></returns> public List <InspectionModeInfo> GetListByPage(string textWhere, string textOrder, int pageIndex, int pageRow, out int dataCount) { textWhere += " and [CODE_FID] = N'" + codeFid + "'"; dataCount = dal.GetCounts(textWhere); List <CodeItemInfo> codeItemInfos = dal.GetListByPage(textWhere, textOrder, pageIndex, pageRow); List <InspectionModeInfo> inspectionModeInfos = new List <InspectionModeInfo>(); foreach (var codeItemInfo in codeItemInfos) { InspectionModeInfo inspectionModeInfo = new InspectionModeInfo(); inspectionModeInfo.Id = codeItemInfo.Id; inspectionModeInfo.ItemName = codeItemInfo.ItemName; inspectionModeInfo.ItemValue = codeItemInfo.ItemValue.GetValueOrDefault(); inspectionModeInfo.Comments = codeItemInfo.Comments; inspectionModeInfo.ValidFlag = codeItemInfo.ValidFlag.GetValueOrDefault(); inspectionModeInfo.CreateUser = codeItemInfo.CreateUser; inspectionModeInfo.CreateDate = codeItemInfo.CreateDate.GetValueOrDefault(); inspectionModeInfos.Add(inspectionModeInfo); } return(inspectionModeInfos); }