/* 依 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);
}
