public override long Create(Person entity)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText = "INSERT INTO public.person (address, name, phone, car) VALUES (:address, :name, :phone, :car)";
command.Parameters.Add(new NpgsqlParameter("address", entity.Address));
command.Parameters.Add(new NpgsqlParameter("name", entity.Name));
command.Parameters.Add(new NpgsqlParameter("phone", entity.Phone));
command.Parameters.Add(new NpgsqlParameter("car", entity.Car.VIN));
command.ExecuteNonQuery();
Dbconnection.Close();
connection = Dbconnection.Open();
command = connection.CreateCommand();
command.CommandText = "SELECT \"person-id\" FROM public.person WHERE car = :car_vin AND name = :name";
command.Parameters.Add(new NpgsqlParameter("car_vin", entity.Car.VIN));
command.Parameters.Add(new NpgsqlParameter("name", entity.Name));
var reader = command.ExecuteReader();
long id = -1;
if (reader.Read())
{
id = reader.GetInt64(0);
}
Dbconnection.Close();
return(id);
}
public override List <Person> Get(int page)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT \"person-id\", address, name, phone, \"VIN\", \"Model\", \"Year\" " +
"FROM public.person " +
"INNER JOIN public.car ON car.\"VIN\" = person.car " +
"ORDER BY \"person-id\" " +
"LIMIT 10 OFFSET :offset";
command.Parameters.Add(new NpgsqlParameter("offset", page * 10));
var reader = command.ExecuteReader();
var persons = new List <Person>();
while (reader.Read())
{
persons.Add(new Person(reader.GetInt64(0), reader.GetString(1), reader.GetString(2), reader.GetString(3),
new Car(reader.GetInt64(4), reader.GetString(5), reader.GetInt32(6))
));
}
Dbconnection.Close();
return(persons);
}
public Person Search(string str)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT \"person-id\", address, name, phone, \"VIN\", \"Model\", \"Year\" " +
"FROM public.person " +
"INNER JOIN public.car ON car.\"VIN\" = person.car " +
"WHERE Name = :name";
command.Parameters.Add(new NpgsqlParameter("name", str));
var reader = command.ExecuteReader();
Person person = null;
if (reader.Read())
{
person = new Person(reader.GetInt64(0), reader.GetString(1), reader.GetString(2),
reader.GetString(3),
new Car(reader.GetInt64(4), reader.GetString(5), reader.GetInt32(6))
);
}
Dbconnection.Close();
return(person);
}
object doQuery(string query)
{
Dbconnection dbCon = new Dbconnection();
return(dbCon.ExeScalar(query));
}
private void butSure_Click(object sender, EventArgs e)
{
if (txtBookID.Text.Length == 0 || txtBookName.Text.Length == 0 || txtBookAhour.Text.Length == 0)
{
MessageBox.Show("图书编号、图书名称、图书作者均不能为空！", "提示");
}
else
{
try
{
// DateTime time = Convert.ToDateTime(DateTime.Now.ToString());
Dbconnection db = new Dbconnection();
if (this.Text == "图书管理(修改)")
{
txtBookID.ReadOnly = true;
if (MessageBox.Show("您将修改图书编号为：'" + txtBookID.Text.Trim() + "'的信息,是否继续？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (db.ExeInfochange("update Book set BookID='" + txtBookID.Text.Trim() + "',Strichcode='" + txtBookCode.Text.Trim() + "',SlassificationID='" + txtSlassificationID.Text.Trim() + "',BookName='" + txtBookName.Text.Trim() + "',Type1='" + cmbBookType.Text.Trim() + "',Author='" + txtBookAhour.Text.Trim() + "',Translator='" + txtTranslator.Text.Trim() + "',ISBN='" + txtISBN.Text.Trim() + "',Publisher='" + cmbBookPublisher.Text.Trim() + "',Revision='" + cmbRevision.Text.Trim() + "',Format='" + cmbFormat.Text.Trim() + "',Word='" + txtBookWord.Text.Trim() + "',Page='" + txtBookPage.Text.Trim() + "',Price='" + txtBookPrice.Text.Trim() + "',EnterTime ='" + dateTimePicker1.Text.Trim() + "',Qty='" + txtQty.Text.Trim() + "',Extant='" + txtBookExtant.Text.Trim() + "',Circulate='" + cmbCirculate.Text.Trim() + "' where BookID='" + txtBookID.Text.Trim() + "'") == 1)
{
db.ExeInfochange("update Borrow set BookName='" + txtBookName.Text.Trim() + "',Author='" + txtBookAhour.Text.Trim() + "',Publisher='" + cmbBookPublisher.Text.Trim() + "',Price=" + txtBookPrice.Text.Trim() + " where BookID='" + txtBookID.Text.Trim() + "'");
db.ExeInfochange("update OverdueInfo set BookName='" + txtBookName.Text.Trim() + "',Author='" + txtBookAhour.Text.Trim() + "',Publisher='" + cmbBookPublisher.Text.Trim() + "',Price=" + txtBookPrice.Text.Trim() + " where BookID='" + txtBookID.Text.Trim() + "'");
db.ExeInfochange("update HandleNote set BookName='" + txtBookName.Text.Trim() + "',Price=" + txtBookPrice.Text.Trim() + " where BookStrichcode='" + txtBookID.Text.Trim() + "'");
db.ExeInfochange("update ReserBroInfo set r_BookType='" + cmbBookType.Text.Trim() + "',r_BookName='" + txtBookName.Text.Trim() + "',r_BookAuthor='" + txtBookAhour.Text.Trim() + "',r_BookPrice=" + txtBookPrice.Text.Trim() + " where r_BookId='" + txtBookID.Text.Trim() + "'");
db.ExeInfochange("update Borrow set BookName='" + txtBookName.Text.Trim() + "' where BookID='" + txtBookID.Text.Trim() + "'");
db.ExeInfochange("update RenewNote set BookName='" + txtBookName.Text.Trim() + "',Author='" + txtBookAhour.Text.Trim() + "',Publisher='" + cmbBookPublisher.Text.Trim() + "',Price=" + txtBookPrice.Text.Trim() + " where BookID='" + txtBookID.Text.Trim() + "'");
this.Close();
}
else
{
MessageBox.Show("数据格式不合法,图书修改失败!", "提示");
}
}
}
if (this.Text == "图书管理(添加)")
{
//txtBookID.ReadOnly = true;
//int MdiNumber= dbl.AutoNumber ("select Max(txtBookID) from Book");
//string LastNumber=Convert .ToString (MdiNumber);
//txtBookID.Text = LastNumber.Trim();
if (MessageBox.Show("您将添加图书名为：'" + txtBookName.Text.Trim() + "'的信息,是否继续？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int number = dbl.AutoNumber("select max(Number) from Book");
if (db.ExeInfochange("insert into Book values(" + number + ",'" + txtBookID.Text.Trim() + "','" + txtBookCode.Text.Trim() + "','" + txtSlassificationID.Text.Trim() + "','" + txtBookName.Text.Trim() + "','" + cmbBookType.Text.Trim() + "','" + txtBookAhour.Text.Trim() + "','" + txtTranslator.Text.Trim() + "','" + txtISBN.Text.Trim() + "','" + cmbBookPublisher.Text.Trim() + "','" + cmbRevision.Text.Trim() + "','" + cmbFormat.Text.Trim() + "','" + txtBookWord.Text.Trim() + "','" + txtBookPage.Text.Trim() + "','" + txtBookPrice.Text.Trim() + "','" + dateTimePicker1.Text.Trim() + "','" + txtQty.Text.Trim() + "','" + txtBookExtant.Text.Trim() + "','" + cmbCirculate.Text.Trim() + "')") == 1)
{
this.Close();
}
else
{
MessageBox.Show("此图书已存在或数据不合法,添加失败!", "提示");
}
}
}
}
catch (Exception)
{
;
}
}
}
protected void Submit_Click(object sender, EventArgs e)
{
if (useremail.Text == "" || password.Text == "")
{
durumLbl.Text = "Email veya sifre bilgilerinizi kontrol ediniz";
}
else
{
Ozellikler yeniKisi = new Ozellikler();
yeniKisi.useremail = useremail.Text;
yeniKisi.userpassword = password.Text;
Dbconnection db = new Dbconnection();
var outh = db.KullaniciGiris(yeniKisi.useremail, yeniKisi.userpassword);
if (outh == true)
{
Response.Redirect("Singin.aspx");
}
else
{
durumLbl.Text = "bilgiler yanlis";
}
Response.Redirect("/signal.aspx");
}
}
public override List <Message> Get(int page)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT mes.id, us.id, us.name, ch.id, ch.name, mes.text, mes.date " +
"FROM public.message AS mes " +
"INNER JOIN public.user AS us ON mes.user_id = us.id " +
"INNER JOIN public.chat AS ch ON mes.chat_id = ch.id " +
"ORDER BY mes.id " +
"LIMIT 10 OFFSET :offset";
command.Parameters.Add(new NpgsqlParameter("offset", page * 10));
var reader = command.ExecuteReader();
var messages = new List <Message>();
while (reader.Read())
{
messages.Add(new Message(reader.GetInt64(0),
new User(reader.GetInt64(1), reader.GetString(2)),
new Chat(reader.GetInt64(3), reader.GetString(4)),
reader.GetString(5),
reader.GetTimeStamp(6).ToDateTime()));
}
Dbconnection.Close();
return(messages);
}
private void butOk_Click(object sender, EventArgs e)
{
if (txtConfident.Text.Length == 0)
{
MessageBox.Show("请输入要查询的内容!");
return;
}
else
{
try
{
DataSet dsm;
{
string strsql = "select Number 流水编号,CardID 借书证号,ReaderName 读者姓名,BorrowNumber 借阅数量,Strichcode 条形码,ReaderTypeID 读者类型,Mode 书证状态,RegistrationTime 登记日期,ValidTime 有效期至,Sex 性别,Dept 工作单位, Call 电话 FROM Reader WHERE(CardID LIKE '%" + txtConfident.Text.Trim() + "%') or(ReaderName LIKE '%" + txtConfident.Text.Trim() + "%') order by Number";
Dbconnection dbc = new Dbconnection(); //调用ClassLibrary 中的 ds 方法来显示数据
dsm = dbc.ds(strsql);
dgvUserManage.DataSource = dsm;
dgvUserManage.DataMember = dsm.Tables[0].ToString();
}
}
catch (Exception)
{
return;
}
}
}
public void UpdateCostomer(int index, string name, string address, string phone)
{
string insertSQL = "update 고객 set 이름 = '" + name + "' , 주소='" + address +
"' , 전화번호 ='" + phone + " ' where 고객번호 = " + index;
cmd = new MySqlCommand();
conn = Dbconnection.GetMySqlConnection();
try
{
conn.Open();
transaction = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = transaction;
cmd.CommandText = insertSQL;
cmd.ExecuteNonQuery();
transaction.Commit();
}
catch (MySqlException ex)
{
transaction.Rollback();
System.Console.WriteLine(ex.ToString());
}
finally
{
conn.Close();
}
}
public override long Create(Accident entity)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText = "INSERT INTO public.accident (location, date, \"damage-amount\", person) VALUES (:location, :date, :dmg, :person)";
command.Parameters.Add(new NpgsqlParameter("location", entity.Location));
command.Parameters.Add(new NpgsqlParameter("date", NpgsqlDateTime.ToNpgsqlDateTime(entity.Date)));
command.Parameters.Add(new NpgsqlParameter("dmg", entity.Damage_Amount));
command.Parameters.Add(new NpgsqlParameter("person", entity.Person.Id));
command.ExecuteNonQuery();
command.CommandText = "SELECT \"record-number\" FROM public.accident WHERE location = :loc AND person = :pers";
command.Parameters.Add(new NpgsqlParameter("loc", entity.Location));
command.Parameters.Add(new NpgsqlParameter("pers", entity.Person.Id));
var reader = command.ExecuteReader();
long id = -1;
if (reader.Read())
{
id = reader.GetInt64(0);
}
Dbconnection.Close();
return(id);
}
public void DeleteCostomer(int index)
{
cmd = new MySqlCommand();
conn = Dbconnection.GetMySqlConnection();
try
{
conn.Open();
transaction = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = transaction;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "deleteCostomer";
cmd.Parameters.Add(new MySqlParameter("num", index));
cmd.ExecuteNonQuery();
transaction.Commit();
}
catch (MySqlException ex)
{
transaction.Rollback();
System.Console.WriteLine(ex.ToString());
}
finally
{
conn.Close();
}
}
private void butDelete_Click(object sender, EventArgs e)
{
try
{
name = dgvUserselect.SelectedCells[0].Value.ToString();
//如果选中的是自己,那么提示不能删除
if (frmlogin.userName == name)
{
MessageBox.Show("删除错误,不能删除自己!", "提示");
}
else
{
if (MessageBox.Show("您将删除'" + name + "'用户,是否继续？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
SqlConnection conn = Dbconnection.Dblink();
conn.Open();
DataSet DS;
string strSql = "delete from Users where u_Name='" + name + "'";
DS = su.GetDataset(strSql);
conn.Close();
//实现实时更新
Reflesh();
}
}
}
catch (Exception)
{
;
}
}
public override UserChat Get(long id)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT rel.id, us.id, us.login, ch.id, ch.tag, rel.isadmin " +
"FROM public.user_chat AS rel " +
"INNER JOIN public.user AS us ON rel.user_id = us.id " +
"INNER JOIN public.chat AS ch ON rel.chat_id = ch.id " +
"WHERE rel.id = :id";
command.Parameters.Add(new NpgsqlParameter("id", id));
var reader = command.ExecuteReader();
UserChat userChat = null;
if (reader.Read())
{
userChat = new UserChat(reader.GetInt64(0),
new User(reader.GetInt64(1), reader.GetString(2)),
new Chat(reader.GetInt64(3), reader.GetString(4)),
reader.GetBoolean(5));
}
Dbconnection.Close();
return(userChat);
}
private void txtPass_TextChanged(object sender, EventArgs e)
{
try
{
SqlConnection Strconn = Dbconnection.Dblink();; //调用Dbconnection类中的连接
Strconn.Open(); //打开连接
string sqlName = "select u_Name from Users";
SqlCommand scomd = new SqlCommand(sqlName, Strconn);
scomd.ExecuteNonQuery();
SqlDataReader sDR = scomd.ExecuteReader();
while (sDR.Read())
{
string name = sDR["u_Name"].ToString();
if (txtUsername.Text == name)
{
MessageBox.Show("用户名'" + txtUsername.Text.Trim() + "'已存在,请重新选择用户名!", "提示");
txtUsername.Focus();
txtUsername.SelectAll();
break;
}
}
Strconn.Close();
}
catch (Exception j)
{
Console.WriteLine(j.Message);
}
}
public override List <UserChat> Get(int page)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT rel.id, us.id, us.login, ch.id, ch.tag, rel.isadmin " +
"FROM public.user_chat AS rel " +
"INNER JOIN public.user AS us ON rel.user_id = us.id " +
"INNER JOIN public.chat AS ch ON rel.chat_id = ch.id " +
"ORDER BY rel.id " +
"LIMIT 10 OFFSET :offset";
command.Parameters.Add(new NpgsqlParameter("offset", page * 10));
var reader = command.ExecuteReader();
var userChats = new List <UserChat>();
while (reader.Read())
{
userChats.Add(new UserChat(reader.GetInt64(0),
new User(reader.GetInt64(1), reader.GetString(2)),
new Chat(reader.GetInt64(3), reader.GetString(4)),
reader.GetBoolean(5)));
}
Dbconnection.Close();
return(userChats);
}
public override Message Get(long id)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT mes.id, us.id, us.login, ch.id, ch.tag, mes.text, mes.date " +
"FROM public.message AS mes " +
"INNER JOIN public.user AS us ON mes.user_id = us.id " +
"INNER JOIN public.chat AS ch ON mes.chat_id = ch.id " +
"WHERE mes.id = :id";
command.Parameters.Add(new NpgsqlParameter("id", id));
var reader = command.ExecuteReader();
Message message = null;
if (reader.Read())
{
message = new Message(reader.GetInt64(0),
new User(reader.GetInt64(1), reader.GetString(2)),
new Chat(reader.GetInt64(3), reader.GetString(4)),
reader.GetString(5),
reader.GetTimeStamp(6).ToDateTime());
}
Dbconnection.Close();
return(message);
}
public override List <Accident> Get(int page)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT \"record-number\", location, date, \"damage-amount\", \"person-id\", address, name, phone, \"VIN\", \"Model\", \"Year\" " +
"FROM public.accident " +
"INNER JOIN public.person ON person.\"person-id\" = accident.person " +
"INNER JOIN public.car ON car.\"VIN\" = person.car " +
"ORDER BY \"record-number\" " +
"LIMIT 10 OFFSET :offset";
command.Parameters.Add(new NpgsqlParameter("offset", page * 10));
var reader = command.ExecuteReader();
var accidents = new List <Accident>();
while (reader.Read())
{
accidents.Add(new Accident(reader.GetInt64(0), reader.GetString(1),
reader.GetTimeStamp(2).ToDateTime(), reader.GetString(3),
new Person(reader.GetInt64(4), reader.GetString(5), reader.GetString(6), reader.GetString(7),
new Car(reader.GetInt64(8), reader.GetString(9), reader.GetInt32(10)))
));
}
Dbconnection.Close();
return(accidents);
}
public override Accident Get(long id)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT \"record-number\", location, date, \"damage-amount\", \"person-id\", address, name, phone, \"VIN\", \"Model\", \"Year\" " +
"FROM public.accident " +
"INNER JOIN public.person ON person.\"person-id\" = accident.person " +
"INNER JOIN public.car ON car.\"VIN\" = person.car " +
"WHERE \"record-number\" = :id";
command.Parameters.Add(new NpgsqlParameter("id", id));
var reader = command.ExecuteReader();
Accident accident = null;
if (reader.Read())
{
accident = new Accident(reader.GetInt64(0), reader.GetString(1), reader.GetTimeStamp(2).ToDateTime(), reader.GetString(3),
new Person(reader.GetInt64(4), reader.GetString(5), reader.GetString(6), reader.GetString(7),
new Car(reader.GetInt64(8), reader.GetString(9), reader.GetInt32(10)))
);
}
Dbconnection.Close();
return(accident);
}
public List <UserChat> Search(string value, bool isAdmin)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText =
"SELECT rel.id, us.id, us.login, ch.id, ch.tag, rel.isadmin " +
"FROM public.user_chat AS rel " +
"INNER JOIN public.user AS us ON rel.user_id = us.id " +
"INNER JOIN public.chat AS ch ON rel.chat_id = ch.id " +
"WHERE (us.login = :value OR us.name = :value OR ch.tag = :value OR ch.name = :value) " +
"AND rel.isadmin = :isadmin";
command.Parameters.Add(new NpgsqlParameter("value", value));
command.Parameters.Add(new NpgsqlParameter("isAdmin", isAdmin));
var reader = command.ExecuteReader();
var userChat = new List <UserChat>();
while (reader.Read())
{
userChat.Add(new UserChat(reader.GetInt64(0),
new User(reader.GetInt64(1), reader.GetString(2)),
new Chat(reader.GetInt64(3), reader.GetString(4)),
reader.GetBoolean(5)));
}
Dbconnection.Close();
return(userChat);
}
public void InsertCostomer(string name, string address, string phone)
{
string insertSQL = "Insert into 고객(이름,주소,전화번호) values( '" + name + "', '" + address + "', '" +
phone + "')";
cmd = new MySqlCommand();
conn = Dbconnection.GetMySqlConnection();
try
{
conn.Open();
transaction = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = transaction;
cmd.CommandText = insertSQL;
cmd.ExecuteNonQuery();
transaction.Commit();
}catch (MySqlException ex)
{
transaction.Rollback();
System.Console.WriteLine(ex.ToString());
}
finally
{
conn.Close();
}
}
public MainWindow()
{
//Dbservice.connection();
Dbconnection.Connect();
Trace.WriteLine("connection succeeded");
InitializeComponent();
}
public override void Clear()
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText = "TRUNCATE TABLE public.user_chat RESTART IDENTITY";
command.ExecuteNonQuery();
Dbconnection.Close();
}
private void butSuerAdd_Click_1(object sender, EventArgs e)
{
//控件的可用性的设置
comboxUsertype.SelectedIndex = 0;
butSuerAdd.Enabled = false;
butAdd.Enabled = true;
txtUsername.Enabled = false;
txtPass.Enabled = false;
txtRepass.Enabled = false;
comboxUsertype.Enabled = false;
butCancel.Enabled = false;
if (txtUsername.Text.Length < 3 || txtUsername.Text.Length > 12 || txtPass.Text.Length < 5 || txtPass.Text.Length > 12 || txtPass.Text.Length == 0 || txtRepass.Text.Length < 5 || txtRepass.Text.Length > 12 || txtRepass.Text.Length == 0)
{
MessageBox.Show("密码长度不符合规定,请重新输入!", "提示");
txtUsername.Clear();
txtPass.Clear();
txtRepass.Clear();
}
else
{
if (txtPass.Text != txtRepass.Text)
{
MessageBox.Show("两次输入的密码不一致,请重新输入!", "提示");
//txtPass.Focus();
txtUsername.Clear();
txtPass.Clear();
txtRepass.Clear();
}
else
{
try
{
if (MessageBox.Show("您将添加用户'" + txtUsername.Text.Trim() + "',是否继续？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
SqlConnection Strconn1 = Dbconnection.Dblink(); //调用Dbconnection类中的连接
Strconn1.Open(); //打开连接
string sqlName1 = "insert into Users values ('" + txtUsername.Text + "','" + txtPass.Text + "','" + comboxUsertype.Text + "','" + "否" + "')";
SqlCommand scomd1 = new SqlCommand(sqlName1, Strconn1);
scomd1.ExecuteNonQuery();
Strconn1.Close();
//实现实时更新
Reflesh();
txtUsername.Clear();
txtPass.Clear();
txtRepass.Clear();
Strconn1.Close();
}
}
catch (Exception c)
{
Console.WriteLine(c.Message);
}
}
}
}
public static Dbconnection Instance()
{
if (_instance == null)
{
_instance = new Dbconnection();
}
return(_instance);
}
private void ReserBorrow(int TxtNumber)
{
try
{
Dbconnection db = new Dbconnection();
string time = System.DateTime.Now.ToShortDateString(); //获得今天的时间
string time1 = dbl.GetTime(3);
//获得系统参数中的数据
DataSet ds = new DataSet();
ds = dbl.GetDataset("select * from Reader where CardID='" + labCardId.Text.Trim() + "'");
int BroNumber = Convert.ToInt32(ds.Tables[0].Rows[0][3]); //获得读者表中已借的数量
ds = dbl.GetDataset("select * from Book where BookID='" + labBookID.Text.Trim() + "'");
int BookStore = Convert.ToInt32(ds.Tables[0].Rows[0][17]); //获得图书表中的可借出数量
int ReBookQty = BookStore - 1; //更新图书表中的可出借数量
int ReReaderQty = BroNumber + 1; //更新读者已借阅图书的数量
if (labSatue.Text.Trim() == "有效")
{
if (BroNumber < TxtNumber)
{
if (BookStore > 1)
{
//向预借表中添加一条记录
int Number1 = dbl.AutoNumber("select Max(r_Number) from ReserBroInfo");
dbc.ExeInfochange("insert into ReserBroInfo values (" + Number1 + ",'" + labBookID.Text.Trim() + "','" + labBookName.Text.Trim() + "','" + labAuthor.Text.Trim() + "','" + labCardId.Text.Trim() + "','" + labReaderName.Text.Trim() + "','" + labSex.Text.Trim() + "','" + dupBookNumber.Text.Trim() + "','" + labPrice.Text.Trim() + "','" + labPublisher.Text.Trim() + "','" + frmlogin.userName.Trim() + "','" + time1 + "')");
//向操作流水表中添加一条记录
int Number2 = dbl.AutoNumber("select Max(HandleNumber) from HandleNote");
dbc.ExeInfochange("insert into HandleNote values (" + Number2 + ",'" + this.Text.Trim() + "','" + frmlogin.userName.Trim() + "','" + labBookName.Text.Trim() + "','" + labBookID.Text.Trim() + "','" + labCardId.Text.Trim() + "','" + labReaderName.Text.Trim() + "','" + labSex.Text.Trim() + "','" + dupBookNumber.Text.Trim() + "','" + labPrice.Text.Trim() + "','" + time1 + "')");
//更新图书表中图书的可借数量
dbc.ExeInfochange("update Book set Extant=" + ReBookQty + " where BookID='" + labBookID.Text.Trim() + "'");
//更新读者表中已借图书的数量
dbc.ExeInfochange("update Reader set BorrowNumber=" + ReReaderQty + " where CardID='" + labCardId.Text.Trim() + "'");
//更新读者已借的图书数量和图书馆藏数量
labBroNumber.Text = Convert.ToString(ReReaderQty);
labQty.Text = Convert.ToString(ReBookQty);
MessageBox.Show("预借成功！", "提示");
}
else
{
MessageBox.Show("最后样书,不能预借！", "提示");
}
}
else
{
MessageBox.Show("已达到最大借书数量,无法继续预借！", "提示");
}
}
else
{
MessageBox.Show("借书证处于无效状态,无法预借图书！", "提示");
}
}
catch (Exception)
{; }
}
public void ShowAll() //实现刷新
{
DataSet dsBookManage;
string strSql = "SELECT Number 流水编号,BookID 图书编号,Strichcode 条形码,SlassificationID 图书分类,BookName 图书名称,Type1 图书类型,Author 图书作者,Translator 图书译者,ISBN ISBN码,Publisher 出版社,Revision 图书版次,Format 图书开本,Word 图书字数,Page 图书页码,Price 图书价格,EnterTime 入馆时间,Qty 库存数目,Extant 可借数量,Circulate 是否流通 FROM Book order by Number";
Dbconnection dbc = new Dbconnection(); //调用ClassLibrary 中的 ds 方法来显示数据
dsBookManage = dbc.ds(strSql);
dgvBookManger.DataSource = dsBookManage;
dgvBookManger.DataMember = dsBookManage.Tables[0].ToString();
}
public object doQuery(string table, string column, string text)
{
string query;
query = "insert into " + table + "(" + column + ") values ('" + text + "')";;
Dbconnection dbCon = new Dbconnection();
return(dbCon.ExeScalar(query));
}
public override void Delete(long id)
{
var connection = Dbconnection.Open();
var command = connection.CreateCommand();
command.CommandText = "DELETE FROM public.user_chat WHERE id = :id";
command.Parameters.Add(new NpgsqlParameter("id", id));
command.ExecuteNonQuery();
Dbconnection.Close();
}
public void InfoShow() //显示日志信息
{
DataSet backupinfo;
string strSql = "select Number 流水编号,lodUser 登录用户,BackupTime 登录时间,Type 操作类型,BackupWay 备份路径 FROM Backupinfo";
Dbconnection dbc = new Dbconnection(); //调用ClassLibrary 中的 ds 方法来显示数据
backupinfo = dbc.ds(strSql);
dgvBackupinfo.DataSource = backupinfo;
dgvBackupinfo.DataMember = backupinfo.Tables[0].ToString();
}
public void ShowAll() //实现刷新
{
DataSet dsUserManage;
string strSql = "select Number 流水编号,CardID 借书证号,ReaderName 读者姓名,BorrowNumber 借阅数量,Strichcode 条形码,ReaderTypeID 读者类型,Mode 书证状态,RegistrationTime 登记日期,ValidTime 有效期至,Sex 性别,Dept 工作单位, Call 电话 from Reader order by Number";
Dbconnection dbc = new Dbconnection(); //调用ClassLibrary 中的 ds 方法来显示数据
dsUserManage = dbc.ds(strSql);
dgvUserManage.DataSource = dsUserManage;
dgvUserManage.DataMember = dsUserManage.Tables[0].ToString();
}
