//初始化出口监管仓货物入仓清单
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;
}
}
