?? st_user.cs
字號:
using System;
using System.Data;
using Microsoft.ApplicationBlocks.Data;
namespace STGROUP.ST_ExamBiz
{
/// <summary>
/// ST_User 的摘要說明。
/// </summary>
public class ST_User
{
string st_SqlString = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
public ST_User()
{
//
// TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
}
/// <summary>
/// 插入用戶基本信息
/// </summary>
/// <param name="st_StuInfo"></param>
public void ST_InsertUserInfo(string ST_Name, string ST_Pass, out int ST_Userid)
{
string sqlString = "insert ST_Users(ST_Name,ST_Pass,ST_Type) values('"+ST_Name+"','"+ST_Pass+"','User');select scope_identity();";
object obj = SqlHelper.ExecuteScalar(st_SqlString, CommandType.Text, sqlString);
ST_Userid = int.Parse(obj.ToString());
}
/// <summary>
/// 判斷用戶是否重復(fù)
/// </summary>
/// <param name="st_StuInfo"></param>
public bool ST_IsUserExist(string ST_Name)
{
string sqlString = "select count(ST_Userid) from ST_Users where ST_Name='" + ST_Name + "'";
object obj = SqlHelper.ExecuteScalar(st_SqlString, CommandType.Text, sqlString);
if (obj != null && obj.ToString() != "0")
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 修改用戶基本信息
/// </summary>
/// <param name="st_StuInfo"></param>
public void ST_UpdateUserInfo(string ST_Pass, int ST_UserID)
{
string sqlString = "update ST_Users set ST_Pass='"+ST_Pass+"' where ST_UserID="+ST_UserID;
SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
}
/// <summary>
/// 取得用戶的信息
/// </summary>
/// <param name="ST_DeptID"></param>
/// <returns></returns>
public DataSet ST_GetUserInfo(int ST_UserID)
{
string sqlString = "select * from ST_Users where ST_UserID="+ST_UserID;
return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -