protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CustNo = this.txtCustNo.Text;
string CustName = this.txtCustName.Text;
string CustNam = this.txtCustNam.Text;
string PYShort = this.txtPYShort.Text;
string CustType = this.drpCustType.Value;
if (CustType == "0")
{
CustType = "";
}
string CustClass = this.txtCustClass.Value;
string AreaID = this.drpAreaID.Value;
if (AreaID == "0")
{
AreaID = "";
}
string CreditGrade = this.drpCreditGrade.Value;
if (CreditGrade == "0")
{
CreditGrade = "";
}
string Manager = this.HidManager.Value;
string StartCreateDate = this.txtStartCreateDate.Text;
string EndCreateDate = this.txtEndCreateDate.Text;
int TotalCount = 0;
DataTable dt = ProviderInfoBus.SelectProviderInfo(1, 1000000, "ID", ref TotalCount, CustNo, CustName, CustNam, PYShort, CustType, CustClass, AreaID, CreditGrade, Manager, StartCreateDate, EndCreateDate);
//DataTable dt = WorkCenterBus.GetWorkCenterListBycondition(model, 1, 1000000, "ID desc", ref totalCount);
//导出标题
string headerTitle = "供应商编号|供应商名称|供应商简称|供应商拼音代码|供应商类别|供应商分类|所在区域|分管采购员|优质级别|建挡人|建挡日期";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "CustNo|CustName|CustNam|PYShort|CustTypeName|CustClassName|AreaName|ManagerName|CreditGradeName|CreatorName|CreateDate";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "供应商档案列表");
}
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_PROVIDERINFO;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase =
{
{ "供应商编号", "CustNo" },
{ "供应商类别", "CustTypeName" },
{ "供应商分类", "CustClassName" },
{ "供应商名称", "CustName" },
{ "供应商简称", "CustNam" },
{ "供应商拼音代码", "PYShort" },
{ "供应商简介", "CustNote" },
{ "国家地区", "CountryName" },
{ "省", "Province" },
{ "市", "City" },
{ "邮编", "Post" },
{ "联系人", "ContactName" },
{ "电话", "Tel" },
{ "传真", "Fax" },
{ "手机", "Mobile" },
{ "邮件", "email" },
{ "在线咨询", "OnLine" },
{ "公司网址", "WebSite" },
{ "交货方式", "TakeTypeName" },
{ "运送方式", "CarryTypeName" },
{ "供应商优先级别", "CreditGradeName" },
{ "热点供应商", "HotIsName" },
{ "启用状态", "UsedStatusName" },
{ "分管采购员", "ManagerName" },
{ "联络期限", "LinkCycle" },
{ "所在地区", "AreaName" },
{ "发货地址", "SendAddress" },
{ "经营范围", "SellArea" },
{ "结算方式", "PayTypeName" },
{ "币种", "CurrencyTypeName" },
{ "开户行", "OpenBank" },
{ "户名", "AccountMan" },
{ "帐号", "AccountNum" },
{ "成立时间", "SetupDate" },
{ "法人代表", "ArtiPerson" },
{ "一般纳税人", "IsTaxName" },
{ "税务登记号", "TaxCD" },
{ "营业执照号", "BusiNumber" },
{ "热度", "HotHowName" },
};
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtProviderInfo = ProviderInfoBus.SelectProviderInfo(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 = "CustNo|CustTypeName|CustClassName|CustName|CustNam|PYShort|CustNote|CountryName|Province|City|Post|ContactName|Tel|Fax|Mobile|email|OnLine|WebSite|TakeTypeName|CarryTypeName|CreditGradeName|HotIsName|UsedStatusName|ManagerName|LinkCycle|AreaName|SendAddress|SellArea|PayTypeName|CurrencyTypeName|OpenBank|AccountMan|AccountNum|SetupDate|ArtiPerson|IsTaxName|TaxCD|BusiNumber|HotHowName";
}
#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
}
