public ActionResult Add(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.Add(conn, model) == false) { throw new Exception("更新错误"); } } return RedirectToAction("index"); } catch (Exception exp) { ModelState.AddModelError("Error", exp.Message); return View(model); } }
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; }
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 string GetDataNodeConnectString(tb_datanode_model model) { return SystemParamConfig.Consumer_DataNode_ConnectString_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); }
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; }