public static string getSenderDiv(string poi_id)
{
string ddlHtml = string.Empty;
/*
* <select>
* <option value ="volvo">Volvo</option>
* <option value ="saab">Saab</option>
* <option value="opel">Opel</option>
* <option value="audi">Audi</option>
* </select>
*/
try
{
DataTable dtSenders = ManagerHelper.GetAllManagers();
ddlHtml += "<select id='ddlSender'>";
foreach (DataRow row in dtSenders.Rows)
{
ddlHtml += string.Format("<option value ='{0}'>{1}:{2}</option>", row["UserId"], row["UserName"], row["AgentName"]);
}
ddlHtml += "</select>";
ddlHtml += string.Format("<a href='javascript:void(0)' poi_id='{0}' id='btnBind'>确定</a>", poi_id);
return(ddlHtml);
}
catch
{
return("err");
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
this.LoadParameters();
if (!this.Page.IsPostBack)
{
//子账号的过滤查询
this.ddlSender.Visible = true;
ddlSender.Items.Add(new ListItem {
Text = "全部", Value = ""
});
DataTable dtmanagers = ManagerHelper.GetAllManagers();
ManagerInfo currentManager = ManagerHelper.GetCurrentManager();
RoleInfo roleinfo = ManagerHelper.GetRole(currentManager.RoleId);
foreach (DataRow row in dtmanagers.Rows)
{
ListItem item = new ListItem
{
Text = row["UserName"].ToString() + ":" + row["AgentName"].ToString(),
Value = row["UserId"].ToString()
};
if (roleinfo.RoleName != "超级管理员")
{
if (currentManager.UserId == row["UserId"].ToInt())
{
this.ddlSender.Items.Clear();
ddlSender.Items.Add(item);
this.sender = currentManager.UserId.ToString();
}
}
}
this.BindUserOrderStatistics();
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
ddlSenders.SelectedIndexChanged += new EventHandler(this.ddlSenders_SelectedIndexChanged);
this.btnExport.Click += new EventHandler(this.orderStatistics);
this.btnProductTotalExport.Click += new EventHandler(this.btnProductTotalExport_click);
this.btnSerch.Click += new EventHandler(this.btnSerch_click);
if (!this.Page.IsPostBack)
{
ManagerInfo currentManager = ManagerHelper.GetCurrentManager();
if (ManagerHelper.GetRole(currentManager.RoleId).RoleName == "超级管理员")
{
DataTable dtSenders = ManagerHelper.GetAllManagers();
foreach (DataRow row in dtSenders.Rows)
{
ListItem item = new ListItem
{
Text = row["UserName"].ToString() + "：" + row["agentName"].ToString(),
Value = row["UserId"].ToString(),
};
if (!string.IsNullOrEmpty(row["clientUserId"].ToString()) && row["clientUserId"].ToString() != "0")
{
ddlSenders.Items.Add(item);
}
}
ddlSenders.SelectedIndex = 0;
if (!string.IsNullOrEmpty(ddlSenders.SelectedValue))
{
loadTables("", "", Convert.ToInt32(ddlSenders.SelectedValue));
}
else
{
ddlSenders.Visible = false;
}
}
else
{
ddlSenders.Items.Clear();
ListItem item = new ListItem
{
Text = currentManager.UserName + "：" + currentManager.AgentName,
Value = currentManager.UserId.ToString(),
};
ddlSenders.Items.Add(item);
ddlSenders.SelectedIndex = 0;
ddlSenders.Visible = false;
loadTables("", "", currentManager.UserId);
}
}
}
private void LoadParameters()
{
this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
if (!this.Page.IsPostBack)
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["startTime"]))
{
this.startTime = new System.DateTime?(System.DateTime.Parse(this.Page.Request.QueryString["startTime"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["endTime"]))
{
this.endTime = new System.DateTime?(System.DateTime.Parse(this.Page.Request.QueryString["endTime"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["storeid"]))
{
this.storeid = int.Parse(this.Page.Request.QueryString["storeid"]);
}
this.calendarStart.SelectedDate = this.startTime;
this.calendarEnd.SelectedDate = this.endTime;
DataTable dtsender = ManagerHelper.GetAllManagers();
foreach (DataRow da in dtsender.Rows)
{
ListItem item = new ListItem()
{
Text = da["UserName"].ToString() + "：" + da["agentName"].ToString(),
Value = da["clientuserid"].ToString(),
};
if (!string.IsNullOrEmpty(da["clientUserId"].ToString()) && da["clientUserId"].ToString() != "0")
{
DDLservice.Items.Add(item);
}
}
DDLservice.SelectedValue = storeid.ToString();
}
else
{
this.startTime = this.calendarStart.SelectedDate;
this.endTime = this.calendarEnd.SelectedDate;
}
}
private void LoadParameters()
{
this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
if (!this.Page.IsPostBack)
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["startTime"]))
{
this.startTime = new System.DateTime?(System.DateTime.Parse(this.Page.Request.QueryString["startTime"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["storeid"]))
{
this.storeid = int.Parse(this.Page.Request.QueryString["storeid"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["categoryid"]))
{
this.categoryid = int.Parse(this.Page.Request.QueryString["categoryid"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["productid"]))
{
this.productid = int.Parse(this.Page.Request.QueryString["productid"]);
}
this.calendarStart.SelectedDate = this.startTime;
#region 门店下拉框
DataTable dtsender = ManagerHelper.GetAllManagers();
ListItem itemFirst = new ListItem()
{
Text = "全部",
Value = "0"
};
DDLservice.Items.Add(itemFirst);
foreach (DataRow da in dtsender.Rows)
{
ListItem item = new ListItem()
{
Text = da["UserName"].ToString() + "：" + da["agentName"].ToString(),
Value = da["userid"].ToString(),
};
if (!string.IsNullOrEmpty(da["clientUserId"].ToString()) && da["clientUserId"].ToString() != "0")
{
DDLservice.Items.Add(item);
}
}
DDLservice.SelectedIndex = 0;
DDLservice.SelectedValue = storeid.ToString();
#endregion
#region 分类下拉框
ListItem itemFirst1 = new ListItem()
{
Text = "全部",
Value = "0"
};
DDLcategories.Items.Add(itemFirst1);
IList <CategoryInfo> list = new List <CategoryInfo>();
list = CatalogHelper.GetMainCategories();
foreach (CategoryInfo info in list)
{
ListItem item = new ListItem();
item.Text = info.Name;
item.Value = info.CategoryId.ToString();
DDLcategories.Items.Add(item);
}
DDLcategories.SelectedIndex = 0;
DDLcategories.SelectedValue = categoryid.ToString();
#endregion
#region 商品下拉框
ListItem itemFirst2 = new ListItem()
{
Text = "全部",
Value = "0"
};
DDLproduct.Items.Add(itemFirst2);
DataTable product = ManagerHelper.GetHishop_Product();
foreach (DataRow row in product.Rows)
{
ListItem item = new ListItem()
{
Text = row["ProductName"].ToString(),
Value = row["ProductId"].ToString(),
};
DDLproduct.Items.Add(item);
}
DDLproduct.SelectedIndex = 0;
DDLproduct.SelectedValue = productid.ToString();
#endregion
}
else
{
this.startTime = this.calendarStart.SelectedDate;
}
}
