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