private void button1_Click(object sender, EventArgs e)
{
string username = textBox1.Text;
string pwd = maskedTextBox1.Text;
string email = textBox2.Text;
if (username == "")
{
MessageBox.Show("管理员用户名不能为空");
return;
}
if (pwd == "" || maskedTextBox2.Text == "")
{
MessageBox.Show("管理员密码不能为空");
return;
}
if (maskedTextBox1.Text != maskedTextBox2.Text)
{
MessageBox.Show("两次输入的密码不一致");
return;
}
Admin adm = new Admin();
adm.adminEmail = email;
adm.adminPassword = pwd;
adm.adminUsername = username;
adm.adminLastLoginDate = DateTime.Now;
try {
AdminDAL.Add(adm);
MessageBox.Show("添加成功");
}catch (Exception ex) {
MessageBox.Show("添加失败！");
}
}
/// <summary>
/// 读取管理员信息
/// </summary>
/// <returns></returns>
public static AdminDAL GetAdmins()
{
AdminDAL admins;
if (File.Exists(adminDocPath))
{
using (FileStream fs = new FileStream(adminDocPath, FileMode.Open, FileAccess.Read))
{
BinaryFormatter bf = new BinaryFormatter();
admins = (AdminDAL)bf.Deserialize(fs);
}
}
else
{
using (FileStream fs = new FileStream(adminDocPath, FileMode.CreateNew, FileAccess.Write))
{
BinaryFormatter bf = new BinaryFormatter();
admins = new AdminDAL();
Admin admin = new Admin("管理员", "A001", "123");
admins.Add(admin);
bf.Serialize(fs, admins);
}
}
return(admins);
}
/// <summary>
/// 添加管理员
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static UserResult Add(AdminModel model)
{
UserResult result = new UserResult();
// 检查输入是否合法
if (!CheckName(model.Name))
{
result.HasError = true;
result.ErrorMessage = "用户名格式错误。";
result.Message = "name";
return(result);
}
if (AdminDAL.CheckEqualName(model.Name))
{
result.HasError = true;
result.ErrorMessage = "用户名重复";
result.Message = "name";
return(result);
}
if (!CheckPassword(model.Pass))
{
result.HasError = true;
result.ErrorMessage = "密码格式错误。";
result.Message = "password";
return(result);
}
//调用加密密码
model.Pass = Encrypt(model.Pass);
// 调用数据层保存
int res = AdminDAL.Add(model);
if (res > 0)
{
result.HasError = false;
return(result);
}
else
{
result.HasError = true;
result.ErrorMessage = "添加失败！";
return(result);
}
}
public static bool Add(Admin a)
{
return(AdminDAL.Add(a));
}
public static void ConnectDataBase()
{
#region DAL.ReaderType测试
Console.WriteLine("DAL.SqlHelper:测试数据库连接...");
SqlHelper.OpenConn();
Console.WriteLine("DAL.SqlHelper:测试数据库关闭...\n");
SqlHelper.CloseConn();
Console.WriteLine("Model.ReaderType:测试创建数据单元...");
ReaderType rdt1 = new ReaderType();
rdt1.rdType = 1;
rdt1.rdTypeName = "admin";
rdt1.maxBorrowDay = 30;
rdt1.maxBorrowNum = 8;
rdt1.maxContinueTimes = 1;
Console.WriteLine("DAL.ReaderType:测试Delete()...");
ReaderTypeDAL.Delete(rdt1);
Console.WriteLine("DAL.ReaderType:测试Add()...");
rdt1.rdType = ReaderTypeDAL.Add(rdt1);
string old_rdTypeName = rdt1.rdTypeName;
rdt1.rdTypeName = "管理员";
Console.WriteLine("DAL.ReaderType:测试Update()...rdType由" + old_rdTypeName + "改为" + rdt1.rdTypeName + "\n");
ReaderTypeDAL.Update(rdt1);
#endregion
#region DAL.Reader测试
Console.WriteLine("Model.Reader:测试创建数据单元...");
Reader rd1 = new Reader();
rd1.rdID = 1;
rd1.rdUsername = "******";
rd1.rdPassword = "******";
rd1.rdName = "duguying";
rd1.rdSex = "男";
rd1.rdType = 1;
rd1.rdDept = "计科院";
rd1.rdPhone = "18900000000";
rd1.rdEmail = "*****@*****.**";
rd1.rdDateReg = DateTime.Now;
rd1.rdPhoto = Encoding.Default.GetBytes("test");
rd1.rdStatus = "正常";
rd1.rdHaveBorrowNum = 1;
Console.WriteLine("DAL.Reader:测试Delete()...");
ReaderDAL.Delete(rd1);
Console.WriteLine("DAL.Reader:测试Add()...");
rd1.rdID = ReaderDAL.Add(rd1);
string old_rdPassword = rd1.rdPassword;
rd1.rdPassword = "******";
Console.WriteLine("DAL.Reader:测试Update()...rdPassword由" + old_rdPassword + "改为" + rd1.rdPassword + "\n");
ReaderDAL.Update(rd1);
#endregion
#region DAL.Borrow测试
Console.WriteLine("Model.Borrow:测试创建数据单元...");
Borrow br1 = new Borrow();
br1.borrowId = 1;
br1.bkId = 1;
br1.ldContinueTimes = 0;
br1.ldDateOut = DateTime.Now;
br1.ldDateRetPlan = DateTime.Now;
br1.ldDateRetAct = DateTime.Now;
br1.ldOverDay = 12;
br1.ldOverMoney = 1.2f;
br1.IsHasReturn = false;
br1.OperatorLendId = 1;
br1.OperatorRetId = 0;
Console.WriteLine("DAL.Borrow:测试Delete()...");
BorrowDAL.Delete(br1);
Console.WriteLine("DAL.Borrow:测试Add()...");
br1.borrowId = (decimal)BorrowDAL.Add(br1);
float old_ldPunishMoney = br1.ldPunishMoney;
br1.ldPunishMoney = 2.4f;
Console.WriteLine("DAL.Borrow:测试Update()...ldPunishMoney由" + old_ldPunishMoney + "改为" + br1.ldPunishMoney + "\n");
BorrowDAL.Update(br1);
#endregion
#region DAL.Book测试
Console.WriteLine("Model.Book:测试创建数据单元...");
Book bk1 = new Book();
bk1.bkId = 1;
bk1.bkCode = "1234";
bk1.bkName = "测试书籍";
bk1.bkAuthor = "作者";
bk1.bkPress = "出版社";
bk1.bkDatePress = DateTime.Now;
bk1.bkISBN = "92520111234";
bk1.bkCatalog = "计算机科学";
bk1.bkLanguage = 0;
bk1.bkPages = 300;
bk1.bkPrice = 30.5f;
bk1.bkDateIn = DateTime.Now;
bk1.bkBrief = "Go语言基础教程";
bk1.bkCover = Encoding.Default.GetBytes("test");
bk1.bkStatus = "在馆";
Console.WriteLine("DAL.Book:测试Delete()...");
BookDAL.Delete(bk1);
Console.WriteLine("DAL.Book:测试Add()...");
bk1.bkId = BookDAL.Add(bk1);
string old_bkName = bk1.bkName;
bk1.bkName = "Go语言云动力";
Console.WriteLine("DAL.Book:测试Update()...bkName由" + old_bkName + "改为" + bk1.bkName + "\n");
BookDAL.Update(bk1);
#endregion
#region DAL.Admin测试
Console.WriteLine("Model.Admin:测试创建数据单元...");
Admin ad1 = new Admin();
ad1.adminId = 1;
ad1.adminUsername = "******";
ad1.adminPassword = "******";
ad1.adminEmail = "*****@*****.**";
ad1.adminLastLoginDate = DateTime.Now;
Console.WriteLine("DAL.Admin:测试Delete()...");
AdminDAL.Delete(ad1);
Console.WriteLine("DAL.Admin:测试Add()...");
ad1.adminId = AdminDAL.Add(ad1);
string old_adminPassword = ad1.adminPassword;
ad1.adminPassword = "******";
Console.WriteLine("DAL.Admin:测试Update()...adminPassword由" + old_adminPassword + "改为" + ad1.adminPassword + "\n");
AdminDAL.Update(ad1);
#endregion
#region 测试数据清理
ReaderTypeDAL.Delete(rdt1);
Console.WriteLine("ReaderType:数据已清理");
ReaderDAL.Delete(rd1);
Console.WriteLine("Reader:数据已清理");
BorrowDAL.Delete(br1);
Console.WriteLine("Borrow:数据已清理");
BookDAL.Delete(bk1);
Console.WriteLine("Book:数据已清理");
AdminDAL.Delete(ad1);
Console.WriteLine("Admin:数据已清理\n");
#endregion
#region DAL.Admin扩展操作测试
AdminDAL.getAdminByUsername("lijun");
#endregion
}
/// <summary>
///Add
/// </summary>
public int Add(Admin model)
{
return(dal.Add(model));
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Admin">数据表实体对象</param>
public static Exception Add(AdminInfo AdminInfo)
{
return(AdminDAL.Add(AdminInfo));
}
private void AdminRegisterBtn_Click(object sender, EventArgs e)
{
AdminDAL.Add(userNameAdminRegTextBox.Text, nameAdminRegTextBox.Text, emailAdminRegTextBox.Text, passAdminRegTextBox.Text);
}
