static Common()
{
server0 = "LAPTOP-U7HEJ86K";
database0 = "QLVT";
userid0 = "QLVT_HTKN";
password0 = "123";
LoaiHangDataTable = new QLVTDataSet.LoaiHangDataTable();
NhanVienDataTable = new QLVTDataSet.NhanVienDataTable();
NhaCungCapDataTable = new QLVTDataSet.NhaCungCapDataTable();
MatHangDataTable = new QLVTDataSet.MatHangDataTable();
CTDatHangDataTable = new QLVTDataSet.CTDatHangDataTable();
KhoDataTable = new QLVTDataSet.KhoDataTable();
KhachHangDataTable = new QLVTDataSet.KhachHangDataTable();
CTHoaDonDataTable = new QLVTDataSet.CTHoaDonDataTable();
PhieuNhapDataTable = new QLVTDataSet.PhieuNhapDataTable();
CTPhieuNhapDataTable = new QLVTDataSet.CTPhieuNhapDataTable();
NhanVienTableAdapter = new QLVTDataSetTableAdapters.NhanVienTableAdapter();
NhanVienTableAdapter.Adapter.InsertCommand.CommandText = "INSERT INTO NhanVien (Ten,Ho,Phai,DiaChi,SoDienThoai,TrangThai,NgaySinh,ChiNhanhId)"
+ "VALUES(@Ten,@Ho,@Phai,@DiaChi,@SoDienThoai,@TrangThai,@NgaySinh,@ChiNhanhId)";
KhoTableAdapter = new QLVTDataSetTableAdapters.KhoTableAdapter();
KhoTableAdapter.Adapter.InsertCommand.CommandText =
"IF(@KhoId < 0) INSERT INTO Kho (Ten,ViTri,ChiNhanhId) VALUES(@Ten,@ViTri,@ChiNhanhId) "
+ "ELSE INSERT INTO Kho (KhoId,Ten,ViTri,ChiNhanhId) VALUES(@KhoId,@Ten,@ViTri,@ChiNhanhId)";
KhachHangTableAdapter = new QLVTDataSetTableAdapters.KhachHangTableAdapter();
KhachHangTableAdapter.Adapter.InsertCommand.CommandText =
"IF(@KhachHangId < 0) INSERT INTO KhachHang (Ten,SoDienThoai,DiaChi,ChiNhanhId) VALUES(@Ten,@SoDienThoai,@DiaChi,@ChiNhanhId)"
+ "ELSE INSERT INTO KhachHang (KhachHangId,Ten,SoDienThoai,DiaChi,ChiNhanhId) VALUES(@KhachHangId,@Ten,@SoDienThoai,@DiaChi,@ChiNhanhId)";
NhaCungCapTableAdapter = new QLVTDataSetTableAdapters.NhaCungCapTableAdapter();
NhaCungCapTableAdapter.Adapter.InsertCommand.CommandText =
"IF(@NhaCungCapId < 0) INSERT INTO NhaCungCap (Ten,SoDienThoai,DiaChi) VALUES(@Ten,@SoDienThoai,@DiaChi)"
+ "ELSE INSERT INTO NhaCungCap (NhaCungCapId,Ten,SoDienThoai,DiaChi) VALUES(@NhaCungCapId,@Ten,@SoDienThoai,@DiaChi)";
LoaiHangTableAdapter = new QLVTDataSetTableAdapters.LoaiHangTableAdapter();
LoaiHangTableAdapter.Adapter.InsertCommand.CommandText =
"IF(@LoaiHangId < 0) INSERT INTO LoaiHang (Ten) VALUES(@Ten)"
+ "ELSE INSERT INTO LoaiHang (LoaiHangId,Ten) VALUES(@LoaiHangId,@Ten)";
MatHangTableAdapter = new QLVTDataSetTableAdapters.MatHangTableAdapter();
MatHangTableAdapter.Adapter.InsertCommand.CommandText =
"IF(@MatHangId < 0) INSERT INTO MatHang (Ten,DonViTinh,LoaiHangId) VALUES(@Ten,@DonViTinh,@LoaiHangId)"
+ "ELSE INSERT INTO MatHang (MatHangId,Ten,DonViTinh,LoaiHangId) VALUES(@MatHangId,@Ten,@DonViTinh,@LoaiHangId)";
DatHangTableAdapter = new QLVTDataSetTableAdapters.DatHangTableAdapter();
//DatHangTableAdapter.Adapter.InsertCommand.CommandText =
// "IF(@DatHangId < 0) INSERT INTO DatHang (NhanVienId,NhaCungCapId,ThoiGian) VALUES(@NhanVienId,@NhaCungCapId)"
// + "ELSE INSERT INTO DatHang (DatHangId,Ten,DonViTinh,LoaiHangId) VALUES(@DatHangId,@NhanVienId,@NhaCungCapId)";
CTDatHangTableAdapter = new QLVTDataSetTableAdapters.CTDatHangTableAdapter();
PhieuNhapTableAdapter = new QLVTDataSetTableAdapters.PhieuNhapTableAdapter();
PhieuNhapTableAdapter.Adapter.InsertCommand.CommandText = "INSERT INTO PhieuNhap (NhanVienId,KhoId,DatHangId) VALUES(@NhanVienId,@KhoId,@DatHangId)";
HoaDonTableAdapter = new QLVTDataSetTableAdapters.HoaDonTableAdapter();
//HoaDonTableAdapter.Adapter.InsertCommand.CommandText= "INSERT INTO HoaDon (NhanVienId,KhoId,DatHangId) VALUES(@NhanVienId,@KhoId,@DatHangId)";
CTHoaDonTableAdapter = new QLVTDataSetTableAdapters.CTHoaDonTableAdapter();
CTPhieuNhapTableAdapter = new QLVTDataSetTableAdapters.CTPhieuNhapTableAdapter();
}
//static AddPhieuNhap()
//{
// if (signleton == null)
// {
// signleton = new AddPhieuNhap();
// }
//}
public AddPhieuNhap(string dhid)
{
this.dhId = dhid;
InitializeComponent();
ViewModel d = new ViewModel();
dgKho.ItemsSource = Common.KhoDataTable;
QLVTDataSet.CTDatHangDataTable dhs = new QLVTDataSet.CTDatHangDataTable();
DataTable tb = Common.CTDatHangDataTable.Select("DatHangId = " + dhId).CopyToDataTable();
if (tb.Rows.Count > 0)
{
dhs.Merge(tb);
}
dgCTDH.ItemsSource = dhs;
dgCTPN.ItemsSource = ctpn = new QLVTDataSet.CTPhieuNhapDataTable();
d.Kho = dgKho.SelectedValue;
this.DataContext = d;
//ctpn.ColumnChanging += (e, v) => {
// if (v.Row.RowState == DataRowState.Detached)
// return;
// id = v.Row["MatHangId"];
// old= v.Row["SoLuong"];
//};
bool change = false;
ctpn.ColumnChanged += (e, v) => {
if (v.Row.RowState == DataRowState.Detached || change)
{
return;
}
Object current, id;
id = v.Row["MatHangId"];
current = v.Row["SoLuong"];
DataRow[] dataRows = ((QLVTDataSet.CTDatHangDataTable)dgCTDH.ItemsSource).Select("MatHangId = '" + id + "'");
if (dataRows.Length > 0)
{
int sl = (int)dataRows[0]["SoLuong"];
if (sl < ((int)current))
{
change = true;
v.Row["SoLuong"] = dataRows[0]["SoLuong"];
MessageBox.Show("Số lượng mặt hàng đang chọn không thể lớn hơn " + sl);
}
}
change = false;
};
//EventHandler eventHandler = (o, i) => { signleton = new AddPhieuNhap(); };
//this.Closed += eventHandler;
}
private void txbVT_KeyUp(object sender, KeyEventArgs e)
{
QLVTDataSet.CTDatHangDataTable matHangs = new QLVTDataSet.CTDatHangDataTable();
try
{
DataTable table;
int rs;
if (int.TryParse(txbVT.Text, out rs))
{
table = Common.CTDatHangDataTable.Select("MatHangId = " + rs).CopyToDataTable();
matHangs.Merge(table);
dgCTDH.ItemsSource = matHangs;
}
}
catch (Exception ex)
{
}
}
private AddDatHang()
{
InitializeComponent();
ViewModel viewModel = new ViewModel();
this.DataContext = viewModel;
dgNhaCungCap.ItemsSource = Common.NhaCungCapDataTable;
dgMatHang.ItemsSource = Common.MatHangDataTable;
dgCTDH.ItemsSource = ctdh = new QLVTDataSet.CTDatHangDataTable();
EventHandler eventHandler = (o, i) => { signleton = new AddDatHang(); };
this.Closed += eventHandler;
//viewModel.NhaCungCap = dgNhaCungCap.SelectedValue;
//viewModel.ChiTietDatHang = dgCTDH.SelectedValue;
}
//private void btnEdit_Click(object sender, RoutedEventArgs e)
//{
// if (dgContent.CurrentItem != null)
// {
// //tableLog.SetRowChange(((DataRowView)dgContent.CurrentItem).Row);
// AddKho addKho = new AddKho(((DataRowView)dgContent.CurrentItem).Row);
// addKho.dataGrid = this.dgContent;
// addKho.Show();
// }
// else
// {
// MessageBox.Show("Không có hàng nào được chọn!");
// }
//}
private void btnRemove_Click(object sender, RoutedEventArgs e)
{
if (dgContent.CurrentItem != null)
{
DataRow row = ((DataRowView)dgContent.CurrentItem).Row;
string ms = "Đơn đặt hàng sau khi xóa sẻ không thể khôi phục. Bạn chắn chắn muốn xóa " + row["DatHangId"] + " ?";
System.Windows.Forms.DialogResult result = System.Windows.Forms.MessageBox.Show(ms, "Xóa đơn đặt hàng", System.Windows.Forms.MessageBoxButtons.YesNo);
if (result == System.Windows.Forms.DialogResult.Yes)
{
try
{
QLVTDataSet.CTDatHangDataTable ctdh = new QLVTDataSet.CTDatHangDataTable();
DataTable dataTable = ((DataRow[])dgCTContent.ItemsSource).CopyToDataTable();
ctdh.Merge(dataTable);
foreach (var r in ctdh)
{
r.Delete();
}
Common.CTDatHangTableAdapter.Connection = Common.connection;
Common.CTDatHangTableAdapter.Update(ctdh);
((DataRowView)dgContent.CurrentItem).Delete();
Common.DatHangTableAdapter.Connection = Common.connection;
Common.DatHangTableAdapter.Update((QLVTDataSet.DatHangDataTable)dgContent.ItemsSource);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (result == System.Windows.Forms.DialogResult.No)
{
//no...
}
}
else
{
MessageBox.Show("Không có hàng nào được chọn!");
}
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
ForceValidation();
if (!Validation.GetHasError(dgNhaCungCap) && dgCTDH.Items.Count > 0)
{
DataRow ncc = ((DataRowView)dgNhaCungCap.SelectedItem).Row;
string sql = "exec SP_DATHANG @NhanVien = " + Common.CurrentUser + " ,@NhaCungCap = " + ncc["NhaCungCapId"];
SqlCommand c = new SqlCommand(sql, Common.connection);
if (Common.connection.State != ConnectionState.Open)
{
Common.connection.Open();
}
SqlDataReader reader = c.ExecuteReader();
reader.Read();
String dhId = reader.GetValue(0).ToString();
reader.Close();
QLVTDataSet.CTDatHangDataTable datHangRows = (QLVTDataSet.CTDatHangDataTable)dgCTDH.ItemsSource;
foreach (DataRow row in datHangRows.Rows)
{
row["DatHangId"] = dhId;
}
Common.CTDatHangTableAdapter.Connection = Common.connection;
Common.CTDatHangTableAdapter.Update(datHangRows);
DatHang.loadData(0);
//this.Close();
dgCTDH.SelectedIndex = -1;
dgNhaCungCap.SelectedIndex = -1;
dgMatHang.SelectedIndex = -1;
dgCTDH.ItemsSource = ctdh = new QLVTDataSet.CTDatHangDataTable();
MessageBox.Show("Đã thêm!");
}
else
if (dgCTDH.Items.Count == 0)
{
MessageBox.Show("Không được bỏ trống chi tiết đặt hàng.");
}
}
