protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_CUSTOMER);
model.PrintTypeFlag = ConstUtil.PRINTBILL_CUSTINFOLINK;
CustInfoModel modelMRP = new CustInfoModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.CustNo = this.CustNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase =
{
{ "{ExtField1}", "ExtField1" },
{ "{ExtField2}", "ExtField2" },
{ "{ExtField3}", "ExtField3" },
{ "{ExtField4}", "ExtField4" },
{ "{ExtField5}", "ExtField5" },
{ "{ExtField6}", "ExtField6" },
{ "{ExtField7}", "ExtField7" },
{ "{ExtField8}", "ExtField8" },
{ "{ExtField9}", "ExtField9" },
{ "{ExtField10}", "ExtField10" },
{ "{ExtField11}", "ExtField11" },
{ "{ExtField12}", "ExtField12" },
{ "{ExtField13}", "ExtField13" },
{ "{ExtField14}", "ExtField14" },
{ "{ExtField15}", "ExtField15" },
{ "{ExtField16}", "ExtField16" },
{ "{ExtField17}", "ExtField17" },
{ "{ExtField18}", "ExtField18" },
{ "{ExtField19}", "ExtField19" },
{ "{ExtField20}", "ExtField20" },
{ "{ExtField21}", "ExtField21" },
{ "{ExtField22}", "ExtField22" },
{ "{ExtField23}", "ExtField23" },
{ "{ExtField24}", "ExtField24" },
{ "{ExtField25}", "ExtField25" },
{ "{ExtField26}", "ExtField26" },
{ "{ExtField27}", "ExtField27" },
{ "{ExtField28}", "ExtField28" },
{ "{ExtField29}", "ExtField29" },
{ "{ExtField30}", "ExtField30" },
{ "客户编号", "CustNo" },
{ "客户名称", "CustName" },
{ "客户大类", "BigType" },
{ "拼音缩写", "CustShort" },
{ "客户管理分类", "CustTypeManage" },
{ "客户营销分类", "CustTypeSell" },
{ "客户优质级别", "CreditGradeNm" },
{ "客户时间分类", "CustTypeTime" },
{ "客户细分", "CustClassName" },
{ "客户类别", "CustTypaNm" },
{ "建档人", "CreatorName" },
{ "建档日期", "CreatedDate" },
{ "客户简介", "CustNote" },
{ "国家地区", "CountryName" },
{ "区域", "AreaName" },
{ "业务类型", "BusiType" },
{ "分管业务员 ", "ManagerName" },
{ "联络期限(天)", "LinkCycleNm" },
{ "收货地址", "ReceiveAddress" },
{ "允许延期付款", "CreditManage" },
{ "帐期天数(天)", "MaxCreditDate" },
{ "结算方式", "PayTypeNm" },
{ "关系等级", "RelaGrade" },
{ "启用状态", "UsedStatus" },
{ "最后更新用户", "ModifiedUserID" },
{ "最后更新日期", "ModifiedDate" },
{ "可查看该客户档案的人员", "CanViewUserName" },
{ "卡号", "CustNum" },
{ "性别", "Sex" },
{ "联系人类型", "LinkTypeName" },
{ "身份证号", "PaperNum" },
{ "生日", "Birthday" },
{ "电话", "WorkTel" },
{ "手机", "Handset" },
{ "传真", "Fax" },
{ "职务", "Position" },
{ "年龄", "Age" },
{ "邮编", "Post" },
{ "Eamil", "MailAddress" },
{ "籍贯", "HomeTown" },
{ "民族", "NationalName" },
{ "所受教育", "CultureLevelName" },
{ "所学专业", "ProfessionalName" },
{ "年收入情况", "IncomeYear" },
{ "饮食偏好", "FuoodDrink" },
{ "喜欢的音乐", "LoveMusic" },
{ "喜欢的颜色", "LoveColor" },
{ "喜欢的香烟", "LoveSmoke" },
{ "爱喝的酒", "LoveDrink" },
{ "爱喝的茶", "LoveTea" },
{ "喜欢的书籍", "LoveBook" },
{ "喜欢的运动", "LoveSport" },
{ "喜欢的品牌服饰", "LoveClothes" },
{ "喜欢的品牌化妆品", "Cosmetic" },
{ "性格描述", "Nature" },
{ "外表描述", "Appearance" },
{ "健康状况", "AdoutBody" },
{ "家人情况", "AboutFamily" },
{ "开什么车", "Car" },
};
string[,] aDetail = { { "", "" } };
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.CustInfo");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 59; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
//DataTable dtMRP = SellContractBus.GetRepOrder(OfferNo);
DataTable dtMRP = CustInfoBus.GetCustInfoByNo(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, CustBig, CustNo);
string strBaseFields = "";
string strDetailFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "CustNo|CustName|BigType|CustShort|CustTypeManage|CustTypeSell|CreditGradeNm|CustTypeTime|CustClassName|CustTypaNm|CreatorName|" +
"CreatedDate|CustNote|CountryName|AreaName|BusiType|ManagerName|LinkCycleNm|ReceiveAddress|CreditManage|MaxCreditDate|PayTypeNm|RelaGrade|" +
"UsedStatus|ModifiedUserID|ModifiedDate|CanViewUserName|CustNum|Sex|LinkTypeName|PaperNum|Birthday|WorkTel|Handset|Fax|Position|Age|Post|" +
"MailAddress|HomeTown|NationalName|CultureLevelName|ProfessionalName|IncomeYear|FuoodDrink|LoveMusic|LoveColor|LoveSmoke|LoveDrink|LoveTea|" +
"LoveBook|LoveSport|LoveClothes|Cosmetic|Nature|Appearance|AdoutBody|AboutFamily|Car";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
strDetailFields = "";
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("客户档案", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, null, true);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_CUSTOMER);
model.PrintTypeFlag = ConstUtil.PRINTBILL_CUSTINFO;
CustInfoModel modelMRP = new CustInfoModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.CustNo = this.CustNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase =
{
{ "{ExtField1}", "ExtField1" },
{ "{ExtField2}", "ExtField2" },
{ "{ExtField3}", "ExtField3" },
{ "{ExtField4}", "ExtField4" },
{ "{ExtField5}", "ExtField5" },
{ "{ExtField6}", "ExtField6" },
{ "{ExtField7}", "ExtField7" },
{ "{ExtField8}", "ExtField8" },
{ "{ExtField9}", "ExtField9" },
{ "{ExtField10}", "ExtField10" },
{ "{ExtField11}", "ExtField11" },
{ "{ExtField12}", "ExtField12" },
{ "{ExtField13}", "ExtField13" },
{ "{ExtField14}", "ExtField14" },
{ "{ExtField15}", "ExtField15" },
{ "{ExtField16}", "ExtField16" },
{ "{ExtField17}", "ExtField17" },
{ "{ExtField18}", "ExtField18" },
{ "{ExtField19}", "ExtField19" },
{ "{ExtField20}", "ExtField20" },
{ "{ExtField21}", "ExtField21" },
{ "{ExtField22}", "ExtField22" },
{ "{ExtField23}", "ExtField23" },
{ "{ExtField24}", "ExtField24" },
{ "{ExtField25}", "ExtField25" },
{ "{ExtField26}", "ExtField26" },
{ "{ExtField27}", "ExtField27" },
{ "{ExtField28}", "ExtField28" },
{ "{ExtField29}", "ExtField29" },
{ "{ExtField30}", "ExtField30" },
{ "客户编号", "CustNo" },
{ "客户名称", "CustName" },
{ "客户大类", "CustBig" },
{ "客户简称", "CustNam" },
{ "拼音缩写", "CustShort" },
{ "客户管理分类", "CustTypeManage" },
{ "客户营销分类", "CustTypeSell" },
{ "客户优质级别", "CreditGradeNm" },
{ "客户时间分类", "CustTypeTime" },
{ "客户细分", "CustClassName" },
{ "客户类别", "CustTypaNm" },
{ "建档人", "CreatorName" },
{ "建档日期", "CreatedDate" },
{ "客户简介", "CustNote" },
{ "国家地区", "CountryName" },
{ "区域", "AreaName" },
{ "省", "Province" },
{ "市(县)", "City" },
{ "业务类型", "BusiType" },
{ "分管业务员 ", "ManagerName" },
{ "联系人", "ContactName" },
{ "电话", "Tel" },
{ "手机", "Mobile" },
{ "传真", "Fax" },
{ "在线咨询", "OnLine" },
{ "公司网址 ", "WebSite" },
{ "邮编", "Post" },
{ "电子邮件", "email" },
{ "首次交易日期", "FirstBuyDate" },
{ "运送方式", "CarryTypeNm" },
{ "交货方式", "TakeTypeNm" },
{ "联络期限(天)", "LinkCycleNm" },
{ "收货地址", "ReceiveAddress" },
{ "经营范围", "SellArea" },
{ "允许延期付款", "CreditManage" },
{ "信用额度(元)", "MaxCredit" },
{ "帐期天数(天)", "MaxCreditDate" },
{ "结算方式", "PayTypeNm" },
{ "结算币种", "CurrencyaNm" },
{ "发票类型", "BillTypeNm" },
{ "支付方式", "MoneyTypeNm" },
{ "开户行", "OpenBank" },
{ "户名", "AccountMan" },
{ "账号", "AccountNum" },
{ "单位性质", "CompanyType" },
{ "资产规模(万元)", "CapitalScale" },
{ "成立时间", "SetupDate" },
{ "注册资本(万元)", "SetupMoney" },
{ "员工总数(个)", "StaffCount" },
{ "法人代表", "ArtiPerson" },
{ "行业", "Trade" },
{ "营业执照号", "BusiNumber" },
{ "注册地址", "SetupAddress" },
{ "税务登记号", "TaxCD" },
{ "是否为一般纳税人", "IsTax" },
{ "客户来源", "Source" },
{ "年销售额(万元)", "SaleroomY" },
{ "年利润额(万元)", "ProfitY" },
{ "销售模式", "SellMode" },
{ "上级客户", "CustSupe" },
{ "价值评估", "MeritGrade" },
{ "阶段", "Phase" },
{ "热点客户", "HotIs" },
{ "热度", "HotHow" },
{ "关系等级", "RelaGrade" },
{ "启用状态", "UsedStatus" },
{ "关系描述", "Relation" },
{ "备注", "Remark" },
{ "最后更新用户", "ModifiedUserID" },
{ "最后更新日期", "ModifiedDate" },
{ "经营理念", "CompanyValues" },
{ "企业口号", "CatchWord" },
{ "企业文化概述", "ManageValues" },
{ "发展潜力", "Potential" },
{ "存在问题", "Problem" },
{ "市场优劣势", "Advantages" },
{ "行业地位", "TradePosition" },
{ "竞争对手", "Competition" },
{ "合作伙伴", "Collaborator" },
{ "发展计划", "ManagePlan" },
{ "合作方法", "Collaborate" },
{ "可查看该客户档案的人员", "CanViewUserName" },
};
string[,] aDetail = { { "", "" } };
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.CustInfo");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 82; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
//DataTable dtMRP = SellContractBus.GetRepOrder(OfferNo);
DataTable dtMRP = CustInfoBus.GetCustInfoByNo(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, CustBig, CustNo);
string strBaseFields = "";
string strDetailFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "CustNo|CustName|CustBig|CustNam|CustShort|CustTypeManage|CustTypeSell|CreditGradeNm|CustTypeTime|CustClassName|CustTypaNm|CreatorName|" +
"CreatedDate|CustNote|CountryName|AreaName|Province|City|BusiType|ManagerName|ContactName|Tel|Mobile|Fax|OnLine|WebSite|Post|email|FirstBuyDate|" +
"CarryTypeNm|TakeTypeNm|LinkCycleNm|ReceiveAddress|SellArea|CreditManage|MaxCredit|MaxCreditDate|PayTypeNm|CurrencyaNm|BillTypeNm|MoneyTypeNm|" +
"OpenBank|AccountMan|AccountNum|CompanyType|CapitalScale|SetupDate|SetupMoney|StaffCount|ArtiPerson|Trade|BusiNumber|SetupAddress|TaxCD|IsTax|" +
"Source|SaleroomY|ProfitY|SellMode|CustSupe|MeritGrade|Phase|HotIs|HotHow|RelaGrade|UsedStatus|Relation|Remark|ModifiedUserID|ModifiedDate|" +
"CompanyValues|CatchWord|ManageValues|Potential|Problem|Advantages|TradePosition|Competition|Collaborator|ManagePlan|Collaborate|CanViewUserName";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
strDetailFields = "";
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("客户档案", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, null, true);
}
#endregion
}
