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