/// <summary> /// 增加一条数据并返回该数据的自增Id /// </summary> public int AddReturnId(Model.News model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into 102s_com_News("); strSql.Append("NewsTitle,AddTime,Content"); strSql.Append(") values ("); strSql.Append("@NewsTitle,@AddTime,@Content"); strSql.Append(");"); strSql.Append("select @Id=@@IDENTITY;"); SqlParameter[] parameters = { new SqlParameter("@NewsTitle", SqlDbType.NVarChar,100) , new SqlParameter("@AddTime", SqlDbType.DateTime) , new SqlParameter("@Content", SqlDbType.NVarChar,-1) , new SqlParameter("@Id", SqlDbType.Int) }; parameters[0].Value = model.NewsTitle; parameters[1].Value = model.AddTime; parameters[2].Value = model.Content; parameters[3].Direction = ParameterDirection.Output; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return int.Parse(parameters[3].Value.ToString()); }
本帖最后由 一片云 于 2016-07-09 14:02 编辑
|