/// <summary> /// 修改序号 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Update(SequenceEntity entity) { entity.Include(a => new { a.FirstType,a.FirstRule,a.FirstLength,a.SecondType,a.SecondRule,a.SecondLength,a.ThirdType,a.ThirdRule,a.ThirdLength,a.FourType,a.FourRule,a.FourLength,a.JoinChar,a.Sample,a.CurrentValue,a.Remark }); entity.Where(a => a.SN == entity.SN); int line = this.Sequence.Update(entity); return line; }
/// <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> /// 根据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; }
/// <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; }
public ActionResult SN() { string TabName = WebUtil.GetFormValue<string>("TabName", string.Empty); int PageIndex = WebUtil.GetFormValue<int>("PageIndex", 1); int PageSize = WebUtil.GetFormValue<int>("PageSize", 10); SequenceProvider provider = new SequenceProvider(); SequenceEntity entity = new SequenceEntity(); if (!TabName.IsEmpty()) { entity.Where("TabName", ECondition.Like, "%" + TabName + "%"); } PageInfo pageInfo = new PageInfo() { PageIndex = PageIndex, PageSize = PageSize }; List<SequenceEntity> listResult = provider.GetList(entity, ref pageInfo); listResult = listResult.IsNull() ? new List<SequenceEntity>() : listResult; string json = JsonConvert.SerializeObject(listResult); this.ReturnJson.AddProperty("Data", json); this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount); return Content(this.ReturnJson.ToString()); }