private void xrTableCell27_PreviewClick(object sender, PreviewMouseEventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt("bccnhtdbk"); F.getngay(ngay); F.ShowDialog(); }
private void pnvlpg_Click(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt("hdmhvosl"); F.getrole(role); F.ShowDialog(); }
private void tsbtin_Click(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt("pxhmtlbienbantra"); F.getrole(role); F.ShowDialog(); }
private void tsbtin_Click(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt(pt); F.getrole(role); F.Show(); }
private void toolddh_Click(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt("tsbthdmhkpnphieu"); F.getrole(role); F.ShowDialog(); }
private void hdmhpnk_Click(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt("pnk"); F.getrole(gen.GetString("select ShippingMethodID from PUInvoice where RefID='" + role + "'")); F.ShowDialog(); }
private void tsbtin_ButtonClick(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt(pt + "lpg"); F.getrole(role); F.getcongty("CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG"); F.ShowDialog(); }
private void toolbbgnh_Click(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt("tsbthdmhkpnbienban"); F.getrole(role); F.getkho("0"); F.ShowDialog(); }
public void loadbangkebanhangtheongay(string ngaychungtu, string ngaycuoi, string manhanvien) { manhanvien = gen.GetString("select AccountingObjectID from AccountingObject where AccountingObjectID='" + manhanvien + "'"); DataTable temp = gen.GetTable("select substring(RefNo,4,12) as 'Số phiếu',JournalMemo as 'Đơn hàng', AccountingObjectCode as 'Mã khách', a.AccountingObjectName as 'Tên khách' ,a.AccountingObjectAddress as 'Địa chỉ',TotalAmountOC+TotalAmount-(TotalFreightAmount/(1+Cast(Tax as money)/100)) as 'Số tiền' from INOutward a, AccountingObject b where a.AccountingObjectID=b.AccountingObjectID and RefDate>='" + ngaychungtu + "' and RefDate<='" + ngaycuoi + "' and EmployeeIDSA='" + manhanvien + "' order by AccountingObjectCode"); Frm_nhapxuat F = new Frm_nhapxuat(); F.getdata(temp); F.getngay(ngaychungtu); F.getrole(manhanvien); F.gettsbt("bkthbhtnvkd"); F.ShowDialog(); }
public void gettieude(string phieu, string tsbt, string loai, Frm_nhapxuat F) { roleID = phieu; tsbtID = tsbt; loaiID = loai; ThisF = F; DataTable temp = new DataTable(); xrLabel14.Text = gen.GetString("select Top 1 CompanyName from Center"); //xrLabel20.Text = gen.GetString("select Top 1 Phone from Center"); xrLabel20.Text = "02923.830.582 - Fax: 02923.731.505"; if (tsbt == "tsbtddhphieumn") { temp = gen.GetTable("select RefNo,b.AccountingObjectName,b.Address,Tel,Fax,JournalMemo,RefDate,ShippingNo,Cancel,CustomField6,DocumentIncluded,CustomField3,CustomField1,a.AccountingObjectID,RefType,a.ContactName from DDHNCC a, AccountingObject b where a.AccountingObjectID=b.AccountingObjectID and RefID='" + phieu + "'"); } xrLabel3.Text = "Ngày " + String.Format("{0:dd}", DateTime.Parse(temp.Rows[0][6].ToString())) + " tháng " + String.Format("{0:MM}", DateTime.Parse(temp.Rows[0][6].ToString())) + " năm " + String.Format("{0:yyyy}", DateTime.Parse(temp.Rows[0][6].ToString())); xrLabel9.Text = temp.Rows[0][0].ToString(); if (temp.Rows[0][14].ToString() == "0") { xrLabel34.Text = "[X]"; } else { if (temp.Rows[0][8].ToString() == "True") { xrLabel30.Text = "[X]"; } else { xrLabel32.Text = "[X]"; } } xrLabel26.Text = temp.Rows[0][7].ToString(); xrLabel13.Text = temp.Rows[0][9].ToString(); xrLabel22.Text = temp.Rows[0][10].ToString(); xrLabel18.Text = temp.Rows[0][11].ToString(); xrTableCell3.Text = temp.Rows[0][15].ToString(); //xrLabel24.Text = temp.Rows[0][12].ToString(); xrLabel45.Text = "Nơi nhận hàng: " + temp.Rows[0][12].ToString(); try { xrLabel29.Text = gen.GetString("select Top 1 a.ParentContract from contractB a,(select ParentContract, MAX(SignedDate) as SignedDate from contractB where AccountingObjectID='" + temp.Rows[0][13].ToString() + "' and SignedDate<='" + temp.Rows[0][6].ToString() + "'and EffectiveDate>='" + temp.Rows[0][6].ToString() + "' and Inactive=1 group by ParentContract) b where a.ParentContract=b.ParentContract and a.SignedDate=b.SignedDate");; } catch { } }
private void insl_Click(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); if (pt == "pnkvtddh") { F.gettsbt("pnkvosl"); F.getrole(gen.GetString("select RefID from INInwardSU where RefNo='" + txtsct.Text + "'")); } else { F.gettsbt(pt + "vosl"); F.getrole(role); } F.ShowDialog(); }
private void xrLabel7_PreviewClick(object sender, PreviewMouseEventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt(tsbtID); F.getrole(roleID); if (loaiID == "0") { F.getkho("1"); } else { F.getkho("0"); } F.ShowDialog(); ThisF.Close(); }
private void tsbtin_ButtonClick(object sender, EventArgs e) { Frm_nhapxuat F = new Frm_nhapxuat(); if (pt == "pnkvtddh") { F.gettsbt("pnkvo"); F.getrole(gen.GetString("select RefID from INInwardSU where RefNo='" + txtsct.Text + "'")); } else { F.gettsbt(pt + "vo"); F.getrole(role); } F.getcongty("CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG"); F.ShowDialog(); }
public void loadbangkehangtheongayin(string ngaychungtu, string userid) { DataTable dt = new DataTable(); DataTable temp = new DataTable(); dt.Columns.Add("Mã hàng", Type.GetType("System.String")); dt.Columns.Add("Tên hàng", Type.GetType("System.String")); dt.Columns.Add("Số lượng", Type.GetType("System.Double")); dt.Columns.Add("Trọng lượng", Type.GetType("System.Double")); dt.Columns.Add("Khuyến mãi", Type.GetType("System.Double")); dt.Columns.Add("Đơn vị tính", Type.GetType("System.String")); string manhanvien = null; temp = gen.GetTable("select InventoryItemCode,InventoryItemName,SUM(Quantity),SUM(QuantityConvert),UnitPriceOC,sum(AmountOC),case when Quantity=0 then c.ConvertUnit else c.Unit end as loai,EmployeeIDSACode from INOutward a,INOutwardDetail b, InventoryItem c, (select * from OpeningAccountEntry131TT where EmployeeIDSAName='" + userid + "') d where a.RefNo=d.RefNo and a.RefID=b.RefID and b.InventoryItemID=c.InventoryItemID and RefType<>'1' group by InventoryItemCode,InventoryItemName,UnitPriceOC,EmployeeIDSACode,case when Quantity=0 then c.ConvertUnit else c.Unit end order by UnitPriceOC DESC,SUBSTRING(InventoryItemCode,8,2),InventoryItemCode"); for (int i = 0; i < temp.Rows.Count; i++) { DataRow dr = dt.NewRow(); dr[0] = temp.Rows[i][0]; dr[1] = temp.Rows[i][1]; if (Double.Parse(temp.Rows[i][4].ToString()) != 0) { dr[2] = temp.Rows[i][2]; dr[3] = temp.Rows[i][3]; } else { dr[4] = temp.Rows[i][3]; } dr[5] = temp.Rows[i][6]; manhanvien = temp.Rows[i][7].ToString(); dt.Rows.Add(dr); } if (manhanvien != null) { manhanvien = gen.GetString("select AccountingObjectID from AccountingObject where AccountingObjectCode='" + manhanvien + "'"); Frm_nhapxuat F = new Frm_nhapxuat(); F.getdata(dt); F.getngay(ngaychungtu); F.getrole(manhanvien); F.gettsbt("bkthbhtnvkdintong"); F.ShowDialog(); } }
private void xrTableCell15_PreviewClick(object sender, PreviewMouseEventArgs e) { baocaocongno131 bccn = new baocaocongno131(); for (int i = 0; i < dt1.Rows.Count; i++) { if (dt1.Rows[i][0].ToString() == e.Brick.Text) { if (gen.GetString("select Top 1 CompanyTaxCode from Center") == "1801115004" && kho1.ToUpper() == "E074A43F-0D0E-4D8F-BE2C-BFA6B32DBD5F") { Frm_nhapxuat F = new Frm_nhapxuat(); F.gettsbt("tsbtbccn131bienbanxacnhannochitiet"); F.getngay(tungay1); F.getdenngay(denngay1); F.getrole(e.Brick.Text); if (dt1.Rows[i][6].ToString() != "") { F.getcongty(dt1.Rows[i][6].ToString()); } else { F.getcongty("-" + dt1.Rows[i][7].ToString()); } F.getdauky(dt1.Rows[i][5].ToString()); F.getkho(kho1); F.ShowDialog(); } else { if (dt1.Rows[i][2].ToString() != "") { bccn.loadchitietnothucte(e.Brick.Text, tungay1, denngay1, kho1, dt1.Rows[i][2].ToString(), loai); } else { bccn.loadchitietnothucte(e.Brick.Text, tungay1, denngay1, kho1, "-" + dt1.Rows[i][3].ToString(), loai); } } } } }
public void loadbangkehangtheongayin(string ngaychungtu, string ngaycuoi, string manhanvien) { DataTable dt = new DataTable(); DataTable temp = new DataTable(); dt.Columns.Add("Mã hàng", Type.GetType("System.String")); dt.Columns.Add("Tên hàng", Type.GetType("System.String")); dt.Columns.Add("Số lượng", Type.GetType("System.Double")); dt.Columns.Add("Trọng lượng", Type.GetType("System.Double")); dt.Columns.Add("Khuyến mãi", Type.GetType("System.Double")); dt.Columns.Add("Đơn vị tính", Type.GetType("System.String")); temp = gen.GetTable("select InventoryItemCode,InventoryItemName,SUM(Quantity),SUM(QuantityConvert),UnitPriceOC,sum(AmountOC),case when Quantity=0 then c.ConvertUnit else c.Unit end as loai from INOutward a,INOutwardDetail b, InventoryItem c where a.RefID=b.RefID and b.InventoryItemID=c.InventoryItemID and RefDate>='" + ngaychungtu + "' and RefDate<='" + ngaycuoi + "' and EmployeeIDSA='" + manhanvien + "' and RefType<>'1' group by InventoryItemCode,InventoryItemName,UnitPriceOC,case when Quantity=0 then c.ConvertUnit else c.Unit end order by UnitPriceOC DESC,SUBSTRING(InventoryItemCode,8,2),InventoryItemCode"); for (int i = 0; i < temp.Rows.Count; i++) { DataRow dr = dt.NewRow(); dr[0] = temp.Rows[i][0]; dr[1] = temp.Rows[i][1]; if (Double.Parse(temp.Rows[i][4].ToString()) != 0) { dr[2] = temp.Rows[i][2]; dr[3] = temp.Rows[i][3]; } else { dr[4] = temp.Rows[i][3]; } dr[5] = temp.Rows[i][6]; dt.Rows.Add(dr); } Frm_nhapxuat F = new Frm_nhapxuat(); F.getdata(dt); F.getngay(ngaychungtu); F.getrole(manhanvien); F.gettsbt("bkthbhtnvkdintong"); F.ShowDialog(); }
public void gettieude(string phieu, string loai, string tsbt, Frm_nhapxuat F) { roleID = phieu; tsbtID = tsbt; ThisF = F; loaiID = loai; DataTable temp = new DataTable(); if (tsbt == "pxhtbienban") { temp = gen.GetTable("select RefNo,b.AccountingObjectName,Case when b.ContactName='' then b.ContactAddress else b.ContactName end,ContactTitle,IdentificationNumber,IssueDate,RefDate,ContactOfficeTel,c.FullName,c.JobTitle,c.HomePhone,c.MobilePhone,c.HomeAddress from OUTdeficit a, AccountingObject b, MSC_User c where a.AccountingObjectID=b.AccountingObjectID and a.EmployeeID=c.UserID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthdmhkpnbienban") { temp = gen.GetTable("select RefNo,b.AccountingObjectName,Case when b.ContactName='' then b.ContactAddress else b.ContactName end,ContactTitle,b.IdentificationNumber,b.IssueDate,PURefDate,ContactOfficeTel,c.FullName,c.JobTitle,c.HomePhone,c.MobilePhone,c.HomeAddress from PUInvoice a, AccountingObject b, MSC_User c where a.AccountingObjectID=b.AccountingObjectID and a.UserID=c.UserID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthddhbienbanhp") { temp = gen.GetTable("select RefNo,b.AccountingObjectName,Case when b.ContactName='' then b.ContactAddress else b.ContactName end,ContactTitle,b.IdentificationNumber,b.IssueDate,RefDate,ContactOfficeTel,c.FullName,c.JobTitle,c.HomePhone,c.MobilePhone,c.HomeAddress from DDHNCC a, AccountingObject b, MSC_User c where a.AccountingObjectID=b.AccountingObjectID and a.EmployeeID=c.UserID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthdbhkpnbienban") { temp = gen.GetTable("select RefNo,b.AccountingObjectName,Case when b.ContactName='' then b.ContactAddress else b.ContactName end,ContactTitle,b.IdentificationNumber,b.IssueDate,PURefDate,ContactOfficeTel,c.FullName,c.JobTitle,c.HomePhone,c.MobilePhone,c.HomeAddress from SSInvoice a, AccountingObject b, MSC_User c where a.AccountingObjectID=b.AccountingObjectID and a.UserID=c.UserID and RefID='" + phieu + "'"); } else if (tsbt == "tsbtpnkttbienban") { temp = gen.GetTable("select RefNo,b.AccountingObjectName,Case when b.ContactName='' then b.ContactAddress else b.ContactName end,ContactTitle,IdentificationNumber,IssueDate,RefDate,ContactOfficeTel,c.FullName,c.JobTitle,c.HomePhone,c.MobilePhone,c.HomeAddress from INInwardTT a, AccountingObject b, MSC_User c where a.AccountingObjectID=b.AccountingObjectID and a.EmployeeID=c.UserID and RefID='" + phieu + "'"); } xrLabel5.Text = "Cần Thơ, ngày " + String.Format("{0:dd}", DateTime.Parse(temp.Rows[0][6].ToString())) + " tháng " + String.Format("{0:MM}", DateTime.Parse(temp.Rows[0][6].ToString())) + " năm " + String.Format("{0:yyyy}", DateTime.Parse(temp.Rows[0][6].ToString())); xrLabel7.Text = "Căn cứ theo hợp đồng thuê kho, quản lý, bốc xếp số: "; string tenkhach = temp.Rows[0][1].ToString(); xrLabel10.Text = "Bên giao: " + tenkhach.ToUpper(); xrLabel16.Text = temp.Rows[0][2].ToString(); xrLabel19.Text = temp.Rows[0][3].ToString(); if (temp.Rows[0][4].ToString() != "") { xrLabel14.Text = temp.Rows[0][4].ToString(); xrLabel20.Text = String.Format("{0:dd/MM/yyyy}", DateTime.Parse(temp.Rows[0][5].ToString())); } xrLabel15.Text = temp.Rows[0][7].ToString(); xrLabel27.Text = temp.Rows[0][8].ToString(); xrLabel30.Text = temp.Rows[0][9].ToString(); xrLabel25.Text = temp.Rows[0][10].ToString(); xrLabel26.Text = temp.Rows[0][11].ToString(); xrLabel31.Text = temp.Rows[0][12].ToString(); if (tsbt == "pxhtbienban") { temp = gen.GetTable("select top 1 ContractCode,SignedDate from OUTdeficit a, ContractB b where a.AccountingObjectID=b.AccountingObjectID and ContractName=N'Cho thuê kho' and SignedDate<=RefDate and EffectiveDate>=RefDate and b.No=0 and RefID='" + phieu + "' order by b.SignedDate"); } else if (tsbt == "tsbthdmhkpnbienban") { temp = gen.GetTable("select top 1 ContractCode,SignedDate from PUInvoice a, ContractB b where a.AccountingObjectID=b.AccountingObjectID and ContractName=N'Cho thuê kho' and SignedDate<=PURefDate and EffectiveDate>=PURefDate and b.No=0 and RefID='" + phieu + "' order by b.SignedDate"); } else if (tsbt == "tsbthddhbienbanhp") { temp = gen.GetTable("select top 1 ContractCode,SignedDate from DDHNCC a, ContractB b where a.AccountingObjectID=b.AccountingObjectID and ContractName=N'Cho thuê kho' and SignedDate<=RefDate and EffectiveDate>=RefDate and b.No=0 and RefID='" + phieu + "' order by b.SignedDate"); } else if (tsbt == "tsbthdbhkpnbienban") { temp = gen.GetTable("select top 1 ContractCode,SignedDate from SSInvoice a, ContractB b where a.AccountingObjectID=b.AccountingObjectID and ContractName=N'Cho thuê kho' and SignedDate<=PURefDate and EffectiveDate>=PURefDate and b.No=0 and RefID='" + phieu + "' order by b.SignedDate"); } else if (tsbt == "tsbtpnkttbienban") { temp = gen.GetTable("select top 1 ContractCode,SignedDate from INInwardTT a, ContractB b where a.AccountingObjectID=b.AccountingObjectID and ContractName=N'Cho thuê kho' and SignedDate<=RefDate and EffectiveDate>=RefDate and b.No=0 and RefID='" + phieu + "' order by b.SignedDate"); } try { xrLabel7.Text = xrLabel7.Text + temp.Rows[0][0].ToString() + " ký ngày " + String.Format("{0:dd/MM/yyyy}", DateTime.Parse(temp.Rows[0][1].ToString())); } catch { } xrLabel7.Text = xrLabel7.Text + " giữa " + tenkhach + " và Công ty Cổ phần Vật tư Hậu Giang"; if (loai == "0") { if (tsbt == "pxhtbienban") { temp = gen.GetTable("select sum(QuantityConvert) from OUTdeficitDetail a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthdmhkpnbienban") { temp = gen.GetTable("select sum(QuantityConvert) from PUInvoiceDetail a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthddhbienbanhp") { temp = gen.GetTable("select sum(QuantityConvert) from DDHNCCDetail a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthdbhkpnbienban") { temp = gen.GetTable("select sum(QuantityConvert) from SSInvoiceDetail a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } else if (tsbt == "tsbtpnkttbienban") { temp = gen.GetTable("select sum(QuantityConvert) from INInwardDetailTT a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } xrLabel35.Text = "Bằng chữ: " + doi.ChuyenSo(Math.Round(Double.Parse(temp.Rows[0][0].ToString()), 0).ToString()).Replace("đồng", "kg"); } else { if (tsbt == "pxhtbienban") { temp = gen.GetTable("select sum(Quantity) from OUTdeficitDetail a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthdmhkpnbienban") { temp = gen.GetTable("select sum(Quantity) from PUInvoiceDetail a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthddhbienbanhp") { temp = gen.GetTable("select sum(Quantity) from DDHNCCDetail a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } else if (tsbt == "tsbthdbhkpnbienban") { temp = gen.GetTable("select sum(Quantity) from SSInvoiceDetail a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } else if (tsbt == "tsbtpnkttbienban") { temp = gen.GetTable("select sum(Quantity) from INInwardDetailTT a, InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + phieu + "'"); } xrLabel35.Text = "Bằng chữ: " + doi.ChuyenSo(Math.Round(Double.Parse(temp.Rows[0][0].ToString()), 0).ToString()).Replace("đồng", "cây"); } }