/// <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());
}