public static Int32 SubmitAction(UserAction action)
{
switch (action.actionSource)
{
case "ReaderType":
switch (action.actionType)
{
case "Add":
try
{
return(ReaderTypeDAL.Add((ReaderType)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Update":
try
{
return(ReaderTypeDAL.Update((ReaderType)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Delete":
try
{
return(ReaderTypeDAL.Delete((ReaderType)action.actionModel));
}
catch (Exception)
{
return(0);
}
default:
throw new Exception("Error actionType!");
}
case "Reader":
switch (action.actionType)
{
case "Add":
try
{
return(ReaderDAL.Add((Reader)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Update":
try
{
return(ReaderDAL.Update((Reader)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Delete":
try
{
return(ReaderDAL.Delete((Reader)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Password":
try
{
return(ReaderDAL.Password((Reader)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Permission":
try
{
return(ReaderDAL.Permission((Reader)action.actionModel));
}
catch (Exception)
{
return(0);
}
default:
throw new Exception("Error actionType!");
}
case "Book":
switch (action.actionType)
{
case "Add":
try
{
return(BookDAL.Add((Book)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Update":
try
{
return(BookDAL.Update((Book)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Delete":
try
{
return(BookDAL.Delete((Book)action.actionModel));
}
catch (Exception)
{
return(0);
}
default:
throw new Exception("Error actionType!");
}
case "Borrow":
switch (action.actionType)
{
case "Borrow":
try
{
return(BorrowDAL.Borrow((Borrow)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Update":
try
{
return(BorrowDAL.Update((Borrow)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Delete":
try
{
return(BorrowDAL.Delete((Borrow)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Return":
try
{
return(BorrowDAL.Return((Borrow)action.actionModel));
}
catch (Exception)
{
return(0);
}
case "Continue":
try
{
return(BorrowDAL.Continue((Borrow)action.actionModel));
}
catch (Exception)
{
return(0);
}
default:
throw new Exception("Error actionType!");
}
default:
throw (new Exception("Error actionSource!"));
}
}
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
}
private void button2_Click(object sender, EventArgs e)
{
string username = textBox1.Text;
string pwd = textBox2.Text;
if (textBox2.Text != textBox3.Text)
{
MessageBox.Show("密码不一致，请重新输入！");
return;
}
string name = textBox4.Text;
string sex = comboBox1.Text;
string type = comboBox2.Text;
string dept = textBox5.Text;
string phone = textBox6.Text;
string email = textBox7.Text;
Reader rd = new Reader();
rd.rdDateReg = DateTime.Now;
rd.rdDept = dept;
rd.rdEmail = email;
rd.rdHaveBorrowNum = 0;
//rd.rdID
rd.rdName = name;
rd.rdPassword = pwd;
rd.rdPhone = phone;
byte[] picbyte;
if (this.picturePath != null)
{
picbyte = Tools.GetBytesByImagePath(this.picturePath);
}
else
{
picbyte = Tools.GetBytesByImage(pictureBox1);
};
string tpid = "0";
#region
if (comboBox2.Text == "--请选择类型--" || comboBox2.Text == "")
{
MessageBox.Show("请选择类型");
return;
}
else
{
int rows = TypeTmpTable.Rows.Count;
bool exist_flag = false;
for (int i = 0; i < rows; i++)
{
tpid = TypeTmpTable.Rows[i].ItemArray[0].ToString().Trim();
string tp_name = TypeTmpTable.Rows[i].ItemArray[1].ToString().Trim();
string index = (tp_name + "-" + tpid).Trim();
if (index == comboBox2.Text.Trim())
{
exist_flag = true;
break;
}
}
if (!exist_flag)
{
MessageBox.Show("选择的类型不存在!");
return;
}
}
#endregion
rd.rdPhoto = picbyte;
rd.rdSex = sex;
rd.rdStatus = "正常";
rd.rdType = short.Parse(tpid);
rd.rdUsername = username;
try
{
ReaderDAL.Add(rd);
MessageBox.Show("添加成功");
}
catch (Exception ex)
{
MessageBox.Show("添加失败");
return;
}
}
