protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ChangeHope.DataBase.DataByPage dataPage = commentBll.GetList();
table.AddHeadCol("", "<input id=\"chall\" type=\"checkbox\" onclick=\"SelectAll(chall)\" />全选");
table.AddHeadCol("","评论对象");
table.AddHeadCol("","评论标题");
table.AddHeadCol("","评论时间");
table.AddHeadCol("","操作");
table.AddRow();
if(dataPage.DataReader!=null)
{
while(dataPage.DataReader.Read())
{
table.AddCol("<input id=\"cbTm\" type=\"checkbox\" value=" + dataPage.DataReader["id"] + " />");
table.AddCol(GetProductNameById(Convert.ToInt32(dataPage.DataReader["commentid"]),Convert.ToInt32(dataPage.DataReader["type"])));
table.AddCol(dataPage.DataReader["title"].ToString());
table.AddCol(dataPage.DataReader["commenttime"].ToString());
table.AddCol("<a href=\"product_comment_revert.aspx?w_d_commentid=" + dataPage.DataReader["id"].ToString() + "\">回复</a> <a href=\"#\" onclick='Del(" + dataPage.DataReader["id"] + ")'>删除</a> <a href=\"product_comment_see.aspx?commentId=" + dataPage.DataReader["id"].ToString() + "\">查看</a>");
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
protected void BindInfo(string RoleId)
{
SOSOshop.BLL.Administrators bll = new SOSOshop.BLL.Administrators();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ChangeHope.DataBase.DataByPage dataPage = bll.GetListDB(" and State=0 ");
//添加表的内容
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
bool WhetherIN = false;
String[] gly = dataPage.DataReader["role"].ToString().Split(',');
for (int i = 0; i < gly.Length; i++)
{
if (gly[i].ToString() == RoleId)
{
lbOption2.Items.Add(new ListItem(dataPage.DataReader["name"].ToString(), dataPage.DataReader["adminid"].ToString()));
WhetherIN = true;
break;
}
}
if (!WhetherIN)
{
lbOption.Items.Add(new ListItem(dataPage.DataReader["name"].ToString(), dataPage.DataReader["adminid"].ToString()));
}
}
}
}
private void Getlist()
{
var id = ViewState["id"].ToString();
var data = GetListByWhere(id, 0, 20);
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
// ShowShop.BLL.Product.ProductInfo data = new ShowShop.BLL.Product.ProductInfo();
ChangeHope.DataBase.DataByPage dataPage = data;
//第一步先添加表头
table.AddHeadCol("30%", "ID");
table.AddHeadCol("30%", "属性值");
table.AddHeadCol("40%", "编辑");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
table.AddCol("<span>" + dataPage.DataReader["PropertyValueID"] + "</span>");
table.AddCol("<span>" + dataPage.DataReader["PropertyValueName"] + "</span>");
table.AddCol("<a onclick='return confirm(\"是否删除\");' href='Product_PropertyValue.aspx?del=" + dataPage.DataReader["PropertyValueID"] + "&id=" + ViewState["id"] + "&name=" + ViewState["name"] + "'>删除</a>");
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
this.Literal1.Text = view;
}
protected void GetList()
{
ShowShop.BLL.Accessories.CommentReply rebll = new ShowShop.BLL.Accessories.CommentReply();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ChangeHope.DataBase.DataByPage dataPage = rebll.GetList();
table.AddHeadCol("", "回复内容");
table.AddHeadCol("", "回复时间");
table.AddHeadCol("", "操作");
table.AddRow();
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
table.AddCol(dataPage.DataReader["content"].ToString());
table.AddCol(dataPage.DataReader["replytime"].ToString());
table.AddCol("<a href=\"#\" onclick='Del(" + dataPage.DataReader["rid"] + ")'>删除</a>");
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
this.lblList.Text = view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected void GetList(string name)
{
var data = GetListByWhere(name, 0, 20);
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
// ShowShop.BLL.Product.ProductInfo data = new ShowShop.BLL.Product.ProductInfo();
ChangeHope.DataBase.DataByPage dataPage = data;
//第一步先添加表头
table.AddHeadCol("30%", "ID");
table.AddHeadCol("30%", "属性名");
table.AddHeadCol("40%", "编辑");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
table.AddCol("<span>" + dataPage.DataReader["PropertyID"] + "</span>");
table.AddCol("<span>" + dataPage.DataReader["PropertyName"] + "</span>");
table.AddCol(string.Format("<a onclick='return confirm(\"是否删除\");' href='Product_Property.aspx?del={0}'>删除</a> <a href=Product_PropertyValue.aspx?id={0}&name={1}>添加属性值</a>", dataPage.DataReader["PropertyID"].ToString(), dataPage.DataReader["PropertyName"]));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
this.Literal1.Text = view;
}
protected void BindInfo(string RoleId)
{
ShowShop.BLL.Admin.Administrators bll = new ShowShop.BLL.Admin.Administrators();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ChangeHope.DataBase.DataByPage dataPage = bll.GetListDB();
//添加表的内容
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
bool WhetherIN = false;
String[] gly = dataPage.DataReader["role"].ToString().Split(',');
for (int i = 0; i < gly.Length; i++)
{
if (gly[i].ToString() == RoleId)
{
lbOption2.Items.Add(new ListItem(dataPage.DataReader["name"].ToString(), dataPage.DataReader["adminid"].ToString()));
WhetherIN = true;
break;
}
}
if (!WhetherIN)
{
lbOption.Items.Add(new ListItem(dataPage.DataReader["name"].ToString(), dataPage.DataReader["adminid"].ToString()));
}
}
}
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList(string strWhere)
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.UserinAndExp bll = new ShowShop.BLL.Member.UserinAndExp();
ChangeHope.DataBase.DataByPage dataPage = bll.GetList(strWhere);
//第一步先添加表头
table.AddHeadCol("", "序号");
table.AddHeadCol("", "到款时间");
table.AddHeadCol("", "会员账号");
table.AddHeadCol("", "交易方式");
table.AddHeadCol("", "收入金额");
table.AddHeadCol("", "支出金额");
table.AddHeadCol("", "银行名称");
table.AddHeadCol("", "备注/说明");
table.AddHeadCol("", "是否确认");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
string option = string.Empty;
if (dataPage.DataReader["state"].ToString() == "0")
{
option = string.Format("<a href=userinandexp_view_single.aspx?id={0}>查看</a>", dataPage.DataReader["id"].ToString());
}
else
{
option = string.Format("<a href=userinandexp_view_single.aspx?id={0}>查看</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a> <a href='javascript:void(0)' onclick='SetState({0})'>确认</a>", dataPage.DataReader["id"].ToString());
}
table.AddCol(No);
table.AddCol(Convert.ToDateTime(dataPage.DataReader["adsummoneydate"].ToString()).ToShortDateString());
table.AddCol(dataPage.DataReader["userid"].ToString());
table.AddCol(GetRemitMode(dataPage.DataReader["remitmode"].ToString()));
table.AddCol(dataPage.DataReader["incomeandexpstate"].ToString() == "0" ? dataPage.DataReader["adsummoney"].ToString() : string.Empty);
table.AddCol(dataPage.DataReader["incomeandexpstate"].ToString() == "1" ? dataPage.DataReader["adsummoney"].ToString() : string.Empty);
table.AddCol(dataPage.DataReader["remitbank"].ToString());
table.AddCol(dataPage.DataReader["remark"].ToString());
table.AddCol(dataPage.DataReader["state"].ToString() == "0" ? "确认" : "未确认");
table.AddCol(option);
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
// 得到所有记录
string strWhere = "1=1";
if (q.Text.Trim() != string.Empty)
{
strWhere += " and isnull(Keyword,'') + isnull(EventDescription,'') like '%" + q.Text.Trim().Replace("'", "") + "%' ";
}
if (t.Text.Trim() != string.Empty)
{
strWhere += " and convert(char(10),OperateTime,120)='" + t.Text.Trim().Replace("'", "") + "' ";
}
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_SysLog [where] " + strWhere + " [order by] id desc";
dataPage.GetRecordSetByPage();
//第一步先添加表头
table.AddHeadCol("5", "<input type=\"checkbox\" id=\"chkAll\" onclick=\"CheckAll(this.form)\" alt=\"全选/取消\" title=\"全选/取消\" />");
table.AddHeadCol("70", "关键词");
table.AddHeadCol("120", "系统模块");
table.AddHeadCol("", "事件描述");
table.AddHeadCol("45", "用户ID");
table.AddHeadCol("", "来源");
table.AddHeadCol("115", "时间");
//table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
while (dataPage.DataReader.Read())
{
table.AddCol("<input ID=\"cBox\" type=\"checkbox\" name=\"chk\" value=\"" + dataPage.DataReader["ID"].ToString() + "\" />");
table.AddCol(dataPage.DataReader["Keyword"].ToString());
table.AddCol(dataPage.DataReader["SubModule"].ToString());
table.AddCol(dataPage.DataReader["EventDescription"].ToString());
string UID = dataPage.DataReader["UID"].ToString();
string AdminID = dataPage.DataReader["AdminID"].ToString();
table.AddCol(string.IsNullOrEmpty(UID) ? (string.IsNullOrEmpty(AdminID) ? "" : "" + new SOSOshop.BLL.Db().ExecuteScalar("select name from yxs_administrators where adminid=" + AdminID)) : "" + new SOSOshop.BLL.Db().ExecuteScalar("select isnull(TrueName,IncName) from yxs_memberinfo where UID=" + UID));
table.AddCol(dataPage.DataReader["Source"].ToString());
table.AddCol(dataPage.DataReader["OperateTime"].ToString());
//table.AddCol("");
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return(view);
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.OrderCard.OrderCardInfo data = new ShowShop.BLL.OrderCard.OrderCardInfo();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("4%", "序号");
table.AddHeadCol("11%", "类型");
table.AddHeadCol("15%", "卡号");
table.AddHeadCol("5%", "面值");
table.AddHeadCol("5%", "点数");
table.AddHeadCol("14%", "所属商品");
table.AddHeadCol("8%", "状态");
table.AddHeadCol("10%", "截止日期");
table.AddHeadCol("9%", "使用会员");
table.AddHeadCol("10%", "获取时间");
table.AddHeadCol("15%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["type"].ToString() == "1" ? "本商城充值卡" : "其它公司充值卡");
table.AddCol(dataPage.DataReader["cardnumber"].ToString());
table.AddCol(dataPage.DataReader["facevalue"].ToString());
table.AddCol(dataPage.DataReader["point"].ToString() + dataPage.DataReader["unit"].ToString());
table.AddCol(dataPage.DataReader["iswebsitersale"].ToString() == "1" ? ProductName(dataPage.DataReader["productid"].ToString()) : "不通过商城出售");
table.AddCol(Convert.ToDateTime(dataPage.DataReader["expirationdate"].ToString()) < System.DateTime.Now ? "已失效" : this.State(dataPage.DataReader["whetherRelease"].ToString(), dataPage.DataReader["productid"].ToString()));
table.AddCol(Convert.ToDateTime(dataPage.DataReader["expirationdate"].ToString()).ToString("yyyy-MM-dd"));
table.AddCol(dataPage.DataReader["username"].ToString());
table.AddCol(Convert.ToDateTime(dataPage.DataReader["fullmoneydate"].ToString()) != Convert.ToDateTime("1753-01-01") ? Convert.ToDateTime(dataPage.DataReader["fullmoneydate"].ToString()).ToString("yyyy-MM-dd") : "");
table.AddCol(string.Format("<a href=ordercard_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.SystemInfo.Navigation data = new ShowShop.BLL.SystemInfo.Navigation();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("5%", "序号");
table.AddHeadCol("12%", "系统内容");
table.AddHeadCol("16%", "导航名称");
table.AddHeadCol("18%", "链接");
table.AddHeadCol("8%", "导航类型");
table.AddHeadCol("4%", "排序");
table.AddHeadCol("8%", "是否显示");
table.AddHeadCol("10%", "是否新窗口");
table.AddHeadCol("6%", "位置");
table.AddHeadCol("15%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
ShowShop.BLL.SystemInfo.ArticleChannel bllarticle = new ShowShop.BLL.SystemInfo.ArticleChannel();
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
//table.AddCol(bllarticle.GetArticleName(dataPage.DataReader["contentregion"].ToString()));
table.AddCol(dataPage.DataReader["contentregion"].ToString());
table.AddCol(dataPage.DataReader["filed"].ToString());
table.AddCol(dataPage.DataReader["link"].ToString());
table.AddCol(Type(dataPage.DataReader["type"].ToString()));
table.AddCol(string.Format("<input id='sort{0}' value='{1}' size='3' width='40px' onblur='Sort({0},{1})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sort"].ToString()));
table.AddCol(string.Format("<img src='../images/{0}.gif'/>", dataPage.DataReader["isshow"].ToString()));
table.AddCol(string.Format("<img src='../images/{0}.gif'/>", dataPage.DataReader["isnewwindow"].ToString()));
table.AddCol(Part(dataPage.DataReader["part"].ToString()));
table.AddCol(string.Format("<a href=navigation_customize.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// Table绑定 点卷与日期
/// </summary>
/// <param name="id">用户ID</param>
/// <param name="type">操作明细类型</param>
/// <returns></returns>
public string GetList(int id,int type)
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.UserInfoNote noteBll = new ShowShop.BLL.Member.UserInfoNote();
ChangeHope.DataBase.DataByPage dataPage = noteBll.GetListByIdAndType(id,type);
switch (type)
{
case 0:
table.AddHeadCol("", "交易时间");
table.AddHeadCol("", "增加点卷数");
table.AddHeadCol("", "减少点卷数");
table.AddHeadCol("", "操作人员");
table.AddHeadCol("", "备注/原因");
table.AddRow();
break;
case 1:
break;
case 2:
table.AddHeadCol("", "时间");
table.AddHeadCol("", "添加日期");
table.AddHeadCol("", "减少日期");
table.AddHeadCol("", "操作人员");
table.AddHeadCol("", "备注/原因");
table.AddRow();
break;
default:
break;
}
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
table.AddCol(dataPage.DataReader["noteDate"].ToString());
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString() == "0" ? dataPage.DataReader["ticketCount"].ToString() : "");
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString() == "1" ? dataPage.DataReader["ticketCount"].ToString() : "");
table.AddCol(dataPage.DataReader["noteName"].ToString());
table.AddCol(dataPage.DataReader["causation"].ToString());
table.AddRow();
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
else
{
return "没有找到相关的信息";
}
}
///// <summary>
///// 列表
///// </summary>
///// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.SystemInfo.Deliver bll = new ShowShop.BLL.SystemInfo.Deliver();
ChangeHope.DataBase.DataByPage dataPage=null;
dataPage = bll.GetList();
//第一步先添加表头
table.AddHeadCol("5%", "序号");
table.AddHeadCol("15%", "名称");
table.AddHeadCol("", "描述");
table.AddHeadCol("10%", "保价费用");
table.AddHeadCol("15%", "货到付款(是/否)");
table.AddHeadCol("", "作者");
table.AddHeadCol("", "版本");
table.AddHeadCol("14%", "是否已安装");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["DistributionName"].ToString());
table.AddCol("<span style='line-height:20px'>" + dataPage.DataReader["DistributionDescription"].ToString()+"</span>");
table.AddCol(dataPage.DataReader["InsuredCosts"].ToString()=="0"?"无":string.Format("<input id='txtInsuredCosts{0}' value='{1}' size='2' onblur='SetInsuredCosts({0})'/> <span style='font-size:large'>%</font>", dataPage.DataReader["Id"].ToString(), dataPage.DataReader["InsuredCosts"].ToString()));
table.AddCol(string.Format("<img src='../images/{0}.gif' style=\"cursor:pointer;\" onclick='SetIsUser({1})' alt='点击改变状态'/>", dataPage.DataReader["IsCOD"].ToString(), dataPage.DataReader["Id"].ToString()));
table.AddCol(dataPage.DataReader["Author"].ToString());
table.AddCol(dataPage.DataReader["Version"].ToString());
table.AddCol(dataPage.DataReader["IsInstallation"].ToString() == "0" ? string.Format("<a href='javascript:void(0)' onclick='Del({0})'>点击安装</a>", dataPage.DataReader["Id"].ToString()) : string.Format("<a href='javascript:void(0)' onclick='Del({0})'>卸载</a> <a href=area_list.aspx?delivermode={0}>设置区域</a>", dataPage.DataReader["Id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
public string GetList()
{
ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter();
ChangeHope.WebPage.Table table= new ChangeHope.WebPage.Table();
ShowShop.BLL.SystemInfo.TerraceManage tmDate = new ShowShop.BLL.SystemInfo.TerraceManage();
ChangeHope.DataBase.DataByPage datePage = tmDate.GetAllList();
//添加头
table.AddHeadCol("8%", "<input id=\"chall\" type=\"checkbox\" onclick=\"SelectAll(chall)\" />全选");
table.AddHeadCol("6%", "排序");
table.AddHeadCol("15%", "平台名称");
table.AddHeadCol("10%", "支付平台");
table.AddHeadCol("8%", "发布类型");
table.AddHeadCol("7%", "发布人");
table.AddHeadCol("", "商户ID");
table.AddHeadCol("8%", "手续费率");
table.AddHeadCol("16%", "常规操作");
table.AddRow();
//添加内容
if(datePage.DataReader != null){
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while(datePage.DataReader.Read()){
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol("<input id=\"cbTm\" type=\"checkbox\" value=" + datePage.DataReader["payment_id"] + " />");
// table.AddCol(datePage.DataReader["payment_taxis"].ToString());
table.AddCol(No);
table.AddCol(datePage.DataReader["payment_name"].ToString());
table.AddCol(PaymentByID(Convert.ToInt32(datePage.DataReader["payment_garden"])));
table.AddCol(datePage.DataReader["payment_putouttypeid"].ToString()=="0"?"管理员":"会员");
//这里需要会员信息
table.AddCol(IsInsiderOrAdmin(Convert.ToInt32(datePage.DataReader["payment_putoutid"]),datePage.DataReader["payment_putouttypeid"].ToString()=="0"?true:false));
table.AddCol(datePage.DataReader["payment_seller"].ToString());
table.AddCol(datePage.DataReader["payment_expenses"].ToString()+"");
table.AddCol("<a href='paymentmanage_edit.aspx?Payment_ID=" + datePage.DataReader["payment_id"] + "'>编辑</a> <a href=\"#\" onclick='Del(" + datePage.DataReader["payment_id"] + ")'> 删除</a> " + PaymentById(Convert.ToInt32(datePage.DataReader["payment_garden"])));
table.AddRow();
}
}
string view = table.GetTable() + datePage.PageToolBar;
datePage.Dispose();
datePage = null;
return view;
}
protected void GetMemberRankList(string ShopPrice, string MemberPrice)
{
if (ShopPrice == "")
{
ShopPrice = "0.00";
}
string[] strMemberPrice = MemberPrice.Split('|');
ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.MemberRank data = new ShowShop.BLL.Member.MemberRank();
List<ShowShop.Model.Member.MemberRank> list = data.GetAllMemberRank();
//第一步先添加表头
table.AddHeadCol("30%", "会员等级");
table.AddHeadCol("40%", "价格");
table.AddHeadCol("30%", "默认");
table.AddRow();
//添加表的内容
if (list.Count > 0)
{
int col = 0;
foreach (ShowShop.Model.Member.MemberRank va in list)
{
col++;
table.AddCol("<input type='hidden' id='rankId" + col + "' name ='rankId" + col + "' value='" + va.Id + "'/>" + va.Name);
if(MemberPrice!=""&&MemberPrice!=string.Empty)
{
foreach (string mp in strMemberPrice)
{
string[] memberPr = mp.Split(',');
if (memberPr[0].ToString()==va.Id.ToString())
{
table.AddCol("<input type='text' name='rankName" + col + "' id='rankName" + col + "' value='" + memberPr [1]+ "'/>");
}
}
}
else
{
table.AddCol("<input type='text' name='rankName" + col + "' id='rankName" + col + "'/>");
}
table.AddCol(((Convert.ToDouble(ShopPrice) * Convert.ToDouble(va.Discount)) / 100).ToString("f2"));
table.AddRow();
}
this.hfMemberPrice.Value = col.ToString();
}
string view = table.GetTable();
this.Literal1.Text = view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList(string strWhere)
{
// noteType =0
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.UserInfoNote bll = new ShowShop.BLL.Member.UserInfoNote();
ChangeHope.DataBase.DataByPage dataPage = bll.GetListByWhere(strWhere);
//第一步先添加表头
table.AddHeadCol("", "序号");
table.AddHeadCol("", "用户账号");
table.AddHeadCol("", "录入时间");
table.AddHeadCol("", "增加点卷");
table.AddHeadCol("", "减少点卷");
table.AddHeadCol("", "操作员");
table.AddHeadCol("", "备注/说明");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(GetUserID(Convert.ToInt32(dataPage.DataReader["userId"].ToString())));
table.AddCol(dataPage.DataReader["noteDate"].ToString());
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString() == "0" ? dataPage.DataReader["ticketCount"].ToString() : string.Empty);
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString() == "1" ? dataPage.DataReader["ticketCount"].ToString() : string.Empty);
table.AddCol(dataPage.DataReader["noteName"].ToString());
table.AddCol(dataPage.DataReader["causation"].ToString());
table.AddCol(string.Format("<a href=coupons_record_view.aspx?id={0}>查看</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.MemberPropety data = new ShowShop.BLL.Member.MemberPropety();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("5%", "序号");
table.AddHeadCol("15%", "属性名称");
table.AddHeadCol("25%", "所属值");
table.AddHeadCol("10%", "所属类型");
table.AddHeadCol("5%", "排序");
table.AddHeadCol("10%", "是否必填");
table.AddHeadCol("10%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["filed"].ToString());
//table.AddCol(ProductClassName(dataPage.DataReader["cid"].ToString()));
table.AddCol(dataPage.DataReader["datavalue"].ToString());
table.AddCol(Type(dataPage.DataReader["type"].ToString()));
table.AddCol(string.Format("<input id='sort{0}' value='{1}' size='3' onblur='Sort({0},{1})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sort"].ToString()));
table.AddCol(string.Format("<img src='../images/{0}.gif'/>", dataPage.DataReader["isrequire"].ToString()));
table.AddCol(string.Format("<a href=member_custom_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Product.Deliver bll = new ShowShop.BLL.Product.Deliver();
ChangeHope.DataBase.DataByPage dataPage = bll.GetList();
//第一步先添加表头
table.AddHeadCol("", "序号");
table.AddHeadCol("", "名称");
table.AddHeadCol("", "是否使用");
table.AddHeadCol("", "优先级");
table.AddHeadCol("", "起点价格(元/千克)");
table.AddHeadCol("", "起点重量(单位:千克)");
table.AddHeadCol("", "会员类型");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["name"].ToString());
table.AddCol(string.Format("<img src='../images/{0}.gif' style=\"cursor:pointer;\" onclick='SetIsUser({1})' alt='点击改变状态'/>", dataPage.DataReader["isused"].ToString(), dataPage.DataReader["id"].ToString()));
table.AddCol(string.Format("<input id='txtSort{0}' value='{1}' size='5' onblur='SetSort({0})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sort"].ToString()));
table.AddCol(dataPage.DataReader["inceptprice"].ToString());
table.AddCol(dataPage.DataReader["inceptweight"].ToString());
table.AddCol(dataPage.DataReader["putouttyid"].ToString()=="1"?"普通会员":"管理员");
table.AddCol(string.Format("<a href=deliver_edite.aspx?id={0}>编辑</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Accessories.Outofstock bll = new ShowShop.BLL.Accessories.Outofstock();
ChangeHope.DataBase.DataByPage dataPage = bll.GetList();
//第一步先添加表头
table.AddHeadCol("", "<input type=\"checkbox\" id=\"chkAll\" onclick=\"CheckAll(this.form)\" alt=\"全选/取消\" />选择");
table.AddHeadCol("", "缺货信息");
table.AddHeadCol("", "联系信息");
table.AddHeadCol("", "备注信息");
table.AddHeadCol("", "联系人");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol("<input ID=\"cBox\" type=\"checkbox\" value=\"" + dataPage.DataReader["id"].ToString() + "\" />");
table.AddCol(dataPage.DataReader["proclassandname"].ToString());
table.AddCol("<textarea rows=\"6\" cols=\"8\" style=\"width:200px;\">" +
ContactInfo(dataPage.DataReader["telphone"].ToString(),
dataPage.DataReader["mobile"].ToString(), dataPage.DataReader["qq"].ToString(),
dataPage.DataReader["email"].ToString(), dataPage.DataReader["msn"].ToString()) + "</textarea>");
table.AddCol(string.Format("<textarea rows=\"6\" cols=\"8\" style=\"width:120px;\">{0}</textarea>", dataPage.DataReader["content"].ToString()));
table.AddCol(dataPage.DataReader["username"].ToString());
table.AddCol(string.Format("<a href='javascript:void(0)' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 广告列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Accessories.AdvertiseManage bll = new ShowShop.BLL.Accessories.AdvertiseManage();
ChangeHope.DataBase.DataByPage dataPage = bll.GetList();
//第一步先添加表头
table.AddHeadCol("", "序号");
table.AddHeadCol("", "广告名称");
table.AddHeadCol("", "权重");
table.AddHeadCol("", "点击数");
table.AddHeadCol("", "浏览数");
table.AddHeadCol("", "结束日期");
table.AddHeadCol("", "审核");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(string.Format("<a href='?Ads_ID={0}'>{1}</a>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["name"].ToString()));
table.AddCol(string.Format("<input id='power{0}' value='{1}' size='3' onblur='PowerBy({0})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["power"].ToString()));
table.AddCol(dataPage.DataReader["clickcount"].ToString());
table.AddCol(dataPage.DataReader["browsecount"].ToString());
table.AddCol(Convert.ToDateTime(dataPage.DataReader["overduetime"]).ToShortDateString());
table.AddCol(string.Format("<img src='../images/{0}.gif' alt='审核与否'/>", dataPage.DataReader["examine"].ToString()));
table.AddCol(string.Format("<a href=advertise_info_edit.aspx?Ads_ID={0}&type={1}>编辑</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a> <a href=advertise_createjs.aspx?Ads_ID={0}>生成JS广告</a>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["adtype"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
private string GetList(string where)
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.UserInfoNote noteBll = new ShowShop.BLL.Member.UserInfoNote();
ChangeHope.DataBase.DataByPage dataPage = noteBll.GetListByWhere(where);
table.AddHeadCol("", "序号");
table.AddHeadCol("","交易日期");
table.AddHeadCol("","会员帐号");
table.AddHeadCol("","收入金额");
table.AddHeadCol("","支出金额");
table.AddHeadCol("","操作人员");
table.AddHeadCol("","备注/原因");
table.AddHeadCol("","操作");
table.AddRow();
if(dataPage.DataReader!=null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["noteDate"].ToString());
table.AddCol(dataPage.DataReader["userName"].ToString());
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString()=="0" ? dataPage.DataReader["ticketCount"].ToString() : "");
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString()=="1" ? dataPage.DataReader["ticketCount"].ToString() : "");
table.AddCol(dataPage.DataReader["noteName"].ToString());
table.AddCol(dataPage.DataReader["causation"].ToString());
table.AddCol("<a href='coupons_record_view.aspx?id=" + dataPage.DataReader["id"].ToString() + "'>查看</a>");
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
YXShop.BLL.Accessories.Hailhellowlink bll = new YXShop.BLL.Accessories.Hailhellowlink();
ChangeHope.DataBase.DataByPage dataPage = bll.GetList();
//第一步先添加表头
table.AddHeadCol("", "序号");
table.AddHeadCol("", "会员名称");
table.AddHeadCol("", "优先级");
table.AddHeadCol("", "点击数");
table.AddHeadCol("", "会员类型");
table.AddHeadCol("", "审核状态");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(string.Format("<a href='?id={0}'>{1}</a>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sitename"].ToString()));
table.AddCol(string.Format("<input id='leavel{0}' value='{1}' size='5' onblur='SetLeavel({0})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sitelevel"].ToString()));
table.AddCol(dataPage.DataReader["siteclickcount"].ToString());
table.AddCol(dataPage.DataReader["putouttyid"].ToString() == "0" ? "管理员" : "会员");
table.AddCol(string.Format("<img src='../images/{0}.gif' alt='审核与否'/>", dataPage.DataReader["sitestate"].ToString()));
table.AddCol(string.Format("<a href=hailhellowlink_edit.aspx?id={0}>编辑</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return(view);
}
protected void BindList(int ProductId)
{
ShowShop.BLL.Product.ProductInfo bll = new ShowShop.BLL.Product.ProductInfo();
ShowShop.Model.Product.ProductInfo modle = bll.GetModel(ProductId);
if (modle != null)
{
// if (!string.IsNullOrEmpty(modle.pro_Specialspecifications))
{
Regex productSpe = new Regex(@"s_spacebar");
// string[] specifiactionVa = productSpe.Split(modle.pro_Specialspecifications);
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
//第一步先添加表头
table.AddHeadCol("5%", "序号");
table.AddHeadCol("75%", "规格值");
table.AddHeadCol("20%", "操作");
table.AddRow();
//添加表的内容
//if (!string.IsNullOrEmpty(specifiactionVa[1]))
//{
// this.Spec.Text = specifiactionVa[0];
// int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
// if (curpage < 0)
// {
// curpage = 1;
// }
// int count = 0;
// string[] spval = specifiactionVa[1].Replace("\r\n",",").Split(',');
// for (int i = 0; i < spval.Length; i++)
// {
// count++;
// string No = (15 * (curpage - 1) + count).ToString();
// table.AddCol(No);
// table.AddCol(spval[i]);
// table.AddCol(string.Format("<a href=product_specialspecification.aspx?productId={0}&id={1}&val={2}&spec={3}>编辑</a>", ProductId, i, spval[i], specifiactionVa[0]));
// table.AddRow();
// }
//}
string view = table.GetTable();
this.Literal1.Text = view;
}
}
}
private void GetList()
{
ShowShop.BLL.Order.Orders bll = new ShowShop.BLL.Order.Orders();
ChangeHope.DataBase.DataByPage datapage = bll.GetListByPage("");
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.Common.OrdersStatusEnum ose = new ShowShop.Common.OrdersStatusEnum();
table.AddHead("<input type=\"checkbox\" id=\"cheAll\" onclick=\"SelectAll(cheAll)\"/>/,订单号/,用户名/,下单时间/,商品金额/,<img src=\"..\\images\\notice.gif\" title=\"订单金额=商品总价+运费+支付手续费\" >订单金额/,订单状态/,付款状态/,物流状态/");
int index = 0;
if(datapage.DataReader!=null)
{
while(datapage.DataReader.Read())
{
index++;
table.AddCol(string.Format("<input type=\"checkbox\" name=\"checkboxid\" value=\"{0}\">", datapage.DataReader["Id"].ToString()));
string TypeStr = string.Empty;
if (datapage.DataReader["OrderType"].ToString() == "1")
{
TypeStr = "<span style='color:red'>拍</span>";
}
else if (datapage.DataReader["OrderType"].ToString() == "2")
{
TypeStr = "<span style='color:red'>团</span>";
}
table.AddCol(TypeStr + "<a href='order_order_info.aspx?OrderId=" + datapage.DataReader["Id"].ToString() + "'>" + datapage.DataReader["OrderId"].ToString() + "</a>");
table.AddCol("<span title='" + datapage.DataReader["UserId"].ToString() + "'>" + ChangeHope.Common.StringHelper.SubString(datapage.DataReader["UserId"].ToString(), 10) + "</span>");
table.AddCol(datapage.DataReader["OrderDate"].ToString());
table.AddCol("￥" + Convert.ToDouble(datapage.DataReader["TotalPrice"].ToString()).ToString("f2") + " 元");
table.AddCol("￥" + Convert.ToDouble(datapage.DataReader["FactPrice"].ToString()).ToString("f2") + " 元");
table.AddCol(ose.OrderStatus(int.Parse(datapage.DataReader["OrderStatus"].ToString())));
table.AddCol(ose.PaymentStatus(int.Parse(datapage.DataReader["PaymentStatus"].ToString())));
table.AddCol(ose.OgisticsStatu(int.Parse(datapage.DataReader["OgisticsStatus"].ToString())));
table.AddRow();
}
}
this.ltlView.Text = table.GetTable() + datapage.PageToolBar;
table = null;
datapage.Dispose();
datapage = null;
bll = null;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Accessories.Hailhellowlink bll = new ShowShop.BLL.Accessories.Hailhellowlink();
ChangeHope.DataBase.DataByPage dataPage = bll.GetList();
//第一步先添加表头
table.AddHeadCol("", "序号");
table.AddHeadCol("", "会员名称");
table.AddHeadCol("", "优先级");
table.AddHeadCol("", "点击数");
table.AddHeadCol("", "会员类型");
table.AddHeadCol("", "审核状态");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(string.Format("<a href='?id={0}'>{1}</a>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sitename"].ToString()));
table.AddCol(string.Format("<input id='leavel{0}' value='{1}' size='5' onblur='SetLeavel({0})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sitelevel"].ToString()));
table.AddCol(dataPage.DataReader["siteclickcount"].ToString());
table.AddCol(dataPage.DataReader["putouttyid"].ToString() == "0" ? "管理员" : "会员");
table.AddCol(string.Format("<img src='../images/{0}.gif' alt='审核与否'/>", dataPage.DataReader["sitestate"].ToString()));
table.AddCol(string.Format("<a href=hailhellowlink_edit.aspx?id={0}>编辑</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Product.Productclass data = new ShowShop.BLL.Product.Productclass();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("5%", "序号");
table.AddHeadCol("35%", "分类名称");
// table.AddHeadCol("25%", "商品类型");
table.AddHeadCol("10%", "排序");
// table.AddHeadCol("5%", "状态");
table.AddHeadCol("20%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(string.Format("<a href='?w_d_fatherid={0}'>{1}</a>", dataPage.DataReader["cid"].ToString(), dataPage.DataReader["name"].ToString()));
// table.AddCol(dataPage.DataReader["TypeName"].ToString());
table.AddCol(string.Format("<input id='sort{0}' value='{1}' size='5' onblur='Sort({0},{1})'/>", dataPage.DataReader["cid"].ToString(), dataPage.DataReader["sort"].ToString()));
// table.AddCol(string.Format("<img src='../images/{0}.gif' alt='推荐与否'/>", dataPage.DataReader["isrecommend"].ToString()));
table.AddCol(string.Format("<a href=productclass_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a> <a href=productclass_edit.aspx?fatherid={0}>添加子分类</a>", dataPage.DataReader["cid"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Accessories.CommentForm data = new ShowShop.BLL.Accessories.CommentForm();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("5%", "序号");
table.AddHeadCol("15%", "属性名称");
table.AddHeadCol("25%", "所属值");
table.AddHeadCol("10%", "所属类型");
table.AddHeadCol("10%", "是否必填");
table.AddHeadCol("10%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["filed"].ToString());
table.AddCol(dataPage.DataReader["datavalue"].ToString().Replace("\n",","));
table.AddCol(Type(dataPage.DataReader["type"].ToString()));
table.AddCol(string.Format("<img src='../images/{0}.gif'/>", dataPage.DataReader["isrequire"].ToString()));
table.AddCol(string.Format("<a href=commentform_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
SOSOshop.BLL.SysParameter sp = new SOSOshop.BLL.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
YXShop.BLL.Accessories.Top_Searches data = new YXShop.BLL.Accessories.Top_Searches();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("10%", "序号");
table.AddHeadCol("40%", "关键词");
table.AddHeadCol("15%", "排序");
table.AddHeadCol("20%", "状态");
table.AddHeadCol("25%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol("No." + No);
table.AddCol("<a href=\"" + dataPage.DataReader["linkad"].ToString() + "\">" + dataPage.DataReader["name"].ToString() + "</a>");
table.AddCol(string.Format("<input id='sort{0}' value='{1}' size='5' onblur='Sort({0},{1})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sort"].ToString()));
table.AddCol(string.Format("<img src='../images/{0}.gif'/>", dataPage.DataReader["isshow"].ToString()));
table.AddCol(string.Format("<a href=topsearchesseting_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return(view);
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Accessories.Top_Searches data = new ShowShop.BLL.Accessories.Top_Searches();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("10%", "序号");
table.AddHeadCol("40%", "名称");
table.AddHeadCol("15%", "排序");
table.AddHeadCol("20%", "状态");
table.AddHeadCol("25%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol("No."+No);
table.AddCol("<span style='cursor:hand');\">" + dataPage.DataReader["name"].ToString() + "</span>");
table.AddCol(string.Format("<input id='sort{0}' value='{1}' size='5' onblur='Sort({0},{1})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sort"].ToString()));
table.AddCol(string.Format("<img src='../images/{0}.gif'/>", dataPage.DataReader["isshow"].ToString()));
table.AddCol(string.Format("<a href=topsearchesseting_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Product.Express bll = new ShowShop.BLL.Product.Express();
ChangeHope.DataBase.DataByPage dataPage = bll.GetList();
//第一步先添加表头
table.AddHeadCol("", "序号");
table.AddHeadCol("", "名称");
table.AddHeadCol("", "联系人");
table.AddHeadCol("", "电话");
table.AddHeadCol("", "优先级");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["name"].ToString());
table.AddCol(dataPage.DataReader["person"].ToString());
table.AddCol(dataPage.DataReader["phone"].ToString());
table.AddCol(string.Format("<input id='txtSort{0}' value='{1}' size='5' onblur='SetSort({0})'/>", dataPage.DataReader["id"].ToString(), dataPage.DataReader["sort"].ToString()));
table.AddCol(string.Format("<a href=express_edite.aspx?id={0}>编辑</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
SOSOshop.BLL.SysParameter sp = new SOSOshop.BLL.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
SOSOshop.BLL.Role data = new SOSOshop.BLL.Role();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("10%", "序号");
table.AddHeadCol("25%", "角色名");
table.AddHeadCol("40%", "描述");
table.AddHeadCol("25%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol("No." + No);
table.AddCol(dataPage.DataReader["name"].ToString());
table.AddCol(dataPage.DataReader["description"].ToString());
table.AddCol(string.Format("<a href=role_edit.aspx?id={0}>编辑</a> <a href='role_setmember.aspx?id={0}'>设置成员</a> <a href='popedom_manage.aspx?id={0}'>权限管理</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return(view);
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected void GetList(string PutoutType)
{
ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Product.ProductInfo data = new ShowShop.BLL.Product.ProductInfo();
ChangeHope.DataBase.DataByPage dataPage = data.GetList("[order by] ProductID desc", 20, "");
//第一步先添加表头
table.AddHeadCol("5%", "<input type=\"checkbox\" id=\"chkAll\" onclick=\"CheckAll(this.form)\" alt=\"全选/取消\" />选择");
table.AddHeadCol("10%", "商品编号");
table.AddHeadCol("18%", "商品名称");
table.AddHeadCol("15%", "所属分类");
table.AddHeadCol("10%", "品牌");
table.AddHeadCol("14%", "创建时间");
table.AddHeadCol("8%", "上架状态");
table.AddHeadCol("20%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
string pic_url = sp.DummyPaht + dataPage.DataReader["Thumbnail"].ToString();
table.AddCol("<input ID=\"cBox\" type=\"checkbox\" value=\"" + dataPage.DataReader["ProductID"].ToString() + "\" />");
table.AddCol(dataPage.DataReader["ProductNo"].ToString());
table.AddCol("<span style='cursor:hand' onMouseOut=\"hiddenPic();\" onMouseMove=\"showPic('" + pic_url + "');\">" + dataPage.DataReader["ProductName"].ToString() + "(" + dataPage.DataReader["ProductAttachName"].ToString() + ")</span>");
table.AddCol(ProductClassName(dataPage.DataReader["cid"].ToString()));
table.AddCol(dataPage.DataReader["BrandID"].ToString());
table.AddCol(dataPage.DataReader["CreateTime"].ToString());
table.AddCol(dataPage.DataReader["IsShelves"].ToString() == "1" ? "上架" : "未上架");
table.AddCol(string.Format("<a href=product_info_edit.aspx?productNo={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a> <a href=product_info_edit.aspx?productNo={0}>属性添加</a> <a href='../../product/productcontent.aspx?q_productid={0}' target='_blank'>SKU添加</a>", dataPage.DataReader["ProductID"].ToString(), dataPage.DataReader["cid"].ToString(), PutoutType));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
this.Literal1.Text = view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Order.OrderProduct bll = new ShowShop.BLL.Order.OrderProduct();
ShowShop.BLL.Order.Orders orderBll = new ShowShop.BLL.Order.Orders();
ChangeHope.DataBase.DataByPage dataPage = bll.GetListByPage();
//第一步先添加表头
table.AddHeadCol("", "订单号");
table.AddHeadCol("", "用户账号");
table.AddHeadCol("", "收货人");
table.AddHeadCol("", "商品名称");
table.AddHeadCol("", "实际价格");
table.AddHeadCol("", "下单时间");
table.AddHeadCol("", "状态");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
ShowShop.Model.Order.Orders orderModel = orderBll.GetModel(Convert.ToInt32(dataPage.DataReader["OrderId"].ToString()));
if (orderModel != null)
{
table.AddCol(orderModel.OrderId);
table.AddCol(orderModel.UserId);
table.AddCol(orderModel.ConsigneeName);
table.AddCol(dataPage.DataReader["ProName"].ToString());
table.AddCol(dataPage.DataReader["ProPrice"].ToString());
table.AddCol(orderModel.OrderDate.ToString());
table.AddCol(this.ShowStatu(orderModel.OrderStatus));
table.AddRow();
}
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Accessories.Collection bll = new ShowShop.BLL.Accessories.Collection();
ChangeHope.DataBase.DataByPage dataPage = bll.GetList();
//第一步先添加表头
table.AddHeadCol("", "<input type=\"checkbox\" id=\"chkAll\" onclick=\"CheckAll(this.form)\" alt=\"全选/取消\" />选择");
table.AddHeadCol("", "商品名称");
table.AddHeadCol("", "收藏用户");
table.AddHeadCol("", "收藏时间");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol("<input ID=\"cBox\" type=\"checkbox\" value=\"" + dataPage.DataReader["id"].ToString() + "\" />");
table.AddCol(GetProductName(dataPage.DataReader["collectionid"].ToString()));
table.AddCol(dataPage.DataReader["collectionname"].ToString());
table.AddCol(dataPage.DataReader["collectiondate"].ToString());
table.AddCol(string.Format("<a href='javascript:void(0)' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Product.ProductBrand data = new ShowShop.BLL.Product.ProductBrand();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("5%", "序号");
table.AddHeadCol("25%", "品牌名称");
table.AddHeadCol("25%", "排序");
table.AddHeadCol("25%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["name"].ToString());
table.AddCol(string.Format("<input id='sort{0}' value='{1}' size='5' onblur='Sort({0},{1})'/>", dataPage.DataReader["bid"].ToString(), dataPage.DataReader["sort"].ToString()));
table.AddCol(string.Format("<a href=productbrand_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["bid"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.Role data = new ShowShop.BLL.Member.Role();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("10%", "序号");
table.AddHeadCol("25%", "角色名");
table.AddHeadCol("40%", "描述");
table.AddHeadCol("25%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol("No."+No);
table.AddCol( dataPage.DataReader["name"].ToString() );
table.AddCol(dataPage.DataReader["description"].ToString());
table.AddCol(string.Format("<a href=role_edit.aspx?id={0}>编辑</a> <a href='role_setmember.aspx?id={0}'>设置成员</a> <a href='popedom_manage.aspx?id={0}'>权限管理</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
YXShop.BLL.Accessories.Sms bll = new YXShop.BLL.Accessories.Sms();
string sqlWhere = "1=1";
#region 时间
DateTime now = DateTime.Now; DateTime from = now; DateTime to = now;
try { if (fromOrderDate.Text != null && fromOrderDate.Text.Trim() != "")
{
from = DateTime.Parse(fromOrderDate.Text.Trim());
}
}
catch { }
try { if (toOrderDate.Text != null && toOrderDate.Text.Trim() != "")
{
to = DateTime.Parse(toOrderDate.Text.Trim());
}
}
catch { }
if (from != now && to != now)
{
sqlWhere += string.Format(" and OperateTime >= '{0}' and OperateTime <= '{1}' ", from.ToString("yyyy/MM/dd"), to.ToString("yyyy/MM/dd"));
}
else if (from != now)
{
sqlWhere += string.Format(" and OperateTime >= '{0}' ", from.ToString("yyyy/MM/dd"));
}
else if (to != now)
{
sqlWhere += string.Format(" and OperateTime <= '{0}' ", to.ToString("yyyy/MM/dd"));
}
#endregion
ChangeHope.DataBase.DataByPage dataPage = bll.GetList(sqlWhere);
//第一步先添加表头
table.AddHeadCol("5", "<input type=\"checkbox\" id=\"chkAll\" onclick=\"CheckAll(this.form)\" alt=\"全选/取消\" title=\"全选/取消\" />");
table.AddHeadCol("80", "发件人");
table.AddHeadCol("80", "收件人");
table.AddHeadCol("80", "发送手机");
table.AddHeadCol("", "发送内容");
table.AddHeadCol("120", "发送时间");
table.AddHeadCol("30", "状态");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0; string state = "";
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol("<input ID=\"cBox\" type=\"checkbox\" name=\"chk\" value=\"" + dataPage.DataReader["id"].ToString() + "\" />");
table.AddCol(dataPage.DataReader["fromUID"].ToString());
table.AddCol(dataPage.DataReader["toUID"].ToString());
table.AddCol(dataPage.DataReader["Mobile"].ToString());
table.AddCol("<textarea rows=\"5\" cols=\"8\" style=\"border: 0pt none; width: 100%; height: 41px;\">" + dataPage.DataReader["Msg"].ToString() + "</textarea>");
table.AddCol(dataPage.DataReader["OperateTime"].ToString());
state = dataPage.DataReader["State"].ToString();
if (state == "1")
{
table.AddCol(string.Format("<img src='../images/{0}.gif' style='cursor:pointer;' title='{1}' />", state, "成功"));
}
else
{
table.AddCol(string.Format("<img src='../images/{0}.gif' style='cursor:pointer;' title='{1}' />", state, "失败"));
}
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return(view);
}
