// Chungkhoan.cs
using System.Collections.Generic; using System.ComponentModel; using System.Windows.Forms;
{
{
{
InitializeComponent();
}
{
OleDbConnection connect
= new OleDbConnection
("Provider=Microsoft.Jet.Oledb.4.0;data source=chungkhoan.mdb"); connect.Open();
String SelectSoKH
= "select Max(MaKH) from KHACHHANG"; OleDbCommand cmm
= new OleDbCommand
(); cmm.CommandText = SelectSoKH;
cmm.Connection = connect;
object ob
= cmm
.ExecuteScalar(); txtMa.Text = "1";
{
int temp
= int.Parse(ob
.ToString()) + 1; txtMa.Text = temp.ToString();
}
connect.Close();
}
{
OleDbConnection connect
= new OleDbConnection
("Provider=Microsoft.Jet.Oledb.4.0;data source=chungkhoan.mdb"); connect.Open();
String command
= "Insert into KHACHHANG values(" + txtMa
.Text + ",'" + txtTen
.Text + "'," + txtCMND
.Text + "," + txtTien
.Text + ")"; OleDbCommand cmm
= new OleDbCommand
(); cmm.CommandText = command;
cmm.Connection = connect;
{
cmm.ExecuteNonQuery();
}
{
MessageBox.Show("Bạn nhập không đúng kiểu dữ liệu");
}
connect.Close();
int temp
= int.Parse(txtMa
.Text) + 1; txtMa.Text = temp.ToString();
}
{
OleDbConnection connect
= new OleDbConnection
("Provider=Microsoft.Jet.Oledb.4.0;data source=chungkhoan.mdb"); connect.Open();
String select = "Delete from KHACHHANG where MaKH=" + txtXoa
.Text; OleDbCommand command
= new OleDbCommand
(); command.Connection = connect;
{
command.ExecuteNonQuery();
}
{
MessageBox.Show("Bạn nhập không đúng kiểu dữ liệu");
}
connect.Close();
}
{
Tacgia about
= new Tacgia
(); about.Show();
}
{
PhieuDatLenh b
= new PhieuDatLenh
(); b.Show();
}
{
BaoGia Bg
= new BaoGia
(); Bg.Show();
}
{
TaiKhoan Tk
= new TaiKhoan
(); Tk.Show();
}
{
}
{
OleDbConnection connect
= new OleDbConnection
("Provider=Microsoft.Jet.Oledb.4.0;data source=chungkhoan.mdb"); connect.Open();
//phat sinh cho bang KETQUAGIAODICH
DataSet dsKQGD
= new DataSet
(); if ((DateTime
.Now.Hour == 8 && DateTime
.Now.Minute == 31)||(DateTime
.Now.Hour>8)) {
kiemtra = 1;
String selectKQGD
= "Select PDL.MaCP,PDL.Phien,(select (sum(PDL1.Gia)/count(*))as GiaKhopLenh from PHIEUDATLENH PDL1 where PDL.MaCP=PDL1.MaCP) from PHIEUDATLENH PDL where PDL.Phien=1 and PDL.Trangthai='dang cho' group by PDL.MaCP,PDL.Phien"; OleDbDataAdapter da
= new OleDbDataAdapter
(selectKQGD, connect
); da.Fill(dsKQGD, "KETQUAGIAODICH");
}
if ((DateTime
.Now.Hour == 9 && DateTime
.Now.Minute == 31) || DateTime
.Now.Hour > 9) {
kiemtra = 2;
String selectKQGD
= "Select PDL.MaCP,PDL.Phien,(select (sum(PDL1.Gia)/count(*))as GiaKhopLenh from PHIEUDATLENH PDL1 where PDL.MaCP=PDL1.MaCP) from PHIEUDATLENH PDL where PDL.Phien=2 and PDL.Trangthai='dang cho' group by PDL.MaCP,PDL.Phien"; OleDbDataAdapter da
= new OleDbDataAdapter
(selectKQGD, connect
); da.Fill(dsKQGD, "KETQUAGIAODICH");
}
if ((DateTime
.Now.Hour == 10 && DateTime
.Now.Minute == 31)||DateTime
.Now.Hour>10) {
kiemtra = 3;
String selectKQGD
= "Select PDL.MaCP,PDL.Phien,(select (sum(PDL1.Gia)/count(*))as GiaKhopLenh from PHIEUDATLENH PDL1 where PDL.MaCP=PDL1.MaCP) from PHIEUDATLENH PDL where PDL.Phien=3 and PDL.Trangthai='dang cho' group by PDL.MaCP,PDL.Phien"; OleDbDataAdapter da
= new OleDbDataAdapter
(selectKQGD, connect
); da.Fill(dsKQGD, "KETQUAGIAODICH");
}
{
MessageBox.Show("Cap nhat khong dung thoi diem roi!!");
}
if (dsKQGD
.Tables[0].Rows.Count == 0) {
MessageBox.Show("Khong co phieu dat lenh duoc dat(Bang PHIEUDATLENH rong)");
}
String Selectcmm
= "Insert into KETQUAGIAODICH values(@MaKQGD,@MaCP,@Phien,@Ngay,@GiaKhopLenh)"; OleDbCommand command
= new OleDbCommand
(); command.CommandText = Selectcmm;
command.Connection = connect;
foreach (DataRow row
in dsKQGD
.Tables[0].Rows) {
command
.Parameters.Add(new OleDbParameter
("@MaKQGD", OleDbType
.Integer)); command
.Parameters["@MaKQGD"].Value = i
; command
.Parameters.Add(new OleDbParameter
("@MaCP", OleDbType
.VarWChar)); command
.Parameters["@MaCP"].Value = row
[0].ToString(); command
.Parameters.Add(new OleDbParameter
("@Phien", OleDbType
.Integer)); command
.Parameters["@Phien"].Value = row
[1]; command
.Parameters.Add(new OleDbParameter
("@Ngay", OleDbType
.VarWChar)); command
.Parameters["@Ngay"].Value = DateTime
.Today.ToShortDateString(); command
.Parameters.Add(new OleDbParameter
("@GiaKhopLenh", OleDbType
.Double)); command
.Parameters["@GiaKhopLenh"].Value = row
[2]; command.ExecuteNonQuery();
i++;
}
//cap nhat bang PHIEUDATLENH
String SelectUp
= "Update PHIEUDATLENH set Trangthai= 'duoc khop' where (PHIEUDATLENH.LoaiLenh='Mua' and PHIEUDATLENH.Gia>=(select GiaKhopLenh from KETQUAGIAODICH where PHIEUDATLENH.MaCP=KETQUAGIAODICH.MaCP)) OR (PHIEUDATLENH.LoaiLenh='Bán' and PHIEUDATLENH.Gia<=(select GiaKhopLenh from KETQUAGIAODICH where PHIEUDATLENH.MaCP=KETQUAGIAODICH.MaCP))"; command.CommandText = SelectUp;
command.Connection = connect;
command.ExecuteReader();
OleDbCommand cmm1
= new OleDbCommand
(); SelectUp = "Update PHIEUDATLENH set Trangthai= 'khong duoc khop' where (PHIEUDATLENH.LoaiLenh='Mua' and PHIEUDATLENH.Gia<(select GiaKhopLenh from KETQUAGIAODICH where PHIEUDATLENH.MaCP=KETQUAGIAODICH.MaCP)) OR (PHIEUDATLENH.LoaiLenh='Bán' and PHIEUDATLENH.Gia>(select GiaKhopLenh from KETQUAGIAODICH where PHIEUDATLENH.MaCP=KETQUAGIAODICH.MaCP))";
cmm1.CommandText = SelectUp;
cmm1.Connection = connect;
cmm1.ExecuteReader();
//Cap nhat bang SOHUU
DataSet dsSohuu
= new DataSet
(); String SelectSH
= "Select MaKH,MaCP,Soluong from PHIEUDATLENH where Trangthai='duoc khop'"; OleDbDataAdapter da_SH
= new OleDbDataAdapter
(SelectSH, connect
); da_SH.Fill(dsSohuu, "SOHUU");
OleDbCommand cmm2
= new OleDbCommand
("Insert into SOHUU values(@MaKH,@MaCP,@Soluong)", connect
); foreach (DataRow r
in dsSohuu
.Tables[0].Rows) {
cmm2
.Parameters.Add(new OleDbParameter
("@MaKH", OleDbType
.Integer)); cmm2
.Parameters["@MaKH"].Value = r
[0]; cmm2
.Parameters.Add(new OleDbParameter
("@MaCP", OleDbType
.VarWChar)); cmm2
.Parameters["@MaCP"].Value = r
[1].ToString(); cmm2
.Parameters.Add(new OleDbParameter
("@Soluong", OleDbType
.Integer)); cmm2
.Parameters["@Soluong"].Value = r
[2]; cmm2.ExecuteNonQuery();
}
connect.Close();
}
{
MessageBox.Show("Chúc mọi người 1 ngày làm việc vui vẻ");
}
{
LoiChuc lc
= new LoiChuc
(); lc.Show();
}
}
}