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