/// <summary>
/// 返回数据数
/// </summary>
public int GetCount(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) as H from " + databaseprefix + "manager_log ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(Convert.ToInt32(DbHelperOleDb.GetSingle(strSql.ToString())));
}
/// <summary>
/// 统计数据条目
/// </summary>
public object Stat(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Scheme_DLTData");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelperOleDb.GetSingle(strSql.ToString()));
}
private int GetMaxId(OleDbConnection conn, OleDbTransaction trans)
{
string SQLString = "select top 1 id from " + this.databaseprefix + "user_oauth_app order by id desc";
object single = DbHelperOleDb.GetSingle(conn, trans, SQLString);
if (single == null)
{
return(0);
}
return(int.Parse(single.ToString()));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TFXK.Model.Users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Users(");
strSql.Append("userName,[password],trueName,email,telephone,address,roleid,question,answer,state,regDate,lastLoginDate,loginCount,description)");
strSql.Append(" values (");
strSql.Append("@userName,@password,@trueName,@email,@telephone,@address,@roleid,@question,@answer,@state,@regDate,@lastLoginDate,@loginCount,@description)");
OleDbParameter[] parameters =
{
new OleDbParameter("@userName", OleDbType.VarChar, 50),
new OleDbParameter("@password", OleDbType.VarChar, 50),
new OleDbParameter("@trueName", OleDbType.VarChar, 50),
new OleDbParameter("@email", OleDbType.VarChar, 50),
new OleDbParameter("@telephone", OleDbType.VarChar, 50),
new OleDbParameter("@address", OleDbType.VarChar, 200),
new OleDbParameter("@roleid", OleDbType.Integer, 4),
new OleDbParameter("@question", OleDbType.VarChar, 50),
new OleDbParameter("@answer", OleDbType.VarChar, 50),
new OleDbParameter("@state", OleDbType.Integer, 4),
new OleDbParameter("@regDate", OleDbType.DBDate),
new OleDbParameter("@lastLoginDate", OleDbType.DBDate),
new OleDbParameter("@loginCount", OleDbType.Integer, 4),
new OleDbParameter("@description", OleDbType.VarChar)
};
parameters[0].Value = model.userName;
parameters[1].Value = model.password;
parameters[2].Value = model.trueName;
parameters[3].Value = model.email;
parameters[4].Value = model.telephone;
parameters[5].Value = model.address;
parameters[6].Value = model.roleid;
parameters[7].Value = model.question;
parameters[8].Value = model.answer;
parameters[9].Value = model.state;
parameters[10].Value = model.regDate;
parameters[11].Value = model.lastLoginDate;
parameters[12].Value = model.loginCount;
parameters[13].Value = model.description;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
string sql = "select max(id) from [tb_Users]";
try
{
return(int.Parse(DbHelperOleDb.GetSingle(sql).ToString()));
}
catch
{
return(0);
}
}
public int GetCount(string strWhere)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select count(*) as H ");
stringBuilder.Append(" from " + this.databaseprefix + "article_comment ");
if (strWhere.Trim() != "")
{
stringBuilder.Append(" where " + strWhere);
}
return(Convert.ToInt32(DbHelperOleDb.GetSingle(stringBuilder.ToString())));
}
/// <summary>
/// 获得查询分页数据
/// </summary>
public DataSet GetList(int pageSize, int pageIndex, string strWhere, string filedOrder, out int recordCount)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * FROM " + databaseprefix + "orders");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
recordCount = Convert.ToInt32(DbHelperOleDb.GetSingle(PagingHelper.CreateCountingSql(strSql.ToString())));
return(DbHelperOleDb.Query(PagingHelper.CreatePagingSql(recordCount, pageSize, pageIndex, strSql.ToString(), filedOrder)));
}
/// <summary>
/// 返回长查询数据总数 （分页用到）
/// </summary>
public int GetCount(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) as H ");
strSql.Append(" from Administrator ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(Convert.ToInt32(DbHelperOleDb.GetSingle(strSql.ToString())));
}
/// <summary>
/// 返回该类别下的所有记录总数
/// </summary>
/// <param name="strWhere">条件</param>
/// <param name="classId">类别</param>
/// <param name="kindId">种类</param>
/// <returns></returns>
public int GetCount(string strWhere, int classId, int kindId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) as H ");
strSql.Append(" from Article ");
strSql.Append(" where ClassId in(select Id from Channel where KindId=" + kindId + " and ClassList like '%," + classId + ",%')");
if (strWhere.Trim() != "")
{
strSql.Append(" and " + strWhere);
}
return(Convert.ToInt32(DbHelperOleDb.GetSingle(strSql.ToString())));
}
public static int GetMaxID(string FieldName, string TableName)
{
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = DbHelperOleDb.GetSingle(strsql);
if (obj == null)
{
return 1;
}
else
{
return int.Parse(obj.ToString());
}
}
public int GetNavId(string nav_name)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 id from " + this.databaseprefix + nameof(navigation));
stringBuilder.Append(" where name=@nav_name");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@nav_name", OleDbType.VarChar, 50)
};
oleDbParameterArray[0].Value = (object)nav_name;
return(Utils.StrToInt(Convert.ToString(DbHelperOleDb.GetSingle(stringBuilder.ToString(), oleDbParameterArray)), 0));
}
/// <summary>
/// 返回账户名称
/// </summary>
public string GetName()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 name from " + databaseprefix + "weixin_account");
string title = Convert.ToString(DbHelperOleDb.GetSingle(strSql.ToString()));
if (string.IsNullOrEmpty(title))
{
return(string.Empty);
}
return(title);
}
/// <summary>
/// 获取最大ID值
/// </summary>
/// <returns></returns>
public int GetMaxId()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select max(schemeID) from Scheme_Check");
string result = DbHelperOleDb.GetSingle(strSql.ToString()).ToString();
if (string.IsNullOrEmpty(result))
{
result = "0";
}
return(Convert.ToInt32(result));
}
public int GetDiscount(int id)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 discount from " + this.databaseprefix + nameof(user_groups));
stringBuilder.Append(" where id=" + (object)id);
string str = Convert.ToString(DbHelperOleDb.GetSingle(stringBuilder.ToString()));
if (string.IsNullOrEmpty(str))
{
return(0);
}
return(Convert.ToInt32(str));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public string GetToken()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 token from " + databaseprefix + "weixin_account");
object obj = DbHelperOleDb.GetSingle(strSql.ToString());
if (obj != null)
{
return(obj.ToString());
}
return(string.Empty);
}
/// <summary>
/// 返回站点对应的导航ID
/// </summary>
public int GetSiteNavId(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select N.id from " + databaseprefix + "navigation as N," + databaseprefix + "channel_site as S");
strSql.Append(" where 'channel_'+S.build_path=N.name and S.id=" + id);
object obj = DbHelperOleDb.GetSingle(strSql.ToString());
if (obj != null)
{
return(Convert.ToInt32(obj));
}
return(0);
}
/// <summary>
/// 返回站点的生成目录名
/// </summary>
public string GetBuildPath(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 build_path from " + databaseprefix + "channel_site");
strSql.Append(" where id=" + id);
object obj = DbHelperOleDb.GetSingle(strSql.ToString());
if (obj != null)
{
return(Convert.ToString(obj));
}
return(string.Empty);
}
public int GetCountNum(int article_id)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select sum(down_num) from " + this.databaseprefix + nameof(article_attach));
stringBuilder.Append(" where article_id=" + (object)article_id);
string str = Convert.ToString(DbHelperOleDb.GetSingle(stringBuilder.ToString()));
if (string.IsNullOrEmpty(str))
{
return(0);
}
return(Convert.ToInt32(str));
}
/// <summary>
/// 返回规则下面的内容数量
/// </summary>
public int GetCount(int rule_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) as H ");
strSql.Append(" from " + databaseprefix + "weixin_request_content");
strSql.Append(" where rule_id=@rule_id");
OleDbParameter[] parameters =
{
new OleDbParameter("@rule_id", OleDbType.Integer, 4)
};
parameters[0].Value = rule_id;
return(Convert.ToInt32(DbHelperOleDb.GetSingle(strSql.ToString(), parameters)));
}
public string GetTitle(int id)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 title from " + this.databaseprefix + nameof(payment));
stringBuilder.Append(" where id=" + (object)id);
string str = Convert.ToString(DbHelperOleDb.GetSingle(stringBuilder.ToString()));
if (string.IsNullOrEmpty(str))
{
return("-");
}
return(str);
}
/// <summary>
/// 获取单个附件下载次数
/// </summary>
public int GetDownNum(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 down_num from " + databaseprefix + "article_attach");
strSql.Append(" where id=" + id);
string str = Convert.ToString(DbHelperOleDb.GetSingle(strSql.ToString()));
if (string.IsNullOrEmpty(str))
{
return(0);
}
return(Convert.ToInt32(str));
}
/// <summary>
/// 获得下一个序号
/// </summary>
/// <returns></returns>
public int GetNextOrderIndex()
{
string strSql = "select max(orderindex) from District";
object obj = DbHelperOleDb.GetSingle(strSql);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj) + 1);
}
}
/// <summary>
/// 获取会员组折扣
/// </summary>
public int GetDiscount(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 discount from " + databaseprefix + "user_groups");
strSql.Append(" where id=" + id);
string str = Convert.ToString(DbHelperOleDb.GetSingle(strSql.ToString()));
if (string.IsNullOrEmpty(str))
{
return(0);
}
return(Convert.ToInt32(str));
}
public string GetChannelName(int id)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 name from " + this.databaseprefix + nameof(channel));
stringBuilder.Append(" where id=" + (object)id);
object single = DbHelperOleDb.GetSingle(stringBuilder.ToString());
if (single != null)
{
return(Convert.ToString(single));
}
return(string.Empty);
}
/// <summary>
/// 根据用户名取得Salt
/// </summary>
public string GetSalt(string user_name)
{
//尝试用户名取得Salt
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 salt from " + databaseprefix + "users");
strSql.Append(" where user_name=@user_name");
OleDbParameter[] parameters =
{
new OleDbParameter("@user_name", OleDbType.VarChar, 100)
};
parameters[0].Value = user_name;
string salt = Convert.ToString(DbHelperOleDb.GetSingle(strSql.ToString(), parameters));
if (!string.IsNullOrEmpty(salt))
{
return(salt);
}
//尝试用手机号取得Salt
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select top 1 salt from " + databaseprefix + "users");
strSql1.Append(" where mobile=@mobile");
OleDbParameter[] parameters1 =
{
new OleDbParameter("@mobile", OleDbType.VarChar, 20)
};
parameters1[0].Value = user_name;
salt = Convert.ToString(DbHelperOleDb.GetSingle(strSql1.ToString(), parameters1));
if (!string.IsNullOrEmpty(salt))
{
return(salt);
}
//尝试用邮箱取得Salt
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("select top 1 salt from " + databaseprefix + "users");
strSql2.Append(" where email=@email");
OleDbParameter[] parameters2 =
{
new OleDbParameter("@email", OleDbType.VarChar, 50)
};
parameters2[0].Value = user_name;
salt = Convert.ToString(DbHelperOleDb.GetSingle(strSql2.ToString(), parameters2));
if (!string.IsNullOrEmpty(salt))
{
return(salt);
}
return(string.Empty);
}
/// <summary>
/// 获取子分类数量
/// </summary>
public int GetChildNum(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from tb_Category");
strSql.Append(" where parentID=@id ");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
return(int.Parse(DbHelperOleDb.GetSingle(strSql.ToString(), parameters) + ""));
}
/// <summary>
/// 返回角色名称
/// </summary>
public string GetTitle(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 role_name from " + databaseprefix + "manager_role");
strSql.Append(" where id=" + id);
string title = Convert.ToString(DbHelperOleDb.GetSingle(strSql.ToString()));
if (string.IsNullOrEmpty(title))
{
return("");
}
return(title);
}
/// <summary>
/// 得到最大ID
/// </summary>
private int GetMaxId(OleDbConnection conn, OleDbTransaction trans)
{
string strSql = "select top 1 id from " + databaseprefix + "manager_role order by id desc";
object obj = DbHelperOleDb.GetSingle(conn, trans, strSql);
if (obj == null)
{
return(0);
}
else
{
return(int.Parse(obj.ToString()));
}
}
public string GetSalt(string user_name)
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("select top 1 salt from " + this.databaseprefix + nameof(users));
stringBuilder1.Append(" where user_name=@user_name");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[1]
{
new OleDbParameter("@user_name", OleDbType.VarChar, 100)
};
oleDbParameterArray1[0].Value = (object)user_name;
string str1 = Convert.ToString(DbHelperOleDb.GetSingle(stringBuilder1.ToString(), oleDbParameterArray1));
if (!string.IsNullOrEmpty(str1))
{
return(str1);
}
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("select top 1 salt from " + this.databaseprefix + nameof(users));
stringBuilder2.Append(" where mobile=@mobile");
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[1]
{
new OleDbParameter("@mobile", OleDbType.VarChar, 20)
};
oleDbParameterArray2[0].Value = (object)user_name;
string str2 = Convert.ToString(DbHelperOleDb.GetSingle(stringBuilder2.ToString(), oleDbParameterArray2));
if (!string.IsNullOrEmpty(str2))
{
return(str2);
}
StringBuilder stringBuilder3 = new StringBuilder();
stringBuilder3.Append("select top 1 salt from " + this.databaseprefix + nameof(users));
stringBuilder3.Append(" where email=@email");
OleDbParameter[] oleDbParameterArray3 = new OleDbParameter[1]
{
new OleDbParameter("@email", OleDbType.VarChar, 50)
};
oleDbParameterArray3[0].Value = (object)user_name;
string str3 = Convert.ToString(DbHelperOleDb.GetSingle(stringBuilder3.ToString(), oleDbParameterArray3));
if (!string.IsNullOrEmpty(str3))
{
return(str3);
}
return(string.Empty);
}
public static string AddUser(string as_name)
{
if (Convert.ToInt32(DbHelperOleDb.GetSingle("select count(*) from tb_user")) > 1000)
{
throw new ApplicationException("插入的用户记录数已经超出猫冬设置的最大笔数(1000)，请到QQ群里通知猫冬清除记录");
}
if (CheckUser(as_name) == "0")
{
return(Insert(as_name));
}
else
{
return("0");
}
}
/// <summary>
/// 根据导航的名称查询其ID
/// </summary>
public int GetNavId(string nav_name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id from " + databaseprefix + "navigation");
strSql.Append(" where name=@nav_name");
OleDbParameter[] parameters =
{
new OleDbParameter("@nav_name", OleDbType.VarChar, 50)
};
parameters[0].Value = nav_name;
string str = Convert.ToString(DbHelperOleDb.GetSingle(strSql.ToString(), parameters));
return(Utils.StrToInt(str, 0));
}
