public virtual tb_dbsubscribe_config_model CreateModel(DataRow dr)
{
var o = new tb_dbsubscribe_config_model();
//
if(dr.Table.Columns.Contains("f_id"))
{
o.id = dr["f_id"].Toint();
}
//
if(dr.Table.Columns.Contains("f_partitionno"))
{
o.partitionno = dr["f_partitionno"].Tostring();
}
//
if(dr.Table.Columns.Contains("f_partitiontype"))
{
o.partitiontype = dr["f_partitiontype"].Toint();
}
//
if(dr.Table.Columns.Contains("f_dbserver"))
{
o.dbserver = dr["f_dbserver"].Tostring();
}
//
if(dr.Table.Columns.Contains("f_dbname"))
{
o.dbname = dr["f_dbname"].Tostring();
}
//
if(dr.Table.Columns.Contains("f_dbuser"))
{
o.dbuser = dr["f_dbuser"].Tostring();
}
//
if(dr.Table.Columns.Contains("f_dbpass"))
{
o.dbpass = dr["f_dbpass"].Tostring();
}
//
if(dr.Table.Columns.Contains("f_dbtype"))
{
o.dbtype = dr["f_dbtype"].Toint();
}
//������ʱ��
if (dr.Table.Columns.Contains("f_last_update_time"))
{
o.lastUpdateTime = LibConvert.ObjToDateTime(dr["f_last_update_time"]);
}
//�Ƿ�ɾ��
if (dr.Table.Columns.Contains("f_isdel"))
{
o.isDel = LibConvert.ObjToBool(dr["f_isdel"]);
}
return o;
}
public virtual bool Add(DbConn PubConn, tb_dbsubscribe_config_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//
new ProcedureParameter("@f_partitionno", model.partitionno),
//
new ProcedureParameter("@f_partitiontype", model.partitiontype),
//
new ProcedureParameter("@f_dbserver", model.dbserver),
//
new ProcedureParameter("@f_dbname", model.dbname),
//
new ProcedureParameter("@f_dbuser", model.dbuser),
//
new ProcedureParameter("@f_dbpass", model.dbpass),
//
new ProcedureParameter("@f_dbtype", model.dbtype)
};
int rev = PubConn.ExecuteSql(@"insert into tb_dbsubscribe_config(f_partitionno,f_partitiontype,f_dbserver,f_dbname,f_dbuser,f_dbpass,f_dbtype)
values(@f_partitionno,@f_partitiontype,@f_dbserver,@f_dbname,@f_dbuser,@f_dbpass,@f_dbtype)", Par);
return rev == 1;
}
/// <summary>
/// 根据连接字符串模板获取连接字符串
/// </summary>
public static string ReplaceConnectStringTemplate(string connectstringTemplate, DbSubscribeRuleConfig.Model.tb_dbsubscribe_config_model o)
{
if (o == null)
{
throw new Exception("找不到订阅数据库连接分库配置");
}
return(connectstringTemplate.Replace("{partitionno}", o.partitionno + "").Replace("{dbserver}", o.dbserver).Replace("{dbname}", o.dbname)
.Replace("{dbuser}", o.dbuser).Replace("{dbpass}", o.dbpass));
}
public virtual bool Edit(DbConn PubConn, tb_dbsubscribe_config_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//
new ProcedureParameter("@f_partitionno", model.partitionno),
//
new ProcedureParameter("@f_partitiontype", model.partitiontype),
//
new ProcedureParameter("@f_dbserver", model.dbserver),
//
new ProcedureParameter("@f_dbname", model.dbname),
//
new ProcedureParameter("@f_dbuser", model.dbuser),
//
new ProcedureParameter("@f_dbpass", model.dbpass),
//
new ProcedureParameter("@f_dbtype", model.dbtype)
};
Par.Add(new ProcedureParameter("@f_id", model.id));
int rev = PubConn.ExecuteSql("update tb_dbsubscribe_config set f_partitionno=@f_partitionno,f_partitiontype=@f_partitiontype,f_dbserver=@f_dbserver,f_dbname=@f_dbname,f_dbuser=@f_dbuser,f_dbpass=@f_dbpass,f_dbtype=@f_dbtype where f_id=@f_id", Par);
return rev == 1;
}
