/// <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 dtbInType001 = new DataTable(); //监管仓核增方式
DataTable dtbInType500 = new DataTable(); //保税仓核增方式
DataTable dtbSPBCODES = new DataTable();
dtbInType001 = BasicData.BLL.BLLFactory <BasicData.BLL.B_datacategory> .Instance.GetInWarehouseTypeFromDepot("001", true);
dtbInType500 = BasicData.BLL.BLLFactory <BasicData.BLL.B_datacategory> .Instance.GetInWarehouseTypeFromDepot("500", true);
dtbSPBCODES = BasicData.BLL.BLLFactory <BasicData.BLL.C_codes> .Instance.GetAllToDataTable();
Customs.Entity.Store_in_headInfo Store_in_head = Customs.BLL.BLLFactory <Customs.BLL.Store_in_head> .Instance.FindSingle(" BILL_ID='" + sCurrentRowBillCode + "'");
DataTable dstInHead = Customs.BLL.BLLFactory <Customs.BLL.Store_in_head> .Instance.SelectSimpleStoreInHead(sCurrentRowBillCode);
DataTable dstInList = Customs.BLL.BLLFactory <Customs.BLL.Store_in_list> .Instance.SelectSimpleStoreInList(sCurrentRowBillCode);
dstInHead.Rows[0]["dec_type"] = CommonReport.GetDecCodeName(dstInHead.Rows[0]["dec_type"].ToString());
if (LadingType == "MCC" && dstInList.Rows.Count > 20)
{
if (dstInList != null)
{
dstInList.Columns.Add("ColNo", typeof(string));
//增加汇总行
decimal TotalNet = 0;
decimal TotalGross = 0;
decimal TotalPrice = 0;
decimal TotalPkgs = 0;
#region
if (dstInList != null)
{
if (dstInList.Rows.Count > 0)
{
DataRow dr = null;
int m = 0;
for (int i = 0; i < dstInList.Rows.Count; i++)
{
if (dstInList.Rows[i]["BILL_ID"] != null && dstInList.Rows[i]["BILL_ID"].ToString().Trim() != "")
{
TotalNet += string.IsNullOrEmpty(dstInList.Rows[i]["NET"].ToString().Trim()) ? 0 : decimal.Parse(dstInList.Rows[i]["NET"].ToString().Trim());
TotalGross += string.IsNullOrEmpty(dstInList.Rows[i]["GROSS"].ToString().Trim()) ? 0 : decimal.Parse(dstInList.Rows[i]["GROSS"].ToString().Trim());
TotalPrice += string.IsNullOrEmpty(dstInList.Rows[i]["TRADE_TTL"].ToString().Trim()) ? 0 : decimal.Parse(dstInList.Rows[i]["TRADE_TTL"].ToString().Trim());
TotalPkgs += string.IsNullOrEmpty(dstInList.Rows[i]["PKGS"].ToString().Trim()) ? 0 : decimal.Parse(dstInList.Rows[i]["PKGS"].ToString().Trim());
m++;
if (m % 20 == 0 && m != 0)
{
dr = dstInList.NewRow();
dr["NET"] = TotalNet;
dr["GROSS"] = TotalGross;
dr["TRADE_TTL"] = TotalPrice;
dr["PKGS"] = TotalPkgs;
dr["ColNo"] = i + 1;
dr["QTY_2"] = 0;
dr["ORIGN_COUN"] = "";
dr["Curr_code"] = "";
dstInList.Rows.InsertAt(dr, i + 1);
TotalNet = 0;
TotalGross = 0;
TotalPrice = 0;
TotalPkgs = 0;
}
else
{
dstInList.Rows[i]["ColNo"] = i + 1;
}
}
}
if (TotalNet != 0)//如果非21倍数
{
dr = dstInList.NewRow();
dr["NET"] = TotalNet;
dr["GROSS"] = TotalGross;
dr["TRADE_TTL"] = TotalPrice;
dr["PKGS"] = TotalPkgs;
dr["ColNo"] = "小计";
dr["ORIGN_COUN"] = "";
dr["Curr_code"] = "";
dr["QTY_2"] = 0;
dstInList.Rows.InsertAt(dr, dstInList.Rows.Count);
}
}
}
#endregion
}
}
//获得列表中商品内容
string CODE_TS = "";
foreach (DataRow drw in dstInList.Rows)
{
CODE_TS += drw["CODE_T"].ToString().Trim() + "|";
}
//List<Customs.Entity.Store_in_listInfo> dtbSTORE_IN_LIST = Customs.BLL.BLLFactory<Customs.BLL.Store_in_list>.Instance.Find(" BILL_ID='" + Store_in_head.Bill_id + "'", " order by g_no ");
DataTable dstComplexys = BasicData.BLL.BLLFactory <BasicData.BLL.C_complex> .Instance.GetListByCodes(CODE_TS);
DataSet dstReport = new DataSet();
DataTable dtbHead = new DataTable("STORE_IN_HEAD");
DataTable dtbList = new DataTable("STORE_IN_LIST");
DataTable dtbSpbComplexys = new DataTable("SPBCOMPLEXYS");
dtbHead = dstInHead.Copy();
dtbList = dstInList.Copy();
dtbSpbComplexys = dstComplexys.Copy();
dstReport.Tables.Add(dtbHead);
//dstReport.Tables.Add(dtbList);
//dstReport.Tables.Add(dtbSpbComplexys);
DataTable Enterprise = null;
DataTable InType = null;
if (Store_in_head.Lading_type == "保税")
{
InType = dtbInType500;
}
else
{
InType = dtbInType001;
}
Enterprise = BasicData.BLL.BLLFactory <BasicData.BLL.B_custom_info> .Instance.GetEnterpriseFromDepot(string.Empty);
XtraReport reportClass = new Rpt_Customs_InWarehouseBil(Store_in_head, dstInList, dtbSPBCODES, Enterprise, InType, dstComplexys);
reportClass.DataSource = dstReport;
reportClass.DataMember = "STORE_IN_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 }));
}
}
/// <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;
}
}
