62,046
社区成员
发帖
与我相关
我的任务
分享
create proc pro_checkIntegrity
@uid int,
@Integrity int output
as
declare @userName varchar(50)
declare @userMonolog varchar(1000)
select @userName=userName,@userMonolog=userMonolog from tb_user where uid=@uid
if(@userName is not null and @userMonolog is null)
set @Integrity=1
if(@userName is not null and @userMonolog is not null)
set @Integrity=3
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Bind();
}
public string userMonolog = string.Empty;
public void Bind()
{
SqlConnection conn = new SqlConnection("Data Source=WWW-E4165B1EB09;Initial Catalog=mm;User ID=sa;pwd=3737");
SqlCommand cmd = new SqlCommand("pro_checkIntegrity", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@uid","13");
cmd.Parameters.Add("@Integrity",SqlDbType.Int);
cmd.Parameters["@Integrity"].Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
string checkIntegrity = cmd.Parameters["@Integrity"].Value.ToString();
if (checkIntegrity == "3")
{
userMonolog += "<img src=\"images/star.gif\">";
}
if (checkIntegrity == "1")
{
userMonolog += "<img src=\"images/star.gif\"><img src=\"images/star.gif\"><img src=\"images/star.gif\"><img src=\"images/star.gif\"><img src=\"images/star.gif\">";
}
conn.Close();
}
}