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);
}
