/// <summary>
/// 维护document和checkitem的关系表
/// </summary>
/// <param name="_list"></param>
/// <param name="_documentid"></param>
private void MaintainRIRelRecordCheckItem(List <RICheckItemModel> _list, string _documentid)
{
//先把原来的documentid的删除
_recordCheckItemService.DeleteRecordCheckItemByDocment(_documentid);
var _r = new RecordCheckItemModel();
int _sort = 0;
foreach (var e in _list)
{
_sort++;
_r.DocID = _documentid;
_r.CheckItemID = e.DocID;
_r.SortOrder = _sort;
_r.IsDelete = false;
_recordCheckItemService.AddlnRIRelRecordCheckItem(_r);
}
//删除旧版本保留新版本的checkitem
List <RICheckItemModel> _listislatest0 = _lnRIRecordDataProvider.GetCheckItemListReadytoRef(_documentid);
foreach (var e1 in _listislatest0)
{
_recordCheckItemService.DeleteRecordCheckItemById(e1.DocID, _documentid);
}
}
public RecordCheckItemModel UpdateRecordCheckItem(RecordCheckItemModel cplnRIRelRecordCheckItem)
{
RecordCheckItemModel result = null;
lnRIRelRecordCheckItem _recordCheckItem = null;
try
{
_recordCheckItem = Mapper.Map <lnRIRelRecordCheckItem>(cplnRIRelRecordCheckItem);
_recordCheckItem.Update();
result = Mapper.Map <RecordCheckItemModel>(_recordCheckItem);
}
catch (Exception ex)
{
LogHelper.Error <lnRIRelRecordCheckItemDataProvider>("Update lnRIRelRecordCheckItem Failed! \n", ex);
}
return(result);
}
public RecordCheckItemModel AddRecordCheckItem(RecordCheckItemModel cplnRIRelRecordCheckItem)
{
RecordCheckItemModel result = null;
lnRIRelRecordCheckItem _recodeCheckItem = null;
try
{
_recodeCheckItem = Mapper.Map <lnRIRelRecordCheckItem>(cplnRIRelRecordCheckItem);
var Id = Convert.ToInt64(_recodeCheckItem.Insert());
result = cplnRIRelRecordCheckItem;
}
catch (Exception ex)
{
LogHelper.Error <lnRIRelRecordCheckItemDataProvider>("Add lnRIRelRecordCheckItem Failed! \n", ex);
}
return(result);
}
private void MaintainRIRelRecordCheckItem2(List <RICheckItemModel> _newlist, string _documentid)
{
var _r = new RecordCheckItemModel();
int _sort = 0;
foreach (var e in _newlist)
{
if (e.IsLatest == true)
{
_sort++;
_r.DocID = _documentid;
_r.CheckItemID = e.DocID;
_r.SortOrder = _sort;
_r.IsDelete = false;
_recordCheckItemService.AddlnRIRelRecordCheckItem(_r);
}
}
}
public RecordCheckItemModel GetById(string id, string docId)
{
var query = new Sql("select * from [APlatformAppSchema].[lnRIRelRecordCheckItem] where CheckItemID=@0 and DocID=@1 and IsDelete=0",
new SqlParameter {
DbType = DbType.String, Value = id
},
new SqlParameter {
DbType = DbType.String, Value = docId
});
RecordCheckItemModel recordCheckItem = null;
try
{
recordCheckItem = Mapper.Map <RecordCheckItemModel>(lnRIRelRecordCheckItem.SingleOrDefault(query));
}
catch (Exception ex)
{
}
return(recordCheckItem);
}
public RecordCheckItemModel UpdateRecordCheckItem(RecordCheckItemModel cplnRIRelRecordCheckItem)
{
return(_lnRIRelRecordCheckItemataProvider.UpdateRecordCheckItem(cplnRIRelRecordCheckItem));
}
public RecordCheckItemModel AddlnRIRelRecordCheckItem(RecordCheckItemModel cplnRIRelRecordCheckItem)
{
return(_lnRIRelRecordCheckItemataProvider.AddRecordCheckItem(cplnRIRelRecordCheckItem));
}
