public RICheckItemModel GetById(string id) { var query = new Sql("select * from [APlatformAppSchema].[lnRICheckItem] where DocID=@0 and IsDelete=0", new SqlParameter { DbType = DbType.String, Value = id }); RICheckItemModel checkItem = null; try { checkItem = Mapper.Map <RICheckItemModel>(lnRICheckItem.SingleOrDefault(query)); } catch (Exception ex) { } return(checkItem); }
public RICheckItemModel UpdateCheckItem(RICheckItemModel cplnRICheckItem) { lnRICheckItem result = null; try { result = Mapper.Map <lnRICheckItem>(cplnRICheckItem); result.Update(); } catch (Exception ex) { LogHelper.Error <lnRICheckItemDataProvider>("Update RICheckitem Failed! \n", ex); } cplnRICheckItem = Mapper.Map <RICheckItemModel>(result); return(cplnRICheckItem); }
public void UpdateCheckItem2(RICheckItemModel et) { _lnRICheckItemDataProvider.UpdateCheckItem2(et); }
public RICheckItemModel UpdateCheckItem(RICheckItemModel cplnRICheckItem) { return(_lnRICheckItemDataProvider.UpdateCheckItem(cplnRICheckItem)); }
public RICheckItemModel AddCheckItem(RICheckItemModel cplnRICheckItem) { return(_lnRICheckItemDataProvider.AddCheckItem(cplnRICheckItem)); }
public void UpdateCheckItem2(RICheckItemModel _et) { var query = new Sql(@" UPDATE [APlatformAppSchema].[lnRICheckItem] SET Version = @0, IsLatest = @1, UPDATETIME = GETDATE(), Penalty = @2, Path = @3, IsDelete = @4, MetaPath = @5, CheckItemContent = @6, ReasonCodes = @7, Importance = @8, Risk = @9, HasMeta = @10, UnderReview = @13 WHERE DocID = @11 AND EntityID = @12 ", new SqlParameter { Value = _et.Version } , new SqlParameter { Value = _et.IsLatest } , new SqlParameter { Value = _et.Penalty } , new SqlParameter { Value = _et.Path } , new SqlParameter { Value = _et.IsDelete } , new SqlParameter { Value = _et.MetaPath } , new SqlParameter { Value = _et.CheckItemContent } , new SqlParameter { Value = _et.ReasonCodes } , new SqlParameter { Value = _et.Importance } , new SqlParameter { Value = _et.Risk } , new SqlParameter { Value = _et.HasMeta } , new SqlParameter { Value = _et.DocID } , new SqlParameter { Value = _et.EntityID } , new SqlParameter { Value = _et.UnderReview } ); try { lnRICheckItem.repo.Execute(query); } catch (Exception ex) { } }
public RICheckItemModel AddCheckItem(RICheckItemModel cplnRICheckItem) { var sql = new Sql(@"INSERT INTO [APlatformAppSchema].[lnRICheckItem] ([DocID] ,[EntityID] ,[Version] ,[IsLatest] ,[CREATETIME] ,[UPDATETIME] ,[Path] ,[IsDelete] ,[MetaPath] ,[Title] ,[ReasonCodes] ,[Importance] ,[Risk] ,[EffectiveDate] ,[HasMeta] ,[CheckItemContent] ,[Penalty],[UnderReview]) VALUES (@0 ,@1 ,@2 ,@3 ,@4 ,@5 ,@6 ,@7 ,@8 ,@9 ,@10 ,@11 ,@12 ,@13 ,@14 ,@15 ,@16,@17)", new SqlParameter { Value = cplnRICheckItem.DocID }, new SqlParameter { Value = cplnRICheckItem.EntityID }, new SqlParameter { Value = cplnRICheckItem.Version }, new SqlParameter { Value = cplnRICheckItem.IsLatest }, new SqlParameter { Value = cplnRICheckItem.CREATETIME }, new SqlParameter { Value = cplnRICheckItem.UPDATETIME }, new SqlParameter { Value = cplnRICheckItem.Path }, new SqlParameter { Value = cplnRICheckItem.IsDelete }, new SqlParameter { Value = cplnRICheckItem.MetaPath }, new SqlParameter { Value = cplnRICheckItem.Title }, new SqlParameter { Value = cplnRICheckItem.ReasonCodes }, new SqlParameter { Value = cplnRICheckItem.Importance }, new SqlParameter { Value = cplnRICheckItem.Risk }, new SqlParameter { Value = cplnRICheckItem.EffectiveDate }, new SqlParameter { Value = cplnRICheckItem.HasMeta }, new SqlParameter { Value = cplnRICheckItem.CheckItemContent }, new SqlParameter { Value = cplnRICheckItem.Penalty }, new SqlParameter { Value = cplnRICheckItem.UnderReview }); RICheckItemModel result = null; try { var ItemId = lnRICheckItem.Fetch(sql); result = Mapper.Map <RICheckItemModel>(cplnRICheckItem); } catch (Exception ex) { LogHelper.Error <lnRICheckItemDataProvider>("Add lnRICheckItem Failed! \n", ex); } return(result); }