/// <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)); }