public Rain.Model.user_point_log DataRowToModel(DataRow row)
{
Rain.Model.user_point_log userPointLog = new Rain.Model.user_point_log();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
userPointLog.id = int.Parse(row["id"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
userPointLog.user_id = int.Parse(row["user_id"].ToString());
}
if (row["user_name"] != null)
{
userPointLog.user_name = row["user_name"].ToString();
}
if (row["value"] != null && row["value"].ToString() != "")
{
userPointLog.value = int.Parse(row["value"].ToString());
}
if (row["remark"] != null)
{
userPointLog.remark = row["remark"].ToString();
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
userPointLog.add_time = DateTime.Parse(row["add_time"].ToString());
}
}
return(userPointLog);
}
public int Add(Rain.Model.user_point_log model, bool is_upgrade)
{
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("insert into " + this.databaseprefix + "user_point_log(");
stringBuilder1.Append("user_id,user_name,[value],[remark],add_time)");
stringBuilder1.Append(" values (");
stringBuilder1.Append("@user_id,@user_name,@value,@remark,@add_time)");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[5]
{
new OleDbParameter("@user_id", OleDbType.Integer, 4),
new OleDbParameter("@user_name", OleDbType.VarChar, 100),
new OleDbParameter("@value", OleDbType.Integer, 4),
new OleDbParameter("@remark", OleDbType.VarChar, 500),
new OleDbParameter("@add_time", OleDbType.Date)
};
oleDbParameterArray1[0].Value = (object)model.user_id;
oleDbParameterArray1[1].Value = (object)model.user_name;
oleDbParameterArray1[2].Value = (object)model.value;
oleDbParameterArray1[3].Value = (object)model.remark;
oleDbParameterArray1[4].Value = (object)model.add_time;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder1.ToString(), oleDbParameterArray1);
model.id = this.GetMaxId(oleDbConnection, trans);
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("update " + this.databaseprefix + "users set point=point+" + (object)model.value);
if (model.value > 0 && is_upgrade)
{
stringBuilder2.Append(",exp=exp+" + (object)model.value);
}
stringBuilder2.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray2[0].Value = (object)model.user_id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder2.ToString(), oleDbParameterArray2);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(model.id);
}
