/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.storage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into storage("); strSql.Append("storage_name,storage_create_time,storage_area,storage_remain_chest,storage_remain_seat,storage_comment)"); strSql.Append(" values ("); strSql.Append("@storage_name,@storage_create_time,@storage_area,@storage_remain_chest,@storage_remain_seat,@storage_comment)"); MySqlParameter[] parameters = { new MySqlParameter("@storage_name", MySqlDbType.VarChar, 32), new MySqlParameter("@storage_create_time", MySqlDbType.DateTime), new MySqlParameter("@storage_area", MySqlDbType.Decimal, 10), new MySqlParameter("@storage_remain_chest", MySqlDbType.Int32, 32), new MySqlParameter("@storage_remain_seat", MySqlDbType.Int32, 32), new MySqlParameter("@storage_comment", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.storage_name; parameters[1].Value = model.storage_create_time; parameters[2].Value = model.storage_area; parameters[3].Value = model.storage_remain_chest; parameters[4].Value = model.storage_remain_seat; parameters[5].Value = model.storage_comment; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.storage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update storage set "); strSql.Append("storage_name=@storage_name,"); strSql.Append("storage_create_time=@storage_create_time,"); strSql.Append("storage_area=@storage_area,"); strSql.Append("storage_remain_chest=@storage_remain_chest,"); strSql.Append("storage_remain_seat=@storage_remain_seat,"); strSql.Append("storage_comment=@storage_comment"); strSql.Append(" where storage_id=@storage_id"); MySqlParameter[] parameters = { new MySqlParameter("@storage_name", MySqlDbType.VarChar, 32), new MySqlParameter("@storage_create_time", MySqlDbType.DateTime), new MySqlParameter("@storage_area", MySqlDbType.Decimal, 10), new MySqlParameter("@storage_remain_chest", MySqlDbType.Int32, 32), new MySqlParameter("@storage_remain_seat", MySqlDbType.Int32, 32), new MySqlParameter("@storage_comment", MySqlDbType.VarChar, 255), new MySqlParameter("@storage_id", MySqlDbType.Int32, 32) }; parameters[0].Value = model.storage_name; parameters[1].Value = model.storage_create_time; parameters[2].Value = model.storage_area; parameters[3].Value = model.storage_remain_chest; parameters[4].Value = model.storage_remain_seat; parameters[5].Value = model.storage_comment; parameters[6].Value = model.storage_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.storage DataRowToModel(DataRow row) { Model.storage model = new Model.storage(); if (row != null) { if (row["storage_id"] != null && row["storage_id"].ToString() != "") { model.storage_id = int.Parse(row["storage_id"].ToString()); } if (row["storage_name"] != null) { model.storage_name = row["storage_name"].ToString(); } if (row["storage_create_time"] != null && row["storage_create_time"].ToString() != "") { model.storage_create_time = DateTime.Parse(row["storage_create_time"].ToString()); } if (row["storage_area"] != null && row["storage_area"].ToString() != "") { model.storage_area = decimal.Parse(row["storage_area"].ToString()); } if (row["storage_remain_chest"] != null && row["storage_remain_chest"].ToString() != "") { model.storage_remain_chest = int.Parse(row["storage_remain_chest"].ToString()); } if (row["storage_remain_seat"] != null && row["storage_remain_seat"].ToString() != "") { model.storage_remain_seat = int.Parse(row["storage_remain_seat"].ToString()); } if (row["storage_comment"] != null) { model.storage_comment = row["storage_comment"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.storage GetModel(int storage_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select storage_id,storage_name,storage_create_time,storage_area,storage_remain_chest,storage_remain_seat,storage_comment from storage "); strSql.Append(" where storage_id=@storage_id"); MySqlParameter[] parameters = { new MySqlParameter("@storage_id", MySqlDbType.Int32) }; parameters[0].Value = storage_id; Model.storage model = new Model.storage(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }