在前台根据用户填写资料的完整性或者真实性来显示用户的诚信度 这个诚信度要用在前台用小星星显示,诚信度越高,星星就越多,希望高手们给出自己的方法。
解决方案 »
- 将cookieless="true"之后Url如http://localhost/Mobile/(S(3qafbh55ruyijiatmx)
- 偶尔出现 列XXX 不再table中 刷新一下就好了 怎么回事啊
- JScript 运行时错误: getElementById(...)' 为空或不是对象
- TreeView显示文件目录,右边显示文件
- 调试时的问题
- 初学者想提个问题,希望大家能帮帮我,谢谢
- 选择目录
- 怎么让ListItem支持html代码?
- 请教高手啊!!!datagrid能否显示出以(image)格式记下sql server下的的图片!
- 高手进,asp.net子线程弹无法弹出自己定义对话框
- 动态生成控件过多时点击操作为什么会有延时?
- 用Request.Form["TextBox"]跟用TextBox.Text两者之间的优缺点
参考
自己在数据库里设个字段就行
@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=3using 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();
}
}