//初始化出口监管仓货物入仓清单 public Report_ExSup(Customs.Entity.Store_in_headInfo CurInHead, List <Customs.Entity.Store_in_listInfo> list) { //先初始化界面 InitializeComponent(); //初始化报表 try { //初始化表头部分 //仓库编号 labWareNO.Text = CurInHead.Cust_bill_id; labCustomCode.Text = CurInHead.Bill_id; lbCnsNo.Text = CurInHead.Cns_no; tbWareName.Text = "深国际华南物流监管仓"; tbreferdoc.Text = CurInHead.Refer_doc; //发货单位 tbdeliverUnit.Text = CommonReport.GetCompanyName(CurInHead.Rs_code); tbSumWeight.Text = "毛重:" + CurInHead.Gross_wt.ToString() + "\n" + "净重:" + CurInHead.Net_wt.ToString();//CurInHead.Gross_wt.ToString(); lbPkgs.Text = "共 " + CurInHead.Pkgs_num + " 件"; tbtotalValue.Text = CurInHead.All_value.ToString(); tbPlace.Text = CurInHead.Place; //国别 tbOutCountry.Text = list != null?CommonReport.GetCode("102", list[0].Orign_coun, false) : ""; //WareCommon.GetCode("102", CurInHead.Trade_coun, false); tbtaxRebate.Text = CurInHead.Tax_flag.Trim() == "1" ? "是" : "否"; tbTradetype.Text = httrade_way.Contains(CurInHead.Trade_mode) ? httrade_way[CurInHead.Trade_mode].ToString() : ""; tbInWaretype.Text = htIn_type.Contains(CurInHead.In_type) ? htIn_type[CurInHead.In_type].ToString() : ""; //目的海关 labCustom.Text = CurInHead.Ie_portName; //报关员 //labName.Text = "报关员"; //货主 //lab.Text = "龙卓公司"; //仓库员 //labAdmin.Text = "胡藩"; BarCode.Text = CurInHead.Bill_id; tbremark.Text = CurInHead.Remark; labDate.Text = CurInHead.Ie_date.ToString("yyyy-MM-dd") != "1900-01-01" ? CurInHead.Ie_date.ToString("yyyy-MM-dd") : ""; //txtPkgs.Text = "200件"; if (list.Count <= 5) { for (int i = 1; i <= list.Count; i++) { #region 给table赋值 DevExpress.XtraReports.UI.XRTableCell seq = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cseq" + i, false); seq.Text = list[i - 1].G_no.ToString(); DevExpress.XtraReports.UI.XRTableCell cCode = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cCode" + i, false); cCode.Text = list[i - 1].Code_t; //货物名称和规格 DevExpress.XtraReports.UI.XRTableCell cName = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cName" + i, false); cName.Text = list[i - 1].Mg_name + "\r\n" + list[i - 1].Mg_spec + "\n" + list[i - 1].Pkgs.ToString() + "件"; //数量 string temp = PublicMethod.RemoveZero(list[i - 1].Qty_2.ToString()) == "0" ? "" : PublicMethod.RemoveZero(list[i - 1].Qty_2.ToString()); DevExpress.XtraReports.UI.XRTableCell cNum = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cNum" + i, false); //cNum.Text = PublicMethod.RemoveZero(list[i - 1].G_qty.ToString()) + "\n" + PublicMethod.RemoveZero(list[i - 1].Qty_1.ToString()) + "\n" + temp; cNum.Text = PublicMethod.RemoveZero(list[i - 1].Qty_1.ToString()) + "\n" + temp + "\n" + PublicMethod.RemoveZero(list[i - 1].G_qty.ToString()); //list[i - 1].G_qty.ToString(); //单位 DevExpress.XtraReports.UI.XRTableCell cUnit = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cUnit" + i, false); //cUnit.Text = PublicMethod.GetHashValue(ht,list[i - 1].G_unit).ToString() + "\n" + PublicMethod.GetHashValue(ht,list[i - 1].Unit_code1).ToString() + "\n" + PublicMethod.GetHashValue(ht,list[i - 1].Unit_code2).ToString(); cUnit.Text = CommonReport.GetHashValue(ht, list[i - 1].Unit_code1).ToString() + "\n" + CommonReport.GetHashValue(ht, list[i - 1].Unit_code2).ToString() + "\n" + CommonReport.GetHashValue(ht, list[i - 1].G_unit).ToString(); //ht.Contains(list[i - 1].G_unit) ? ht[list[i - 1].G_unit].ToString() : "";//list[i - 1].G_unit; DevExpress.XtraReports.UI.XRTableCell cWeight = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cWeight" + i, false); cWeight.Text = list[i - 1].Gross + "\r\n" + list[i - 1].Net; //币值 DevExpress.XtraReports.UI.XRTableCell cCoin = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cCoin" + i, false); cCoin.Text = CommonReport.GetCode("118", list[i - 1].Curr_code.ToString(), true); DevExpress.XtraReports.UI.XRTableCell cPrice = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cPrice" + i, false); cPrice.Text = list[i - 1].Unit_price.ToString(); DevExpress.XtraReports.UI.XRTableCell cTotal = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cTotal" + i, false); cTotal.Text = list[i - 1].Trade_ttl.ToString(); #endregion } } if (list.Count > 5) { for (int i = 1; i <= 5; i++) { #region 给table赋值 DevExpress.XtraReports.UI.XRTableCell seq = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cseq" + i, false); seq.Text = list[i - 1].G_no.ToString(); DevExpress.XtraReports.UI.XRTableCell cCode = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cCode" + i, false); cCode.Text = list[i - 1].Code_t; //货物名称和规格 DevExpress.XtraReports.UI.XRTableCell cName = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cName" + i, false); cName.Text = list[i - 1].Mg_name + "\r\n" + list[i - 1].Mg_spec + "\r\n" + list[i - 1].Pkgs.ToString() + "件"; //数量 string temp = PublicMethod.RemoveZero(list[i - 1].Qty_2.ToString()) == "0"?"":PublicMethod.RemoveZero(list[i - 1].Qty_2.ToString()); DevExpress.XtraReports.UI.XRTableCell cNum = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cNum" + i, false); //cNum.Text = PublicMethod.RemoveZero(list[i - 1].G_qty.ToString()) + "\n" + PublicMethod.RemoveZero(list[i - 1].Qty_1.ToString()) + "\n" + temp; //list[i - 1].G_qty.ToString(); cNum.Text = PublicMethod.RemoveZero(list[i - 1].Qty_1.ToString()) + "\n" + temp + "\n" + PublicMethod.RemoveZero(list[i - 1].G_qty.ToString()); //list[i - 1].G_qty.ToString(); //单位 DevExpress.XtraReports.UI.XRTableCell cUnit = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cUnit" + i, false); //cUnit.Text = PublicMethod.GetHashValue(ht,list[i - 1].G_unit).ToString() + "\n" + PublicMethod.GetHashValue(ht,list[i - 1].Unit_code1).ToString() + "\n" + PublicMethod.GetHashValue(ht,list[i - 1].Unit_code2).ToString(); //ht.Contains(list[i - 1].G_unit) ? ht[list[i - 1].G_unit].ToString() : "";//list[i - 1].G_unit; cUnit.Text = CommonReport.GetHashValue(ht, list[i - 1].Unit_code1).ToString() + "\n" + CommonReport.GetHashValue(ht, list[i - 1].Unit_code2).ToString() + "\n" + CommonReport.GetHashValue(ht, list[i - 1].G_unit).ToString(); //ht.Contains(list[i - 1].G_unit) ? ht[list[i - 1].G_unit].ToString() : "";//list[i - 1].G_unit; DevExpress.XtraReports.UI.XRTableCell cWeight = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cWeight" + i, false); cWeight.Text = list[i - 1].Gross + "\r\n" + list[i - 1].Net; //币值 DevExpress.XtraReports.UI.XRTableCell cCoin = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cCoin" + i, false); cCoin.Text = CommonReport.GetCode("118", list[i - 1].Curr_code.ToString(), true); DevExpress.XtraReports.UI.XRTableCell cPrice = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cPrice" + i, false); cPrice.Text = list[i - 1].Unit_price.ToString(); DevExpress.XtraReports.UI.XRTableCell cTotal = (DevExpress.XtraReports.UI.XRTableCell)Detail.FindControl("cTotal" + i, false); cTotal.Text = list[i - 1].Trade_ttl.ToString(); #endregion } } } catch (Exception ex) { LogManager.WriteErrorLog(ex.Message.ToString()); } }
/// <summary> /// 打印之前 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Rpt_Customs_InWarehouseBil_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { try { String DecType = CommonReport.GetDecCodeName(_Store_in_head.Dec_type); xrLabel1.Text = "(" + _Store_in_head.Lading_type + ") 核增表--" + DecType + " 复核表"; bStore_in_list.DataSource = _Store_in_head; xrTableCell_TAX_FLAG.Text = _Store_in_head.Tax_flag.Trim() == "1" ? "是" : (_Store_in_head.Tax_flag.Trim() == "0" ? "否" : "");//退税标志xrTableCell_SFDZBH xrTableCell_YUNF.Text = GetToValue(_Store_in_head.Yunf) + "/" + ILIMS.Common.PublicMethod.RemoveZero(_Store_in_head.Yunf2.ToString()) + "/" + GetCodeFromName(_dtbSPBCODES, _Store_in_head.Yunf3); //保费3 xrTableCell_BAOF.Text = GetToValue(_Store_in_head.Baof) + "/" + ILIMS.Common.PublicMethod.RemoveZero(_Store_in_head.Baof2.ToString()) + "/" + GetCodeFromName(_dtbSPBCODES, _Store_in_head.Baof3); xrTableCell_ZAF.Text = GetToValue(_Store_in_head.Zaf) + "/" + ILIMS.Common.PublicMethod.RemoveZero(_Store_in_head.Zaf2.ToString()) + "/" + GetCodeFromName(_dtbSPBCODES, _Store_in_head.Zaf3); //报关单类型 xrTableCell10.Text = DecType; //运输方式 xrTableCell_TRAF_MODE.Text = "(" + _Store_in_head.Traf_mode.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "116", _Store_in_head.Traf_mode.Trim()); //贸易方式 xrTableCell_TRADE_MODE.Text = "(" + _Store_in_head.Trade_mode.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "112", _Store_in_head.Trade_mode.Trim()); //结汇方式 xrTableCell_JHFS.Text = "(" + _Store_in_head.Jhfs_code.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "125", _Store_in_head.Jhfs_code.Trim()); //启运国 xrTableCell_TRADE_COUN.Text = "(" + _Store_in_head.Trade_coun.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "102", _Store_in_head.Trade_coun.Trim()); //装货港 xrTableCell_TRADE_PORT.Text = "(" + _Store_in_head.Trade_port.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "100", _Store_in_head.Trade_port.Trim()); //境地货源/目的地 xrTableCell_TRADE_AREA.Text = "(" + _Store_in_head.Trade_area.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "121", _Store_in_head.Trade_area.Trim()); //经营单位 xrTableCell_TRADE.Text = "(" + _Store_in_head.Trade_code + ")" + CommonReport.GetCompanyName(_Store_in_head.Trade_code.Trim()); xrTableCell_RS.Text = "(" + _Store_in_head.Rs_code + ")" + CommonReport.GetCompanyName(_Store_in_head.Rs_code.Trim()); //进出口岸 xrTableCell_IE_PORT.Text = "(" + _Store_in_head.Ie_port.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "108", _Store_in_head.Ie_port.Trim()); //入仓方式 xrTableCell93.Text = GetCName(_dtbInType001, _Store_in_head.In_type.Trim()); //币制 xrTableCell_CURR.Text = GetCodeFromName(_dtbSPBCODES, _Store_in_head.Curr_code.Trim()); // xrTableCell_CNTNR.Text = _Store_in_head.Cntnr_spec; xrTableCell_CZQY.Text = GetSIGN_NAME(_dtbEnterprise001, _Store_in_head.Lease_holder); //仓租企业名称 //货物类型 xrTableCell57.Text = _Store_in_head.Lading_type; xrTableCell_SFDZBH.Text = _Store_in_head.Sfdz;; //随附单证编号 //征免性质 xrTableCell_ZMXZ.Text = "(" + _Store_in_head.Zmxz_code.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "119", _Store_in_head.Zmxz_code.Trim()); //成交方式 xrTableCell_TRANS_MODE.Text = "(" + _Store_in_head.Trans_mode.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "115", _Store_in_head.Trans_mode.Trim()); //生产厂家及用途 xrTableCell_PU_CODE.Text = _Store_in_head.Pu_name + "/" + GetCodeFromName(_dtbSPBCODES, "117", _Store_in_head.Pu_code.Trim());; //包装种类 xrTableCell99.Text = "(" + _Store_in_head.Bzzl_code.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "133", _Store_in_head.Bzzl_code.Trim()); xrPkgs_num.Text = ILIMS.Common.PublicMethod.RemoveZero(_Store_in_head.Pkgs_num.ToString()); xrGross_Wt.Text = ILIMS.Common.PublicMethod.RemoveZero(_Store_in_head.Gross_wt.ToString()); xrNet_wt.Text = ILIMS.Common.PublicMethod.RemoveZero(_Store_in_head.Net_wt.ToString()); xrAll_value.Text = ILIMS.Common.PublicMethod.RemoveZero(_Store_in_head.All_value.ToString()); } catch (Exception ex) { throw ex; } }
private void Rpt_Customs_OutWarehouseBill_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { try { string DecType = CommonReport.GetDecCodeName(_Store_Out_head.Dec_type); xrLabel1.Text = "(" + _Store_Out_head.Lading_type + ") 核扣表--" + DecType + " 复核表"; //bStore_Out_list.DataSource = _Store_Out_head; //条码 xrBarCode1.Text = _Store_Out_head.Bill_id; //出仓单号 xtcClp_No.Text = _Store_Out_head.Bill_id; //出仓日期 xrLabel_IEDate.Text = _Store_Out_head.Out_date.ToString("yyyy-MM-dd"); //创建人 xtcCreate_name.Text = _Store_Out_head.Creater_name; //车牌号 xtcCar_no.Text = _Store_Out_head.Car_no; //司机本编号 xtDriver_no.Text = _Store_Out_head.Driver_no; //报关单号 xtRefer_doc.Text = _Store_Out_head.Refer_doc; //客户订单号 xtClient_no.Text = _Store_Out_head.Client_no; //MCC号 xtMcc_no.Text = _Store_Out_head.Mcc_no; //封条 xtSeal_no.Text = _Store_Out_head.Seal_no; //备注 xtRemark.Text = _Store_Out_head.Remark; //备案号 xtBah.Text = _Store_Out_head.Bah; //进出口日期 xrTableCell_IE_DATE.Text = _Store_Out_head.Ie_date.ToString("yyyy-MM-dd"); //运输工具 xtTraf_name.Text = _Store_Out_head.Traf_name; //提运单号 xtTydh.Text = _Store_Out_head.Tydh; //许可证号 xtPermission_no.Text = _Store_Out_head.Permission_no; //批准文号 xtPzwh.Text = _Store_Out_head.Pzwh; //合同协议号 xtHtxyh.Text = _Store_Out_head.Htxyh; // xtNote_s.Text = _Store_Out_head.Note_s; //转关单号 xrTableCell29.Text = _Store_Out_head.Trans_doc; xrTableCell_YUNF.Text = GetToValue(_Store_Out_head.Yunf) + "/" + ILIMS.Common.PublicMethod.RemoveZero(_Store_Out_head.Yunf2.ToString()) + "/" + GetCodeFromName(_dtbSPBCODES, _Store_Out_head.Yunf3); //保费3 xrTableCell_BAOF.Text = GetToValue(_Store_Out_head.Baof) + "/" + ILIMS.Common.PublicMethod.RemoveZero(_Store_Out_head.Baof2.ToString()) + "/" + GetCodeFromName(_dtbSPBCODES, _Store_Out_head.Baof3); xrTableCell_ZAF.Text = GetToValue(_Store_Out_head.Zaf) + "/" + ILIMS.Common.PublicMethod.RemoveZero(_Store_Out_head.Zaf2.ToString()) + "/" + GetCodeFromName(_dtbSPBCODES, _Store_Out_head.Zaf3); //报关单类型 xrTableCell91.Text = CommonReport.GetDecCodeName(_Store_Out_head.Dec_type); //运输方式 xrTableCell_TRAF_MODE.Text = "(" + _Store_Out_head.Traf_mode.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "116", _Store_Out_head.Traf_mode.Trim()); //贸易方式 xrTableCell_TRADE_MODE.Text = "(" + _Store_Out_head.Trade_mode.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "112", _Store_Out_head.Trade_mode.Trim()); //结汇方式 xrTableCell_JHFS.Text = "(" + _Store_Out_head.Jhfs_code.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "125", _Store_Out_head.Jhfs_code.Trim()); //启运国 xrTableCell_TRADE_COUN.Text = "(" + _Store_Out_head.Trade_coun.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "102", _Store_Out_head.Trade_coun.Trim()); //装货港 xrTableCell_TRADE_PORT.Text = "(" + _Store_Out_head.Trade_port.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "100", _Store_Out_head.Trade_port.Trim()); //境地货源/目的地 xrTableCell_TRADE_AREA.Text = "(" + _Store_Out_head.Trade_area.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "121", _Store_Out_head.Trade_area.Trim()); //成交方式 xrTableCell_TRANS_MODE.Text = "(" + _Store_Out_head.Trans_mode.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "115", _Store_Out_head.Trans_mode.Trim()); //经营单位 xrTableCell_TRADE.Text = "(" + _Store_Out_head.Trade_code + ")" + CommonReport.GetCompanyName(_Store_Out_head.Trade_code.Trim()); xrTableCell_RS.Text = "(" + _Store_Out_head.Rs_code + ")" + CommonReport.GetCompanyName(_Store_Out_head.Rs_code.Trim()); //进出口岸 xrTableCell_IE_PORT.Text = "(" + _Store_Out_head.Ie_port.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "108", _Store_Out_head.Ie_port.Trim()); //出仓方式 if (_Store_Out_head.Lading_type.ToString() == "保税") {//保税仓出仓方式dtbOutWarehouseWay500 DataRow[] drdtbOutWarehouseWay500 = _dtbOutType500.Select("outtype_id=" + _Store_Out_head.Out_type); xrTableCell65.Text = drdtbOutWarehouseWay500[0]["outtype"].ToString(); } else {//监管仓出仓方式dtbOutWarehouseWay001 DataRow[] drdtbOutWarehouseWay001 = _dtbInType001.Select("outtype_id=" + _Store_Out_head.Out_type); xrTableCell65.Text = drdtbOutWarehouseWay001[0]["outtype"].ToString(); } //币制 xrTableCell_CURR.Text = "(" + _Store_Out_head.Curr_code.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, _Store_Out_head.Curr_code.Trim()); //包装种类 xrTableCell73.Text = "(" + _Store_Out_head.Bzzl_code.Trim() + ")" + GetCodeFromName(_dtbSPBCODES, "133", _Store_Out_head.Bzzl_code.Trim()); //货物类型 xrTableCell96.Text = _Store_Out_head.Lading_type; xrTableCell_CNTNR.Text = _Store_Out_head.Cntnr_spec; xrTableCell_CZQY.Text = GetSIGN_NAME(_dtbEnterprise001, _Store_Out_head.Lease_holder); //仓租企业名称 xrTableCell_SFDZBH.Text = _Store_Out_head.Sfdz; //随附单证编号 //生产厂家用途 xrTableCell_PU_CODE.Text = _Store_Out_head.Pu_name + "/" + GetCodeFromName(_dtbSPBCODES, "117", _Store_Out_head.Pu_code.Trim());; //证免 xrTableCell_ZMXZ.Text = GetCodeFromName(_dtbSPBCODES, "119", _Store_Out_head.Zmxz_code.Trim()); xrPkgs_num.Text = ILIMS.Common.PublicMethod.RemoveZero(_Store_Out_head.Pkgs_num.ToString()); xrGross_Wt.Text = ILIMS.Common.PublicMethod.RemoveZero(_Store_Out_head.Gross_wt.ToString()); xrNet_wt.Text = ILIMS.Common.PublicMethod.RemoveZero(_Store_Out_head.Net_wt.ToString()); xrAll_value.Text = ILIMS.Common.PublicMethod.RemoveZero(_Store_Out_head.All_value.ToString()); } catch (Exception ex) { throw ex; } }