Example #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(HQ.Model.RebatesModel model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into HQ_Rebates(");
            strSql.Append("UserId,RebateType,FlowMoney,FinalMoney,CreateTime,LastModify,RebateDesc,ContribUserId,SettleStatus,ContribDepth,OrderId,AgentId,PlatType)");
            strSql.Append(" values (");
            strSql.Append("@UserId,@RebateType,@FlowMoney,@FinalMoney,@CreateTime,@LastModify,@RebateDesc,@ContribUserId,@SettleStatus,@ContribDepth,@OrderId,@AgentId,@PlatType)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserId",        SqlDbType.Int,         4),
                new SqlParameter("@RebateType",    SqlDbType.SmallInt,    2),
                new SqlParameter("@FlowMoney",     SqlDbType.Decimal,     5),
                new SqlParameter("@FinalMoney",    SqlDbType.Decimal,     5),
                new SqlParameter("@CreateTime",    SqlDbType.DateTime),
                new SqlParameter("@LastModify",    SqlDbType.DateTime),
                new SqlParameter("@RebateDesc",    SqlDbType.VarChar,   400),
                new SqlParameter("@ContribUserId", SqlDbType.Int,         4),
                new SqlParameter("@SettleStatus",  SqlDbType.SmallInt,    2),
                new SqlParameter("@ContribDepth",  SqlDbType.SmallInt,    2),
                new SqlParameter("@OrderId",       SqlDbType.VarChar,    30),
                new SqlParameter("@AgentId",       SqlDbType.Int,         4),
                new SqlParameter("@PlatType",      SqlDbType.SmallInt, 2)
            };
            parameters[0].Value  = model.UserId;
            parameters[1].Value  = model.RebateType;
            parameters[2].Value  = model.FlowMoney;
            parameters[3].Value  = model.FinalMoney;
            parameters[4].Value  = model.CreateTime;
            parameters[5].Value  = model.LastModify;
            parameters[6].Value  = model.RebateDesc;
            parameters[7].Value  = model.ContribUserId;
            parameters[8].Value  = model.SettleStatus;
            parameters[9].Value  = model.ContribDepth;
            parameters[10].Value = model.OrderId;
            parameters[11].Value = model.AgentId;
            parameters[12].Value = model.PlatType;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Example #2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public HQ.Model.RebatesModel GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 * from HQ_Rebates ");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Id", SqlDbType.Int, 4)
            };
            parameters[0].Value = Id;

            HQ.Model.RebatesModel model = new HQ.Model.RebatesModel();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Example #3
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(HQ.Model.RebatesModel model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update HQ_Rebates set ");
            strSql.Append("UserId=@UserId,");
            strSql.Append("RebateType=@RebateType,");
            strSql.Append("FlowMoney=@FlowMoney,");
            strSql.Append("FinalMoney=@FinalMoney,");
            strSql.Append("CreateTime=@CreateTime,");
            strSql.Append("LastModify=@LastModify,");
            strSql.Append("RebateDesc=@RebateDesc,");
            strSql.Append("ContribUserId=@ContribUserId,");
            strSql.Append("SettleStatus=@SettleStatus,");
            strSql.Append("ContribDepth=@ContribDepth,");
            strSql.Append("OrderId=@OrderId,");
            strSql.Append("AgentId=@AgentId,");
            strSql.Append("PlatType=@PlatType");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserId",        SqlDbType.Int,         4),
                new SqlParameter("@RebateType",    SqlDbType.SmallInt,    2),
                new SqlParameter("@FlowMoney",     SqlDbType.Decimal,     5),
                new SqlParameter("@FinalMoney",    SqlDbType.Decimal,     5),
                new SqlParameter("@CreateTime",    SqlDbType.DateTime),
                new SqlParameter("@LastModify",    SqlDbType.DateTime),
                new SqlParameter("@RebateDesc",    SqlDbType.VarChar,   400),
                new SqlParameter("@ContribUserId", SqlDbType.Int,         4),
                new SqlParameter("@SettleStatus",  SqlDbType.SmallInt,    2),
                new SqlParameter("@ContribDepth",  SqlDbType.SmallInt,    2),
                new SqlParameter("@OrderId",       SqlDbType.VarChar,    30),
                new SqlParameter("@AgentId",       SqlDbType.Int,         4),
                new SqlParameter("@PlatType",      SqlDbType.SmallInt,    2),
                new SqlParameter("@Id",            SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.UserId;
            parameters[1].Value  = model.RebateType;
            parameters[2].Value  = model.FlowMoney;
            parameters[3].Value  = model.FinalMoney;
            parameters[4].Value  = model.CreateTime;
            parameters[5].Value  = model.LastModify;
            parameters[6].Value  = model.RebateDesc;
            parameters[7].Value  = model.ContribUserId;
            parameters[8].Value  = model.SettleStatus;
            parameters[9].Value  = model.ContribDepth;
            parameters[10].Value = model.OrderId;
            parameters[11].Value = model.AgentId;
            parameters[12].Value = model.PlatType;
            parameters[13].Value = model.Id;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #4
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public HQ.Model.RebatesModel DataRowToModel(DataRow row)
 {
     HQ.Model.RebatesModel model = new HQ.Model.RebatesModel();
     if (row != null)
     {
         if (row["Id"] != null && row["Id"].ToString() != "")
         {
             model.Id = int.Parse(row["Id"].ToString());
         }
         if (row["UserId"] != null && row["UserId"].ToString() != "")
         {
             model.UserId = int.Parse(row["UserId"].ToString());
         }
         if (row["RebateType"] != null && row["RebateType"].ToString() != "")
         {
             model.RebateType = int.Parse(row["RebateType"].ToString());
         }
         if (row["FlowMoney"] != null && row["FlowMoney"].ToString() != "")
         {
             model.FlowMoney = decimal.Parse(row["FlowMoney"].ToString());
         }
         if (row["FinalMoney"] != null && row["FinalMoney"].ToString() != "")
         {
             model.FinalMoney = decimal.Parse(row["FinalMoney"].ToString());
         }
         if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
         {
             model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
         }
         if (row["LastModify"] != null && row["LastModify"].ToString() != "")
         {
             model.LastModify = DateTime.Parse(row["LastModify"].ToString());
         }
         if (row["RebateDesc"] != null)
         {
             model.RebateDesc = row["RebateDesc"].ToString();
         }
         if (row["ContribUserId"] != null && row["ContribUserId"].ToString() != "")
         {
             model.ContribUserId = int.Parse(row["ContribUserId"].ToString());
         }
         if (row["SettleStatus"] != null && row["SettleStatus"].ToString() != "")
         {
             model.SettleStatus = int.Parse(row["SettleStatus"].ToString());
         }
         if (row["ContribDepth"] != null && row["ContribDepth"].ToString() != "")
         {
             model.ContribDepth = int.Parse(row["ContribDepth"].ToString());
         }
         if (row["OrderId"] != null)
         {
             model.OrderId = row["OrderId"].ToString();
         }
         if (row["AgentId"] != null && row["AgentId"].ToString() != "")
         {
             model.AgentId = int.Parse(row["AgentId"].ToString());
         }
         if (row["PlatType"] != null && row["PlatType"].ToString() != "")
         {
             model.PlatType = int.Parse(row["PlatType"].ToString());
         }
     }
     return(model);
 }