Exemplo n.º 1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Add(Tz888.Model.ConsumeRepay model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserName",      SqlDbType.VarChar,  30),
                new SqlParameter("@RepayWay",      SqlDbType.VarChar,  20),
                new SqlParameter("@RepayMoney",    SqlDbType.Float,     8),
                new SqlParameter("@RepayStatus",   SqlDbType.Int,       4),
                new SqlParameter("@CreateDate",    SqlDbType.DateTime,  8),
                new SqlParameter("@AuditMan",      SqlDbType.VarChar,  30),
                new SqlParameter("@RepayDate",     SqlDbType.DateTime,  8),
                new SqlParameter("@AuditStatus",   SqlDbType.Int,       4),
                new SqlParameter("@AuditDescript", SqlDbType.Text),
                new SqlParameter("@flag",          SqlDbType.VarChar,  30),
            };
            parameters[0].Value = model.UserName;
            parameters[1].Value = model.RepayWay;
            parameters[2].Value = model.RepayMoney;
            parameters[3].Value = model.RepayStatus;
            parameters[4].Value = model.Createdate;
            parameters[5].Value = model.AuditMan;
            parameters[6].Value = model.RepayDate;
            parameters[7].Value = model.AuditStatus;
            parameters[8].Value = model.AuditDescript;
            parameters[9].Value = "Insert";
            bool b = DbHelperSQL.RunProcLob("ConsumeRepayInfo", parameters);

            return(b);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 审核
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Update(Tz888.Model.ConsumeRepay model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@RepayID",       SqlDbType.Int,       4),
                new SqlParameter("@AuditMan",      SqlDbType.VarChar,  30),
                new SqlParameter("@AuditStatus",   SqlDbType.Int,       4),
                new SqlParameter("@AuditDescript", SqlDbType.Text),
                new SqlParameter("@RepayDate",     SqlDbType.DateTime,  8),
                new SqlParameter("@flag",          SqlDbType.VarChar,  30),
            };
            parameters[0].Value = model.RepayID;
            parameters[1].Value = model.AuditMan;
            parameters[2].Value = model.AuditStatus;
            parameters[3].Value = model.AuditDescript;
            parameters[4].Value = model.RepayDate;
            parameters[5].Value = "Update";
            bool b = DbHelperSQL.RunProcLob("ConsumeRepayInfo", parameters);

            return(b);
        }