Esempio n. 1
0
        /// <summary>
        /// 获取记录总数
        /// </summary>
        public int GetRecordCount(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) FROM Customer ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            object obj = DbHelperMySql.GetSingle(strSql.ToString());

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT * FROM ( ");
            strSql.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                strSql.Append("order by T." + orderby);
            }
            else
            {
                strSql.Append("order by T.Id desc");
            }
            strSql.Append(")AS Row, T.*  from CustomerJPush T ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSql.Append(" WHERE " + strWhere);
            }
            strSql.Append(" ) TT");
            strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
            return(DbHelperMySql.Query(strSql.ToString()));
        }
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public CustomerJPush GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select Id,CustomerId,RegId,Platform,Created from CustomerJPush ");
            strSql.Append(" where Id=@Id");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Id", MySqlDbType.Int32)
            };
            parameters[0].Value = id;

            DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("delete from CustomerJPush ");
            strSql.Append(" where Id=@Id");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Id", MySqlDbType.Int32)
            };
            parameters[0].Value = id;

            int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Customer GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select Id,Account,Password,Sign,NickName,Name,Phone,Email,OpenId,CardType,CardNo,Photo,ReferenceId,IsGrantLibrary,Count,Platform,RegisterIP,RegisterAddredss,Deleted,Created,Modified,RedeemPassword,EnabledFingerprint,HadaCount,IsAutoRedeem,IsSetPassword from Customer ");
            strSql.Append(" where Id=@Id");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Id", MySqlDbType.Int32)
            };
            parameters[0].Value = id;

            DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Esempio n. 6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public SystemConfig GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select Id,Category,Key,Value,Name,Deleted,Created,Modified from SystemConfig ");
            strSql.Append(" where Id=@Id");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Id", MySqlDbType.Int32)
            };
            parameters[0].Value = id;

            DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Esempio n. 7
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(SystemConfig model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into SystemConfig(");
            strSql.Append("Category,Key,Value,Name,Deleted,Created,Modified)");
            strSql.Append(" values (");
            strSql.Append("@Category,@Key,@Value,@Name,@Deleted,@Created,@Modified)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Category", MySqlDbType.VarChar,      2),
                new MySqlParameter("@Key",      MySqlDbType.VarChar,    100),
                new MySqlParameter("@Value",    MySqlDbType.VarChar,   1000),
                new MySqlParameter("@Name",     MySqlDbType.VarChar,     50),
                new MySqlParameter("@Deleted",  MySqlDbType.Bit),
                new MySqlParameter("@Created",  MySqlDbType.DateTime),
                new MySqlParameter("@Modified", MySqlDbType.DateTime)
            };
            parameters[0].Value = model.Category;
            parameters[1].Value = model.Key;
            parameters[2].Value = model.Value;
            parameters[3].Value = model.Name;
            parameters[4].Value = model.Deleted;
            parameters[5].Value = model.Created;
            parameters[6].Value = model.Modified;

            int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 8
0
        /*
         *      /// <summary>
         *      /// 分页获取数据列表
         *      /// </summary>
         *      public DataSet GetList(int PageSize,int PageIndex,string strWhere)
         *      {
         *              MySqlParameter[] parameters = {
         *                              new MySqlParameter("@tblName", MySqlDbType.VarChar, 255),
         *                              new MySqlParameter("@fldName", MySqlDbType.VarChar, 255),
         *                              new MySqlParameter("@PageSize", MySqlDbType.Int32),
         *                              new MySqlParameter("@PageIndex", MySqlDbType.Int32),
         *                              new MySqlParameter("@IsReCount", MySqlDbType.Bit),
         *                              new MySqlParameter("@OrderType", MySqlDbType.Bit),
         *                              new MySqlParameter("@strWhere", MySqlDbType.VarChar,1000),
         *                              };
         *              parameters[0].Value = "SystemConfig";
         *              parameters[1].Value = "Id";
         *              parameters[2].Value = PageSize;
         *              parameters[3].Value = PageIndex;
         *              parameters[4].Value = 0;
         *              parameters[5].Value = 0;
         *              parameters[6].Value = strWhere;
         *              return DbHelperMySql.RunProcedure("UP_GetRecordByPage",parameters,"ds");
         *      }*/

        #endregion  BasicMethod
        #region  ExtensionMethod


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public SystemConfig GetModel(string key)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT Id,Category,`Key`,`Value`,`Name`,Deleted,Created,Modified FROM SystemConfig ");
            strSql.Append(" where `Key`=@Key");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Key", MySqlDbType.String)
            };
            parameters[0].Value = key;

            SystemConfig model = new SystemConfig();
            DataSet      ds    = DbHelperMySql.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Esempio n. 9
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Customer model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Customer(");
            strSql.Append("Account,Password,Sign,NickName,Name,Phone,Email,OpenId,CardType,CardNo,Photo,ReferenceId,IsGrantLibrary,Count,Platform,RegisterIP,RegisterAddredss,Deleted,Created,Modified,RedeemPassword,EnabledFingerprint,HadaCount,IsAutoRedeem,IsSetPassword)");
            strSql.Append(" values (");
            strSql.Append("@Account,@Password,@Sign,@NickName,@Name,@Phone,@Email,@OpenId,@CardType,@CardNo,@Photo,@ReferenceId,@IsGrantLibrary,@Count,@Platform,@RegisterIP,@RegisterAddredss,@Deleted,@Created,@Modified,@RedeemPassword,@EnabledFingerprint,@HadaCount,@IsAutoRedeem,@IsSetPassword)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Account",            MySqlDbType.VarChar,    50),
                new MySqlParameter("@Password",           MySqlDbType.VarChar,   100),
                new MySqlParameter("@Sign",               MySqlDbType.VarChar,    50),
                new MySqlParameter("@NickName",           MySqlDbType.VarChar,    50),
                new MySqlParameter("@Name",               MySqlDbType.VarChar,    50),
                new MySqlParameter("@Phone",              MySqlDbType.VarChar,    11),
                new MySqlParameter("@Email",              MySqlDbType.VarChar,   100),
                new MySqlParameter("@OpenId",             MySqlDbType.VarChar,   200),
                new MySqlParameter("@CardType",           MySqlDbType.VarChar,     2),
                new MySqlParameter("@CardNo",             MySqlDbType.VarChar,    50),
                new MySqlParameter("@Photo",              MySqlDbType.VarChar,   500),
                new MySqlParameter("@ReferenceId",        MySqlDbType.Int32,      11),
                new MySqlParameter("@IsGrantLibrary",     MySqlDbType.Bit),
                new MySqlParameter("@Count",              MySqlDbType.Int32,      11),
                new MySqlParameter("@Platform",           MySqlDbType.VarChar,    50),
                new MySqlParameter("@RegisterIP",         MySqlDbType.VarChar,    20),
                new MySqlParameter("@RegisterAddredss",   MySqlDbType.VarChar,    20),
                new MySqlParameter("@Deleted",            MySqlDbType.Bit),
                new MySqlParameter("@Created",            MySqlDbType.DateTime),
                new MySqlParameter("@Modified",           MySqlDbType.DateTime),
                new MySqlParameter("@RedeemPassword",     MySqlDbType.VarChar,   200),
                new MySqlParameter("@EnabledFingerprint", MySqlDbType.Bit),
                new MySqlParameter("@HadaCount",          MySqlDbType.Int32,      11),
                new MySqlParameter("@IsAutoRedeem",       MySqlDbType.Bit),
                new MySqlParameter("@IsSetPassword",      MySqlDbType.Bit)
            };
            parameters[0].Value  = model.Account;
            parameters[1].Value  = model.Password;
            parameters[2].Value  = model.Sign;
            parameters[3].Value  = model.NickName;
            parameters[4].Value  = model.Name;
            parameters[5].Value  = model.Phone;
            parameters[6].Value  = model.Email;
            parameters[7].Value  = model.OpenId;
            parameters[8].Value  = model.CardType;
            parameters[9].Value  = model.CardNo;
            parameters[10].Value = model.Photo;
            parameters[11].Value = model.ReferenceId;
            parameters[12].Value = model.IsGrantLibrary;
            parameters[13].Value = model.Count;
            parameters[14].Value = model.Platform;
            parameters[15].Value = model.RegisterIP;
            parameters[16].Value = model.RegisterAddredss;
            parameters[17].Value = model.Deleted;
            parameters[18].Value = model.Created;
            parameters[19].Value = model.Modified;
            parameters[20].Value = model.RedeemPassword;
            parameters[21].Value = model.EnabledFingerprint;
            parameters[22].Value = model.HadaCount;
            parameters[23].Value = model.IsAutoRedeem;
            parameters[24].Value = model.IsSetPassword;

            int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 10
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Customer model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Customer set ");
            strSql.Append("Account=@Account,");
            strSql.Append("Password=@Password,");
            strSql.Append("Sign=@Sign,");
            strSql.Append("NickName=@NickName,");
            strSql.Append("Name=@Name,");
            strSql.Append("Phone=@Phone,");
            strSql.Append("Email=@Email,");
            strSql.Append("OpenId=@OpenId,");
            strSql.Append("CardType=@CardType,");
            strSql.Append("CardNo=@CardNo,");
            strSql.Append("Photo=@Photo,");
            strSql.Append("ReferenceId=@ReferenceId,");
            strSql.Append("IsGrantLibrary=@IsGrantLibrary,");
            strSql.Append("Count=@Count,");
            strSql.Append("Platform=@Platform,");
            strSql.Append("RegisterIP=@RegisterIP,");
            strSql.Append("RegisterAddredss=@RegisterAddredss,");
            strSql.Append("Deleted=@Deleted,");
            strSql.Append("Created=@Created,");
            strSql.Append("Modified=@Modified,");
            strSql.Append("RedeemPassword=@RedeemPassword,");
            strSql.Append("EnabledFingerprint=@EnabledFingerprint,");
            strSql.Append("HadaCount=@HadaCount,");
            strSql.Append("IsAutoRedeem=@IsAutoRedeem,");
            strSql.Append("IsSetPassword=@IsSetPassword");
            strSql.Append(" where Id=@Id");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Account",            MySqlDbType.VarChar,    50),
                new MySqlParameter("@Password",           MySqlDbType.VarChar,   100),
                new MySqlParameter("@Sign",               MySqlDbType.VarChar,    50),
                new MySqlParameter("@NickName",           MySqlDbType.VarChar,    50),
                new MySqlParameter("@Name",               MySqlDbType.VarChar,    50),
                new MySqlParameter("@Phone",              MySqlDbType.VarChar,    11),
                new MySqlParameter("@Email",              MySqlDbType.VarChar,   100),
                new MySqlParameter("@OpenId",             MySqlDbType.VarChar,   200),
                new MySqlParameter("@CardType",           MySqlDbType.VarChar,     2),
                new MySqlParameter("@CardNo",             MySqlDbType.VarChar,    50),
                new MySqlParameter("@Photo",              MySqlDbType.VarChar,   500),
                new MySqlParameter("@ReferenceId",        MySqlDbType.Int32,      11),
                new MySqlParameter("@IsGrantLibrary",     MySqlDbType.Bit),
                new MySqlParameter("@Count",              MySqlDbType.Int32,      11),
                new MySqlParameter("@Platform",           MySqlDbType.VarChar,    50),
                new MySqlParameter("@RegisterIP",         MySqlDbType.VarChar,    20),
                new MySqlParameter("@RegisterAddredss",   MySqlDbType.VarChar,    20),
                new MySqlParameter("@Deleted",            MySqlDbType.Bit),
                new MySqlParameter("@Created",            MySqlDbType.DateTime),
                new MySqlParameter("@Modified",           MySqlDbType.DateTime),
                new MySqlParameter("@RedeemPassword",     MySqlDbType.VarChar,   200),
                new MySqlParameter("@EnabledFingerprint", MySqlDbType.Bit),
                new MySqlParameter("@HadaCount",          MySqlDbType.Int32,      11),
                new MySqlParameter("@IsAutoRedeem",       MySqlDbType.Bit),
                new MySqlParameter("@IsSetPassword",      MySqlDbType.Bit),
                new MySqlParameter("@Id",                 MySqlDbType.Int32, 11)
            };
            parameters[0].Value  = model.Account;
            parameters[1].Value  = model.Password;
            parameters[2].Value  = model.Sign;
            parameters[3].Value  = model.NickName;
            parameters[4].Value  = model.Name;
            parameters[5].Value  = model.Phone;
            parameters[6].Value  = model.Email;
            parameters[7].Value  = model.OpenId;
            parameters[8].Value  = model.CardType;
            parameters[9].Value  = model.CardNo;
            parameters[10].Value = model.Photo;
            parameters[11].Value = model.ReferenceId;
            parameters[12].Value = model.IsGrantLibrary;
            parameters[13].Value = model.Count;
            parameters[14].Value = model.Platform;
            parameters[15].Value = model.RegisterIP;
            parameters[16].Value = model.RegisterAddredss;
            parameters[17].Value = model.Deleted;
            parameters[18].Value = model.Created;
            parameters[19].Value = model.Modified;
            parameters[20].Value = model.RedeemPassword;
            parameters[21].Value = model.EnabledFingerprint;
            parameters[22].Value = model.HadaCount;
            parameters[23].Value = model.IsAutoRedeem;
            parameters[24].Value = model.IsSetPassword;
            parameters[25].Value = model.Id;

            int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }