日期:2014-05-17 浏览次数:20537 次
//登录方法
public string[] UserLogin(string uname,string upwd)
{
try
{
SqlParameter[] parmer ={
SqlHelper.CreateCommandParameter("@uname",SqlDbType.VarChar,uname),
SqlHelper.CreateCommandParameter("@upwd",SqlDbType.VarChar,upwd),
};
string str = "Select * from users us,TradeUnion Tu where uname=@uname and upwd=@upwd and us.unitid=Tu.tid";
cmd = SqlHelper.CreateDbCommand(str, conn);
cmd.Parameters.AddRange(parmer);
string[] result = new string[3];
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result[0] = dr["qx"].ToString();//权限
result[1] = dr["tname"].ToString();//登录名
result[2] = dr["unitid"].ToString();//真实姓名
dr.Close();
return result;//最后接收的时候也用string[]数据接收数据就ok了
}
else
{
return null;
}
}