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