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 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); }
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 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 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); }