public virtual tb_datanode_model CreateModel(DataRow dr) { var o = new tb_datanode_model(); // if (dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } // if (dr.Table.Columns.Contains("datanodepartition")) { o.datanodepartition = dr["datanodepartition"].Toint(); } // if (dr.Table.Columns.Contains("serverip")) { o.serverip = dr["serverip"].Tostring(); } // if (dr.Table.Columns.Contains("username")) { o.username = dr["username"].Tostring(); } // if (dr.Table.Columns.Contains("password")) { o.password = dr["password"].Tostring(); } return(o); }
/// <summary> /// nodeList /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="count"></param> /// <returns></returns> public IList <tb_datanode_model> GetPageList(DbConn conn, int pageIndex, int pageSize, ref int count) { int tempCount = 0; IList <tb_datanode_model> list = new List <tb_datanode_model>(); var result = SqlHelper.Visit((ps) => { string sql = "SELECT ROW_NUMBER() OVER(ORDER BY Id DESC) AS rownum,* FROM tb_datanode WITH(NOLOCK)"; string countSql = "SELECT COUNT(1) FROM tb_datanode WITH(NOLOCK) "; object obj = conn.ExecuteScalar(countSql, null); if (obj != DBNull.Value && obj != null) { tempCount = LibConvert.ObjToInt(obj); } string sqlPage = string.Concat("SELECT * FROM (", sql.ToString(), ") A WHERE rownum BETWEEN ", ((pageIndex - 1) * pageSize + 1), " AND ", pageSize * pageIndex); DataTable dt = conn.SqlToDataTable(sqlPage, null); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { tb_datanode_model model = CreateModel(dr); list.Add(model); } } return(list); }); count = tempCount; return(result); }
public ActionResult Update(tb_datanode_model model) { try { using (DbConn conn = DbConfig.CreateConn(DataConfig.MqManage)) { conn.Open(); if (model.datanodepartition < 1 || model.datanodepartition >= 100) { throw new Exception("节点编号只允许1~99之间"); } if (nodeDal.IsExist(conn, model.id, model.datanodepartition)) { throw new Exception("节点编号已存在"); } if (nodeDal.Edit(conn, model) == false) { throw new Exception("更新错误"); } } return(RedirectToAction("index")); } catch (Exception exp) { ModelState.AddModelError("Error", exp.Message); return(View(model)); } }
public ActionResult Update(int id) { using (DbConn conn = DbConfig.CreateConn(DataConfig.MqManage)) { conn.Open(); tb_datanode_model model = nodeDal.Get(conn, id); return(View(model)); } }
public static string DataNodeParConn(string node) { using (DbConn conn = DbConfig.CreateConn(DataConfig.MqManage)) { conn.Open(); tb_datanode_model model = nodeDal.GetModelByPartitionId(conn, LibConvert.ObjToInt(node)); if (model != null) { //string configNodeConn = ConfigConn("DataNodeConnectString"); return(string.Format("server={0};Initial Catalog=dyd_bs_MQ_datanode_{1};User ID={2};Password={3};", model.serverip, XXF.BaseService.MessageQuque.BusinessMQ.SystemRuntime.PartitionRuleHelper.PartitionNameRule(LibConvert.ObjToInt(node)) , model.username, model.password)); } return(""); } }
public virtual bool Add(DbConn PubConn, tb_datanode_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@datanodepartition", model.datanodepartition), // new ProcedureParameter("@serverip", model.serverip), // new ProcedureParameter("@username", model.username), // new ProcedureParameter("@password", model.password) }; int rev = PubConn.ExecuteSql(@"insert into tb_datanode(datanodepartition,serverip,username,password) values(@datanodepartition,@serverip,@username,@password)" , Par); return(rev == 1); }
public virtual bool Edit(DbConn PubConn, tb_datanode_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@datanodepartition", model.datanodepartition), // new ProcedureParameter("@serverip", model.serverip), // new ProcedureParameter("@username", model.username), // new ProcedureParameter("@password", model.password) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_datanode set datanodepartition=@datanodepartition,serverip=@serverip,username=@username,password=@password where id=@id", Par); return(rev == 1); }
//public virtual string GetRedisServerIP(DbConn PubConn) //{ // string serverip = GetConfigValue(PubConn, EnumSystemConfigKey.RedisServer.ToString()); // return serverip; //} public virtual string GetDataNodeConnectString(string template, tb_datanode_model model) { return(template.Replace("{server}", model.serverip).Replace("{password}", model.password) .Replace("{username}", model.username).Replace("{database}", SystemParamConfig.DataNode_DataBaseName_Prefix + model.datanodepartition.ToString().PadLeft(2, '0')).Replace("{server}", model.serverip)); }