public Entities.ChiTietPhieuDieuChuyenKho[] LayChiTiet_PhieuDieuChuyenKho_TheoMaPhieu(string maPhieu)
{
int count = 0;
for (int i = 0; i < ctPDCK.Length; i++)
{
if (ctPDCK[i].MaPhieuDieuChuyenKho == maPhieu)
{
count++;
}
}
Entities.ChiTietPhieuDieuChuyenKho[] ctPDCK1 = new Entities.ChiTietPhieuDieuChuyenKho[count];
count = 0;
for (int i = 0; i < ctPDCK.Length; i++)
{
if (ctPDCK[i].MaPhieuDieuChuyenKho == maPhieu)
{
ctPDCK1[count] = ctPDCK[i];
count++;
}
}
if (ctPDCK1 == null)
{
ctPDCK1 = new Entities.ChiTietPhieuDieuChuyenKho[0];
return(ctPDCK1);
}
else
{
return(ctPDCK1);
}
}
public int InsertUpdate(Entities.ChiTietPhieuDieuChuyenKho CTPhieuDCK)
{
try
{
ctpdck = new Constants.ChiTietPhieuDieuChuyenKho();
Sql = new Constants.Sql();
string sql = Sql.InsertUpdateChiTietPhieuDieuChuyenKho;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(ctpdck.HanhDong, SqlDbType.NVarChar, 20).Value = CTPhieuDCK.HanhDong;
cmd.Parameters.Add(ctpdck.MaPhieuDieuChuyenKho, SqlDbType.NVarChar, 20).Value = CTPhieuDCK.MaPhieuDieuChuyenKho;
cmd.Parameters.Add(ctpdck.MaHangHoa, SqlDbType.NVarChar, 50).Value = CTPhieuDCK.MaHangHoa;
cmd.Parameters.Add(ctpdck.SoLuong, SqlDbType.Int).Value = CTPhieuDCK.SoLuong;
cmd.Parameters.Add(ctpdck.GhiChu, SqlDbType.NVarChar, 100).Value = CTPhieuDCK.GhiChu;
cmd.Parameters.Add(ctpdck.Deleted, SqlDbType.Bit).Value = CTPhieuDCK.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 Entities.ChiTietPhieuDieuChuyenKho[] SelectTheoMaPhieu(string maPDCK)
{
Entities.ChiTietPhieuDieuChuyenKho[] arrC = null;
try
{
ctpdck = new Constants.ChiTietPhieuDieuChuyenKho();
string sql = "";
sql = "select * from ChiTietPhieuDieuChuyenKho where MaPhieuDieuChuyenKho='" + maPDCK + "' 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.ChiTietPhieuDieuChuyenKho CTphieudieuchuyen = new Entities.ChiTietPhieuDieuChuyenKho();
CTphieudieuchuyen.MaPhieuDieuChuyenKho = dr[ctpdck.MaPhieuDieuChuyenKho].ToString();
CTphieudieuchuyen.MaHangHoa = dr[ctpdck.MaHangHoa].ToString();
CTphieudieuchuyen.SoLuong = int.Parse(dr[ctpdck.SoLuong].ToString());
CTphieudieuchuyen.GhiChu = dr[ctpdck.GhiChu].ToString();
CTphieudieuchuyen.Deleted = (Boolean)dr[ctpdck.Deleted];
arr.Add(CTphieudieuchuyen);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
arrC = new Entities.ChiTietPhieuDieuChuyenKho[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.ChiTietPhieuDieuChuyenKho)arr[i];
}
for (int i = 0; i < n; i++)
{
arrC[i].NgayHetHan = LayHSD(arrC[i].MaPhieuDieuChuyenKho, arrC[i].MaHangHoa);
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(arrC);
}
public void LayChiTiet_PhieuDieuChuyenKho()
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietPhieuDieuChuyenKho ctxh = new Entities.ChiTietPhieuDieuChuyenKho("Select");
clientstrem = cl.SerializeObj(this.client, "ChiTietPhieuDieuCHuyenKhoNoiBo", ctxh);
ctPDCK = new Entities.ChiTietPhieuDieuChuyenKho[0];
ctPDCK = (Entities.ChiTietPhieuDieuChuyenKho[])cl.DeserializeHepper1(clientstrem, ctPDCK);
if (ctPDCK == null)
{
ctPDCK = new Entities.ChiTietPhieuDieuChuyenKho[0];
return;
}
}
public void HienThiChiTietTheoPDCK(string Phieudieuchuyenkho)
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietPhieuDieuChuyenKho kh = new Entities.ChiTietPhieuDieuChuyenKho("Select");
clientstrem = cl.SerializeObj(this.client1, "ChiTietPhieuDieuCHuyenKhoNoiBo", kh);
Entities.ChiTietPhieuDieuChuyenKho[] kh1 = new Entities.ChiTietPhieuDieuChuyenKho[1];
kh1 = (Entities.ChiTietPhieuDieuChuyenKho[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 != null)
{
int count = 0;
for (int i = 0; i < kh1.Length; i++)
{
if (kh1[i].MaPhieuDieuChuyenKho == Phieudieuchuyenkho)
{
count++;
}
}
Entities.ChiTietPhieuDieuChuyenKho[] ctpdck1 = new Entities.ChiTietPhieuDieuChuyenKho[count];
count = 0;
for (int i = 0; i < kh1.Length; i++)
{
if (kh1[i].MaPhieuDieuChuyenKho == txtSochungtu.Text)
{
ctpdck1[count] = kh1[i];
count++;
}
}
for (int i = 0; i < count; i++)
{
arr.Add(ctpdck1[i]);
}
arrct = new Entities.ChiTietPhieuDieuChuyenKho[count];
for (int i = 0; i < count; i++)
{
arrct[i] = ctpdck1[i];
}
ctcount = count;
dgvInsertOrder.DataSource = ctpdck1;
FixDataGridView();
}
}
private void toolStrip_btnThem_Click(object sender, EventArgs e)
{
//ấn btn thêm
try
{
if (Convert.ToInt32(toolStrip_txtSoluong.Text) <= 0)
{
MessageBox.Show("Số Lượng Điều Chuyển Phải Lớn Hơn 0.");
return;
}
if (string.IsNullOrEmpty(toolStrip_txtTen.Text))
{
MessageBox.Show("Mã hàng hoá không hợp lệ hãy kiểm tra lại");
return;
}
else
{
if (ct != null) //ct là một datagridRow quăng từ frm Chọn mã hàng hóa. => khác rỗng!
{
int kt = -1;
Entities.ChiTietPhieuDieuChuyenKho ctpdck = new Entities.ChiTietPhieuDieuChuyenKho();
#region hiện tại ctcount = 0 => kt không thay đổi (nếu ctcount lớn hơn 0 thì kiểm tra để thay đổi biến kt)
if (ctcount > 0) //[ctcount: chưa rõ để làm gì?]
{
for (int i = 0; i < ctcount; i++)
{
Entities.ChiTietPhieuDieuChuyenKho ct1 = (Entities.ChiTietPhieuDieuChuyenKho)arr[i];
if (ct1.MaHangHoa == toolStrip_txtTracuu.Text)
{
kt = i;
ct1.MaHangHoa = toolStrip_txtTracuu.Text;
ct1.TenHangHoa = toolStrip_txtTen.Text;
ct1.SoLuong = ct1.SoLuong + int.Parse(toolStrip_txtSoluong.Text);
}
}
}
#endregion
if (kt != -1)
{
arrct = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
for (int j = 0; j < ctcount; j++)
{
arrct[j] = (Entities.ChiTietPhieuDieuChuyenKho)arr[j];
}
}
else
{
//Check: Hàng hóa, gói hàng
string mahanghoa = toolStrip_txtTracuu.Text;
if (Common.Utilities.CheckHangHoaOrGoiHang(mahanghoa, this.goihang, this.chitietgoihang))
{ //là gói hàng
//lấy hàng hóa trong gói hàng
Entities.tem1[] dshh = this.LayHangHoaTrongGoiHang(mahanghoa, this.goihang, this.chitietgoihang);
for (int i = 0; i < dshh.Length; i++)
{
bool kiemtraquydoi = false;
//kiểm tra có phải quy đổi đơn vị tính không?
foreach (Entities.QuyDoiDonViTinh item in quidoidvt)
{
if (item.MaHangQuyDoi.Equals(dshh[i].MaHangHoa))
{
ctpdck.MaPhieuDieuChuyenKho = txtSochungtu.Text;
ctpdck.MaHangHoa = item.MaHangDuocQuyDoi;
ctpdck.TenHangHoa = item.TenHangDuocQuyDoi;
ctpdck.SoLuong = ((Convert.ToInt32(item.SoLuongDuocQuyDoi) * Convert.ToInt32(dshh[i].SoLuong)) / item.SoLuongQuyDoi) * Convert.ToInt32(toolStrip_txtSoluong.Text);
ctpdck.NgayHetHan = GetNgayHetHan(ctpdck.MaHangHoa, this.ctkArr);
kiemtraquydoi = true;
break;
}
}
if (kiemtraquydoi) { }
else
{
ctpdck.MaPhieuDieuChuyenKho = txtSochungtu.Text;
ctpdck.MaHangHoa = dshh[i].MaHangHoa;
ctpdck.TenHangHoa = dshh[i].TenHangHoa;
ctpdck.SoLuong = Convert.ToInt32(dshh[i].SoLuong) * Convert.ToInt32(toolStrip_txtSoluong.Text);
ctpdck.NgayHetHan = GetNgayHetHan(ctpdck.MaHangHoa, this.ctkArr);
}
arr.Add(ctpdck);
ctcount++;
}
arrct = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
for (int i = 0; i < ctcount; i++)
{
arrct[i] = (Entities.ChiTietPhieuDieuChuyenKho)arr[i];
}
} //end Gói hàng
else
{//là hàng hóa
bool kiemtraquydoi = false;
//kiểm tra có phải quy đổi đơn vị tính không?
foreach (Entities.QuyDoiDonViTinh item in quidoidvt)
{
if (item.MaHangQuyDoi.Equals(mahanghoa))
{
ctpdck.MaPhieuDieuChuyenKho = txtSochungtu.Text;
ctpdck.MaHangHoa = item.MaHangDuocQuyDoi;
ctpdck.TenHangHoa = item.TenHangDuocQuyDoi;
ctpdck.SoLuong = (Convert.ToInt32(item.SoLuongDuocQuyDoi) * Convert.ToInt32(toolStrip_txtSoluong.Text)) / item.SoLuongQuyDoi;
ctpdck.NgayHetHan = GetNgayHetHan(ctpdck.MaHangHoa, this.ctkArr);
kiemtraquydoi = true;
break;
}
}
if (kiemtraquydoi) { }
else
{
ctpdck.MaPhieuDieuChuyenKho = txtSochungtu.Text;
ctpdck.MaHangHoa = mahanghoa;
ctpdck.TenHangHoa = toolStrip_txtTen.Text;
ctpdck.SoLuong = Convert.ToInt32(toolStrip_txtSoluong.Text);
ctpdck.NgayHetHan = GetNgayHetHan(ctpdck.MaHangHoa, this.ctkArr);
}
arr.Add(ctpdck);
ctcount++;
arrct = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
for (int i = 0; i < ctcount; i++)
{
arrct[i] = (Entities.ChiTietPhieuDieuChuyenKho)arr[i];
}
}///end hàng hóa
}
dgvInsertOrder.DataSource = arrct;
FixDataGridView();
}
}
}
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 HienThiChiTietTheoPDCK(string Phieudieuchuyenkho)
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietPhieuDieuChuyenKho kh = new Entities.ChiTietPhieuDieuChuyenKho("Select");
clientstrem = cl.SerializeObj(this.client1, "ChiTietPhieuDieuCHuyenKhoNoiBo", kh);
Entities.ChiTietPhieuDieuChuyenKho[] kh1 = new Entities.ChiTietPhieuDieuChuyenKho[1];
kh1 = (Entities.ChiTietPhieuDieuChuyenKho[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 != null)
{
ctcount = 0;
for (int i = 0; i < kh1.Length; i++)
{
if (kh1[i].MaPhieuDieuChuyenKho == Phieudieuchuyenkho)
{
ctcount++;
}
}
Entities.ChiTietPhieuDieuChuyenKho[] ctpdck1 = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
ctcount = 0;
for (int i = 0; i < kh1.Length; i++)
{
if (kh1[i].MaPhieuDieuChuyenKho == txtSochungtu.Text)
{
ctpdck1[ctcount] = kh1[i];
ctcount++;
}
}
for (int i = 0; i < ctcount; i++)
{
arr.Add(ctpdck1[i]);
}
arrct = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
for (int i = 0; i < ctcount; i++)
{
arrct[i] = ctpdck1[i];
}
LayBangHangHoa();
for (int i = 0; i < ctpdck1.Length; i++)
{
for (int j = 0; j < hanghoa.Length; j++)
{
if (ctpdck1[i].MaHangHoa == hanghoa[j].MaHangHoa)
{
ctpdck1[i].TenHangHoa = hanghoa[j].TenHangHoa;
break;
}
}
}
CtPdck_BaoCao = ctpdck1;
dgvInsertOrder.DataSource = ctpdck1;
FixDataGridView();
}
}
catch
{
}
}
public void HienThiChiTiet(string maHDNhap, string makho)
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietHoaDonNhap[] kh = new Entities.ChiTietHoaDonNhap[1];
kh[0] = new Entities.ChiTietHoaDonNhap("Select");
clientstrem = cl.SerializeObj(this.client1, "ChiTietHoaDonNhap", kh);
Entities.ChiTietHoaDonNhap[] kh1 = new Entities.ChiTietHoaDonNhap[1];
kh1 = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1.Length > 0)
{
int ctcount = 0;
foreach (Entities.ChiTietHoaDonNhap h in kh1)
{
if (h.MaHoaDonNhap == maHDNhap)
{
ctcount++;
}
}
Entities.ChiTietHoaDonNhap[] hdn = new Entities.ChiTietHoaDonNhap[ctcount];
ctcount = 0;
foreach (Entities.ChiTietHoaDonNhap h in kh1)
{
if (h.MaHoaDonNhap == maHDNhap)
{
hdn[ctcount] = new Entities.ChiTietHoaDonNhap();
hdn[ctcount].MaHangHoa = h.MaHangHoa;
hdn[ctcount].SoLuong = h.SoLuong;
ctcount++;
}
}
Server_Client.Client cl1 = new Server_Client.Client();
this.client1 = cl1.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietKhoHangTheoHoaHonNhap[] kho = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
kho[0] = new Entities.ChiTietKhoHangTheoHoaHonNhap("Select");
clientstrem = cl.SerializeObj(this.client1, "ChiTietKho", kho);
Entities.ChiTietKhoHangTheoHoaHonNhap[] kho1 = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
kho1 = (Entities.ChiTietKhoHangTheoHoaHonNhap[])cl.DeserializeHepper1(clientstrem, kho1);
Entities.ChiTietPhieuDieuChuyenKho[] ctdck = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
for (int i = 0; i < ctdck.Length; i++)
{
ctdck[i] = new Entities.ChiTietPhieuDieuChuyenKho();
ctdck[i].MaHangHoa = hdn[i].MaHangHoa;
ctdck[i].SoLuong = hdn[i].SoLuong;
ctdck[i].MaPhieuDieuChuyenKho = txtSochungtu.Text;
if (kho1 != null)
{
for (int j = 0; j < kho1.Length; j++)
{
if (kho1[j].Makho == makho & kho1[j].Mahanghoa == hdn[i].MaHangHoa)
{
ctdck[i].NgayHetHan = kho1[j].Ngayhethan;
break;
}
}
}
}
for (int i = 0; i < ctcount; i++)
{
arr.Add(ctdck[i]);
}
arrct = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
for (int i = 0; i < ctcount; i++)
{
arrct[i] = ctdck[i];
}
LayBangHangHoa();
for (int i = 0; i < ctdck.Length; i++)
{
for (int j = 0; j < hanghoa.Length; j++)
{
if (hanghoa[j].MaHangHoa == ctdck[i].MaHangHoa)
{
ctdck[i].TenHangHoa = hanghoa[j].TenHangHoa;
break;
}
}
}
CtPdck_BaoCao = ctdck;
dgvInsertOrder.DataSource = ctdck;
FixDataGridView();
}
}
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 Entities.ChiTietPhieuDieuChuyenKho[] LayChiTiet_PhieuDieuChuyenKho_TheoMaPhieu(string maPhieu)
{
int count = 0;
for (int i = 0; i < ctPDCK.Length; i++)
{
if (ctPDCK[i].MaPhieuDieuChuyenKho == maPhieu)
{
count++;
}
}
Entities.ChiTietPhieuDieuChuyenKho[] ctPDCK1 = new Entities.ChiTietPhieuDieuChuyenKho[count];
count = 0;
for (int i = 0; i < ctPDCK.Length; i++)
{
if (ctPDCK[i].MaPhieuDieuChuyenKho == maPhieu)
{
ctPDCK1[count] = ctPDCK[i];
count++;
}
}
if (ctPDCK1 == null)
{
ctPDCK1 = new Entities.ChiTietPhieuDieuChuyenKho[0];
return ctPDCK1;
}
else
{
return ctPDCK1;
}
}
public Entities.ChiTietPhieuDieuChuyenKho[] SelectTheoMaPhieu(string maPDCK)
{
Entities.ChiTietPhieuDieuChuyenKho[] arrC = null;
try
{
ctpdck = new Constants.ChiTietPhieuDieuChuyenKho();
string sql = "";
sql = "select * from ChiTietPhieuDieuChuyenKho where MaPhieuDieuChuyenKho='"+maPDCK+"' 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.ChiTietPhieuDieuChuyenKho CTphieudieuchuyen = new Entities.ChiTietPhieuDieuChuyenKho();
CTphieudieuchuyen.MaPhieuDieuChuyenKho = dr[ctpdck.MaPhieuDieuChuyenKho].ToString();
CTphieudieuchuyen.MaHangHoa = dr[ctpdck.MaHangHoa].ToString();
CTphieudieuchuyen.SoLuong = int.Parse(dr[ctpdck.SoLuong].ToString());
CTphieudieuchuyen.GhiChu = dr[ctpdck.GhiChu].ToString();
CTphieudieuchuyen.Deleted = (Boolean)dr[ctpdck.Deleted];
arr.Add(CTphieudieuchuyen);
}
int n = arr.Count;
if (n == 0) { return null; }
arrC = new Entities.ChiTietPhieuDieuChuyenKho[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.ChiTietPhieuDieuChuyenKho)arr[i];
}
for (int i = 0; i < n; i++)
{
arrC[i].NgayHetHan = LayHSD(arrC[i].MaPhieuDieuChuyenKho, arrC[i].MaHangHoa);
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return arrC;
}
public void HienThiChiTiet(string maHDNhap, string makho)
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietHoaDonNhap[] kh = new Entities.ChiTietHoaDonNhap[1];
kh[0] = new Entities.ChiTietHoaDonNhap("Select");
clientstrem = cl.SerializeObj(this.client1, "ChiTietHoaDonNhap", kh);
Entities.ChiTietHoaDonNhap[] kh1 = new Entities.ChiTietHoaDonNhap[1];
kh1 = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1.Length > 0)
{
int ctcount = 0;
foreach (Entities.ChiTietHoaDonNhap h in kh1)
{
if (h.MaHoaDonNhap == maHDNhap)
{
ctcount++;
}
}
Entities.ChiTietHoaDonNhap[] hdn = new Entities.ChiTietHoaDonNhap[ctcount];
ctcount = 0;
foreach (Entities.ChiTietHoaDonNhap h in kh1)
{
if (h.MaHoaDonNhap == maHDNhap)
{
hdn[ctcount] = new Entities.ChiTietHoaDonNhap();
hdn[ctcount].MaHangHoa = h.MaHangHoa;
hdn[ctcount].TenHangHoa = h.TenHangHoa;
hdn[ctcount].SoLuong = h.SoLuong;
ctcount++;
}
}
Server_Client.Client cl1 = new Server_Client.Client();
this.client1 = cl1.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietKhoHangTheoHoaHonNhap[] ctkh = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
ctkh[0] = new Entities.ChiTietKhoHangTheoHoaHonNhap("Select");
clientstrem = cl1.SerializeObj(this.client1, "ChiTietKho", ctkh);
Entities.ChiTietKhoHangTheoHoaHonNhap[] ctkh1 = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
ctkh1 = (Entities.ChiTietKhoHangTheoHoaHonNhap[])cl1.DeserializeHepper1(clientstrem, kh1);
Entities.ChiTietPhieuDieuChuyenKho[] ctdck = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
for (int i = 0; i < ctdck.Length; i++)
{
ctdck[i] = new Entities.ChiTietPhieuDieuChuyenKho();
ctdck[i].MaHangHoa = hdn[i].MaHangHoa;
ctdck[i].TenHangHoa = hdn[i].TenHangHoa;
ctdck[i].SoLuong = hdn[i].SoLuong;
ctdck[i].MaPhieuDieuChuyenKho = txtSochungtu.Text;
if (ctkh1 != null)
{
for (int j = 0; j < ctkh1.Length; j++)
{
if (ctkh1[j].Makho == makho && hdn[i].MaHangHoa == ctkh1[j].Mahanghoa)
{
ctdck[i].NgayHetHan = ctkh1[i].Ngayhethan;
}
}
}
}
dgvInsertOrder.DataSource = ctdck;
FixDataGridView();
}
}
public void LayChiTiet_PhieuDieuChuyenKho()
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietPhieuDieuChuyenKho ctxh = new Entities.ChiTietPhieuDieuChuyenKho("Select");
clientstrem = cl.SerializeObj(this.client, "ChiTietPhieuDieuCHuyenKhoNoiBo", ctxh);
ctPDCK = new Entities.ChiTietPhieuDieuChuyenKho[0];
ctPDCK = (Entities.ChiTietPhieuDieuChuyenKho[])cl.DeserializeHepper1(clientstrem, ctPDCK);
if (ctPDCK == null)
{
ctPDCK = new Entities.ChiTietPhieuDieuChuyenKho[0];
return;
}
}
public void HienThiChiTietTheoPDCK(string Phieudieuchuyenkho)
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietPhieuDieuChuyenKho kh = new Entities.ChiTietPhieuDieuChuyenKho("Select");
clientstrem = cl.SerializeObj(this.client1, "ChiTietPhieuDieuCHuyenKhoNoiBo", kh);
Entities.ChiTietPhieuDieuChuyenKho[] kh1 = new Entities.ChiTietPhieuDieuChuyenKho[1];
kh1 = (Entities.ChiTietPhieuDieuChuyenKho[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 != null)
{
int count = 0;
for (int i = 0; i < kh1.Length; i++)
{
if (kh1[i].MaPhieuDieuChuyenKho == Phieudieuchuyenkho)
{
count++;
}
}
Entities.ChiTietPhieuDieuChuyenKho[] ctpdck1 = new Entities.ChiTietPhieuDieuChuyenKho[count];
count = 0;
for (int i = 0; i < kh1.Length; i++)
{
if (kh1[i].MaPhieuDieuChuyenKho == txtSochungtu.Text)
{
ctpdck1[count] = kh1[i];
count++;
}
}
for (int i = 0; i < count; i++)
{
arr.Add(ctpdck1[i]);
}
arrct = new Entities.ChiTietPhieuDieuChuyenKho[count];
for (int i = 0; i < count; i++)
{
arrct[i] = ctpdck1[i];
}
ctcount = count;
dgvInsertOrder.DataSource = ctpdck1;
FixDataGridView();
}
}
