/// <summary> /// 增加一条数据 /// </summary> public int Add(ROYcms.Sys.Model.ROYcms_Shares_News model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into "+ PubConstant.date_prefix + "Shares_News("); strSql.Append("news_id,typename,Time)"); strSql.Append(" values ("); strSql.Append("@news_id,@typename,@Time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@news_id", SqlDbType.Int,4), new SqlParameter("@typename", SqlDbType.NVarChar,50), new SqlParameter("@Time", SqlDbType.DateTime)}; parameters[0].Value = model.news_id; parameters[1].Value = model.typename; parameters[2].Value = model.Time; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 1; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ROYcms.Sys.Model.ROYcms_Shares_News GetModel(int id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 id,news_id,typename,Time from " + PubConstant.date_prefix + "Shares_News "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; ROYcms.Sys.Model.ROYcms_Shares_News model=new ROYcms.Sys.Model.ROYcms_Shares_News(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["id"].ToString()!="") { model.id=int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if(ds.Tables[0].Rows[0]["news_id"].ToString()!="") { model.news_id=int.Parse(ds.Tables[0].Rows[0]["news_id"].ToString()); } model.typename=ds.Tables[0].Rows[0]["typename"].ToString(); if(ds.Tables[0].Rows[0]["Time"].ToString()!="") { model.Time=DateTime.Parse(ds.Tables[0].Rows[0]["Time"].ToString()); } return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ROYcms.Sys.Model.ROYcms_Shares_News model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update "+ PubConstant.date_prefix + "Shares_News set "); strSql.Append("news_id=@news_id,"); strSql.Append("typename=@typename,"); strSql.Append("Time=@Time"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@news_id", SqlDbType.Int,4), new SqlParameter("@typename", SqlDbType.NVarChar,50), new SqlParameter("@Time", SqlDbType.DateTime)}; parameters[0].Value = model.id; parameters[1].Value = model.news_id; parameters[2].Value = model.typename; parameters[3].Value = model.Time; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }