/// <summary> /// SelectInfo /// </summary> /// <param name="id"></param> /// <returns></returns> public PartGroupInfo SelectInfo(long id) { CodeItemInfo codeItemInfo = dal.GetInfo(id); if (codeItemInfo == null) { throw new Exception("MC:0x00000084");///数据错误 } PartGroupInfo partTypeInfo = new PartGroupInfo(); partTypeInfo.Id = codeItemInfo.Id; partTypeInfo.ItemName = codeItemInfo.ItemName; partTypeInfo.Comments = codeItemInfo.Comments; partTypeInfo.ValidFlag = codeItemInfo.ValidFlag.GetValueOrDefault(); partTypeInfo.CreateUser = codeItemInfo.CreateUser; partTypeInfo.CreateDate = codeItemInfo.CreateDate.GetValueOrDefault(); return(partTypeInfo); }
/// <summary> /// InsertInfo /// </summary> /// <param name="info"></param> /// <returns></returns> public bool InsertInfo(PartGroupInfo info) { int cnt = dal.GetCounts("[ITEM_NAME] = N'" + info.ItemName + "' and [CODE_FID] = N'" + codeFid + "'"); if (cnt > 0) { throw new Exception("MC:0x00000121");///分类不能重复 } CodeItemInfo codeItemInfo = new CodeItemInfo(); codeItemInfo.Fid = Guid.NewGuid(); codeItemInfo.ItemName = info.ItemName; 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 <PartGroupInfo> 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 <PartGroupInfo> partTypeInfos = new List <PartGroupInfo>(); foreach (var codeItemInfo in codeItemInfos) { PartGroupInfo partTypeInfo = new PartGroupInfo(); partTypeInfo.Id = codeItemInfo.Id; partTypeInfo.ItemName = codeItemInfo.ItemName; partTypeInfo.Comments = codeItemInfo.Comments; partTypeInfo.ValidFlag = codeItemInfo.ValidFlag.GetValueOrDefault(); partTypeInfo.CreateUser = codeItemInfo.CreateUser; partTypeInfo.CreateDate = codeItemInfo.CreateDate.GetValueOrDefault(); partTypeInfos.Add(partTypeInfo); } return(partTypeInfos); }