/// <summary>
/// 得到不同条件得到列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetList(string strWhere)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_mailreceiver [where] " + strWhere + " [order by] id desc";
dataPage.GetRecordSetByPage();
return(dataPage);
}
/// <summary>
/// 所有记录
/// </summary>
/// <remarks></remarks>
public ChangeHope.DataBase.DataByPage GetList()
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_role [where] 1=1 [order by] id asc";
dataPage.GetRecordSetByPage();
return(dataPage);
}
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()));
}
}
}
}
public ChangeHope.DataBase.DataByPage GetListDB(string where)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.PageSize = 100;
dataPage.Sql = "[select] *,(select top 1 loginintime from yxs_adminloginlog where adminname=yxs_administrators.name order by id desc)as logintime,(select top 1 loginip from yxs_adminloginlog where adminname=yxs_administrators.name order by id desc)as loginip [from] yxs_administrators [where] 1=1 " + where + " [order by] state,adminid asc";
dataPage.GetRecordSetByPage();
return(dataPage);
}
/// <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>
/// 根据用户ID及类型查
/// </summary>
/// <param name="userId"></param>
/// <param name="type"></param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetListByIdAndType(int userId, int type)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("[select] * [from] yxs_userinfonote [where] userId=");
strSql.Append(userId + " and noteType="+type);
strSql.Append(" [order by] id asc ");
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = strSql.ToString();
dataPage.GetRecordSetByPage();
return dataPage;
}
public ChangeHope.DataBase.DataByPage GetListDataByPage(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("[select] * [from] DrugsBase_Enterprise [where] 1=1 ");
if (where != null && where != "")
{
strSql.Append(where);
}
strSql.Append(" [order by] ID desc");
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = strSql.ToString();
dataPage.GetRecordSetByPage();
return(dataPage);
}
public ChangeHope.DataBase.DataByPage GetListByWhere(string id, int topNumber, int pagesize)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
if (!string.IsNullOrWhiteSpace(id))
dataPage.Sql = "[select] * [from] PropertyValue [where] PropertyID = " + id + " [order by] PropertyValueID desc;";
if (topNumber > 0)
{
dataPage.PageSize = topNumber;
}
else
{
dataPage.PageSize = pagesize;
}
dataPage.GetRecordSetByPage();
return dataPage;
}
public ChangeHope.DataBase.DataByPage GetListDataByPage(string where)
{
StringBuilder strSql = new StringBuilder();
string a = "a.UserType, a.UserGroup, a.UserId, a.MobilePhone, a.Email, a.Email_QQ, a.PassWord, a.Question, a.Answer, a.State, a.IsLookPrice, a.RegisterDate, a.RegisterIP, a.Capital, a.Coupons, a.Points, a.PeriodOfValidity, ";
string b = "b.* ";
strSql.Append("[select] " + a + b + ",ISNULL(e.Name,'') AS Enterprise [from] memberaccount AS a INNER JOIN memberinfo AS b ON a.UID=b.UID LEFT JOIN DrugsBase_Enterprise AS e ON b.ParentId=e.ID [where] 1=1 ");
if (!string.IsNullOrEmpty(where))
{
strSql.Append(where);
}
strSql.Append(" [order by] a.UID desc");
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = strSql.ToString();
dataPage.GetRecordSetByPage();
return(dataPage);
}
public ChangeHope.DataBase.DataByPage GetList(string where)
{
string a = "a.UserType, a.UserGroup, a.UserId, a.MobilePhone, a.Email, a.Email_QQ, a.PassWord, a.Question, a.Answer, a.State, a.RegisterDate, a.RegisterIP, a.Capital, a.Coupons, a.Points, a.PeriodOfValidity, a.CompanyClass ";
string b = "b.*,c.*";
StringBuilder strSql = new StringBuilder();
strSql.Append("[select] " + a + b);
strSql.Append(" [from] memberaccount a inner join memberinfo b on a.UID=b.UID inner join memberpermission c on a.UID=c.UID [where] 1=1 ");
if (!string.IsNullOrEmpty(where))
{
strSql.Append(where);
}
strSql.Append(" [order by] a.UID desc");
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = strSql.ToString();
dataPage.GetRecordSetByPage();
return(dataPage);
}
/// <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);
}
public ChangeHope.DataBase.DataByPage GetListByWhere(string name,int topNumber, int pagesize)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
if (!string.IsNullOrWhiteSpace(name))
dataPage.Sql = "[select] * [from] Property [where] PropertyName like '%" + name + "%' [order by] PropertyID desc;";
else
dataPage.Sql = "[select] * [from] Property [where] 1=1 [order by] PropertyID desc;";
if (topNumber > 0)
{
dataPage.PageSize = topNumber;
}
else
{
dataPage.PageSize = pagesize;
}
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <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()
{
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);
}
public ChangeHope.DataBase.DataByPage GetList(string where)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] *,(select name from yxs_articlechannel where id=yxs_Article.Channel)as ChannelContent [from] yxs_Article [where] 1=1 " + where + " [order by] id desc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 分页
/// </summary>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetAllList()
{
string sql = "[select] * [from] yxs_paymentmanage [where] 1=1 [order by] payment_taxis asc";
ChangeHope.DataBase.DataByPage datapage = new ChangeHope.DataBase.DataByPage();
datapage.Sql = sql;
datapage.GetRecordSetByPage();
return datapage;
}
/// <summary>
/// 跟据导航位置AreaName查询属性
/// </summary>
/// <param name="cid"></param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetProperty(string DistributionName)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] " + Pre + "deliverymode Where ','+[DistributionName]+',' like '%," + DistributionName + ",%'";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 分页列表
/// </summary>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetList()
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] " + Pre + "deliverymode [where] 1=1 [order by] Id asc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 跟据配送方式ID查询对应的配送区域列表
/// </summary>
/// <param name="cid">配送方式ID</param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetAreasByPostMethod(int cid)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] " + Pre + "deliveryareasetting [where] DeliveryMode=" + cid.ToString() + " [order by] Id asc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 根据不同条件查
/// </summary>
///
public ChangeHope.DataBase.DataByPage GetListByWhere(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("[select] * [from] yxs_userinfonote ");
if (where != null & where != "")
{
strSql.Append(" [where] " + where + " ");
}
else
{
strSql.Append(" [where] 1=1 ");
}
strSql.Append(" [order by] id asc ");
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = strSql.ToString();
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 得到所有记录
/// </summary>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetList()
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_hailhellowlink [where] 1=1 [order by] sitelevel desc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <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);
}
/// <summary>
/// 跟据AreaName查询属性
/// </summary>
/// <param name="cid"></param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetProperty(string AreaName)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = this.SelectSequel + "Where ','+[AreaName]+',' like '%," + AreaName + ",%'";
dataPage.GetRecordSetByPage();
return dataPage;
}
public ChangeHope.DataBase.DataByPage GetListByWhereAndOrder(string where, int pagesize, string orderfield)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_article [where] "+where+" [order by] "+orderfield+" ";
dataPage.PageSize = pagesize;
dataPage.GetRecordSetByPage();
return dataPage;
}
public ChangeHope.DataBase.DataByPage GetList(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("[select] *");
strSql.Append(",(select content from yxs_code_usertype where code=yxs_MemberAccount.UserType) as UserTypeContent");
strSql.Append(" ,(select Name from yxs_memberrank where id=yxs_MemberAccount.UserGroup) as UserGroupContent");
strSql.Append(" [from] yxs_MemberAccount [where] 1=1 ");
if (where!=null&&where!="")
{
strSql.Append(where);
}
strSql.Append(" [order by] UserId asc ");
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = strSql.ToString();
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 所有记录
/// </summary>
/// <remarks></remarks>
public ChangeHope.DataBase.DataByPage GetList()
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_role [where] 1=1 [order by] id asc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 跟据配送方式条件查询对应的配送区域列表
/// </summary>
/// <param name="cid">配送方式ID</param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetAreasBy(string Condits)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] " + Pre + "deliveryareasetting [where] 1=1 "+Condits+" [order by] Id asc";
dataPage.GetRecordSetByPage();
return dataPage;
}
public ChangeHope.DataBase.DataByPage GetListDB()
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] *,(select top 1 LogininTime from Adminloginlog where AdminName=Administrators.Name order by ID desc)as LoginTime,(select top 1 LoginIP from Adminloginlog where AdminName=Administrators.Name order by ID desc)as LoginIP [from] Administrators [where] 1=1 [order by] AdminID asc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 得到所有记录
/// </summary>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetList()
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_advertisemanage [where] 1=1 [order by] power desc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 排序所有记录
/// </summary>
/// <remarks></remarks>
public ChangeHope.DataBase.DataByPage GetList(string orderfield, int pagesize, string Conditions)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_articlechannel [where] 1=1 " + Conditions + " " + orderfield;
dataPage.PageSize = pagesize;
dataPage.GetRecordSetByPage();
return dataPage;
}
public ChangeHope.DataBase.DataByPage GetList()
{
string sql = "[select] *"
+ ",(select content from yxs_code_usertype where code=yxs_MemberAccount.UserType) as UserTypeContent"
+ " ,(select Name from yxs_memberrank where id=yxs_MemberAccount.UserGroup) as UserGroupContent"
+ " [from] yxs_MemberAccount [where] 1=1 [order by] UID desc";
ChangeHope.DataBase.DataByPage datapage = new ChangeHope.DataBase.DataByPage();
datapage.Sql = sql;
datapage.GetRecordSetByPage();
return datapage;
}
/// <summary>
/// 得到不同条件得到列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetList(string strWhere)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] yxs_ordertransfer [where] " + strWhere + " [order by] id asc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 所有记录
/// </summary>
/// <remarks></remarks>
public ChangeHope.DataBase.DataByPage GetList()
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "select * from Product where 1=1 order by ProductID desc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 查询所有数据
/// </summary>
/// <remarks></remarks>
public ChangeHope.DataBase.DataByPage GetList()
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "[select] * [from] " + Pre + "navigation [where] 1=1 [order by] sort asc";
dataPage.GetRecordSetByPage();
return dataPage;
}
/// <summary>
/// 根据条件返回集合
/// </summary>
/// <param name="where"></param>
/// <param name="topNumber">为0时查所有</param>
/// <returns></returns>
public ChangeHope.DataBase.DataByPage GetListByWhere(string where, int topNumber, int pagesize, string orderfield)
{
ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();
dataPage.Sql = "select * from Product where " + where + " order by " + orderfield + " ";
if (topNumber > 0)
{
dataPage.PageSize = topNumber;
}
else
{
dataPage.PageSize = pagesize;
}
dataPage.GetRecordSetByPage();
return dataPage;
}
