public int InsertUpdate(Entities.PhieuDieuChuyenKhoNoiBo PhieuDCK) { try { pdcknb = new Constants.PhieuDieuChuyenKhoNoiBo(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdatePhieuDieuChuyenKhoNoiBo; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pdcknb.HanhDong, SqlDbType.NVarChar, 20).Value = PhieuDCK.HanhDong; cmd.Parameters.Add(pdcknb.PhieuDieuChuyenKhoID, SqlDbType.Int).Value = PhieuDCK.PhieuDieuChuyenKhoID; cmd.Parameters.Add(pdcknb.MaPhieuDieuChuyenKho, SqlDbType.NVarChar, 20).Value = PhieuDCK.MaPhieuDieuChuyenKho; cmd.Parameters.Add(pdcknb.NgayDieuChuyen, SqlDbType.DateTime).Value = PhieuDCK.NgayDieuChuyen; cmd.Parameters.Add(pdcknb.TuKho, SqlDbType.VarChar, 20).Value = PhieuDCK.TuKho; cmd.Parameters.Add(pdcknb.DenKho, SqlDbType.VarChar, 20).Value = PhieuDCK.DenKho; cmd.Parameters.Add(pdcknb.MaHoaDonNhap, SqlDbType.VarChar, 20).Value = PhieuDCK.MaHoaDonNhap; cmd.Parameters.Add(pdcknb.XacNhan, SqlDbType.Bit).Value = PhieuDCK.XacNhan; cmd.Parameters.Add(pdcknb.GhiChu, SqlDbType.NVarChar, 100).Value = PhieuDCK.GhiChu; cmd.Parameters.Add(pdcknb.Deleted, SqlDbType.Bit).Value = PhieuDCK.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return(i); } catch (Exception ex) { string s = ex.Message; return(0); } }
public void LayPhieuDieuChuyenKhoNoiBo() { try { List <Entities.PhieuDieuChuyenKhoNoiBo> listTemp = new List <Entities.PhieuDieuChuyenKhoNoiBo>(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.PhieuDieuChuyenKhoNoiBo ctxh = new Entities.PhieuDieuChuyenKhoNoiBo("Select", 1); clientstrem = cl.SerializeObj(this.client, "PhieuDieuCHuyenKhoNoiBo", ctxh); Entities.PhieuDieuChuyenKhoNoiBo[] PDieuChuyen1 = new Entities.PhieuDieuChuyenKhoNoiBo[0]; PDieuChuyen1 = (Entities.PhieuDieuChuyenKhoNoiBo[])cl.DeserializeHepper1(clientstrem, PDieuChuyen1); if (PDieuChuyen1 == null) { PDieuChuyen1 = new Entities.PhieuDieuChuyenKhoNoiBo[0]; } for (int i = 0; i < PDieuChuyen1.Length; i++) { DateTime ngaydieuchuyen = PDieuChuyen1[i].NgayDieuChuyen; if (ngaydieuchuyen >= BatDau && ngaydieuchuyen <= KetThuc) { listTemp.Add(PDieuChuyen1[i]); } } // PDieuChuyen = listTemp.ToArray(); } catch { } }
public Entities.PhieuDieuChuyenKhoNoiBo[] Select() { Entities.PhieuDieuChuyenKhoNoiBo[] arrC = null; try { pdcknb = new Constants.PhieuDieuChuyenKhoNoiBo(); Sql = new Constants.Sql(); string sql = Sql.SelectAllPhieuDieuChuyenKhoNoiBo; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.PhieuDieuChuyenKhoNoiBo phieudieuchuyen = new Entities.PhieuDieuChuyenKhoNoiBo(); phieudieuchuyen.PhieuDieuChuyenKhoID = Convert.ToInt32(dr[pdcknb.PhieuDieuChuyenKhoID].ToString()); phieudieuchuyen.MaPhieuDieuChuyenKho = dr[pdcknb.MaPhieuDieuChuyenKho].ToString(); phieudieuchuyen.NgayDieuChuyen = Convert.ToDateTime(dr[pdcknb.NgayDieuChuyen]); phieudieuchuyen.TuKho = dr[pdcknb.TuKho].ToString(); phieudieuchuyen.DenKho = dr[pdcknb.DenKho].ToString(); phieudieuchuyen.MaHoaDonNhap = dr[pdcknb.MaHoaDonNhap].ToString(); phieudieuchuyen.XacNhan = (bool)dr[pdcknb.XacNhan]; phieudieuchuyen.GhiChu = dr[pdcknb.GhiChu].ToString(); phieudieuchuyen.Deleted = (Boolean)dr[pdcknb.Deleted]; arr.Add(phieudieuchuyen); } int n = arr.Count; if (n == 0) { return(null); } arrC = new Entities.PhieuDieuChuyenKhoNoiBo[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.PhieuDieuChuyenKhoNoiBo)arr[i]; } for (int i = 0; i < n; i++) { arrC[i].TenKhoDi = LayTenKho(arrC[i].TuKho); arrC[i].TenKhoDen = LayTenKho(arrC[i].DenKho); } } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(arrC); }
private void tsslXacNhan_Click(object sender, EventArgs e) { if (check_Xacnhan.Checked == true) { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhoHang kho1 = (Entities.KhoHang)cbxTukho.SelectedItem; Entities.KhoHang kho2 = (Entities.KhoHang)cbxDenkho.SelectedItem; Entities.PhieuDieuChuyenKhoNoiBo nv = new Entities.PhieuDieuChuyenKhoNoiBo("Update", PDCKID, txtSochungtu.Text, ConvertDatetime(makNgaychungtu.Text), kho1.MaKho, "", kho2.MaKho, "", maHDNhap, check_Xacnhan.Checked, ghichu, false); clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", nv); int msg = 0; msg = (int)cl.DeserializeHepper(clientstrem, msg); if (msg == 1) { // tru so luong tu kho Entities.KhoHang khoh = (Entities.KhoHang)cbxTukho.SelectedItem; CheckDataGridTruSL(dgvInsertOrder, khoh.MaKho); // Update so luong khi co hang hoa tong tai trong kho den Entities.KhoHang khoDen = (Entities.KhoHang)cbxDenkho.SelectedItem; CheckDataGridCongSL1(dgvInsertOrder, khoDen.MaKho); // Insert so luong kho ko co hang hoa do CheckDataGridCongSL(dgvInsertOrder, khoDen.MaKho); } else { MessageBox.Show("Update that bai"); return; } this.Close(); } else { if (check_Xacnhan.Checked == false) { MessageBox.Show("Chưa xác nhận vào checkbox xác nhận ", "Hệ Thống Cảnh Báo"); } } }
public void Delete(Entities.PhieuDieuChuyenKhoNoiBo phieuDCK) { try { pdcknb = new Constants.PhieuDieuChuyenKhoNoiBo(); Sql = new Constants.Sql(); string sql = Sql.DeletePhieuDieuChuyenKhoNoiBo; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pdcknb.HanhDong, SqlDbType.NVarChar, 20).Value = phieuDCK.HanhDong; cmd.Parameters.Add(pdcknb.PhieuDieuChuyenKhoID, SqlDbType.Int).Value = phieuDCK.PhieuDieuChuyenKhoID; cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; } catch (Exception ex) { string s = ex.Message; } }
public void LayPhieuDieuChuyenKhoNoiBo() { try { Entities.PhieuDieuChuyenKhoNoiBo[] PDieuChuyen1 = new Entities.PhieuDieuChuyenKhoNoiBo[0]; PDieuChuyen1 = new BizLogic.PhieuDieuChuyenKhoNoiBo().Select(); if (PDieuChuyen1 == null) { PDieuChuyen1 = new Entities.PhieuDieuChuyenKhoNoiBo[0]; PDieuChuyen = PDieuChuyen1; return; } int count = 0; for (int i = 0; i < PDieuChuyen1.Length; i++) { DateTime ngaydieuchuyen = PDieuChuyen1[i].NgayDieuChuyen; if (ngaydieuchuyen >= BatDau && ngaydieuchuyen <= KetThuc) { count++; } } PDieuChuyen = new Entities.PhieuDieuChuyenKhoNoiBo[count]; count = 0; for (int i = 0; i < PDieuChuyen1.Length; i++) { DateTime ngaydieuchuyen = PDieuChuyen1[i].NgayDieuChuyen; if (ngaydieuchuyen >= BatDau && ngaydieuchuyen <= KetThuc) { PDieuChuyen[count] = PDieuChuyen1[i]; count++; } } } catch { } }
private void toolStripStatusLabel2_Click(object sender, EventArgs e) { try { if (Validate()) { CheckConflictUpdate(); if (kt == "ok") { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhoHang kho1 = (Entities.KhoHang)cbxTukho.SelectedItem; Entities.KhoHang kho2 = (Entities.KhoHang)cbxDenkho.SelectedItem; Entities.PhieuDieuChuyenKhoNoiBo nv = new Entities.PhieuDieuChuyenKhoNoiBo("Update", PDCKID, txtSochungtu.Text, ConvertDatetime(makNgaychungtu.Text), kho1.MaKho, "a", kho2.MaKho, "a", "", false, txtDiengiai.Text, false); clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", nv); int msg = 0; msg = (int)cl.DeserializeHepper(clientstrem, msg); if (msg != 1) MessageBox.Show("Update that bai"); maPDCK = txtSochungtu.Text; ngaychungtu = xulyNgay(ConvertDatetime(makNgaychungtu.Text)); tukho = kho1.MaKho; denkho = kho2.MaKho; ghichu = txtDiengiai.Text; cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.ChiTietPhieuDieuChuyenKho ctpdck11 = new Entities.ChiTietPhieuDieuChuyenKho("Delete", maPDCK); clientstrem = cl.SerializeObj(this.client1, "ChiTietPhieuDieuCHuyenKhoNoiBo", ctpdck11); int msg1 = 0; msg1 = (int)cl.DeserializeHepper(clientstrem, msg1); int count = 0; int kiemtra = 1; Server_Client.Client cl1 = new Server_Client.Client(); TcpClient client2; NetworkStream stream; while ((count < arrct.Length) && (kiemtra == 1)) { cl1 = new Server_Client.Client(); client2 = cl.Connect(Luu.IP, Luu.Ports); Entities.ChiTietPhieuDieuChuyenKho ctpdck = new Entities.ChiTietPhieuDieuChuyenKho("Insert", arrct[count].MaPhieuDieuChuyenKho, arrct[count].MaHangHoa, arrct[count].SoLuong, arrct[count].NgayHetHan, " ", false); stream = cl.SerializeObj(client2, "ChiTietPhieuDieuCHuyenKhoNoiBo", ctpdck); kiemtra = (int)cl.DeserializeHepper(stream, kiemtra); count++; } this.Close(); } } } catch { } }
public void CheckConflictUpdate() { try { cl = new Server_Client.Client(); // gán TCPclient this.client1 = cl.Connect(Luu.IP, Luu.Ports); // khởi tạo biến truyền vào với hàm khởi tạo Entities.PhieuDieuChuyenKhoNoiBo pt = new Entities.PhieuDieuChuyenKhoNoiBo("Select", 1); // khởi tạo mảng đối tượng để hứng giá trị Entities.PhieuDieuChuyenKhoNoiBo[] nv1 = new Entities.PhieuDieuChuyenKhoNoiBo[1]; clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", pt); // đổ mảng đối tượng vào datagripview Entities.PhieuDieuChuyenKhoNoiBo[] nv2 = (Entities.PhieuDieuChuyenKhoNoiBo[])cl.DeserializeHepper1(clientstrem, nv1); if (nv2 != null) { for (int j = 0; j < nv2.Length; j++) { if (nv2[j].MaPhieuDieuChuyenKho == maPDCK) { kt = Check(nv2[j]); break; } else kt = "null"; } } } catch { } }
private void tsslthemmoi_Click(object sender, EventArgs e) { try { if (Validate()) { CheckConflictInsert(); if (kt == "ok") { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhoHang kho1 = (Entities.KhoHang)cbxTukho.SelectedItem; Entities.KhoHang kho2 = (Entities.KhoHang)cbxDenkho.SelectedItem; Entities.PhieuDieuChuyenKhoNoiBo nv = new Entities.PhieuDieuChuyenKhoNoiBo("Insert", 1, txtSochungtu.Text, ConvertDatetime(makNgaychungtu.Text), kho1.MaKho, "a", kho2.MaKho, "a", "", false, txtDiengiai.Text, false); clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", nv); int msg = 0; msg = (int)cl.DeserializeHepper(clientstrem, msg); if (msg != 1) { MessageBox.Show("Insert Thất Bại"); } txtSochungtu.Text = LayID("PhieuDieuCHuyenKho"); makNgaychungtu.Text = ""; tukho = kho1.MaKho; denkho = kho2.MaKho; int count = 0; int kiemtra = 1; Server_Client.Client cl1 = new Server_Client.Client(); TcpClient client2; NetworkStream stream; while ((count < arrct.Length) && (kiemtra == 1)) { cl1 = new Server_Client.Client(); client2 = cl.Connect(Luu.IP, Luu.Ports); Entities.ChiTietPhieuDieuChuyenKho ctpdck = new Entities.ChiTietPhieuDieuChuyenKho("Insert", arrct[count].MaPhieuDieuChuyenKho, arrct[count].MaHangHoa, arrct[count].SoLuong, arrct[count].NgayHetHan, " ", false); stream = cl.SerializeObj(client2, "ChiTietPhieuDieuCHuyenKhoNoiBo", ctpdck); kiemtra = (int)cl.DeserializeHepper(stream, kiemtra); count++; } dgvInsertOrder.DataSource = new Entities.ChiTietPhieuDieuChuyenKho[0]; FixDataGridView(); arrct = null; arr.Clear(); frmHienThi_DieuChuyenKhoNoiBo.KiemTra = "insert"; this.Close(); } } } catch { } }
public void CheckConflictInsert() { try { cl = new Server_Client.Client(); // gán TCPclient this.client1 = cl.Connect(Luu.IP, Luu.Ports); // khởi tạo biến truyền vào với hàm khởi tạo Entities.PhieuDieuChuyenKhoNoiBo pt = new Entities.PhieuDieuChuyenKhoNoiBo("Select", 1); // khởi tạo mảng đối tượng để hứng giá trị Entities.PhieuDieuChuyenKhoNoiBo[] pt1 = new Entities.PhieuDieuChuyenKhoNoiBo[1]; clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", pt); // đổ mảng đối tượng vào datagripview pt1 = (Entities.PhieuDieuChuyenKhoNoiBo[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 != null) { for (int j = 0; j < pt1.Length; j++) { if (pt1[j].MaPhieuDieuChuyenKho == txtSochungtu.Text) { MessageBox.Show("cập nhật số chứng từ - kiểm tra lại để insert"); kt = "ko"; txtSochungtu.Text = LayID("PhieuDieuChuyenKho"); break; } else kt = "ok"; } } else { kt = "ok"; } } catch { } }
public void LayPhieuDieuChuyenKhoNoiBo() { try { Entities.PhieuDieuChuyenKhoNoiBo[] PDieuChuyen1 = new Entities.PhieuDieuChuyenKhoNoiBo[0]; PDieuChuyen1 = new BizLogic.PhieuDieuChuyenKhoNoiBo().Select(); if (PDieuChuyen1 == null) { PDieuChuyen1 = new Entities.PhieuDieuChuyenKhoNoiBo[0]; PDieuChuyen = PDieuChuyen1; return; } int count = 0; for (int i = 0; i < PDieuChuyen1.Length; i++) { DateTime ngaydieuchuyen = PDieuChuyen1[i].NgayDieuChuyen; if (ngaydieuchuyen >= BatDau && ngaydieuchuyen <= KetThuc) { count++; } } PDieuChuyen = new Entities.PhieuDieuChuyenKhoNoiBo[count]; count = 0; for (int i = 0; i < PDieuChuyen1.Length; i++) { DateTime ngaydieuchuyen = PDieuChuyen1[i].NgayDieuChuyen; if (ngaydieuchuyen >= BatDau && ngaydieuchuyen <= KetThuc) { PDieuChuyen[count] = PDieuChuyen1[i]; count++; } } } catch { } }
public void LayPhieuDieuChuyenKhoNoiBo() { try { List<Entities.PhieuDieuChuyenKhoNoiBo> listTemp = new List<Entities.PhieuDieuChuyenKhoNoiBo>(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.PhieuDieuChuyenKhoNoiBo ctxh = new Entities.PhieuDieuChuyenKhoNoiBo("Select", 1); clientstrem = cl.SerializeObj(this.client, "PhieuDieuCHuyenKhoNoiBo", ctxh); Entities.PhieuDieuChuyenKhoNoiBo[] PDieuChuyen1 = new Entities.PhieuDieuChuyenKhoNoiBo[0]; PDieuChuyen1 = (Entities.PhieuDieuChuyenKhoNoiBo[])cl.DeserializeHepper1(clientstrem, PDieuChuyen1); if (PDieuChuyen1 == null) PDieuChuyen1 = new Entities.PhieuDieuChuyenKhoNoiBo[0]; for (int i = 0; i < PDieuChuyen1.Length; i++) { DateTime ngaydieuchuyen = PDieuChuyen1[i].NgayDieuChuyen; if (ngaydieuchuyen >= BatDau && ngaydieuchuyen <= KetThuc) { listTemp.Add(PDieuChuyen1[i]); } } // PDieuChuyen = listTemp.ToArray(); } catch { } }
public Entities.PhieuDieuChuyenKhoNoiBo[] SelectTheoMaKho(string MaKho) { Entities.PhieuDieuChuyenKhoNoiBo[] arrC = null; try { pdcknb = new Constants.PhieuDieuChuyenKhoNoiBo(); string sql = ""; sql = "Select * from PhieuDieuChuyenKho where TuKho='" + MaKho + "' and deleted =0"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.PhieuDieuChuyenKhoNoiBo phieudieuchuyen = new Entities.PhieuDieuChuyenKhoNoiBo(); phieudieuchuyen.PhieuDieuChuyenKhoID = Convert.ToInt32(dr[pdcknb.PhieuDieuChuyenKhoID].ToString()); phieudieuchuyen.MaPhieuDieuChuyenKho = dr[pdcknb.MaPhieuDieuChuyenKho].ToString(); phieudieuchuyen.NgayDieuChuyen = Convert.ToDateTime(dr[pdcknb.NgayDieuChuyen]); phieudieuchuyen.TuKho = dr[pdcknb.TuKho].ToString(); phieudieuchuyen.DenKho = dr[pdcknb.DenKho].ToString(); phieudieuchuyen.MaHoaDonNhap = dr[pdcknb.MaHoaDonNhap].ToString(); phieudieuchuyen.XacNhan = (bool)dr[pdcknb.XacNhan]; phieudieuchuyen.GhiChu = dr[pdcknb.GhiChu].ToString(); phieudieuchuyen.Deleted = (Boolean)dr[pdcknb.Deleted]; arr.Add(phieudieuchuyen); } int n = arr.Count; if (n == 0) { return null; } arrC = new Entities.PhieuDieuChuyenKhoNoiBo[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.PhieuDieuChuyenKhoNoiBo)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return arrC; }
private void tsslXacNhan_Click(object sender, EventArgs e) { if (check_Xacnhan.Checked == true) { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhoHang kho1 = (Entities.KhoHang)cbxTukho.SelectedItem; Entities.KhoHang kho2 = (Entities.KhoHang)cbxDenkho.SelectedItem; Entities.PhieuDieuChuyenKhoNoiBo nv = new Entities.PhieuDieuChuyenKhoNoiBo("Update", PDCKID, txtSochungtu.Text, ConvertDatetime(makNgaychungtu.Text), kho1.MaKho, "", kho2.MaKho, "", maHDNhap, check_Xacnhan.Checked, ghichu, false); clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", nv); int msg = 0; msg = (int)cl.DeserializeHepper(clientstrem, msg); if (msg == 1) { // tru so luong tu kho Entities.KhoHang khoh = (Entities.KhoHang)cbxTukho.SelectedItem; CheckDataGridTruSL(dgvInsertOrder, khoh.MaKho); // Update so luong khi co hang hoa tong tai trong kho den Entities.KhoHang khoDen = (Entities.KhoHang)cbxDenkho.SelectedItem; CheckDataGridCongSL1(dgvInsertOrder, khoDen.MaKho); // Insert so luong kho ko co hang hoa do CheckDataGridCongSL(dgvInsertOrder, khoDen.MaKho); } else { MessageBox.Show("Update that bai"); return; } this.Close(); } else { if (check_Xacnhan.Checked == false) { MessageBox.Show("Chưa xác nhận vào checkbox xác nhận ", "Hệ Thống Cảnh Báo"); } } }