public virtual tb_config_model CreateModel(DataRow dr)
{
var o = new tb_config_model();
//
if (dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//
if (dr.Table.Columns.Contains("configkey"))
{
o.configkey = dr["configkey"].Tostring();
}
//
if (dr.Table.Columns.Contains("configvalue"))
{
o.configvalue = dr["configvalue"].Tostring();
}
//
if (dr.Table.Columns.Contains("remark"))
{
o.remark = dr["remark"].Tostring();
}
//
if (dr.Table.Columns.Contains("lastupdatetime"))
{
o.lastupdatetime = dr["lastupdatetime"].ToDateTime();
}
return(o);
}
public ActionResult Add(tb_config_model model)
{
return(this.Visit(EnumUserRole.Admin, () =>
{
using (DbConn PubConn = DbConn.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_config_dal dal = new tb_config_dal();
model.lastupdatetime = DateTime.Now;
model.configkey = model.configkey.NullToEmpty();
model.configvalue = model.configvalue.NullToEmpty();
model.remark = model.remark.NullToEmpty();
if (model.id == 0)
{
dal.Add(PubConn, model);
}
else
{
dal.Edit(PubConn, model);
}
RedisHelper.RefreashRedisServerIP();
RedisHelper.SendMessage(new RedisCommondInfo()
{
CommondType = EnumCommondType.ConfigUpdate
});
}
return RedirectToAction("index");
}));
}
public ActionResult Update(string key)
{
using (DbConn conn = DbConfig.CreateConn(DataConfig.MqManage))
{
conn.Open();
tb_config_model model = configDal.Get(conn, key);
return(View(model));
}
}
/// <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>()
{
//配置Value
new ProcedureParameter("@value", model.value),
//配置备注信息
new ProcedureParameter("@remark", model.remark)
};
int rev = PubConn.ExecuteSql(@"insert into tb_config(value,remark)
values(@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 virtual bool Add(DbConn PubConn, tb_config_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@configkey", model.configkey),
//
new ProcedureParameter("@configvalue", model.configvalue),
//
new ProcedureParameter("@lastupdatetime", model.lastupdatetime),
//
new ProcedureParameter("@remark", model.remark),
};
int rev = PubConn.ExecuteSql(@"insert into tb_config(configkey,configvalue,remark,lastupdatetime)
values(@configkey,@configvalue,@remark,@lastupdatetime)" , Par);
return(rev == 1);
}
public ActionResult Add(tb_config_model model)
{
using (DbConn conn = DbConfig.CreateConn(DataConfig.MqManage))
{
conn.Open();
bool flag = configDal.Add(conn, model);
if (flag)
{
CacheManage.Remove("configCache");
return(RedirectToAction("index"));
}
else
{
ModelState.AddModelError("Error", "更新错误");
return(View(model));
}
}
}
/// <summary>
/// 获取所有配置信息
/// </summary>
/// <returns></returns>
public IList <tb_config_model> GetList(DbConn conn)
{
return(SqlHelper.Visit((ps) =>
{
IList <tb_config_model> list = new List <tb_config_model>();
DataTable dt = null;
string sql = "SELECT * FROM tb_config WITH(NOLOCK)";
dt = conn.SqlToDataTable(sql, null);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
tb_config_model model = CreateModel(dr);
list.Add(model);
}
}
return list;
}));
}
public virtual bool Edit(DbConn PubConn, tb_config_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@configkey", model.configkey),
//
new ProcedureParameter("@configvalue", model.configvalue),
//
new ProcedureParameter("@remark", model.remark),
//
new ProcedureParameter("@lastupdatetime", model.lastupdatetime),
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_config set configkey=@configkey,configvalue=@configvalue,remark=@remark,lastupdatetime=@lastupdatetime where id=@id", Par);
return(rev == 1);
}
private static string ConfigConn(string key)
{
string mqConn = MqManage;
using (DbConn conn = DbConfig.CreateConn(mqConn))
{
conn.Open();
IList <tb_config_model> list = configDal.GetCacheList(conn, "configCache");
string connect = string.Empty;
if (list != null && list.Count > 0)
{
tb_config_model model = list.Where(q => q.key.Equals(key)).FirstOrDefault();
if (model != null)
{
connect = model.value;
}
}
return(connect);
}
}
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);
}
