/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XHD.Model.ecs_set_node model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ecs_set_node(");
strSql.Append("node_year,node_month,node_one1,node_one2,node_two1,node_two2,node_three1,node_three2,node_four1,node_four2,telnum1,telnum2,telnum3,telnum4)");
strSql.Append(" values (");
strSql.Append("@node_year,@node_month,@node_one1,@node_one2,@node_two1,@node_two2,@node_three1,@node_three2,@node_four1,@node_four2,@telnum1,@telnum2,@telnum3,@telnum4)");
MySqlParameter[] parameters =
{
new MySqlParameter("@node_year", MySqlDbType.Int32, 4),
new MySqlParameter("@node_month", MySqlDbType.Int32, 2),
new MySqlParameter("@node_one1", MySqlDbType.Int32, 2),
new MySqlParameter("@node_one2", MySqlDbType.Int32, 2),
new MySqlParameter("@node_two1", MySqlDbType.Int32, 2),
new MySqlParameter("@node_two2", MySqlDbType.Int32, 2),
new MySqlParameter("@node_three1", MySqlDbType.Int32, 2),
new MySqlParameter("@node_three2", MySqlDbType.Int32, 2),
new MySqlParameter("@node_four1", MySqlDbType.Int32, 2),
new MySqlParameter("@node_four2", MySqlDbType.Int32, 2),
new MySqlParameter("@telnum1", MySqlDbType.Int32, 10),
new MySqlParameter("@telnum2", MySqlDbType.Int32, 10),
new MySqlParameter("@telnum3", MySqlDbType.Int32, 10),
new MySqlParameter("@telnum4", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.node_year;
parameters[1].Value = model.node_month;
parameters[2].Value = model.node_one1;
parameters[3].Value = model.node_one2;
parameters[4].Value = model.node_two1;
parameters[5].Value = model.node_two2;
parameters[6].Value = model.node_three1;
parameters[7].Value = model.node_three2;
parameters[8].Value = model.node_four1;
parameters[9].Value = model.node_four2;
parameters[10].Value = model.telnum1;
parameters[11].Value = model.telnum2;
parameters[12].Value = model.telnum3;
parameters[13].Value = model.telnum4;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.ecs_set_node GetModel(int node_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select node_id,node_year,node_month,node_one1,node_one2,node_two1,node_two2,node_three1,node_three2,node_four1,node_four2,telnum1,telnum2,telnum3,telnum4 from ecs_set_node ");
strSql.Append(" where node_id=@node_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@node_id", MySqlDbType.Int32)
};
parameters[0].Value = node_id;
XHD.Model.ecs_set_node model = new XHD.Model.ecs_set_node();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XHD.Model.ecs_set_node model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ecs_set_node set ");
strSql.Append("node_year=@node_year,");
strSql.Append("node_month=@node_month,");
strSql.Append("node_one1=@node_one1,");
strSql.Append("node_one2=@node_one2,");
strSql.Append("node_two1=@node_two1,");
strSql.Append("node_two2=@node_two2,");
strSql.Append("node_three1=@node_three1,");
strSql.Append("node_three2=@node_three2,");
strSql.Append("node_four1=@node_four1,");
strSql.Append("node_four2=@node_four2,");
strSql.Append("telnum1=@telnum1,");
strSql.Append("telnum2=@telnum2,");
strSql.Append("telnum3=@telnum3,");
strSql.Append("telnum4=@telnum4");
strSql.Append(" where node_id=@node_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@node_year", MySqlDbType.Int32, 4),
new MySqlParameter("@node_month", MySqlDbType.Int32, 2),
new MySqlParameter("@node_one1", MySqlDbType.Int32, 2),
new MySqlParameter("@node_one2", MySqlDbType.Int32, 2),
new MySqlParameter("@node_two1", MySqlDbType.Int32, 2),
new MySqlParameter("@node_two2", MySqlDbType.Int32, 2),
new MySqlParameter("@node_three1", MySqlDbType.Int32, 2),
new MySqlParameter("@node_three2", MySqlDbType.Int32, 2),
new MySqlParameter("@node_four1", MySqlDbType.Int32, 2),
new MySqlParameter("@node_four2", MySqlDbType.Int32, 2),
new MySqlParameter("@telnum1", MySqlDbType.Int32, 10),
new MySqlParameter("@telnum2", MySqlDbType.Int32, 10),
new MySqlParameter("@telnum3", MySqlDbType.Int32, 10),
new MySqlParameter("@telnum4", MySqlDbType.Int32, 10),
new MySqlParameter("@node_id", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.node_year;
parameters[1].Value = model.node_month;
parameters[2].Value = model.node_one1;
parameters[3].Value = model.node_one2;
parameters[4].Value = model.node_two1;
parameters[5].Value = model.node_two2;
parameters[6].Value = model.node_three1;
parameters[7].Value = model.node_three2;
parameters[8].Value = model.node_four1;
parameters[9].Value = model.node_four2;
parameters[10].Value = model.telnum1;
parameters[11].Value = model.telnum2;
parameters[12].Value = model.telnum3;
parameters[13].Value = model.telnum4;
parameters[14].Value = model.node_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.ecs_set_node DataRowToModel(DataRow row)
{
XHD.Model.ecs_set_node model = new XHD.Model.ecs_set_node();
if (row != null)
{
if (row["node_id"] != null && row["node_id"].ToString() != "")
{
model.node_id = int.Parse(row["node_id"].ToString());
}
if (row["node_year"] != null && row["node_year"].ToString() != "")
{
model.node_year = int.Parse(row["node_year"].ToString());
}
if (row["node_month"] != null && row["node_month"].ToString() != "")
{
model.node_month = int.Parse(row["node_month"].ToString());
}
if (row["node_one1"] != null && row["node_one1"].ToString() != "")
{
model.node_one1 = int.Parse(row["node_one1"].ToString());
}
if (row["node_one2"] != null && row["node_one2"].ToString() != "")
{
model.node_one2 = int.Parse(row["node_one2"].ToString());
}
if (row["node_two1"] != null && row["node_two1"].ToString() != "")
{
model.node_two1 = int.Parse(row["node_two1"].ToString());
}
if (row["node_two2"] != null && row["node_two2"].ToString() != "")
{
model.node_two2 = int.Parse(row["node_two2"].ToString());
}
if (row["node_three1"] != null && row["node_three1"].ToString() != "")
{
model.node_three1 = int.Parse(row["node_three1"].ToString());
}
if (row["node_three2"] != null && row["node_three2"].ToString() != "")
{
model.node_three2 = int.Parse(row["node_three2"].ToString());
}
if (row["node_four1"] != null && row["node_four1"].ToString() != "")
{
model.node_four1 = int.Parse(row["node_four1"].ToString());
}
if (row["node_four2"] != null && row["node_four2"].ToString() != "")
{
model.node_four2 = int.Parse(row["node_four2"].ToString());
}
if (row["telnum1"] != null && row["telnum1"].ToString() != "")
{
model.telnum1 = int.Parse(row["telnum1"].ToString());
}
if (row["telnum2"] != null && row["telnum2"].ToString() != "")
{
model.telnum2 = int.Parse(row["telnum2"].ToString());
}
if (row["telnum3"] != null && row["telnum3"].ToString() != "")
{
model.telnum3 = int.Parse(row["telnum3"].ToString());
}
if (row["telnum4"] != null && row["telnum4"].ToString() != "")
{
model.telnum4 = int.Parse(row["telnum4"].ToString());
}
}
return(model);
}
