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