/// <summary>
/// Add
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(tb_config_model model, DbConn conn)
{
return SqlHelper.Visit((ps) =>
{
tb_config_model config = Get(conn, model.key);
if (config == null)
return Add(conn, model);
return false;
});
}
public virtual bool Add(DbConn PubConn, tb_config_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
new ProcedureParameter("@key", model.key),
//����Value
new ProcedureParameter("@value", model.value),
//���ñ�ע��Ϣ
new ProcedureParameter("@remark", model.remark)
};
int rev = PubConn.ExecuteSql(@"insert into tb_config([key],value,remark)
values(@key,@value,@remark)", Par);
return rev == 1;
}
public virtual bool Edit(DbConn PubConn, tb_config_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//����Value
new ProcedureParameter("@value", model.value),
//���ñ�ע��Ϣ
new ProcedureParameter("@remark", model.remark)
};
Par.Add(new ProcedureParameter("@key", model.key));
int rev = PubConn.ExecuteSql("update tb_config set value=@value,remark=@remark where [key]=@key", Par);
return rev == 1;
}
public ActionResult Update(tb_config_model model)
{
using (DbConn conn = DbConfig.CreateConn(DataConfig.MqManage))
{
conn.Open();
bool flag = configDal.Edit(conn, model);
if (flag)
{
CacheManage.Remove("configCache");
return RedirectToAction("index");
}
else
{
ModelState.AddModelError("Error", "更新错误");
return View(model);
}
}
}
public virtual tb_config_model CreateModel(DataRow dr)
{
var o = new tb_config_model();
//����Key
if (dr.Table.Columns.Contains("key"))
{
o.key = dr["key"].Tostring();
}
//����Value
if (dr.Table.Columns.Contains("value"))
{
o.value = dr["value"].Tostring();
}
//���ñ�ע��Ϣ
if (dr.Table.Columns.Contains("remark"))
{
o.remark = dr["remark"].Tostring();
}
return o;
}