public Report_bscc(Customs.Entity.Store_out_headInfo CurOutHead, List <Customs.Entity.Store_out_listInfo> list, int PageIndex, int PageSize, bool LastPage, int FirstPage, string Title) { InitializeComponent(); //初始化表头 try { #region 表头部分 //初始化表头部分 if (Title == "监管") { labTitle.Text = "出 口 监 管 仓 货 物"; } if (Title == "保税" || Title == "MCC") { labTitle.Text = "进 口 保 税 仓 货 物"; } labPage.Text = "第 " + (PageIndex + 1).ToString() + " 续页"; labCustom.Text = CurOutHead.Ie_port; if (CurOutHead.Ie_date.ToString("yyyy-MM-dd") != "1900-01-01") { labDate.Text = CurOutHead.Ie_date.ToString("yyyy-MM-dd"); } lbcust_bill_id.Text = CurOutHead.Cust_bill_id; lbBill_id.Text = CurOutHead.Bill_id; #endregion #region 明细项 if (!LastPage) { for (int i = 1; i <= PageSize; i++) { int j = i + PageIndex * PageSize + FirstPage - 1; init(list, i, j); } } else { for (int i = 1; i <= list.Count - FirstPage - PageIndex * PageSize; i++) { int j = i + PageIndex * PageSize + FirstPage - 1; init(list, i, j); } } #endregion } catch (Exception) { throw; } }
public Rpt_Customs_OutWarehouseBill(Customs.Entity.Store_out_headInfo Store_Out_head, DataTable Store_Outs_lists, DataTable dtbSPBCODES, DataTable dtbEnterprise001, DataTable dtbInType001,DataTable dtbOutType500, DataTable c_complexys) { InitializeComponent(); this._Store_Out_head = Store_Out_head; this._Store_Outs_lists = Store_Outs_lists; this._dtbSPBCODES = dtbSPBCODES; this._dtbEnterprise001 = dtbEnterprise001; this._dtbInType001 = dtbInType001; this._dtbOutType500 = dtbOutType500; DetailReport.DataSource = _Store_Outs_lists; _c_complexys = c_complexys; }
public Rpt_Customs_OutWarehouseBill(Customs.Entity.Store_out_headInfo Store_Out_head, DataTable Store_Outs_lists, DataTable dtbSPBCODES, DataTable dtbEnterprise001, DataTable dtbInType001, DataTable dtbOutType500, DataTable c_complexys) { InitializeComponent(); this._Store_Out_head = Store_Out_head; this._Store_Outs_lists = Store_Outs_lists; this._dtbSPBCODES = dtbSPBCODES; this._dtbEnterprise001 = dtbEnterprise001; this._dtbInType001 = dtbInType001; this._dtbOutType500 = dtbOutType500; DetailReport.DataSource = _Store_Outs_lists; _c_complexys = c_complexys; }
public Report_ckjgcc(Customs.Entity.Store_out_headInfo CurOutHead, List <Customs.Entity.Store_out_listInfo> CurOutList, string Type) { InitializeComponent(); //Type = "保税"; try { #region 表头项 if (Type == "监管") { tbWareName.Text = "华南物流监管仓"; tbVar.Text = "集装箱号"; tbTitle.Text = "出 口 监 管 仓 货 物"; labCustomCode.Text = CurOutHead.Bill_id; //labWareNO.Text = CurOutHead.Store_code; //tbSum.Visible = false; } if (Type == "保税" || Type == "MCC") { xrPictureBox1.Visible = false; labCustomCode.Visible = false; xrLabel3.Visible = false; tbTitle.Text = "进 口 保 税 仓 货 物"; tbWareName.Text = "华南物流保税仓"; tbVar.Text = "载货清单号"; xrLabel2.Text = "出仓单编号:"; //labWareNO.Text = CurOutHead.Bill_id; } //总的件数合计 BarCode.Text = CurOutHead.Bill_id; lbJZXH.Text = CurOutHead.Cntnr_spec; labWareNO.Text = CurOutHead.Cust_bill_id; lbCnsNo.Text = CurOutHead.Cns_no; tbTotalPkgs.Text = CurOutHead.Pkgs_num.ToString(); tbreferdoc.Text = CurOutHead.Refer_doc; tbLoadCarCode.Text = CurOutHead.Shipping_no; tbdeliverUnit.Text = htCustom[CurOutHead.Lease_holder] != null?htCustom[CurOutHead.Lease_holder].ToString():""; tbOut.Text = CurOutHead.Ie_port; tbFZCode.Text = CurOutHead.Seal_no; //司机本海关编号 tbcarCcode.Text = CurOutHead.Driver_no; tbOutCountry.Text = CommonReport.GetCode("102", CurOutHead.Trade_coun, false); tbCarNO.Text = CurOutHead.Car_no; tbOutType.Text = CurOutHead.Out_type; lbRemark.Text = CurOutHead.Remark; if (CurOutHead.Ie_date.ToString("yyyy-MM-dd") != "1900-01-01") { labDate.Text = CurOutHead.Ie_date.ToString("yyyy-MM-dd"); } //labCustom.Text = CurOutHead.Ie_port; tbTotal.Text = CurOutHead.All_value.ToString(); tbTotalW.Text = "毛重:" + CurOutHead.Gross_wt.ToString() + "\n" + "净重:" + CurOutHead.Net_wt.ToString(); #endregion #region 明细项 if (CurOutList.Count <= 5) { for (int i = 1; i <= CurOutList.Count; i++) { init(i, CurOutList); } } if (CurOutList.Count > 5) { for (int i = 1; i <= 5; i++) { init(i, CurOutList); } } #endregion } catch (Exception) { throw; } }
/// <summary> /// 复核表打印 /// </summary> /// <param name="id">订单号</param> /// <param name="lading_type">货物类型</param> public void ReviewPrint(string id, string lading_type) { try { //权限验证 this.HasActionPower(); if (string.IsNullOrWhiteSpace(id) || string.IsNullOrWhiteSpace(lading_type)) { var msgT = Server.UrlEncode("参数传输错误!"); var msgD = Server.UrlEncode(string.Empty); UrlHelper url = new UrlHelper(this.Request.RequestContext); this.Response.Redirect(url.Action("Index", "Error", new { msgTitle = msgT, msgDetail = msgD })); } var dateFormat = DateTime.Now.ToString("yyyyMMdd"); var rootPath = Server.MapPath("~/FileTemp"); var dirPath = rootPath + "/" + dateFormat + "/"; if (!Directory.Exists(dirPath)) { Directory.CreateDirectory(dirPath); } var fileName = id + "_" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".pdf"; var filePath = dirPath + fileName; #region 生成pdf //取出当前点中的行的核扣单号 //取出当前点中的行的核增单号 string sCurrentRowBillCode = id; string LadingType = lading_type; DataTable dtbEnterprise001 = new DataTable(); //监管仓仓租企业 DataTable dtbEnterprise500 = new DataTable(); //保税仓仓租企业 DataTable dtbOutType001 = new DataTable(); //监管仓核扣方式 DataTable dtbOutType500 = new DataTable(); //保税仓核扣方式 DataTable _allSPBCODES = new DataTable(); dtbEnterprise001 = BasicData.BLL.BLLFactory <BasicData.BLL.B_custom_info> .Instance.GetEnterpriseFromDepot("1", true); dtbEnterprise500 = BasicData.BLL.BLLFactory <BasicData.BLL.B_custom_info> .Instance.GetEnterpriseFromDepot("2", true); dtbOutType001 = BasicData.BLL.BLLFactory <BasicData.BLL.B_datacategory> .Instance.GetOutType("001", true); dtbOutType500 = BasicData.BLL.BLLFactory <BasicData.BLL.B_datacategory> .Instance.GetOutType("500", true); _allSPBCODES = BasicData.BLL.BLLFactory <BasicData.BLL.C_codes> .Instance.GetAllToDataTable(); Customs.Entity.Store_out_headInfo Store_Out_head = Customs.BLL.BLLFactory <Customs.BLL.Store_out_head> .Instance.FindSingle(" Bill_id='" + sCurrentRowBillCode + "'"); DataTable dstOutHead = Customs.BLL.BLLFactory <Customs.BLL.Store_out_head> .Instance.SelectSimpleStoreOutHead(sCurrentRowBillCode); DataTable dstOutList = Customs.BLL.BLLFactory <Customs.BLL.Store_out_list> .Instance.SelectSimpleStoreOutList(sCurrentRowBillCode); dstOutHead.Rows[0]["dec_type"] = CommonReport.GetDecCodeName(dstOutHead.Rows[0]["dec_type"].ToString()); if (dstOutList != null) { dstOutList.Columns.Add("ColNo", typeof(string)); //增加汇总行 decimal TotalNet = 0; decimal TotalGross = 0; decimal TotalPrice = 0; decimal TotalPkgs = 0; if (dstOutList != null && dstOutList.Rows.Count > 0) { DataRow dr = null; int m = 0; for (int i = 0; i < dstOutList.Rows.Count; i++) { if (dstOutList.Rows[i]["BILL_ID"] != null && dstOutList.Rows[i]["BILL_ID"].ToString().Trim() != "") { TotalNet += string.IsNullOrEmpty(dstOutList.Rows[i]["NET"].ToString().Trim()) ? 0 : decimal.Parse(dstOutList.Rows[i]["NET"].ToString().Trim()); TotalGross += string.IsNullOrEmpty(dstOutList.Rows[i]["GROSS"].ToString().Trim()) ? 0 : decimal.Parse(dstOutList.Rows[i]["GROSS"].ToString().Trim()); TotalPrice += string.IsNullOrEmpty(dstOutList.Rows[i]["USD_TRADE_TTL"].ToString().Trim()) ? 0 : decimal.Parse(dstOutList.Rows[i]["USD_TRADE_TTL"].ToString().Trim()); TotalPkgs += string.IsNullOrEmpty(dstOutList.Rows[i]["PKGS"].ToString().Trim()) ? 0 : decimal.Parse(dstOutList.Rows[i]["PKGS"].ToString().Trim()); m++; if (m % 20 == 0 && m != 0) { dr = dstOutList.NewRow(); dr["NET"] = TotalNet; dr["GROSS"] = TotalGross; dr["USD_TRADE_TTL"] = TotalPrice; dr["PKGS"] = TotalPkgs; dr["ColNo"] = i + 1; dr["QTY_2"] = 0; dr["ORIGN_COUN"] = ""; dr["Curr_code"] = ""; dstOutList.Rows.InsertAt(dr, i + 1); TotalNet = 0; TotalGross = 0; TotalPrice = 0; TotalPkgs = 0; } else { dstOutList.Rows[i]["ColNo"] = i + 1; } } } if (TotalNet != 0)//如果非21倍数 { dr = dstOutList.NewRow(); dr["NET"] = TotalNet; dr["GROSS"] = TotalGross; dr["USD_TRADE_TTL"] = TotalPrice; dr["PKGS"] = TotalPkgs; dr["ColNo"] = "小计"; dr["QTY_2"] = 0; dr["ORIGN_COUN"] = ""; dr["Curr_code"] = ""; dstOutList.Rows.InsertAt(dr, dstOutList.Rows.Count); } } } //获得列表中商品内容 string CODE_TS = ""; foreach (DataRow drw in dstOutList.Rows) { CODE_TS += drw["CODE_T"].ToString().Trim() + "|"; } DataTable dstComplexys = new DataTable(); if (!string.IsNullOrEmpty(CODE_TS)) { dstComplexys = BasicData.BLL.BLLFactory <BasicData.BLL.C_complex> .Instance.GetListByCodes(CODE_TS); } DataSet dstReport = new DataSet(); dtbEnterprise001 = BasicData.BLL.BLLFactory <BasicData.BLL.B_custom_info> .Instance.GetEnterpriseFromDepot(string.Empty); XtraReport reportClass = new Rpt_Customs_OutWarehouseBill(Store_Out_head, dstOutList, _allSPBCODES, dtbEnterprise001, dtbOutType001, dtbOutType500, dstComplexys); reportClass.DataSource = dstReport; reportClass.DataMember = "STORE_OUT_HEAD"; reportClass.ExportToPdf(filePath); #endregion //写出文件 if (!string.IsNullOrWhiteSpace(filePath)) { RespWrite(filePath); } } catch (Exception ex) { var msgT = Server.UrlEncode("系统出现错误,请联系客服或管理员处理!"); var msgD = Server.UrlEncode(ex.Message); UrlHelper url = new UrlHelper(this.Request.RequestContext); this.Response.Redirect(url.Action("Index", "Error", new { msgTitle = msgT, msgDetail = msgD })); } }