internal bool EditDicDtlComm(DictionDtl dtl)
{
string sql = string.Format("UPDATE diction_dtl set name = '{0}', `order` = '{1}' where id = {2}'", dtl.name, dtl.order, dtl.id);
int row = mSql.ExcuteSql(sql);
return(row >= 1);
}
internal bool EditDicDtlValue(DictionDtl dtl, ValueTypeE dicType)
{
string sql = string.Format("UPDATE diction_dtl set updatetime = {0}, ", GetTimeOrNull(DateTime.Now));
switch (dicType)
{
case ValueTypeE.Integer:
sql += string.Format("int_value = '{0}'", dtl.int_value);
break;
case ValueTypeE.Boolean:
sql += string.Format("bool_value = {0}", dtl.bool_value);
break;
case ValueTypeE.String:
sql += string.Format("string_value = '{0}'", dtl.string_value);
break;
case ValueTypeE.Double:
sql += string.Format("double_value = '{0}'", dtl.double_value);
break;
case ValueTypeE.UInteger:
sql += string.Format("uint_value = '{0}'", dtl.uint_value);
break;
default:
sql += "1=1";
break;
}
sql += string.Format(" where id = {0}", dtl.id);
int row = mSql.ExcuteSql(sql);
return(row >= 1);
}
public void SetValue(DictionDtl oldv, DictionDtl newv, ValueTypeE type)
{
oldv.order = newv.order;
oldv.name = newv.name;
switch (type)
{
case ValueTypeE.Integer:
oldv.int_value = newv.int_value;
break;
case ValueTypeE.Boolean:
oldv.bool_value = newv.bool_value;
break;
case ValueTypeE.String:
oldv.string_value = newv.string_value;
break;
case ValueTypeE.Double:
oldv.double_value = newv.double_value;
break;
case ValueTypeE.UInteger:
oldv.uint_value = newv.uint_value;
break;
default:
break;
}
}
internal bool AddDictionDtl(DictionDtl dtl, ValueTypeE dicType)
{
string sql = "INSERT INTO `diction_dtl`(`diction_id`, `code`, `name`, `int_value`, `bool_value`, `string_value`, `double_value`, `uint_value`, `order`) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', {4}, '{5}', '{6}', '{7}', '{8}')";
sql = string.Format(sql, dtl.diction_id, dtl.code, dtl.name, dtl.int_value, dtl.bool_value, dtl.string_value, dtl.double_value, dtl.uint_value, dtl.order);
int row = mSql.ExcuteSql(sql);
return(row >= 1);
}
public void UpdateVersion(string dictag)
{
DictionDtl dtl = GetDtlInCode(dictag);
if (dtl != null)
{
dtl.int_value++;
PubMaster.Mod.DicSql.EditDicDtlValue(dtl, ValueTypeE.Integer);
}
}
public bool IsVersionDiffer(VersionDic pack)
{
DictionDtl dtl = GetDtlInCode(pack.Name);
if (dtl != null)
{
return(dtl.int_value != pack.Version);
}
return(false);
}
public bool AddDictionDtl(DictionDtl dtl, ValueTypeE dicType, out string result)
{
result = "";
if (!PubMaster.Mod.DicSql.AddDictionDtl(dtl, dicType))
{
result = "添加失败！";
return(false);
}
Refresh(false, true);
return(true);
}
public bool AddDictionDtl(DictionDtl dtl, ValueTypeE dicType, out string result)
{
result = "";
if (!PubMaster.Mod.DicSql.AddDictionDtl(dtl, dicType))
{
result = "添加失败！";
return(false);
}
mLog.Info(true, string.Format(@"在字典ID【{0}】里,添加字典细节{1}", dtl.diction_id, dtl.ToString()));
Refresh(false, true);
return(true);
}
public string GetDtlStrCode(string code, out byte level)
{
DictionDtl dtl = DicDtlList.Find(c => c.code.Equals(code));
if (dtl != null)
{
level = dtl.level;
return(dtl?.string_value ?? code);
}
level = 0;
return(code);
}
public uint GenerateID(string dictag)
{
DictionDtl dtl = DicDtlList.Find(c => dictag.Equals(c.code));
if (dtl != null)
{
uint uvalue = dtl.uint_value;
dtl.uint_value = uvalue + 1;
PubMaster.Mod.DicSql.EditDicDtlValue(dtl, ValueTypeE.UInteger);
return(uvalue);
}
return(0);
}
public bool EditDictionDtl(DictionDtl dtl, ValueTypeE dicType, out string result)
{
result = "";
DictionDtl d = GetDictionDtl(dtl.id);
SetValue(d, dtl, dicType);
if (!PubMaster.Mod.DicSql.EditDicDtlValue(d, dicType))
{
result = "添加失败！";
return(false);
}
Refresh(false, true);
return(true);
}
public bool EditDictionDtl(DictionDtl dtl, ValueTypeE dicType, out string result)
{
result = "";
DictionDtl d = GetDictionDtl(dtl.id);
SetValue(d, dtl, dicType);
if (!PubMaster.Mod.DicSql.EditDicDtlValue(d, dicType))
{
result = "添加失败！";
return(false);
}
mLog.Info(true, string.Format(@"在字典ID【{0}】里,编辑字典细节{1}", d.diction_id, d.ToString()));
Refresh(false, true);
return(true);
}
public bool UpdateSwitch(string tag, bool onoff, bool fromrf)
{
DictionDtl dtl = GetDtlInCode(tag);
if (dtl != null && dtl.bool_value != onoff)
{
dtl.bool_value = onoff;
PubMaster.Mod.DicSql.EditDicDtlValue(dtl, ValueTypeE.Boolean);
if (fromrf)
{
Messenger.Default.Send(dtl, MsgToken.TaskSwitchUpdate);
}
return(true);
}
return(false);
}