/// <summary> /// 更新一条数据 /// </summary> public bool Update(ITCastOCSS.Model.Notice model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Notice set "); strSql.Append("NTitle=@NTitle,"); strSql.Append("NContent=@NContent,"); strSql.Append("NAuthor=@NAuthor,"); strSql.Append("NTime=@NTime"); strSql.Append(" where NID=@NID"); SqlParameter[] parameters = { new SqlParameter("@NTitle", SqlDbType.NVarChar, 100), new SqlParameter("@NContent", SqlDbType.NVarChar, -1), new SqlParameter("@NAuthor", SqlDbType.NVarChar, 20), new SqlParameter("@NTime", SqlDbType.DateTime), new SqlParameter("@NID", SqlDbType.Int, 4) }; parameters[0].Value = model.NTitle; parameters[1].Value = model.NContent; parameters[2].Value = model.NAuthor; parameters[3].Value = model.NTime; parameters[4].Value = model.NID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ITCastOCSS.Model.Notice DataRowToModel(DataRow row) { ITCastOCSS.Model.Notice model = new ITCastOCSS.Model.Notice(); if (row != null) { if (row["NID"] != null && row["NID"].ToString() != "") { model.NID = int.Parse(row["NID"].ToString()); } if (row["NTitle"] != null) { model.NTitle = row["NTitle"].ToString(); } if (row["NContent"] != null) { model.NContent = row["NContent"].ToString(); } if (row["NAuthor"] != null) { model.NAuthor = row["NAuthor"].ToString(); } if (row["NTime"] != null && row["NTime"].ToString() != "") { model.NTime = DateTime.Parse(row["NTime"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ITCastOCSS.Model.Notice model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Notice("); strSql.Append("NTitle,NContent,NAuthor,NTime)"); strSql.Append(" values ("); strSql.Append("@NTitle,@NContent,@NAuthor,@NTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@NTitle", SqlDbType.NVarChar, 100), new SqlParameter("@NContent", SqlDbType.NVarChar, -1), new SqlParameter("@NAuthor", SqlDbType.NVarChar, 20), new SqlParameter("@NTime", SqlDbType.DateTime) }; parameters[0].Value = model.NTitle; parameters[1].Value = model.NContent; parameters[2].Value = model.NAuthor; parameters[3].Value = model.NTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ITCastOCSS.Model.Notice GetModel(int NID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 NID,NTitle,NContent,NAuthor,NTime from Notice "); strSql.Append(" where NID=@NID"); SqlParameter[] parameters = { new SqlParameter("@NID", SqlDbType.Int, 4) }; parameters[0].Value = NID; ITCastOCSS.Model.Notice model = new ITCastOCSS.Model.Notice(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }