コード例 #1
0
        private void button1_Click(object sender, System.EventArgs e)
        {
            string sql = null;

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            System.Data.DataTable     dt = null;
            string strsol = null;

            sql = "select a.invoice_no,a.FREIGHT_PAYTYPE,a.loadingterm,a.* from SALE_WAYBILL_MASTER a where a.awb_code='" + this._awbNo + "'";
            dt  = TJSystem.Public.PublicStatic.db.GetDataTable(sql);

            TJSystem.Classes.common.DocParamCommon dpcom = new TJSystem.Classes.common.DocParamCommon();
            dpcom.PKCondition = " where a.so_code in (" + this._Sale_So_Code + ")";
            dpcom.DocNO       = this._awbNo;
            dpcom.Remark      = this.comboBox1.Text;
            if (dt.Rows.Count > 0)
            {
                dpcom.DocLCNO     = dt.Rows[0]["invoice_no"].ToString().Trim();
                dpcom.PayType     = dt.Rows[0]["FREIGHT_PAYTYPE"].ToString().Trim();
                dpcom.ShipperType = dt.Rows[0]["loadingterm"].ToString().Trim();
            }

            TJSystem.CrystalRPT.frmReport frm = new TJSystem.CrystalRPT.frmReport("货物托运单", dpcom, this.dataGrid1);
            frm.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
            frm.ShowDialog();
        }
コード例 #2
0
ファイル: frmBasicDocTerm.cs プロジェクト: terry-shen/C-
        private void linkLabel1_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
        {
            string strsol = null;

            if (this.textBox1.Text.Trim().Equals(""))
            {
                TJSystem.Public.PublicStatic.ShowMessage(TJSystem.Public.MessageType.Exclamation, "请选择要打印的条款编号!");
                return;
            }
            strsol = textBox1.Text.Trim();

            TJSystem.Classes.common.DocParamCommon dpcom = new TJSystem.Classes.common.DocParamCommon();
            dpcom.DocSaleNO = this.textBox1.Text.Trim();

            TJSystem.CrystalRPT.frmReport frm = new TJSystem.CrystalRPT.frmReport("OFFER SHEET", dpcom, this.dataGrid1);
            frm.ShowDialog();
        }