/* 依 KEY_ID 取得新序號(String)*/ public string getSerialKey(string keyId) { logger.Debug("get new id by key"); SYS_KEY_SERIAL SnKey = null; String sKey = null; using (var context = new topmepEntities()) { //1.取得現有序號值 string esql = @"SELECT * FROM SYS_KEY_SERIAL AS serialKey WHERE serialKey.KEY_ID=@keyId"; SnKey = context.SYS_KEY_SERIAL.SqlQuery(esql, new SqlParameter("keyId", keyId)).First(); logger.Debug("get new key :" + SnKey.KEY_ID + "=" + SnKey.KEY_NO); sKey = SnKey.KEY_NO.ToString().Trim(); //2.將序號補0 while ((sKey.Length + +SnKey.PREFIX.Length) < SnKey.KEY_LEN) { sKey = "0" + sKey; } SnKey.KEY_NO = SnKey.KEY_NO + 1; int i = context.SaveChanges(); logger.Info("Update SerialKey: Status =" + i); sKey = SnKey.PREFIX + sKey; logger.Info("New KEY :" + SnKey.KEY_ID + "=" + sKey); } return(sKey); }
/*增加序號記錄欄位*/ public bool addSerialKey(SYS_KEY_SERIAL serialKey) { bool status = false; using (var context = new topmepEntities()) { context.SYS_KEY_SERIAL.Add(serialKey); //_db.AddToSYS_KEY_SERIAL(serialKey); int i = context.SaveChanges(); logger.Debug("Add SerialKey : SerialKey=" + serialKey.KEY_ID + ",status=" + i); if (i > 0) { status = true; } ; } return(status); }