public bool AddSettingValue(Setting entity)
{
string strSql = string.Format("insert into setting ({0}) values ('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", DbFields.SETTING,
entity.ID, entity.ApplicationID, entity.MD5, entity.Key, entity.Value, entity.Version, entity.IsUnique, entity.Description, entity.LastOperator, entity.CreateTime, entity.UpdateTime);
return DbHelper.ExecteNonQuery(strSql) > 0;
}
public bool UpdateSettingValue(Setting entity)
{
return false;
}
private Setting GetSettingModel(string strSql)
{
Setting entity = null;
var sdr = DbHelper.ExceuteReader(strSql);
while (sdr.Read())
{
entity = new Setting
{
ID = sdr["Id"].ToString(),
ApplicationID = sdr["ApplicationId"].ToString(),
MD5 = sdr["md5"].ToString(),
Key = sdr["key"].ToString(),
Value = sdr["value"].ToString(),
IsUnique = Convert.ToBoolean(sdr["isunique"]),
Description = sdr["description"].ToString(),
Version = sdr["version"].ToString(),
LastOperator = sdr["lastOperator"].ToString(),
CreateTime = Convert.ToDateTime(sdr["createtime"]),
UpdateTime = Convert.ToDateTime(sdr["updatetime"])
};
}
sdr.Close();
return entity;
}
