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");
}
}
}
