一、存储过程
1.名称:t8_sysGetNewsInfo
CREATE proc t8_sysGetNewsInfo
@userid varchar(255) ,
@nlaiyuan char(255) ,
@nwebsite varchar(255) ,
@nissuer varchar(50) ,
@ntitle varchar(255) ,
@ncontent varchar(8000)
AS
INSERT INTO t8_news(
[userid],[nlaiyuan],[nwebsite],[nissuer],[ntitle],[ncontent])
VALUES(
@userid,@nlaiyuan,@nwebsite,@nissuer,@ntitle,@ncontent)
//添加
public bool InsertNewsInfo(string userid, string ntitle, string nlaiyuan, string nissuer, string nwebsite, string ncontent)
{
MyConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());
MyCommand = new SqlCommand("t8_sysInsertIntoNewsinfo", MyConnection);
MyCommand.CommandType = CommandType.StoredProcedure;
SqlParameter puserid = new SqlParameter("@userid", SqlDbType.VarChar, 255);
puserid.Value = userid;
MyCommand.Parameters.Add(puserid);
SqlParameter pntitle = new SqlParameter("@ntitle", SqlDbType.VarChar, 255);
pntitle.Value = ntitle;
MyCommand.Parameters.Add(pntitle);
SqlParameter pnlaiyuan = new SqlParameter("@nlaiyuan", SqlDbType.VarChar, 255);
pnlaiyuan.Value = nlaiyuan;
MyCommand.Parameters.Add(pnlaiyuan);
SqlParameter pnissuer = new SqlParameter("@nissuer", SqlDbType.VarChar, 50);
pnissuer.Value = nissuer;
MyCommand.Parameters.Add(pnissuer);
SqlParameter pnwebsite = new SqlParameter("@nwebsite", SqlDbType.VarChar, 255);
pnwebsite.Value = nwebsite;
MyCommand.Parameters.Add(pnwebsite);
SqlParameter pncontent = new SqlParameter("@ncontent", SqlDbType.VarChar,8000);
pncontent.Value = ncontent;
MyCommand.Parameters.Add(pncontent);
MyConnection.Open();
int result;
result = MyCommand.ExecuteNonQuery();
MyConnection.Close();
if (result > 0)
{
return true;
}
else
{
return false;
}
}
//读取
public SqlDataReader GetNewsInfo(string nlinkid)
{
MyConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());
MyCommand = new SqlCommand("t8_sysGetNewsInfo", MyConnection);
MyCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pnlinkid = new SqlParameter("@nlinkid", SqlDbType.VarChar, 255);
pnlinkid.Value = nlinkid;
MyCommand.Parameters.Add(pnlinkid);
MyConnection.Open();
SqlDataReader dr = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}