public static void 打印内贸结算明细单(string 对账单号, int iFyxs)
{
if (iFyxs == 0)
{
ServiceProvider.GetService <IMessageBox>().ShowWarning("不能打印费用项数为0的对账单！");
return;
}
string sql = "exec 过程查询_交叉表_对账单_内贸结算明细'" + 对账单号 + "'";
DataTable tempTB = DbHelper.Instance.ExecuteDataTable(sql);
DataTable dt = dtx2(tempTB, iFyxs);
MyReportForm form = new MyReportForm(iFyxs > 1 ? "报表_内贸结算明细_2" : "报表_内贸结算明细");
form.FillDataSet(0, dt.DefaultView);
for (int i = 1; i < iFyxs + 1; i++)
{
form.CrystalReportViewer.CrystalHelper.SetParameter("c" + i.ToString(), tempTB.Columns[16 + i].ColumnName);
if (tempTB.Columns[16 + i].ColumnName.Equals("单箱代理费"))
{
form.CrystalReportViewer.CrystalHelper.SetParameter("c" + i.ToString(), "包干费");
}
}
if (iFyxs > 2)
{
form.CrystalReportViewer.CrystalHelper.SetParameter("c2", "其他费用");
}
form.Show();
}
public static void 打印凭证(string 凭证号)
{
MyReportForm form = new MyReportForm("报表_凭证");
form.FillDataSet(0, DbHelper.Instance.ExecuteDataTable("SELECT * FROM 报表_凭证 WHERE 凭证号 = '" + 凭证号 + "'").DefaultView);
form.FillDataSet(1, DbHelper.Instance.ExecuteDataTable("SELECT * FROM 报表_凭证费用明细 WHERE 凭证号 = '" + 凭证号 + "'").DefaultView);
form.Show();
}
//进口其他业务应收对账单
public static void 打印进口其他业务对账单(string 对账单号, int iFyxs)
{
if (iFyxs == 0)
{
return;
}
string sql = "exec 过程查询_交叉表_对账单_进口其他业务'" + 对账单号 + "'";
DataTable tempTB = DbHelper.Instance.ExecuteDataTable(sql);
DataTable dt = dtx_jkqt(tempTB, iFyxs);
string reportName = null;
switch (iFyxs)
{
case 1:
reportName = "报表_进口其他业务_应收对账单_1";
break;
case 2:
reportName = "报表_进口其他业务_应收对账单_2";
break;
case 3:
reportName = "报表_进口其他业务_应收对账单_3";
break;
case 4:
reportName = "报表_进口其他业务_应收对账单_4";
break;
case 5:
reportName = "报表_进口其他业务_应收对账单_5";
break;
case 6:
reportName = "报表_进口其他业务_应收对账单_6";
break;
case 7:
reportName = "报表_进口其他业务_应收对账单_7";
break;
default:
MessageForm.ShowError("报表创建失败！");
return;
}
MyReportForm form = new MyReportForm(reportName);
form.FillDataSet(0, dt.DefaultView);
for (int i = 1; i < iFyxs + 1; i++)
{
form.CrystalReportViewer.CrystalHelper.SetParameter("c" + i.ToString(), tempTB.Columns[10 + i].ColumnName);
}
form.Show();
}
//YYH对账单
public static void 打印原始对账单(string 对账单号, int iFyxs)
{
if (iFyxs == 0)
{
ServiceProvider.GetService <IMessageBox>().ShowWarning("不能打印费用项数为0的对账单！");
return;
}
string sql = "exec 过程查询_交叉表_对账单 '" + 对账单号 + "'";
DataTable tempTB = DbHelper.Instance.ExecuteDataTable(sql);
int count = tempTB.Columns.Count;
DataTable dt = dtx_ys(tempTB, iFyxs);
MyReportForm form = new MyReportForm("报表_对账单_原始");
form.FillDataSet(0, dt.DefaultView);
form.Show();
}
public static void 打印凭证(ArchiveOperationForm masterForm)
{
凭证 pz = masterForm.DisplayManager.CurrentItem as 凭证;
if (pz == null)
{
MessageForm.ShowError("请选择要打印的凭证！");
return;
}
using (IRepository rep = ServiceProvider.GetService <IRepositoryFactory>().GenerateRepository <凭证>())
{
rep.Initialize(pz.凭证费用明细, pz);
}
MyReportForm form = new MyReportForm("报表_凭证");
form.FillDataSet(0, new List <凭证> {
pz
});
form.FillDataSet(1, pz.凭证费用明细);
//System.Data.DataSet ds = form.TemplateDataSet;
//ds.Tables["凭证"].Rows[0]["大写金额"] = ChineseHelper.ConvertToChinese(pz.金额.数额.Value);
//ds.Tables["凭证"].Rows[0]["金额.币制编号"] = NameValueMappingCollection.Instance.FindColumn2FromColumn1("财务_币制", "代码", "符号", pz.金额.币制编号);
form.Show();
//Hd.Report.凭证Ds ds = new Hd.Report.凭证Ds();
//Hd.Report.凭证Ds.凭证Row row = ds.凭证.New凭证Row();
//row["凭证号"] = pz.凭证号;
//row["日期"] = pz.日期;
//row["相关人编号"] = NameValueMappingCollection.Instance.FindNameFromId("人员单位_全部", pz.相关人编号);
////row["项目名称"] = "000";
//row["金额.数额"] = pz.金额.数额;
//row["大写金额"] = Feng.Utils.ChineseHelper.ConvertToChinese(pz.金额.数额.Value);
//row["备注"] = pz.备注;
//ds.凭证.Rows.Add(row);
//FormRptPreView frmReport = new FormRptPreView(ds, new Hd.Report.凭证());
//frmReport.Show();
}
public static void 打印货代报关部委托运输联系单(ArchiveOperationForm masterForm)
{
进口票过程转关标志 pz = masterForm.DisplayManager.CurrentItem as 进口票过程转关标志;
进口票 entity = pz.票;
if (entity == null)
{
MessageForm.ShowError("请选择要打印的票！");
return;
}
using (IRepository rep = ServiceProvider.GetService <IRepositoryFactory>().GenerateRepository <进口票>())
{
rep.Initialize(entity.箱, entity);
}
MyReportForm form = new MyReportForm("报表_货代报关部委托运输联系单_进口");
form.FillDataSet(0, new List <进口票> {
entity
});
form.FillDataSet(1, entity.箱);
form.Show();
}
public static void 打印对账单_额外(string 对账单号, int iFyxs)
{
if (iFyxs == 0)
{
ServiceProvider.GetService <IMessageBox>().ShowWarning("不能打印费用项数为0的对账单！");
return;
}
string sql = "exec 过程查询_交叉表_对账单_额外 '" + 对账单号 + "'";
DataTable tempTB = DbHelper.Instance.ExecuteDataTable(sql);
int count = tempTB.Columns.Count;
DataTable dt = dtx_ew(tempTB, iFyxs);
MyReportForm form = null;
if (iFyxs <= 5)
{
form = new MyReportForm("报表_对账单_额外_" + iFyxs);
}
else if (iFyxs > 5 && iFyxs < 10)
{
form = new MyReportForm("报表_对账单_额外_5");
}
else
{
form = new MyReportForm("报表_对账单_额外_10");
}
form.FillDataSet(0, dt.DefaultView);
//设置参数，即表头
if (iFyxs > 5 && iFyxs < 10)
{
for (int i = 1; i <= 5; i++)
{
if (i <= tempTB.Columns.Count - 19)
{
form.CrystalReportViewer.CrystalHelper.SetParameter("c" + i.ToString(), tempTB.Columns[14 + i].ColumnName);
}
//else
// //给没用到的参数一个空值
// form.CrystalReportViewer.CrystalHelper.SetParameter("c" + i.ToString(), " ");
}
}
else
{
for (int i = 1; i <= (iFyxs <= 5 ? iFyxs : 10); i++)
{
if (i <= tempTB.Columns.Count - 19)
{
form.CrystalReportViewer.CrystalHelper.SetParameter("c" + i.ToString(), tempTB.Columns[14 + i].ColumnName);
}
//else
// //给没用到的参数一个空值
// form.CrystalReportViewer.CrystalHelper.SetParameter("c" + i.ToString(), " ");
}
}
if (iFyxs > 5 && count > 23)
{
form.CrystalReportViewer.CrystalHelper.SetParameter("c5", "其他费用");
}
if (iFyxs > 10 && count > 26)
{
form.CrystalReportViewer.CrystalHelper.SetParameter("c10", "其他费用");
}
form.Show();
}
