public PidUsingInformation Query(Guid userId) { PidUsingInformation pidUsingInfo = null; const string sql = @"SELECT UserId, FromDate , ThruDate, Total FROM T_PidUsingInfo " + @"WHERE UserId = @UserId"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("UserId", userId); using (var reader = dbOperator.ExecuteReader(sql)) { if (reader.Read()) { var id = reader.GetGuid(0); var fromDate = reader.GetDateTime(1); var thruDate = reader.GetDateTime(2); var total = reader.GetInt64(3); pidUsingInfo = new PidUsingInformation { UserId = id, FromDate = fromDate, ThruDate = thruDate, Total = total }; } } } return(pidUsingInfo); }
public int Update(PidUsingInformation pidUsingInfo) { const string sql = @"UPDATE dbo.T_PidUsingInfo " + "SET FromDate = @FromDate, ThruDate = @ThruDate, Total = @Total " + "WHERE UserId = @UserId; "; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("UserId", pidUsingInfo.UserId); dbOperator.AddParameter("FromDate", pidUsingInfo.FromDate); dbOperator.AddParameter("ThruDate", pidUsingInfo.ThruDate); dbOperator.AddParameter("Total", pidUsingInfo.Total); return(dbOperator.ExecuteNonQuery(sql)); } }
public int Insert(PidUsingInformation pidUsingInfo) { const string sql = @"INSERT INTO dbo.T_PidUsingInfo(UserId, FromDate, ThruDate, Total) " + "VALUES (@UserId, @FromDate, @ThruDate, @Total)"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("UserId", pidUsingInfo.UserId); dbOperator.AddParameter("FromDate", pidUsingInfo.FromDate); dbOperator.AddParameter("ThruDate", pidUsingInfo.ThruDate); dbOperator.AddParameter("Total", pidUsingInfo.Total); return(dbOperator.ExecuteNonQuery(sql)); } }