/// <summary> /// InsertInfo /// </summary> /// <param name="info"></param> /// <returns></returns> public bool InsertInfo(BusinessAccountProjectInfo 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 BusinessAccountProjectInfo SelectInfo(long id) { CodeItemInfo codeItemInfo = dal.GetInfo(id); if (codeItemInfo == null) { throw new Exception("MC:0x00000084");///数据错误 } BusinessAccountProjectInfo businessAccountProjectInfo = new BusinessAccountProjectInfo(); businessAccountProjectInfo.Id = codeItemInfo.Id; businessAccountProjectInfo.ItemNameEn = codeItemInfo.ItemNameEn; businessAccountProjectInfo.ItemName = codeItemInfo.ItemName; businessAccountProjectInfo.Comments = codeItemInfo.Comments; businessAccountProjectInfo.ValidFlag = codeItemInfo.ValidFlag.GetValueOrDefault(); businessAccountProjectInfo.CreateUser = codeItemInfo.CreateUser; businessAccountProjectInfo.CreateDate = codeItemInfo.CreateDate.GetValueOrDefault(); return(businessAccountProjectInfo); }
/// <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 <BusinessAccountProjectInfo> 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 <BusinessAccountProjectInfo> businessAccountProjectInfos = new List <BusinessAccountProjectInfo>(); foreach (var codeItemInfo in codeItemInfos) { BusinessAccountProjectInfo businessAccountProjectInfo = new BusinessAccountProjectInfo(); businessAccountProjectInfo.Id = codeItemInfo.Id; businessAccountProjectInfo.ItemNameEn = codeItemInfo.ItemNameEn; businessAccountProjectInfo.ItemName = codeItemInfo.ItemName; businessAccountProjectInfo.Comments = codeItemInfo.Comments; businessAccountProjectInfo.ValidFlag = codeItemInfo.ValidFlag.GetValueOrDefault(); businessAccountProjectInfo.CreateUser = codeItemInfo.CreateUser; businessAccountProjectInfo.CreateDate = codeItemInfo.CreateDate.GetValueOrDefault(); businessAccountProjectInfos.Add(businessAccountProjectInfo); } return(businessAccountProjectInfos); }