本文共 2011 字，大约阅读时间需要 6 分钟。
namespace Entity
{ /// <summary> /// 自定义主键编码 /// </summary> public enum PkIdRecordCode { /// <summary> /// OrderID /// </summary> OR = 10, /// <summary> /// ProductID /// </summary> PR = 30, /// <summary> /// StoreID /// </summary> ST = 40, /// <summary> /// UserID /// </summary> US = 20, } /// <summary> /// 含有自增主键性质的表枚举 /// </summary> public enum PKIDTable { /// <summary> /// 地区信息 /// </summary> Areas = 1, /// <summary> /// 银行信息 /// </summary> BankInfos = 2, /// <summary> /// 商品虚拟分类属性 /// </summary> CategoryPropertys = 3,}
}
/// <summary>
/// 代替数据库的自增主键的解决方案，解决了批量导数据ID出错的问题 /// </summary> /// <param name="code"></param> /// <returns></returns> public int GetNewPKID(Entity.PKIDTable code) //由后后台也要建立用户，所以把它改为public -zhangzhanling { string _code = null;int idNum = 0;
using (TransactionScope transactionScope = new TransactionScope()) { try { _code = Enum.GetName(typeof(Entity.PKIDTable), code); idNum = base._db.ExecuteQuery<int>("UPDATE PkIdTable SET IDNum= IDNum+1 WHERE Code={0};select IDNum from PkIdTable WHERE Code = {0}", _code).Single(); transactionScope.Complete(); transactionScope.Dispose(); return idNum; } catch (Exception ex) { throw ex; } finally { transactionScope.Dispose(); } } } /// <summary> /// 一些特殊的主键，需要有固定的位数，当位数的数字不够时，在前面补0 /// </summary> /// <param name="code"></param> /// <returns></returns> public string GetNewID(Entity.PkIdRecordCode code) //由后后台也要建立用户，所以把它改为public -zhangzhanling { string _code = null;int idNum = 0;
using (TransactionScope transactionScope = new TransactionScope()) { try { _code = Enum.GetName(typeof(Entity.PkIdRecordCode), code); idNum = base._db.ExecuteQuery<int>("UPDATE PkIdRecords SET IDNum= IDNum+1 WHERE Code={0};select IDNum from PkIdRecords WHERE Code = {0}", _code).Single(); transactionScope.Complete(); transactionScope.Dispose(); return string.Format("{0}{1}", (int)code, idNum.ToString().PadLeft(6, '0')); } catch (Exception ex) { throw ex; } finally { transactionScope.Dispose(); } } }数据库结构
本文转自博客园张占岭（仓储大叔）的博客，原文链接：，如需转载请自行联系原博主。