/// <summary>
/// 导出会员
/// </summary>
private void ExportMember()
{
string[] memberCodes = MemberStr.Split(',');
WebService.CRM.CRMCooperationInfo service = new WebService.CRM.CRMCooperationInfo();
DataTable dt = service.GetMemberCoorperation(memberCodes);
//导出数据
if (dt != null)
{
ExprotExcel(dt);
}
}
/// <summary>
/// Modify=2012-08-23 Masj 更改查询数据逻辑
/// </summary>
private void dataBind()
{
DataTable dt = new DataTable();
dt.Columns.Add("type", typeof(string));
dt.Columns.Add("name", typeof(string));
dt.Columns.Add("saletype", typeof(string));
dt.Columns.Add("period", typeof(string));
dt.Columns.Add("createtime", typeof(DateTime));
dt.Columns.Add("note", typeof(string));
WebService.CRM.CRMCooperationInfo service = new WebService.CRM.CRMCooperationInfo();
DataSet ds = service.GetCooperationByCustID(CustID);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt_edm = ds.Tables["edm"];
if (dt_edm != null)
{
for (int i = 0; i < dt_edm.Rows.Count; i++)
{
var iRow = dt_edm.Rows[i];
DataRow dr = dt.NewRow();
dr["type"] = "杂志直投";
dr["name"] = iRow["CooperationName"];
dr["saletype"] = "";
dr["period"] = iRow["ExecCycle"];
dr["createtime"] = iRow["CreateTime"];
dr["note"] = iRow["Remark"];
dt.Rows.Add(dr);
}
}
DataTable dt_order = ds.Tables["order"];
if (dt_order != null)
{
for (int i = 0; i < dt_order.Rows.Count; i++)
{
var iRow = dt_order.Rows[i];
DataRow dr = dt.NewRow();
dr["type"] = iRow["OrderTypeName"];
dr["name"] = iRow["MemberCode"] + "（" + iRow["AdDateCode"] + "）";
dr["saletype"] = iRow["UseStyle"];
dr["period"] = iRow["ExecPeriod"];
dr["createtime"] = iRow["CreateTime"];
dr["note"] = iRow["ProductName"];
dt.Rows.Add(dr);
}
}
}
DataTable dt_page = new DataTable();
dt_page = dt.Clone();
int showCount = PageSize * CurrentPage >= dt.Rows.Count ? dt.Rows.Count : PageSize * CurrentPage;
for (int k = PageSize * (CurrentPage - 1); k < showCount; k++)
{
dt_page.ImportRow(dt.Rows[k]);
}
repeater.DataSource = dt_page;
repeater.DataBind();
AjaxPagerCooperationProjects.PageSize = 5;
AjaxPagerCooperationProjects.InitPager(dt.Rows.Count);
}
