/// <summary>
/// 设置盘亏单数据
/// </summary>
/// <param name="strBillNum">盘亏单单号清单</param>
private void GetMaterialData(string strBillNum)
{
Int64 iBillNum;
var l = new List<string>();
if (!string.IsNullOrWhiteSpace(strBillNum))
{
//分解单号
string[] billNums = strBillNum.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
//遍历
foreach (var billNum in billNums)
{
if (Int64.TryParse(billNum, out iBillNum))
{
l.Add(iBillNum.ToString());
}
}
}
if (l.Count <= 0)
{
Response.Write("未检测到传入正确的单据编号！");
return;
}
//修改标题
this.Title = "盘亏单预览" + strBillNum;
//设置公司名称
strCompanyName = "根基";
//表头行各单元格css
cssClasses =
("rowidtdth,suppliercodetdth,suppliernametdth,materialcodetdth,materialnametdth," +
"materialsizetdth,qtytdth,materialunittdth,remarktdth").Split(',');
//表头行各单元格显示的文字
showTexts = "行号,供应商代码,供应商名称,物料代码,物料名称,规格,数量,单位,备注".Split(',');
//数据适配器
using (var daHead = new t_material_lose_headTableAdapter())
using (var daContent = new t_material_lose_contentTableAdapter())
using (var conn = daHead.Connection)
{
//设置数据库连接对象
daContent.Connection = conn;
//打开数据库连接
conn.Open();
//初始化表头表身
tabHead = new DataSetMaterialLose.t_material_lose_headDataTable();
tabContent = new DataSetMaterialLose.t_material_lose_contentDataTable();
//设置填充不清除之前数据
daHead.ClearBeforeFill = false;
daContent.ClearBeforeFill = false;
//遍历获取数据
foreach (var billNum in l)
{
//获取表头数据
daHead.FillDataByBillNum(tabHead, billNum);
//获取表身数据
daContent.FillDataByBillNum(tabContent, billNum);
}
}
}
