public override List <CPFlow> GetFlowMaxTwoVer(int flowId)
{
CPFlowDbContext _db = this._dbContext as CPFlowDbContext;
var q = (from flow in _db.CPFlowCol
where flow.FlowId.Equals(flowId)
orderby flow.FlowVerId descending
select flow).Take(2);
return(q.ToList());
}
public override CPFlow GetFlowMaxVer(int flowId)
{
CPFlowDbContext _db = this._dbContext as CPFlowDbContext;
var q = (from flow in _db.CPFlowCol
where flow.FlowId.Equals(flowId)
orderby flow.FlowVerId descending
select flow).Take(1);
if (q.Count() > 0)
{
return(q.ToList()[0]);
}
else
{
return(null);
}
}
public override List <CPFlow> GetAllFlowMaxVer()
{
DbHelper _helper = new DbHelper("CPCommonIns", CPAppContext.CurDbType());
string strSql = @" SELECT FlowId,MAX(FlowVerId) AS FlowVerId FROM dbo.Flow_Template
GROUP BY FlowId";
DataTable dt = _helper.ExecuteDataTable(strSql);
List <int> col = new List <int>();
foreach (DataRow dr in dt.Rows)
{
col.Add(int.Parse(dr["FlowVerId"].ToString()));
}
CPFlowDbContext _db = this._dbContext as CPFlowDbContext;
var q = (from flow in _db.CPFlowCol
where col.Contains(flow.FlowVerId)
select flow);
return(q.ToList());
}