/// <summary> /// 更新一条数据 /// </summary> public bool Update(BusinessInfoViewer.Model.detile model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update detile set "); strSql.Append("BusinessID=@BusinessID,"); strSql.Append("DetileURL=@DetileURL,"); strSql.Append("Content=@Content"); strSql.Append(" where DetileID=@DetileID "); MySqlParameter[] parameters = { new MySqlParameter("@BusinessID", MySqlDbType.VarChar, 50), new MySqlParameter("@DetileURL", MySqlDbType.VarChar, 500), new MySqlParameter("@Content", MySqlDbType.VarChar, 5000), new MySqlParameter("@DetileID", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.BusinessID; parameters[1].Value = model.DetileURL; parameters[2].Value = model.Content; parameters[3].Value = model.DetileID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(BusinessInfoViewer.Model.detile model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into detile("); strSql.Append("DetileID,BusinessID,DetileURL,Content)"); strSql.Append(" values ("); strSql.Append("@DetileID,@BusinessID,@DetileURL,@Content)"); MySqlParameter[] parameters = { new MySqlParameter("@DetileID", MySqlDbType.VarChar, 50), new MySqlParameter("@BusinessID", MySqlDbType.VarChar, 50), new MySqlParameter("@DetileURL", MySqlDbType.VarChar, 500), new MySqlParameter("@Content", MySqlDbType.VarChar, 5000) }; parameters[0].Value = model.DetileID; parameters[1].Value = model.BusinessID; parameters[2].Value = model.DetileURL; parameters[3].Value = model.Content; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BusinessInfoViewer.Model.detile DataRowToModel(DataRow row) { BusinessInfoViewer.Model.detile model = new BusinessInfoViewer.Model.detile(); if (row != null) { if (row["DetileID"] != null) { model.DetileID = row["DetileID"].ToString(); } if (row["BusinessID"] != null) { model.BusinessID = row["BusinessID"].ToString(); } if (row["DetileURL"] != null) { model.DetileURL = row["DetileURL"].ToString(); } if (row["Content"] != null) { model.Content = row["Content"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public BusinessInfoViewer.Model.detile GetModel(string DetileID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select DetileID,BusinessID,DetileURL,Content from detile "); strSql.Append(" where DetileID=@DetileID "); MySqlParameter[] parameters = { new MySqlParameter("@DetileID", MySqlDbType.VarChar, 50) }; parameters[0].Value = DetileID; BusinessInfoViewer.Model.detile model = new BusinessInfoViewer.Model.detile(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }