Example #1
0
        public int SystemRequestRecord_Add(int userID, int bussnessId, decimal requestMoney, int requestType, out string errorMsg)
        {
            SqlCommand cmd = db.GetStoredProcedureCommand("Proc_SystemRequestRecord_Add");

            db.AddInputParameter(cmd, "@UserID", DbType.Int32, userID);
            db.AddInputParameter(cmd, "@BussnessId", DbType.Int32, bussnessId);
            db.AddInputParameter(cmd, "@RequestMoney", DbType.Decimal, requestMoney);
            db.AddInputParameter(cmd, "@RequestType", DbType.Int32, requestType);
            db.AddOutputParameter(cmd, "@ErrorMsg", DbType.String, 500);
            db.AddReturnValueParameter(cmd, "@ReturnValue", DbType.Int32, 4);
            db.ExecuteNonQuery(cmd);
            errorMsg = db.GetParameter(cmd, "@ErrorMsg").Value.ToString();
            return(db.GetParameter(cmd, "@ReturnValue").Value.ToInt());
        }
Example #2
0
        /// <summary>
        /// 2.7. 转账 (用于投资)
        /// </summary>
        /// <param name="uid"></param>
        /// <param name="PayNo"></param>
        /// <returns></returns>
        public bool ToCpTransaction(string PayNo, out string errorMsg)
        {
            SqlCommand cmd = db.GetStoredProcedureCommand("Proc_Transaction_PayCompleted");

            db.AddInputParameter(cmd, "@PayNo", System.Data.DbType.String, PayNo);
            db.AddOutputParameter(cmd, "@ErrorMsg", System.Data.DbType.String, 4);
            db.AddReturnValueParameter(cmd, "@ReturnValue", System.Data.DbType.Int32, 4);
            db.ExecuteNonQuery(cmd);
            errorMsg = db.GetParameter(cmd, "@ErrorMsg").Value.ToString();
            return(db.GetParameter(cmd, "@ReturnValue").Value.ToInt() == 1);
        }
Example #3
0
        /// <summary>
        /// 用户注册
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int SystemUsers_Registered(SystemUsers model, out string errorMsg)
        {
            SqlCommand cmd = db.GetStoredProcedureCommand("Proc_SystemUsers_Registered");

            db.AddInputParameter(cmd, "@UserName", DbType.String, model.UserName);
            db.AddInputParameter(cmd, "@UserPassword", DbType.String, model.UserPassword);
            db.AddInputParameter(cmd, "@UserEmail", DbType.String, model.UserEmail);
            db.AddInputParameter(cmd, "@CellPhone", DbType.String, model.CellPhone);
            db.AddInputParameter(cmd, "@CellPahoneIsAuthenticate", DbType.Boolean, model.CellPahoneIsAuthenticate);
            db.AddInputParameter(cmd, "@UserState", DbType.Int32, model.UserState);
            db.AddInputParameter(cmd, "@UserType", DbType.Int32, model.UserType);
            db.AddInputParameter(cmd, "@Recommended", DbType.String, model.Recommended);
            db.AddInputParameter(cmd, "@IsEnterprise", DbType.Int32, model.IsEnterprise);
            db.AddInputParameter(cmd, "@RegTime", DbType.String, model.RegTime);
            db.AddOutputParameter(cmd, "@ErrorMsg", DbType.String, 500);
            db.AddReturnValueParameter(cmd, "@ReturnValue", DbType.Int32, 4);
            db.ExecuteNonQuery(cmd);
            errorMsg = db.GetParameter(cmd, "@ErrorMsg").Value.ToString();
            return(db.GetParameter(cmd, "@ReturnValue").Value.ToInt());
        }
Example #4
0
        /// <summary>
        /// 添加债券明细
        /// </summary>
        /// <param name="userID">用户编号</param>
        /// <param name="claimsID">债券ID</param>
        /// <param name="buyCount">购买数量</param>
        /// <param name="dayEarnings">日结利息</param>
        /// <param name="expireEarnings">预期收益</param>
        /// <param name="IsUserBounty">是否使用虚拟本金</param>
        /// <param name="virtualMoney">虚拟本金数量</param>
        /// <param name="virtualMoneyDayEarnings">虚拟本金日结利息</param>
        /// <param name="errorMsg">错误信息</param>
        /// <param name="targetUserID">扣钱的用户ID</param>
        /// <returns></returns>
        public int SystemClaimsDetails_Add(int userID, int claimsID, int buyCount, decimal dayEarnings, decimal expireEarnings, int IsUserBounty, decimal virtualMoney, decimal virtualMoneyDayEarnings, out string errorMsg, out int targetUserID)
        {
            errorMsg = "";
            SqlCommand cmd = db.GetStoredProcedureCommand("Proc_SystemClaimsDetails_Add");

            db.AddInputParameter(cmd, "@UserID", DbType.Int32, userID);
            db.AddInputParameter(cmd, "@ClaimsID", DbType.Int32, claimsID);
            db.AddInputParameter(cmd, "@BuyCount", DbType.Int32, buyCount);
            db.AddInputParameter(cmd, "@DayEarnings", DbType.Decimal, dayEarnings);
            db.AddInputParameter(cmd, "@ExpireEarnings", DbType.Decimal, expireEarnings);
            db.AddInputParameter(cmd, "@IsUserBounty", DbType.Int32, IsUserBounty);
            db.AddInputParameter(cmd, "@VirtualMoney", DbType.Decimal, virtualMoney);
            db.AddInputParameter(cmd, "@VirtualMoneyDayEarnings", DbType.Decimal, virtualMoneyDayEarnings);
            db.AddOutputParameter(cmd, "@TargetUserID", DbType.Int32, 40);
            db.AddOutputParameter(cmd, "@ErrorMsg", DbType.String, 500);
            db.AddReturnValueParameter(cmd, "@ReturnValue", DbType.Int32, 40);
            db.ExecuteNonQuery(cmd);
            errorMsg     = db.GetParameter(cmd, "@ErrorMsg").Value.ToString();
            targetUserID = db.GetParameter(cmd, "@TargetUserID").Value.ToInt();
            return(db.GetParameter(cmd, "@ReturnValue").Value.ToInt());
        }