protected virtual Channel_UserRow MapRow(DataRow row) { Channel_UserRow mappedObject = new Channel_UserRow(); DataTable dataTable = row.Table; DataColumn dataColumn; // Column "CU_ID" dataColumn = dataTable.Columns["CU_ID"]; if (!row.IsNull(dataColumn)) { mappedObject.CU_ID = (int)row[dataColumn]; } // Column "User_ID" dataColumn = dataTable.Columns["User_ID"]; if (!row.IsNull(dataColumn)) { mappedObject.User_ID = (string)row[dataColumn]; } // Column "Channel_ID" dataColumn = dataTable.Columns["Channel_ID"]; if (!row.IsNull(dataColumn)) { mappedObject.Channel_ID = (int)row[dataColumn]; } return(mappedObject); }
public virtual bool Update(Channel_UserRow value) { string sqlStr = "UPDATE [dbo].[Channel_User] SET " + "[User_ID]=" + _db.CreateSqlParameterName("User_ID") + ", " + "[Channel_ID]=" + _db.CreateSqlParameterName("Channel_ID") + " WHERE " + "[CU_ID]=" + _db.CreateSqlParameterName("CU_ID"); IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "User_ID", value.User_ID); AddParameter(cmd, "Channel_ID", value.IsChannel_IDNull ? DBNull.Value : (object)value.Channel_ID); AddParameter(cmd, "CU_ID", value.CU_ID); return(0 != cmd.ExecuteNonQuery()); }
public virtual void Insert(Channel_UserRow value) { string sqlStr = "INSERT INTO [dbo].[Channel_User] (" + "[User_ID], " + "[Channel_ID]" + ") VALUES (" + _db.CreateSqlParameterName("User_ID") + ", " + _db.CreateSqlParameterName("Channel_ID") + ");SELECT @@IDENTITY"; IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "User_ID", value.User_ID); AddParameter(cmd, "Channel_ID", value.IsChannel_IDNull ? DBNull.Value : (object)value.Channel_ID); value.CU_ID = Convert.ToInt32(cmd.ExecuteScalar()); }
protected virtual Channel_UserRow[] MapRecords(IDataReader reader, int startIndex, int length, ref int totalRecordCount) { if (0 > startIndex) { throw new ArgumentOutOfRangeException("startIndex", startIndex, "StartIndex cannot be less than zero."); } if (0 > length) { throw new ArgumentOutOfRangeException("length", length, "Length cannot be less than zero."); } int cu_idColumnIndex = reader.GetOrdinal("CU_ID"); int user_IDColumnIndex = reader.GetOrdinal("User_ID"); int channel_IDColumnIndex = reader.GetOrdinal("Channel_ID"); System.Collections.ArrayList recordList = new System.Collections.ArrayList(); int ri = -startIndex; while (reader.Read()) { ri++; if (ri > 0 && ri <= length) { Channel_UserRow record = new Channel_UserRow(); recordList.Add(record); record.CU_ID = Convert.ToInt32(reader.GetValue(cu_idColumnIndex)); if (!reader.IsDBNull(user_IDColumnIndex)) { record.User_ID = Convert.ToString(reader.GetValue(user_IDColumnIndex)); } if (!reader.IsDBNull(channel_IDColumnIndex)) { record.Channel_ID = Convert.ToInt32(reader.GetValue(channel_IDColumnIndex)); } if (ri == length && 0 != totalRecordCount) { break; } } } totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1; return((Channel_UserRow[])(recordList.ToArray(typeof(Channel_UserRow)))); }
public bool Delete(Channel_UserRow value) { return(DeleteByPrimaryKey(value.CU_ID)); }