protected override void OnViewLoaded()
{
ExcuteTimer.Interval = TimeSpan.FromSeconds(Properties.Settings.Default.Internal);
ExcuteTimerCust.Interval = TimeSpan.FromSeconds(10);
ExcuteTimerCust.Tick += ExcuteTimerCust_Tick;
//初始化Provider
Provider.InitailProvider();
//原来是读取excel，由于受到补丁影响现在统一改成用.xml文件
string filePath = AppDomain.CurrentDomain.BaseDirectory + "\\" + "Protocol_Cloud.xml";
if (File.Exists(filePath))
{
DataSet ds = DealXML.XmlToDataTableByFile(filePath);
DtPack = ds.Tables["PackInfoNode"];
DtPackgroup = ds.Tables["GroupInfoNode"];
DtModeText = ds.Tables["ModeInfoNode"];
}
SetMasterVariable();
SetPackVariable();
base.OnViewLoaded();
Navigate("MasterItemsPage");
FuncUpdateStatus += o => CustSelectItem = o as CustInfoModel;
}
public void SocketEventHandler(object sender, EventArgs e)
{
SocketEvent evt = e as SocketEvent;
if (evt == null)
{
return;
}
switch (evt.eventType)
{
case SocketEventType.StartEvent:
break;
case SocketEventType.ConnectEvent:
break;
case SocketEventType.ReceEvent:
byte remark = evt.remark;
if (remark == CS_AskReply.ClientReplyGroup)
{
if (modelIndex == 2 || modelIndex == 4)
{
if (FuncDoAction != null)
{
System.Windows.Application.Current.Dispatcher.Invoke(FuncDoAction, evt.message, remark);
}
}
}
else if (remark == CS_AskReply.ClientReplyPackStatus)
{
if (modelIndex == 2 || modelIndex == 4)
{
if (FuncDoAction != null)
{
System.Windows.Application.Current.Dispatcher.Invoke(FuncDoAction, evt.message, remark);
}
}
}
else if (remark == CS_AskReply.ClientReplyGroupStatus)
{
if (modelIndex == 1)
{
if (FuncDoAction != null)
{
System.Windows.Application.Current.Dispatcher.Invoke(FuncDoAction, evt.message, remark);
}
}
}
else if (remark == CS_AskReply.ClientReplyPack)
{
if (modelIndex == 3 || modelIndex == 4)
{
if (FuncDoAction != null)
{
System.Windows.Application.Current.Dispatcher.Invoke(FuncDoAction, evt.message, remark);
}
}
}
else if (remark == CS_AskReply.ServerAsk)
{
BLLCommon.SendToServer(CS_AskReply.ServerReply, 0xffff, 0xff, 0xff, System.Text.Encoding.ASCII.GetBytes("0n"));
}
else if (remark == CS_AskReply.ClientReplyCust)
{
System.Windows.Application.Current.Dispatcher.Invoke(() =>
{
DataTable dtCust = evt.message as DataTable;
foreach (DataRow item in dtCust.Rows)
{
CustInfoModel CIM = null;
for (int i = 0; i < CustListSource.Count; i++)
{
if (CustListSource[i].CustId == Convert.ToInt32(item["cust_id"]))
{
CIM = CustListSource[i];
break;
}
}
if (CIM == null)
{
CustListSource.Add(new CustInfoModel(
Convert.ToInt32(item["cust_id"]),
Convert.ToInt32(item["group_num"]),
Convert.ToInt32(item["pack_num"]),
item["cust_name"].ToString(),
item["cust_status"].ToString(),
Convert.ToByte(item["cust_fault"])
));
}
else
{
CIM.CustId = Convert.ToInt32(item["cust_id"]);
CIM.GroupNum = Convert.ToInt32(item["group_num"]);
CIM.PackNum = Convert.ToInt32(item["pack_num"]);
CIM.CustName = item["cust_name"].ToString();
CIM.CustStatus = item["cust_status"].ToString();
CIM.CustFault = Convert.ToByte(item["cust_fault"]);
if (CIM.CustId == Properties.Settings.Default.DTUIndex)
{
//刷新当前状态栏数据
FuncUpdateStatus(CIM);
}
}
}
});
}
else
{
System.Windows.Application.Current.Dispatcher.Invoke(() =>
{
BLLCommon.CloseWaitWindow(true);
});
}
break;
case SocketEventType.SendEvent:
break;
case SocketEventType.DisconnectEvent:
if (socketClient != null)
{
socketClient.Stop();
if (FuncRefershOffLine != null)
{
FuncRefershOffLine(true);
}
socketClient = null;
ExcuteTimer.Stop();
ExcuteTimerCust.Stop();
}
break;
case SocketEventType.StopEvent:
break;
}
}
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 btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "CustNo"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
CustInfoModel CustInfoM = new CustInfoModel();
CustInfoM.CustNo = txtCustNo.Value.Trim();
CustInfoM.CustNam = txtCustNam.Value;
CustInfoM.CustClass = hiddCustClass.Value.Trim() == "" ? 0 : Convert.ToInt32(hiddCustClass.Value.Trim());
CustInfoM.CustName = txtCustName.Value.Trim();
CustInfoM.CustShort = txtCustShort.Value.Trim();
CustInfoM.AreaID = ddlArea.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlArea.SelectedItem.Value);
CustInfoM.CreditGrade = ddlCreditGrade.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlCreditGrade.SelectedItem.Value);
CustInfoM.RelaGrade = seleRelaGrade.Value;
CustInfoM.UsedStatus = seleUsedStatus.Value;
CustInfoM.Tel = txtTel.Value.Trim();
string Manager = txtManager.Value.Trim();
string CreatedBegin = txtCreatedBegin.Value.Trim();
string CreatedEnd = txtCreatedEnd.Value.Trim();
CustInfoM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();//当前用户ID
DataTable dt = CustInfoBus.ExportCustInfo(CustInfoM, Manager, CanUserID, CreatedBegin, CreatedEnd, ord);
//OutputToExecl.ExportToTableFormat(this, dt,
// new string[] { "客户编号", "客户名称", "客户大类", "拼音缩写", "客户细分", "客户类别", "所在区域", "分管业务员", "客户优质级别", "客户关系等级", "创建人", "创建日期", "启用状态" },
// new string[] { "CustNo", "CustName", "CustBigName", "CustShort", "CodeName", "TypeName", "Area", "Manager", "CreditGrade", "RelaGradeName", "Creator", "CreatedDate", "UsedStatusName" },
// "客户档案列表");
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "客户编号", "客户名称", "客户大类", "客户简称", "拼音缩写", "客户管理分类",
"客户营销分类", "客户优质级别", "客户时间分类", "客户细分", "客户类别", "建档人", "建档日期",
"客户简介", "国家地区", "区域", "省", "市(县)", "业务类型", "分管业务员", "联系人", "电话",
"手机", "传真", "在线咨询", "公司网址", "邮编", "电子邮件", "首次交易日期", "运送方式", "交货方式",
"联络期限(天)", "收货地址", "经营范围", "允许延期付款", "信用额度(元)", "帐期天数(天)", "结算方式",
"结算币种", "发票类型", "支付方式", "开户行", "户名", "账号", "单位性质", "资产规模(万元)",
"成立时间", "注册资本(万元)", "员工总数(个)", "法人代表", "行业", "营业执照号", "注册地址",
"税务登记号", "是否为一般纳税人", "客户来源", "年销售额(万元)", "年利润额(万元)", "销售模式",
"上级客户", "价值评估", "阶段", "热点客户", "热度", "关系等级", "启用状态", "关系描述", "备注",
"最后更新用户", "最后更新日期", "经营理念", "企业口号", "企业文化概述", "发展潜力", "存在问题",
"市场优劣势", "行业地位", "竞争对手", "合作伙伴", "发展计划", "合作方法", "可查看该客户档案的人员" },
new string[] { "CustNo", "CustName", "BigType", "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" },
"客户档案列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
public static DataTable GetCust_jhByCon(CustInfoModel CustInfoM, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(CustCallDBHelper.GetCust_jhByCon(CustInfoM, pageIndex, pageCount, ord, ref TotalCount));
}
/// <summary>
/// Cust树
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable GetCustTree(CustInfoModel model, string CanUserID)
{
return(CustCallDBHelper.GetCustTree(model, CanUserID));
}
public static DataTable GetCust_ldByCon(CustInfoModel CustInfoM, string DateBegin, string DateEnd, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(CustCallDBHelper.GetCust_ldByCon(CustInfoM, DateBegin, DateEnd, pageIndex, pageCount, ord, ref TotalCount));
}
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
}