public EasyOne.Model.UserManage.UserPointLogInfo GetPointLogById(int logId) { using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT * FROM PE_PointLog WHERE LogID = @LogID", new Parameters("@LogID", DbType.String, logId))) { if (reader.Read()) { EasyOne.Model.UserManage.UserPointLogInfo info = UserPointLogInfo(reader); info.Memo = reader.GetString("Memo"); return(info); } return(new EasyOne.Model.UserManage.UserPointLogInfo(true)); } }
private static EasyOne.Model.UserManage.UserPointLogInfo UserPointLogInfo(NullableDataReader rdr) { EasyOne.Model.UserManage.UserPointLogInfo info = new EasyOne.Model.UserManage.UserPointLogInfo(); info.LogId = rdr.GetInt32("LogID"); info.UserName = rdr.GetString("UserName"); info.ModuleType = rdr.GetInt32("ModuleType"); info.InfoId = rdr.GetInt32("InfoID"); info.Point = rdr.GetInt32("Point"); info.LogTime = rdr.GetDateTime("LogTime"); info.Times = rdr.GetInt32("Times"); info.IncomePayOut = rdr.GetInt32("IncomePayOut"); info.Remark = rdr.GetString("Remark"); info.IP = rdr.GetString("IP"); info.Inputer = rdr.GetString("Inputer"); return(info); }
public EasyOne.Model.UserManage.UserPointLogInfo GetPointLogByIdAndUserName(int logId, string userName) { string strSql = "SELECT * FROM PE_PointLog WHERE LogID = @LogID AND UserName = @UserName"; Parameters cmdParams = new Parameters("@LogID", DbType.Int32, logId); cmdParams.AddInParameter("@UserName", DbType.String, userName); using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams)) { if (reader.Read()) { EasyOne.Model.UserManage.UserPointLogInfo info = UserPointLogInfo(reader); info.Memo = reader.GetString("Memo"); return(info); } return(new EasyOne.Model.UserManage.UserPointLogInfo(true)); } }
private static Parameters GetProcdbComm(EasyOne.Model.UserManage.UserPointLogInfo userPointLogInfo) { Parameters parameters = new Parameters(); parameters.AddInParameter("@LogID", DbType.Int32, userPointLogInfo.LogId); parameters.AddInParameter("@UserName", DbType.String, userPointLogInfo.UserName); parameters.AddInParameter("@ModuleType", DbType.Int32, userPointLogInfo.ModuleType); parameters.AddInParameter("@InfoID", DbType.Int32, userPointLogInfo.InfoId); parameters.AddInParameter("@Point", DbType.Int32, userPointLogInfo.Point); parameters.AddInParameter("@LogTime", DbType.DateTime, userPointLogInfo.LogTime); parameters.AddInParameter("@Times", DbType.Int32, userPointLogInfo.Times); parameters.AddInParameter("@IncomePayOut", DbType.Int32, userPointLogInfo.IncomePayOut); parameters.AddInParameter("@Remark", DbType.String, userPointLogInfo.Remark); parameters.AddInParameter("@IP", DbType.String, userPointLogInfo.IP); parameters.AddInParameter("@Inputer", DbType.String, userPointLogInfo.Inputer); parameters.AddInParameter("@Memo", DbType.String, userPointLogInfo.Memo); return(parameters); }
public bool Add(EasyOne.Model.UserManage.UserPointLogInfo userPointLogInfo) { return(DBHelper.ExecuteProc("PR_UserManage_UserPointLog_Add", GetProcdbComm(userPointLogInfo))); }