private void PaintPailToggleChange(bool val)
{
if (val)
{
curTool = PrintTool.paintPail;
}
else if (curTool == PrintTool.paintPail)
{
curTool = PrintTool.none;
}
SetTool();
}
private void GetColorToggleChange(bool val)
{
if (val)
{
curTool = PrintTool.getColor;
}
else if (curTool == PrintTool.getColor)
{
curTool = PrintTool.none;
}
SetTool();
}
private void MosaicToggleChange(bool val)
{
if (val)
{
curTool = PrintTool.mosaic;
}
else if (curTool == PrintTool.mosaic)
{
curTool = PrintTool.none;
}
SetTool();
MosaicSliderValValueChange(0);
}
private static void PrintControl(IWin32Window owner, LinkBase link, UserLookAndFeel lookAndFeel)
{
using PrintingSystem ps = new PrintingSystem();
link.PrintingSystemBase = ps;
ps.Links.Add(link);
using (new WaitCursor())
{
link.CreateDocument(ps);
}
using var printTool = new PrintTool(ps);
printTool.ShowRibbonPreviewDialog(owner, lookAndFeel);
}
private void btnReportKhacPhucPhongNgua_Click(object sender, EventArgs e)
{
Model.Function.ConnectSanXuat();//Mo ket noi
string sqlQuery = string.Format(@"select * from ViewChatLuongHoatDong where
LoaiDeNghi like 'NCR' and ID like '{0}'", iD);
ReportKhacPhucPhongNgua kppn = new ReportKhacPhucPhongNgua();
kppn.DataSource = Function.GetDataTable(sqlQuery);
kppn.DataMember = "Table";
kppn.CreateDocument(false);
kppn.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = "NCR-No-" + iD;
PrintTool tool = new PrintTool(kppn.PrintingSystem);
kppn.ShowPreviewDialog();
Function.Disconnect();
}
{/*
* static void Main()
* {
* var patent1 = new {Title = "B", YearOfPublication = "1784"}; //匿名类型,
* var patent2 = new {YearOfPublication = "1877", Title = "P"};
* var patent3 = new {patent1.Title, Year = patent1.YearOfPublication};
*
* Console.WriteLine("{0} ({1})", patent1.Title, patent1.YearOfPublication);
* Console.WriteLine("{0} ({1})", patent2.Title, patent2.YearOfPublication);
* Console.WriteLine();
* Console.WriteLine("patent1 " + patent1);
* Console.WriteLine("patent2 " + patent2);
* Console.WriteLine("patent3 " + patent3);
* Console.WriteLine();
*
* //类型兼容：属性名称、数据类型和属性顺序必须完全匹配
* //patent1 = patent2; //错误，属性顺序不一样
* Console.WriteLine("patent1 " + patent1);
* //错误，属性类型不一样
* // patent1 = patent3;
*
* //错误，匿名类型是只读的，不可变的，匿名类型一旦实例化就不允许再更改他的某个属性
* // patent3.Title = "1212";
*
* collectionInitializers();
* Console.WriteLine();
*
* AnonymousArry();
* ForeachStack();
* }
*/
//集合初始化器
static void collectionInitializers()
{
List <string> sevenWorldBlunders;
sevenWorldBlunders = new List <string>() //没有参数，最后这个()可以不要
{
"walth without work",
"k",
"s",
"c",
"w",
"p",
"z"
};
PrintTool.PrintIEnumerable(sevenWorldBlunders);
}
private void BtnXuatPhieu_Click(object sender, EventArgs e)// Xuất phiếu nhập kho vật tư
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang("select * from ViewNhapKhoThanhPham where Maphieunhap like N'" + txtMaphieunhap.Text + "' ");
XRNhapThanhPham RPNhapThanhPham = new XRNhapThanhPham();
RPNhapThanhPham.DataSource = dt;
RPNhapThanhPham.DataMember = "Table";
RPNhapThanhPham.CreateDocument(false);
RPNhapThanhPham.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtMaphieunhap.Text;
PrintTool tool = new PrintTool(RPNhapThanhPham.PrintingSystem);
RPNhapThanhPham.ShowPreviewDialog();
}
private void btnPhieuXuat_Click(object sender, EventArgs e)
{
Function.ConnectSanXuat();//Mo ket noi
string sqlQuery = string.Format(@" select * from NhapXuatKhoCN_vw where left(MaChungTu,2)='PX'
and MaChungTu like N'{0}'", maphieu);
ReportXuatKhoVatTuCN XuatKho = new ReportXuatKhoVatTuCN();
XuatKho.DataSource = Function.GetDataTable(sqlQuery);
XuatKho.DataMember = "Table";
XuatKho.CreateDocument(false);
XuatKho.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = maphieu;
PrintTool tool = new PrintTool(XuatKho.PrintingSystem);
XuatKho.ShowPreviewDialog();
Function.Disconnect();
}
private void btnReport_Click(object sender, EventArgs e)
{
maPhieuKiem = gridLookUpEditListView.Text;
Function.ConnectSanXuat();//Mo ket noi
string sqlQuery = string.Format(@"select * from tblKiemTraHangHoa
where IDKiemTra like '{0}'", gridLookUpEditListView.Text);
RpKiemTraSanPham kiemTraSanPham = new RpKiemTraSanPham();
kiemTraSanPham.DataSource = Function.GetDataTable(sqlQuery);
kiemTraSanPham.DataMember = "Table";
kiemTraSanPham.CreateDocument(false);
kiemTraSanPham.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = gridLookUpEditListView.Text;
PrintTool tool = new PrintTool(kiemTraSanPham.PrintingSystem);
kiemTraSanPham.ShowPreviewDialog();
Function.Disconnect();
}
private void btnDonHangDaTinhDinhMuc_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
ketnoi Connect = new ketnoi();
dt = Connect.laybang("select * from PHIEUSANXUAT where madh like N'" + txtMaDonHang.Text + "'");
XRPhieuSX_DaDuyet rpPHIEUSANXUAT_Duyet = new XRPhieuSX_DaDuyet();
rpPHIEUSANXUAT_Duyet.DataSource = dt;
rpPHIEUSANXUAT_Duyet.DataMember = "Table";
rpPHIEUSANXUAT_Duyet.CreateDocument(false);
rpPHIEUSANXUAT_Duyet.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtMaDonHang.Text;
PrintTool tool = new PrintTool(rpPHIEUSANXUAT_Duyet.PrintingSystem);
rpPHIEUSANXUAT_Duyet.ShowPreviewDialog();
Connect.dongketnoi();
}
private void btnDinhMucVatTu_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang("select * from PHIEUSANXUAT where madh like N'" + cbMaDH.Text + "'");
XRPhieuSX_DaDuyet xrPSX_VatTu = new XRPhieuSX_DaDuyet();
xrPSX_VatTu.DataSource = dt;
xrPSX_VatTu.DataMember = "Table";
xrPSX_VatTu.CreateDocument(false);
xrPSX_VatTu.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = cbMaDH.Text;
PrintTool tool = new PrintTool(xrPSX_VatTu.PrintingSystem);
tool.ShowPreviewDialog();
kn.dongketnoi();
}
private void LoadLayout_PSX(object sender, EventArgs e)//Sự kiện gọi phiếu sản xuất
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang("SELECT * from IN_LENHSANXUAT where madh like N'" + maDonHang + "'");
RpPhieusanxuat rpPHIEUSANXUAT = new RpPhieusanxuat();
rpPHIEUSANXUAT.DataSource = dt;
rpPHIEUSANXUAT.DataMember = "Table";
rpPHIEUSANXUAT.CreateDocument(false);
rpPHIEUSANXUAT.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = maDonHang;
PrintTool tool = new PrintTool(rpPHIEUSANXUAT.PrintingSystem);
rpPHIEUSANXUAT.ShowPreviewDialog();
kn.dongketnoi();
}
private void btnPrintDexuat_VT_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang("SELECT DatHangVatTuDauVao_STT.* FROM DatHangVatTuDauVao_STT where MaDN_VATTU like '" + cbMaPhieudexuat.Text + "'");
XtraReportDeNghiVatTu rpDEXUATVATTU = new XtraReportDeNghiVatTu();
rpDEXUATVATTU.DataSource = dt;
rpDEXUATVATTU.DataMember = "Table";
rpDEXUATVATTU.CreateDocument(false);
rpDEXUATVATTU.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = cbMaPhieudexuat.Text;
PrintTool tool = new PrintTool(rpDEXUATVATTU.PrintingSystem);
tool.ShowPreviewDialog();
kn.dongketnoi();
}
private void BtnXuatPhieu_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
string sqlQuery = string.Format(@"select * from viewNhapKho_VT where So_chung_tu like N'{0}' ", txtMaPhieuNhap.Text);
dt = kn.laybang(sqlQuery);
XRNhapKho RpNhapVT = new XRNhapKho();
RpNhapVT.DataSource = dt;
RpNhapVT.DataMember = "Table";
RpNhapVT.CreateDocument(false);
RpNhapVT.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtMaPhieuNhap.Text;
PrintTool tool = new PrintTool(RpNhapVT.PrintingSystem);
RpNhapVT.ShowPreviewDialog();
}
private void LapPhieuXuat(object sender, EventArgs e)//print phieu xuat kho
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang("select * from viewXuatKho_VT where Maxuat like N'" + txtMaxuat.Text + "'");
XReportXuatKhoVT XuatKho = new XReportXuatKhoVT();
XuatKho.DataSource = dt;
XuatKho.DataMember = "Table";
XuatKho.CreateDocument(false);
XuatKho.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtMaxuat.Text;
PrintTool tool = new PrintTool(XuatKho.PrintingSystem);
XuatKho.ShowPreviewDialog();
kn.dongketnoi();
}
private static void ExecutePrintCommand(LinkBase link, PrintingSystemCommand command, object[] args)
{
using PrintingSystem ps = new PrintingSystem();
using (new WaitCursor())
{
link.CreateDocument(ps);
}
using var printTool = new PrintTool(ps);
if (args != null)
{
printTool.PreviewRibbonForm.PrintControl.ExecCommand(command, args);
}
else
{
printTool.PreviewRibbonForm.PrintControl.ExecCommand(command);
}
}
public void Imprimir()
{
PrintableComponentLink componentLink = new PrintableComponentLink(new PrintingSystem());
componentLink.Component = gridControl1;
componentLink.CreateDocument();
PrintTool pt = new PrintTool(componentLink.PrintingSystemBase);
pt.ShowPreviewDialog();
//GridControl grid = new GridControl();
//GridView view = new GridView(gridControl1);
//gridControl1.MainView = view;
//gridControl1.DataSource = gridControl1.DataSource;
//gridControl1.BindingContext = new System.Windows.Forms.BindingContext();
//gridControl1.ForceInitialize();
//gridControl1.MainView.ShowPrintPreview();
}
private void btnKeHoachSanXuat_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
ketnoi kn = new ketnoi();
dt = kn.laybang(@"select * from vw_KeHoachNgayCongDoanCuoi where madh= '" + txtMaDonHang.Text + "' order by KetThuc ASC ");
XRLichSanXuaTheoNgay rpKiemHang = new XRLichSanXuaTheoNgay();
rpKiemHang.DataSource = dt;
rpKiemHang.DataMember = "Table";
rpKiemHang.CreateDocument(false);
rpKiemHang.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtMaDonHang.Text;
PrintTool tool = new PrintTool(rpKiemHang.PrintingSystem);
tool.ShowPreviewDialog();
kn.dongketnoi();
}
private void PrintNCR_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang(@"select R.*,D.Cai,D.Kg,D.Thongtin,D.ChiPhiDonHang from tblNCR R
inner join NcrDatHang D
on R.NcrID=D.NcrID where R.NcrID='" + txtNcrID.Text + "'");
ReportKhacPhucPhongNgua xRNcr = new ReportKhacPhucPhongNgua();
xRNcr.DataSource = dt;
xRNcr.DataMember = "Table";
xRNcr.CreateDocument(false);
xRNcr.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtNcrID.Text;
PrintTool tool = new PrintTool(xRNcr.PrintingSystem);
xRNcr.ShowPreviewDialog();
kn.dongketnoi();
}
private void btnExport__Click(object sender, EventArgs e)
{
if (txtMaPhieuNhap.Text == "")
{
MessageBox.Show("No Code OUTPUT VOUCHER", ""); return;
}
else
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang("select * from ViewNhapKho_VTPhu where Manhap like N'" + txtMaPhieuNhap.Text + "' ");
XRNhapvatlieuphu RpNhapVTPhu = new XRNhapvatlieuphu();
RpNhapVTPhu.DataSource = dt;
RpNhapVTPhu.DataMember = "Table";
RpNhapVTPhu.CreateDocument(false);
RpNhapVTPhu.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtMaPhieuNhap.Text;
PrintTool tool = new PrintTool(RpNhapVTPhu.PrintingSystem);
RpNhapVTPhu.ShowPreviewDialog();
}
}
private void btnBienBanViPham_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
ketnoi kn = new ketnoi();
dt = kn.laybang(
@"SELECT NhanVienID,HoTen,Sothe,ChiPhiNhanVien,NoiDungViPham,SBB,SoNcr,
KhongPhuHop,HinhThucXuLy FROM tblNCR R
INNER JOIN NcrNhanVien N
ON R.NcrID=N.NcrID where SBB='" + txtSoBB.Text + "'");
XRBienBan xRBienBan = new XRBienBan();
xRBienBan.DataSource = dt;
xRBienBan.DataMember = "Table";
xRBienBan.CreateDocument(false);
xRBienBan.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtSoBB.Text;
PrintTool tool = new PrintTool(xRBienBan.PrintingSystem);
tool.ShowPreviewDialog();
kn.dongketnoi();
}
public void SetPrintTool(PrintTool tool)
{
if (curTool != tool && paintTool != null)
{
paintTool.CloseTool();
}
curTool = tool;
switch (curTool)
{
case PrintTool.magicBand:
paintTool = new MagicBandTool();
break;
case PrintTool.getColor:
paintTool = new GetColorTool();
break;
case PrintTool.paintPail:
paintTool = new PaintPailTool();
break;
case PrintTool.mosaic:
paintTool = new MosaicTool();
break;
case PrintTool.chooseArea:
paintTool = new ChooseAreaTool();
break;
case PrintTool.none:
paintTool = null;
break;
default:
break;
}
}
//匿名类型数组,由匿名类型构成的数组，每个项的类型必须相同
static void AnonymousArry()
{
var worldCup = new[]
{
new
{
teamNma = "a",
players = new string[]
{
"a", "b", "c"
}
},
new
{
teamNma = "b",
players = new string[]
{
"d", "e", "f"
}
}
};
PrintTool.PrintIEnumerable(worldCup);
}
protected virtual void OnPrintOptionsButton()
{
using (PrintTool tool = new PrintTool(this.appointmentBackstageControl.Document))
tool.PrintDialog(FindForm(), LookAndFeel);
}
public void ShowRibbonPreviewDialog()
{
BarManager = PrintTool.PreviewRibbonForm.Ribbon.Manager;
PrintTool.ShowRibbonPreviewDialog();
}
protected virtual void OnPrintButton()
{
using (PrintTool tool = new PrintTool(this.appointmentBackstageControl.Document))
tool.Print(this.appointmentBackstageControl.SelectedPrinterName);
}
public XtraReport1()
{
InitializeComponent();
PrintTool.MakeCommandResponsive(this.PrintingSystem);
PrintingSystem.SetCommandVisibility(PrintingSystemCommand.Save, CommandVisibility.None);
}
public void ShowPreviewDialog()
{
BarManager = PrintTool.PreviewForm.PrintBarManager;
PrintTool.ShowPreviewDialog();
}
public virtual void InitPrintTool(PrintTool tool)
{
tool.ShowRibbonPreviewDialog(UserLookAndFeel.Default);
}
