基于C#图书管理系统的设计与实现(6)

conn.Open();

SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Clear();

foreach (SqlParameter parameter in parameters) {

cmd.Parameters.Add(parameter); } try {

str = cmd.ExecuteScalar().ToString(); }

catch (Exception e) {

string msg = e.Message; }

finally {

conn.Close(); cmd.Dispose(); }

return str; }

#endregion

#region 执行SQL语句（增加 删除 修改） ///

/// 执行SQL语句（增加 删除 修改） ///

///

///

public static bool Execsql(string sql, params SqlParameter[] parameters) {

bool flag = false; conn.Open();

SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Clear();

foreach (SqlParameter parameter in parameters) {

cmd.Parameters.Add(parameter); } try {

cmd.ExecuteNonQuery(); flag = true; }

catch (Exception e) {

string msg = e.Message; }

finally {

conn.Close(); cmd.Dispose(); }

return flag; }

#endregion

22

#region 生成SQL参数 ///

/// 生成SQL参数，参数名，值 ///

///

public static SqlParameter MakeParam(string ParamName, string Value) {

return new SqlParameter(ParamName, Value); }

#endregion

///

/// 获取用户组 ///

/// public DataSet GetGroup() {

string sql = \; DataSet ds = GetDataSet(sql); return ds; }

///

/// 获取用户名 ///

///

public DataSet GetUserID(string group) {

string sql = \; DataSet ds = GetDataSet(sql,MakeParam(\,group)); return ds; }

///

/// 检查用户名密码 ///

/// /// /// ///

public DataSet CheckUser(string username, string password,string group) {

string sql = \UserSort=@group\;

DataSet ds = GetDataSet(sql, MakeParam(\, username), MakeParam(\, password),MakeParam(\,group)); return ds; }

///

/// 查询用户信息 ///

/// /// /// /// ///

23

public DataSet SelectUser(bool ch1, bool ch2, string username, string group) {

string sql = \; if (ch1) {

sql += \; }

if (ch2) {

sql += \; }

DataSet ds = GetDataSet(sql,MakeParam(\,group),MakeParam(\,username)); return ds; }

///

/// 添加用户 ///

///

public bool InsertUsers(string username,string password,string group) {

string sql=\(@username,@password,@group)\; bool flag =

Execsql(sql,MakeParam(\,username),MakeParam(\,password),MakeParam(\,group)); return flag; }

///

/// 更新用户组 ///

///

public bool UpdateUserGroup(string username, string group1,string group2) {

string sql = \Users set UserSort=@group2 where UserID=@username and UserSort=@group1\; bool flag =

Execsql(sql,MakeParam(\,group2),MakeParam(\,username),MakeParam(\,group1)); return flag; }

///

/// 通过用户名获取用户组 ///

///

public DataSet GetGroup(string username) {

string sql = \; DataSet ds = GetDataSet(sql,MakeParam(\,username)); return ds; }

///

24

/// 根据用户名删除用户 ///

///

public bool DeleteUser(string username) {

string sql = \; bool flag = Execsql(sql,MakeParam(\,username)); return flag; }

///

/// 获取新用户名 ///

/// public string GetUserID() {

string sj = DateTime.Now.ToString(\);

string sql = \; int i =Convert.ToInt32(GetFirstRow(sql,MakeParam(\,sj+\)))+1; string userid = sj + i.ToString().PadLeft(3,'0'); return userid; }

///

/// 获取新用户名 ///

/// public string GetReaderID() {

string sj = DateTime.Now.ToString(\);

string sql = \; int i = Convert.ToInt32(GetFirstRow(sql, MakeParam(\, sj + \))) + 1; string readerid = sj + i.ToString().PadLeft(3, '0'); return readerid; }

///

/// 插入读者数据 ///

///

public bool InsertReader(string id, string name, string psw, string sex, string age, string dept, string pro) {

bool flag1,flag2;

string sql1 = @\

(ReaderID,ReaderName,ReaderPassword,ReaderSex,ReaderAge,ReaderDept,ReaderPro,BorrowingAmount,IsLost) values (@id,@name,@psw,@sex,@age,@dept,@pro,0,'否')\; flag1 =

Execsql(sql1,MakeParam(\,id),MakeParam(\,name),MakeParam(\,psw),MakeParam(\,sex),MakeParam(\,age),MakeParam(\,dept),MakeParam(\,pro));

string sql2 = \

25

(@userid,@userpassword,'普通用户')\;

flag2 = Execsql(sql2,MakeParam(\,id),MakeParam(\,psw)); return flag1 && flag2; }

///

/// 获取读者ID ///

///

public DataSet GetReaderID_1() {

string sql = \; DataSet ds = GetDataSet(sql); return ds; }

///

/// 根据读者ID获取信息 ///

///

public DataSet GetReader(string id) {

string sql = \; DataSet ds = GetDataSet(sql,MakeParam(\,id)); return ds; }

///

/// 更新读者信息 ///

///

public bool UpdateReader(string id, string name, string psw, string sex, string age, string dept, string pro) {

string sql=\

ReaderName=@name,ReaderPassword=@psw,ReaderSex=@sex,ReaderAge=@age,ReaderDept=@dept,ReaderPro=@pro where ReaderID=@id\; bool

flag=Execsql(sql,MakeParam(\,name),MakeParam(\,psw),MakeParam(\,sex),MakeParam(\,age),MakeParam(\,dept),MakeParam(\,pro),MakeParam(\,id)); return flag; }

///

/// 查询读者信息 ///

///

26