Example #1
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public VipSoft.Model.RechargeLog DataRowToModel(DataRow row)
 {
     VipSoft.Model.RechargeLog model=new VipSoft.Model.RechargeLog();
     if (row != null)
     {
         if(row["ID"]!=null && row["ID"].ToString()!="")
         {
             model.ID=int.Parse(row["ID"].ToString());
         }
         if(row["MemID"]!=null && row["MemID"].ToString()!="")
         {
             model.MemID=int.Parse(row["MemID"].ToString());
         }
         if(row["CardID"]!=null)
         {
             model.CardID=row["CardID"].ToString();
         }
         if(row["MemName"]!=null)
         {
             model.MemName=row["MemName"].ToString();
         }
         if(row["Type"]!=null && row["Type"].ToString()!="")
         {
             model.Type=int.Parse(row["Type"].ToString());
         }
         if(row["Money"]!=null && row["Money"].ToString()!="")
         {
             model.Money=decimal.Parse(row["Money"].ToString());
         }
         if(row["GiveMoney"]!=null && row["GiveMoney"].ToString()!="")
         {
             model.GiveMoney=decimal.Parse(row["GiveMoney"].ToString());
         }
         if(row["MasterID"]!=null && row["MasterID"].ToString()!="")
         {
             model.MasterID=int.Parse(row["MasterID"].ToString());
         }
         if(row["MasterName"]!=null)
         {
             model.MasterName=row["MasterName"].ToString();
         }
         if(row["ShopID"]!=null && row["ShopID"].ToString()!="")
         {
             model.ShopID=int.Parse(row["ShopID"].ToString());
         }
         if(row["ShopName"]!=null)
         {
             model.ShopName=row["ShopName"].ToString();
         }
         if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
         {
             model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
         }
         if (row["Remark"] != null)
         {
             model.Remark = row["Remark"].ToString();
         }
     }
     return model;
 }
Example #2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(VipSoft.Model.RechargeLog model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update RechargeLog set ");
            strSql.Append("MemID=@MemID,");
            strSql.Append("CardID=@CardID,");
            strSql.Append("MemName=@MemName,");
            strSql.Append("Type=@Type,");
            strSql.Append("Money=@Money,");
            strSql.Append("GiveMoney=@GiveMoney,");
            strSql.Append("MasterID=@MasterID,");
            strSql.Append("MasterName=@MasterName,");
            strSql.Append("ShopID=@ShopID,");
            strSql.Append("ShopName=@ShopName");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@MemID",      SqlDbType.Int,      4),
                new SqlParameter("@CardID",     SqlDbType.VarChar, 50),
                new SqlParameter("@MemName",    SqlDbType.VarChar, 50),
                new SqlParameter("@Type",       SqlDbType.Int,      4),
                new SqlParameter("@Money",      SqlDbType.Money,    8),
                new SqlParameter("@GiveMoney",  SqlDbType.Money,    8),
                new SqlParameter("@MasterID",   SqlDbType.Int,      4),
                new SqlParameter("@MasterName", SqlDbType.VarChar, 50),
                new SqlParameter("@ShopID",     SqlDbType.Int,      4),
                new SqlParameter("@ShopName",   SqlDbType.VarChar, 50),
                new SqlParameter("@ID",         SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.MemID;
            parameters[1].Value  = model.CardID;
            parameters[2].Value  = model.MemName;
            parameters[3].Value  = model.Type;
            parameters[4].Value  = model.Money;
            parameters[5].Value  = model.GiveMoney;
            parameters[6].Value  = model.MasterID;
            parameters[7].Value  = model.MasterName;
            parameters[8].Value  = model.ShopID;
            parameters[9].Value  = model.ShopName;
            parameters[10].Value = model.ID;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #3
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public VipSoft.Model.RechargeLog DataRowToModel(DataRow row)
 {
     VipSoft.Model.RechargeLog model = new VipSoft.Model.RechargeLog();
     if (row != null)
     {
         if (row["ID"] != null && row["ID"].ToString() != "")
         {
             model.ID = int.Parse(row["ID"].ToString());
         }
         if (row["MemID"] != null && row["MemID"].ToString() != "")
         {
             model.MemID = int.Parse(row["MemID"].ToString());
         }
         if (row["CardID"] != null)
         {
             model.CardID = row["CardID"].ToString();
         }
         if (row["MemName"] != null)
         {
             model.MemName = row["MemName"].ToString();
         }
         if (row["Type"] != null && row["Type"].ToString() != "")
         {
             model.Type = int.Parse(row["Type"].ToString());
         }
         if (row["Money"] != null && row["Money"].ToString() != "")
         {
             model.Money = decimal.Parse(row["Money"].ToString());
         }
         if (row["GiveMoney"] != null && row["GiveMoney"].ToString() != "")
         {
             model.GiveMoney = decimal.Parse(row["GiveMoney"].ToString());
         }
         if (row["MasterID"] != null && row["MasterID"].ToString() != "")
         {
             model.MasterID = int.Parse(row["MasterID"].ToString());
         }
         if (row["MasterName"] != null)
         {
             model.MasterName = row["MasterName"].ToString();
         }
         if (row["ShopID"] != null && row["ShopID"].ToString() != "")
         {
             model.ShopID = int.Parse(row["ShopID"].ToString());
         }
         if (row["ShopName"] != null)
         {
             model.ShopName = row["ShopName"].ToString();
         }
     }
     return(model);
 }
Example #4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VipSoft.Model.RechargeLog model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into RechargeLog(");
            strSql.Append("MemID,CardID,MemName,Type,Money,GiveMoney,MasterID,MasterName,ShopID,ShopName)");
            strSql.Append(" values (");
            strSql.Append("@MemID,@CardID,@MemName,@Type,@Money,@GiveMoney,@MasterID,@MasterName,@ShopID,@ShopName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@MemID",      SqlDbType.Int,      4),
                new SqlParameter("@CardID",     SqlDbType.VarChar, 50),
                new SqlParameter("@MemName",    SqlDbType.VarChar, 50),
                new SqlParameter("@Type",       SqlDbType.Int,      4),
                new SqlParameter("@Money",      SqlDbType.Money,    8),
                new SqlParameter("@GiveMoney",  SqlDbType.Money,    8),
                new SqlParameter("@MasterID",   SqlDbType.Int,      4),
                new SqlParameter("@MasterName", SqlDbType.VarChar, 50),
                new SqlParameter("@ShopID",     SqlDbType.Int,      4),
                new SqlParameter("@ShopName",   SqlDbType.VarChar, 50)
            };
            parameters[0].Value = model.MemID;
            parameters[1].Value = model.CardID;
            parameters[2].Value = model.MemName;
            parameters[3].Value = model.Type;
            parameters[4].Value = model.Money;
            parameters[5].Value = model.GiveMoney;
            parameters[6].Value = model.MasterID;
            parameters[7].Value = model.MasterName;
            parameters[8].Value = model.ShopID;
            parameters[9].Value = model.ShopName;

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

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

            strSql.Append("select  top 1 ID,MemID,CardID,MemName,Type,Money,GiveMoney,MasterID,MasterName,ShopID,ShopName from RechargeLog ");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID", SqlDbType.Int, 4)
            };
            parameters[0].Value = ID;

            VipSoft.Model.RechargeLog model = new VipSoft.Model.RechargeLog();
            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 #6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public VipSoft.Model.RechargeLog GetModel(int ID)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 ID,MemID,CardID,MemName,Type,Money,GiveMoney,CreateTime,Remark,MasterID,MasterName,ShopID,ShopName from RechargeLog ");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters = {
                    new SqlParameter("@ID", SqlDbType.Int,4)
            };
            parameters[0].Value = ID;

            VipSoft.Model.RechargeLog model=new VipSoft.Model.RechargeLog();
            DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }