static void Main()
{
Model.Reader k = new Model.Reader();
k.rdID = 1;
k.rdName = "马设废";
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new admain_frm(k));
//Application.Run(new borrow_frm(k));
Application.Run(new login_frm());
}
//删除操作
public static int Delete(Reader reader)
{
int rows = 0;
string sql = "delete from Reader where rdID=@rdID";
SqlParameter[] parameters = { new SqlParameter("@rdID", reader.rdID) };
try
{
rows = SqlHelper.ExecuteNonQuery(sql, parameters);
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return rows;
}
public Reader(Reader rt)
{
this.rdID = rt.rdID;
this.rdName = rt.rdName;
this.rdSex = rt.rdSex;
this.rdType = rt.rdType;
this.rdDept = rt.rdDept;
this.rdPhone = rt.rdPhone;
this.rdEmail = rt.rdEmail;
this.rdDateReg = rt.rdDateReg;
this.rdPhoto = rt.rdPhoto;
this.rdStatus = rt.rdStatus;
this.rdBorrowQty = rt.rdBorrowQty;
this.rdPwd = rt.rdPwd;
this.rdAdminRoles = rt.rdAdminRoles;
}
private void btnLogin_Click(object sender, EventArgs e)
{
loginTimes++;
int rdID;
rdID = Convert.ToInt32(txtUserID.Text.Trim());
reader = ReaderAdmin.GetReader(rdID);
if (reader == null)
{
txtUserID.Focus();
lblReaderInfo.Text = "登录信息：查无此人..{" + loginTimes.ToString() + "}";
}
else
{
if (reader.rdPwd == txtUserPwd.Text)
{
this.DialogResult = DialogResult.OK;//登录成功
}
else
{
txtUserPwd.Text = "";
txtUserPwd.Focus();
lblReaderInfo.Text = "登录信息：..密码错误！{" + loginTimes.ToString() + "}";
}
}
//使用下面方法会导致数据库注入登录，不安全
//SqlConnection conn = new SqlConnection("server=.; database=bookLibrary; integrated security=true");
//conn.Open();
//SqlCommand cmd = conn.CreateCommand();
//cmd.CommandText = string.Format("select count(*) from reader where rdid={0} and rdPwd='{1}'", txtUserID.Text, txtUserPwd.Text);
//int count = Convert.ToInt32(cmd.ExecuteScalar());
//if (count == 0)
//{
// MessageBox.Show("用户登录失败！");
//}
//else
//{
// MessageBox.Show("嘿嘿，登录成功！");
//}
}
//修改密码
public static int UpdatePwd(Reader readerPwd)
{
int rows = 0;
string sql = "update Reader set rdPwd=@rdPwd where rdID=@rdID";
SqlParameter[] parameters ={
new SqlParameter("@rdID",readerPwd.rdID),
new SqlParameter("@rdPwd",readerPwd.rdPwd)
};
try
{
rows = SqlHelper.ExecuteNonQuery(sql, parameters);
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return rows;
}
public static int Update(Reader reader)
{
int rows = 0;
string sql = "update Reader set "
+ "rdID=@rdID,"
+ "rdName=@rdName,"
+ "rdSex=@rdSex,"
+ "rdType=@rdType,"
+ "rdDept=@rdDept,"
+ "rdPhone=@rdPhone,"
+ "rdEmail=@rdEmail,"
+ "rdDateReg=@rdDateReg,"
+ "rdPhoto=@rdPhoto,"
+ "rdStatus=@rdStatus,"
+ "rdBorrowQty=@rdBorrowQty,"
+ "rdPwd=@rdPwd,"
+ "rdAdminRoles=@rdAdminRoles "
+ "where rdID=@rdID";
SqlParameter[] parameters ={
new SqlParameter("@rdID",reader.rdID),
new SqlParameter("@rdName",reader.rdName),
new SqlParameter("@rdSex",reader.rdSex),
new SqlParameter("@rdType",reader.rdType),
new SqlParameter("@rdDept",reader.rdDept),
new SqlParameter("@rdPhone",reader.rdPhone),
new SqlParameter("@rdEmail",reader.rdEmail),
new SqlParameter("@rdDateReg",reader.rdDateReg),
new SqlParameter("@rdPhoto",reader.rdPhoto),
new SqlParameter("@rdStatus",reader.rdStatus),
new SqlParameter("@rdBorrowQty",reader.rdBorrowQty),
new SqlParameter("@rdPwd",reader.rdPwd),
new SqlParameter("@rdAdminRoles",reader.rdAdminRoles)
};
try
{
rows = SqlHelper.ExecuteNonQuery(sql, parameters);
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return rows;
}
//借书后更新读者借书本数
public int UpdateBorrowNum(Reader reader)
{
return (BorrowDAL.UpdateBorrowNum(reader));
}
//选择行操作
private void dgvReader_SelectionChanged(object sender, EventArgs e)
{
if (dgvReader.CurrentCell == null)
return;
reader = ReaderAdmin.GetReader((int)dgvReader["rdID", dgvReader.CurrentCell.RowIndex].Value);
SetReaderToText();
}
public int Update(Reader reader)
{
return (ReaderDAL.Update(reader));
}
public int UnLoss(Reader reader)
{
return (ReaderDAL.UnLoss(reader));
}
public int Loss(Reader reader)
{
return (ReaderDAL.Loss(reader));
}
public int Insert(Reader reader)
{
return (ReaderDAL.Insert(reader));
}
public int Delete(Reader reader)
{
return (ReaderDAL.Delete(reader));
}
//借书
private void btnBorrowBook_Click(object sender, EventArgs e)
{
int rdID,rdType,bkID;
int CanLendQty,CanLendDay,rdBorrowQty;
string rdStatus,bkStatus;
Borrow borrow = new Borrow();
Reader reader = new Reader();
DataRow dr=null;
DataRow ds = null;
for(int i=0;i<dgvBook.SelectedRows.Count;i++)
{
dr = (dgvBook.SelectedRows[i].DataBoundItem as DataRowView).Row;
}
for (int j = 0; j < dgvReader.SelectedRows.Count; j++)
{
ds = (dgvReader.SelectedRows[j].DataBoundItem as DataRowView).Row;
}
rdID = Convert.ToInt32(txtrdID.Text);
rdType = Convert.ToInt32(ds.ItemArray[3]);
dt = borrowBLL.GetReaderType(rdType);
CanLendQty=Convert.ToInt32(dt.Rows[0][0]);
CanLendDay = Convert.ToInt32(dt.Rows[0][1]);
dm = borrowBLL.GetrdStatus(rdID);
rdStatus = Convert.ToString(dm.Rows[0][0]);
rdBorrowQty=Convert.ToInt32(dm.Rows[0][1]);
bkStatus = Convert.ToString(dr.ItemArray[15]);
if (rdStatus != "有效")
{
MessageBox.Show("借书证无效，无法借书，无法借书！");
}
else
{
if (bkStatus != "在馆")
{
MessageBox.Show("对不起，该书已不在馆！！");
}
else
{
if (rdBorrowQty >= CanLendQty)
{
MessageBox.Show("已借书数超出最大可借书量，无法借书！");
}
else
{
borrow.rdID = rdID;
borrow.bkID = Convert.ToInt32(dr.ItemArray[0]);
borrow.IdContinueTimes = 0;
borrow.IdDateOut = DateTime.Now;
borrow.IdDateRetPlan = DateTime.Now.AddDays(CanLendDay);
borrow.IdDateRetAct = DateTime.Now;
borrow.IdOverDay = 0;
borrow.IdOverMoney = 0;
borrow.IdPunishMoney = 0;
borrow.IsHasReturn = false;
borrow.OperatorLend = Convert.ToString(ds.ItemArray[1]);
borrow.OperatorRet = Convert.ToString(ds.ItemArray[1]);
borrowBLL.Insert(borrow);
txtbkName.Text = Convert.ToString(borrow.rdID);
borrowBLL.UpdateBook(borrow);
reader.rdID = rdID;
borrowBLL.UpdateBorrowNum(reader);
MessageBox.Show("借书成功！！！");
}
}
}
}
public static int Insert(Reader reader)
{
int rows = 0;
string sql ="insert into Reader(rdID,rdName,rdSex,rdType,rdDept,rdPhone,rdEmail,rdDateReg,rdPhoto,rdStatus,rdBorrowQty,rdPwd,rdAdminRoles)"
+" values (@rdID,@rdName,@rdSex,@rdType,@rdDept,@rdPhone,@rdEmail,@rdDateReg,@rdPhoto,@rdStatus,@rdBorrowQty,@rdPwd,@rdAdminRoles)";
SqlParameter[] parameters ={
new SqlParameter("@rdID",reader.rdID),
new SqlParameter("@rdName",reader.rdName),
new SqlParameter("@rdSex",reader.rdSex),
new SqlParameter("@rdType",reader.rdType),
new SqlParameter("@rdDept",reader.rdDept),
new SqlParameter("@rdPhone",reader.rdPhone),
new SqlParameter("@rdEmail",reader.rdEmail),
new SqlParameter("@rdDateReg",reader.rdDateReg),
new SqlParameter("@rdPhoto",reader.rdPhoto),
new SqlParameter("@rdStatus",reader.rdStatus),
new SqlParameter("@rdBorrowQty",reader.rdBorrowQty),
new SqlParameter("@rdPwd",reader.rdPwd),
new SqlParameter("@rdAdminRoles",reader.rdAdminRoles)
};
try
{
rows = SqlHelper.ExecuteNonQuery(sql, parameters);
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return rows;
}
//修改密码
public int UpdatePwd(Reader readerPwd)
{
return (ReaderDAL.UpdatePwd(readerPwd));
}
//借书后更新读者借书本数
public static int UpdateBorrowNum(Reader reader)
{
int rows = 0;
string sql = "update Reader set rdBorrowQty=rdBorrowQty+1 where rdID=@rdID";
SqlParameter[] parameters ={
new SqlParameter("@rdID",reader.rdID)
};
try
{
rows = SqlHelper.ExecuteNonQuery(sql, parameters);
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return rows;
}