/// <summary>
/// 将对象转换为实体
/// </summary>
public Model.user_point_log DataRowToModel(DataRow row)
{
Model.user_point_log model = new Model.user_point_log();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["user_name"] != null)
{
model.user_name = row["user_name"].ToString();
}
if (row["value"] != null && row["value"].ToString() != "")
{
model.value = int.Parse(row["value"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(row["add_time"].ToString());
}
}
return(model);
}
/// <summary>
/// 将对象转换为实体
/// </summary>
public Model.user_point_log DataRowToModel(DataRow row)
{
Model.user_point_log model = new Model.user_point_log();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["user_name"] != null)
{
model.user_name = row["user_name"].ToString();
}
if (row["value"] != null && row["value"].ToString() != "")
{
model.value = int.Parse(row["value"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(row["add_time"].ToString());
}
if (row["order_id"] != null && row["order_id"].ToString() != "")
{
model.order_id = int.Parse(row["order_id"].ToString());
}
if (row["islock"] != null && row["islock"].ToString() != "")
{
model.islock = int.Parse(row["islock"].ToString());
}
if (row["bank"] != null && row["bank"].ToString() != "")
{
model.bank = row["bank"].ToString();
}
if (row["show"] != null && row["show"].ToString() != "")
{
model.show = int.Parse(row["show"].ToString());
}
if (row["admin_id"] != null && row["admin_id"].ToString() != "")
{
model.admin_id = int.Parse(row["admin_id"].ToString());
}
if (row["admin_time"] != null && row["admin_time"].ToString() != "")
{
model.admin_time = DateTime.Parse(row["admin_time"].ToString());
}
if (row["jieyu"] != null && row["jieyu"].ToString() != "")
{
model.jieyu = int.Parse(row["jieyu"].ToString());
}
}
return(model);
}
public int Add(Model.user_point_log model)
{
int result = dal.Add(model);
new Tea.BLL.users().JiSuan(model.user_id);
return(result);
}
/// <summary>
/// 增加积分及检查升级
/// </summary>
/// <param name="user_id">用户ID</param>
/// <param name="user_name">用户名</param>
/// <param name="value">积分值可为正负</param>
/// <param name="remark">备注</param>
/// <param name="is_upgrade">是否检查升级</param>
public int Add(int user_id, string user_name, int value, string remark, bool is_upgrade, int order_id, int islock)
{
Model.user_point_log model = new Model.user_point_log();
model.user_id = user_id;
model.user_name = user_name;
model.value = value;
model.remark = remark;
model.order_id = order_id;
model.islock = islock;
int result = dal.Add(model);
//new Tea.BLL.users().JiSuan(model.user_id);
//int point = new Tea.BLL.users().GetModel(model.user_id).point;
//UpdateField(result, "jieyu=" + point + "");
try
{
//購物金
int all = Utils.StrToInt(Tea.DBUtility.DbHelperSQL.Query("select sum(value) as c from shop_user_point_log where user_id=" + user_id + "").Tables[0].Rows[0][0].ToString(), 0);
new Tea.BLL.users().UpdateField(user_id, "point=" + all + "");
}
catch (Exception eee) { }
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.user_point_log GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder();
Model.user_point_log model = new Model.user_point_log();
//利用反射获得属性的所有公共属性
PropertyInfo[] pros = model.GetType().GetProperties();
foreach (PropertyInfo p in pros)
{
str1.Append(p.Name + ",");//拼接字段
}
strSql.Append("select top 1 " + str1.ToString().Trim(','));
strSql.Append(" from " + databaseprefix + "user_point_log");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
DataTable dt = DbHelperSQL.Query(strSql.ToString(), parameters).Tables[0];
if (dt.Rows.Count > 0)
{
return(DataRowToModel(dt.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 将对象转换为实体
/// </summary>
public Model.user_point_log DataRowToModel(DataRow row)
{
Model.user_point_log model = new Model.user_point_log();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["user_name"] != null)
{
model.user_name = row["user_name"].ToString();
}
if (row["value"] != null && row["value"].ToString() != "")
{
model.value = int.Parse(row["value"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(row["add_time"].ToString());
}
}
return model;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.user_point_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "user_point_log(");
strSql.Append("user_id,user_name,value,remark,add_time,order_id,islock,bank,show,admin_id,admin_time,jieyu)");
strSql.Append(" values (");
strSql.Append("@user_id,@user_name,@value,@remark,@add_time,@order_id,@islock,@bank,@show,@admin_id,@admin_time,@jieyu)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@user_id", SqlDbType.Int, 4),
new SqlParameter("@user_name", SqlDbType.NVarChar, 100),
new SqlParameter("@value", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@ReturnValue", SqlDbType.Int),
new SqlParameter("@order_id", SqlDbType.Int, 4),
new SqlParameter("@islock", SqlDbType.Int, 4),
new SqlParameter("@bank", SqlDbType.NVarChar, 512),
new SqlParameter("@show", SqlDbType.Int, 4),
new SqlParameter("@admin_id", SqlDbType.Int, 4),
new SqlParameter("@admin_time", SqlDbType.DateTime),
new SqlParameter("@jieyu", SqlDbType.Int, 4)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.user_name;
parameters[2].Value = model.value;
parameters[3].Value = model.remark;
parameters[4].Value = model.add_time;
parameters[5].Direction = ParameterDirection.Output;
parameters[6].Value = model.order_id;
parameters[7].Value = model.islock;
parameters[8].Value = model.bank;
parameters[9].Value = model.show;
parameters[10].Value = model.admin_id;
parameters[11].Value = model.admin_time;
parameters[12].Value = model.jieyu;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
//StringBuilder strSql2 = new StringBuilder();
//strSql2.Append("update " + databaseprefix + "users set point=point+" + model.value);
//strSql2.Append(" where id=@id");
//SqlParameter[] parameters2 = {
// new SqlParameter("@id", SqlDbType.Int,4)};
//parameters2[0].Value = model.user_id;
//cmd = new CommandInfo(strSql2.ToString(), parameters2);
//sqllist.Add(cmd);
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[5].Value);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.user_point_log model, bool is_upgrade)
{
using (MySqlConnection conn = new MySqlConnection(DbHelperMySql.connectionString))
{
conn.Open();
using (MySqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "user_point_log(");
strSql.Append("user_id,user_name,value,remark,add_time)");
strSql.Append(" values (");
strSql.Append("@user_id,@user_name,@value,@remark,@add_time)");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_id", MySqlDbType.Int32, 4),
new MySqlParameter("@user_name", MySqlDbType.VarChar, 100),
new MySqlParameter("@value", MySqlDbType.Int32, 4),
new MySqlParameter("@remark", MySqlDbType.VarChar, 500),
new MySqlParameter("@add_time", MySqlDbType.Date)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.user_name;
parameters[2].Value = model.value;
parameters[3].Value = model.remark;
parameters[4].Value = model.add_time;
DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//取得新插入的ID
model.id = GetMaxId(conn, trans);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update " + databaseprefix + "users set point=point+" + model.value);
if (model.value > 0 && is_upgrade)
{
strSql2.Append(",exp=exp+" + model.value);
}
strSql2.Append(" where id=@id");
MySqlParameter[] parameters2 =
{
new MySqlParameter("@id", MySqlDbType.Int32, 4)
};
parameters2[0].Value = model.user_id;
DbHelperMySql.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(model.id);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.user_point_log model, bool is_upgrade)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "user_point_log(");
strSql.Append("user_id,user_name,value,remark,add_time)");
strSql.Append(" values (");
strSql.Append("@user_id,@user_name,@value,@remark,@add_time)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@user_id", SqlDbType.Int, 4),
new SqlParameter("@user_name", SqlDbType.NVarChar, 100),
new SqlParameter("@value", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.user_name;
parameters[2].Value = model.value;
parameters[3].Value = model.remark;
parameters[4].Value = model.add_time;
parameters[5].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update " + databaseprefix + "users set point=point+" + model.value);
if (model.value > 0 && is_upgrade)
{
strSql2.Append(",exp=exp+" + model.value);
}
strSql2.Append(" where id=@id");
SqlParameter[] parameters2 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters2[0].Value = model.user_id;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[5].Value);
}
/// <summary>
/// 增加积分及检查升级
/// </summary>
/// <param name="user_id">用户ID</param>
/// <param name="user_name">用户名</param>
/// <param name="value">积分值可为正负</param>
/// <param name="remark">备注</param>
/// <param name="is_upgrade">是否检查升级</param>
public int Add(int user_id, string user_name, int value, string remark, bool is_upgrade)
{
Model.user_point_log model = new Model.user_point_log();
model.user_id = user_id;
model.user_name = user_name;
model.value = value;
model.remark = remark;
int result = dal.Add(model, is_upgrade);
if (is_upgrade && value > 0 && result > 0)
{
new BLL.users().Upgrade(user_id);
}
return result;
}
/// <summary>
/// 增加积分及检查升级
/// </summary>
/// <param name="user_id">用户ID</param>
/// <param name="user_name">用户名</param>
/// <param name="value">积分值可为正负</param>
/// <param name="remark">备注</param>
/// <param name="is_upgrade">是否检查升级</param>
public int Add(int user_id, string user_name, int value, string remark, bool is_upgrade)
{
Model.user_point_log model = new Model.user_point_log();
model.user_id = user_id;
model.user_name = user_name;
model.value = value;
model.remark = remark;
int result = dal.Add(model, is_upgrade);
if (is_upgrade && value > 0 && result > 0)
{
new BLL.users().Upgrade(user_id);
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.user_point_log GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,user_id,user_name,value,remark,add_time from " + databaseprefix + "user_point_log ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.user_point_log model = new Model.user_point_log();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "")
{
model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "")
{
model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString();
}
if (ds.Tables[0].Rows[0]["value"] != null && ds.Tables[0].Rows[0]["value"].ToString() != "")
{
model.value = int.Parse(ds.Tables[0].Rows[0]["value"].ToString());
}
if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "")
{
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 将对象转换实体
/// </summary>
public Model.user_point_log DataRowToModel(DataRow row)
{
Model.user_point_log model = new Model.user_point_log();
if (row != null)
{
//利用反射获得属性的所有公共属性
Type modelType = model.GetType();
for (int i = 0; i < row.Table.Columns.Count; i++)
{
//查找实体是否存在列表相同的公共属性
PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
if (proInfo != null && row[i] != DBNull.Value)
{
proInfo.SetValue(model, row[i], null);//用索引值设置属性值
}
}
}
return(model);
}
/// <summary>
/// 确认充值
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static bool ConfirmRecharge(string ID, int PayType)
{
user_point_log bll = new user_point_log("dt_");
Model.user_point_log model = bll.GetModelrechargeno(ID);
users bll1 = new users("dt_");
Model.users model1 = bll1.GetModel(model.user_id);
if (model.status == 2 || model.pointtype == 2)
{
return(false);
}
//积分表
model.status = PayType;
model.add_time = DateTime.Now;
//用户表
model1.amount += model.amount;
if (bll.Update(model) && bll1.Update(model1))
{
return(true);
}
return(false);
}
/// <summary>
/// 更新数据
/// </summary>
public bool Update(Model.user_point_log model)
{
return(dal.Update(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.user_point_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "user_point_log set ");
strSql.Append("order_no=@order_no,");
strSql.Append("user_id=@user_id,");
strSql.Append("user_name=@user_name,");
strSql.Append("remark=@remark,");
strSql.Append("pointtype=@pointtype,");
strSql.Append("status=@status,");
strSql.Append("add_time=@add_time,");
strSql.Append("value=@value,");
strSql.Append("reason=@reason,");
strSql.Append("order_status=@order_status,");
strSql.Append("refund_no=@refund_no");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@order_no", SqlDbType.NVarChar, 100),
new SqlParameter("@user_id", SqlDbType.Int, 4),
new SqlParameter("@user_name", SqlDbType.NVarChar, 100),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@pointtype", SqlDbType.Int, 4),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@value", SqlDbType.Int, 4),
new SqlParameter("@reason", SqlDbType.NVarChar, 500),
new SqlParameter("@order_status", SqlDbType.Int, 4),
new SqlParameter("@refund_no", SqlDbType.NVarChar, 100),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.order_no;
parameters[1].Value = model.user_id;
parameters[2].Value = model.user_name;
parameters[3].Value = model.remark;
parameters[4].Value = model.pointtype;
parameters[5].Value = model.status;
parameters[6].Value = model.add_time;
parameters[7].Value = model.value;
parameters[8].Value = model.reason;
parameters[9].Value = model.order_status;
parameters[10].Value = model.refund_no;
parameters[11].Value = model.id;
try
{
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 添加充值记录
/// </summary>
/// <returns></returns>
public int Addrecharge(Model.user_point_log model, bool is_upgrade)
{
return(dal.Add(model, is_upgrade));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.user_point_log model, bool is_upgrade)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.ConnectionString))
{
conn.Open();//打开数据连接
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
#region 主表信息==========================
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder(); //数据字段
StringBuilder str2 = new StringBuilder(); //数据参数
//利用反射获得属性的所有公共属性
PropertyInfo[] pros = model.GetType().GetProperties();
List <SqlParameter> paras = new List <SqlParameter>();
strSql.Append("insert into " + databaseprefix + "user_point_log(");
foreach (PropertyInfo pi in pros)
{
//如果不是主键则追加sql字符串
if (!pi.Name.Equals("id"))
{
//判断属性值是否为空
if (pi.GetValue(model, null) != null)
{
str1.Append(pi.Name + ","); //拼接字段
str2.Append("@" + pi.Name + ","); //声明参数
paras.Add(new SqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值
}
}
}
strSql.Append(str1.ToString().Trim(','));
strSql.Append(") values (");
strSql.Append(str2.ToString().Trim(','));
strSql.Append(") ");
strSql.Append(";select @@IDENTITY;");
object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), paras.ToArray());//带事务
model.id = Convert.ToInt32(obj);
#endregion
#region 用户表信息========================
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("update " + databaseprefix + "users set point=point+" + model.value);
if (model.value > 0 && is_upgrade)
{
strSql1.Append(",exp=exp+" + model.value);
}
strSql1.Append(" where id=@id");
SqlParameter[] parameters1 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters1[0].Value = model.user_id;
DbHelperSQL.ExecuteSql(conn, trans, strSql1.ToString(), parameters1);
#endregion
trans.Commit();//提交事务
}
catch
{
trans.Rollback();//回滚事务
return(0);
}
}
}
return(model.id);
}
/// <summary>
/// 得到一个对象实体(通过充值单号)
/// </summary>
public Model.user_point_log GetModelrechargeno(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,user_id,user_name,value,remark,add_time,order_no,pointtype,status,amount from " + databaseprefix + "user_point_log ");
strSql.Append(" where order_no=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.NVarChar, 100)
};
parameters[0].Value = id;
Model.user_point_log model = new Model.user_point_log();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "")
{
model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "")
{
model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString();
}
if (ds.Tables[0].Rows[0]["value"] != null && ds.Tables[0].Rows[0]["value"].ToString() != "")
{
model.value = int.Parse(ds.Tables[0].Rows[0]["value"].ToString());
}
if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "")
{
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
if (ds.Tables[0].Rows[0]["order_no"] != null && ds.Tables[0].Rows[0]["order_no"].ToString() != "")
{
model.order_no = ds.Tables[0].Rows[0]["order_no"].ToString();
}
if (ds.Tables[0].Rows[0]["pointtype"] != null && ds.Tables[0].Rows[0]["pointtype"].ToString() != "")
{
model.pointtype = int.Parse(ds.Tables[0].Rows[0]["pointtype"].ToString());
}
if (ds.Tables[0].Rows[0]["status"] != null && ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
if (ds.Tables[0].Rows[0]["amount"] != null && ds.Tables[0].Rows[0]["amount"].ToString() != "")
{
model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.user_point_log GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,user_id,user_name,value,remark,add_time from " + databaseprefix + "user_point_log ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
Model.user_point_log model = new Model.user_point_log();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "")
{
model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "")
{
model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString();
}
if (ds.Tables[0].Rows[0]["value"] != null && ds.Tables[0].Rows[0]["value"].ToString() != "")
{
model.value = int.Parse(ds.Tables[0].Rows[0]["value"].ToString());
}
if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "")
{
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
return model;
}
else
{
return null;
}
}
