protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CustID = this.txtCustID.Value;
string Linker = this.HidLinker.Value;
string StartLinkDate = this.txtStartLinkDate.Text;
string EndLinkDate = this.txtEndLinkDate.Text;
int TotalCount = 0;
DataTable dt = ProviderContactHistoryBus.SelectProviderContactHistory(1, 1000000, "ID", ref TotalCount, CustID, Linker, StartLinkDate, EndLinkDate);
//DataTable dt = WorkCenterBus.GetWorkCenterListBycondition(model, 1, 1000000, "ID desc", ref totalCount);
//导出标题
string headerTitle = "联络单编号|供应商名称|供应商类型|联络人|联络时间|被联络人";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "ContactNo|CustName|CustTypeName|LinkerName|LinkDate|LinkManName";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "供应商联络列表");
}
private void BinddrpLinkMode()
{
DataTable dt = ProviderContactHistoryBus.GetdrpLinkMode();
if (dt != null && dt.Rows.Count > 0)
{
drpLinkMode.DataSource = dt;
drpLinkMode.DataTextField = "TypeName";
drpLinkMode.DataValueField = "ID";
drpLinkMode.DataBind();
}
ListItem Item = new ListItem();
Item.Value = "0";
Item.Text = "--请选择--";
drpLinkMode.Items.Insert(0, Item);
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_PURCHASE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_PROVIDERCONTACTHISTORY;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase =
{
{ "联络单编号", "ContactNo" },
{ "供应商名称", "CustName" },
{ "主题", "Title" },
{ "供应商联络人", "LinkManName" },
{ "联络事由", "LinkReasonName" },
{ "联络方式", "LinkModeName" },
{ "联络时间", "LinkDate" },
{ "我方联络人", "LinkerName" },
{ "联络内容", "Contents" },
};
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtProviderInfo = ProviderContactHistoryBus.SelectProviderContactHistory(this.intMrpID);
string strBaseFields = "";
string strDetailFields = "";
/*第二明细*/
string strDetailSecondFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
/*第二明细*/
strDetailSecondFields = dbPrint.Rows[0]["DetailSecondFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "ContactNo|CustName|Title|LinkManName|LinkReasonName|LinkModeName|LinkDate|LinkerName|Contents";
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("供应商联络", strBaseFields, null, aBase, null, dtProviderInfo, null, true);
}
#endregion
//#region 3.明细信息
//if (!string.IsNullOrEmpty(strDetailFields))
//{
// tableDetail.InnerHtml = WritePrintPageTable("物料需求计划", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
//}
//#endregion
///*第二明细*/
//#region 4.明细信息2
//if (!string.IsNullOrEmpty(strDetailSecondFields))
//{
// tableDetail2.InnerHtml = WritePrintPageTable("物料需求计划", strBaseFields, strDetailSecondFields, aBase, aSecondDetail, dtMRP, dtDetail, false);
//}
//#endregion
}
