/// <summary>
/// 新增序号管理
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Init()
{
DataTable table = this.Sequence.GetTables();
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
string TabName = row["name"] != null ? row["name"].ToString() : string.Empty;
if (!TabName.IsEmpty())
{
SequenceEntity entity = new SequenceEntity();
entity.Where(a => a.TabName == TabName);
if (this.Sequence.GetCount(entity) == 0)
{
entity = new SequenceEntity();
entity.SN = TNumProivder.CreateGUID();
entity.TabName = TabName;
entity.FirstType = (int)ESequence.Sequence;
entity.FirstRule = "";
entity.FirstLength = 6;
entity.JoinChar = "";
entity.IncludeAll();
this.Sequence.Add(entity);
}
}
}
}
return 0;
}
/// <summary>
/// 查询序列分页
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List<SequenceEntity> GetList(SequenceEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.OrderBy(a => a.ID, EOrderBy.ASC);
int rowCount = 0;
List<SequenceEntity> listResult = this.Sequence.GetList(entity,pageInfo.PageSize,pageInfo.PageIndex,out rowCount);
pageInfo.RowCount = rowCount;
return listResult;
}
/// <summary>
/// 根据表名序列
/// </summary>
/// <param name="TabName"></param>
/// <returns></returns>
public SequenceEntity GetSingle(string TabName)
{
SequenceEntity entity = new SequenceEntity();
entity.IncludeAll();
entity.Where(a => a.TabName == TabName);
entity = this.Sequence.GetSingle(entity);
return entity;
}
/// <summary>
/// 根据SN号获得序列
/// </summary>
/// <param name="SN"></param>
/// <returns></returns>
public SequenceEntity Get(string SN)
{
SequenceEntity entity = new SequenceEntity();
entity.IncludeAll();
entity.Where(a => a.SN == SN);
entity = this.Sequence.GetSingle(entity);
return entity;
}