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