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