/// <summary>
/// Copies the elements of the specified <see cref="AttachPaymentlogInfo">AttachPaymentlogInfo</see> array to the end of the collection.
/// </summary>
/// <param name="value">An array of type <see cref="AttachPaymentlogInfo">AttachPaymentlogInfo</see> containing the Components to add to the collection.</param>
public void AddRange(AttachPaymentlogInfo[] value)
{
for (int i = 0; (i < value.Length); i = (i + 1))
{
this.Add(value[i]);
}
}
/// <summary>
/// 加载单个实体对象
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private static AttachPaymentlogInfo LoadSingleAttachPaymentlogInfo(IDataReader reader)
{
AttachPaymentlogInfo attachPaymentlogInfo = new AttachPaymentlogInfo();
attachPaymentlogInfo.Id = TypeConverter.ObjectToInt(reader["id"]);
attachPaymentlogInfo.Uid = TypeConverter.ObjectToInt(reader["uid"]);
attachPaymentlogInfo.UserName = reader["username"].ToString().Trim();
attachPaymentlogInfo.Aid = TypeConverter.ObjectToInt(reader["aid"]);
attachPaymentlogInfo.Authorid = TypeConverter.ObjectToInt(reader["authorid"]);
attachPaymentlogInfo.PostDateTime = Convert.ToDateTime(reader["postdatetime"]);
attachPaymentlogInfo.Amount = TypeConverter.ObjectToInt(reader["amount"]);
attachPaymentlogInfo.NetAmount = TypeConverter.ObjectToInt(reader["netamount"]);
return attachPaymentlogInfo;
}
/// <summary>
/// 更新的附件交易信息
/// </summary>
/// <param name="attachPaymentLogInfo">要更新的附件交易信息</param>
/// <returns></returns>
public static int UpdateAttachPaymetLog(AttachPaymentlogInfo attachPaymentLogInfo)
{
return DatabaseProvider.GetInstance().UpdateAttachPaymetLog(attachPaymentLogInfo);
}
/// <summary>
/// Gets a value indicating whether the collection contains the specified <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see>.
/// </summary>
/// <param name="value">The <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see> to search for in the collection.</param>
/// <returns><b>true</b> if the collection contains the specified object; otherwise, <b>false</b>.</returns>
public bool Contains(AttachPaymentlogInfo value)
{
return(this.List.Contains(value));
}
public int Add(AttachPaymentlogInfo value)
{
return(this.List.Add(value));
}
public void Remove(AttachPaymentlogInfo value)
{
List.Remove(value);
}
public void Insert(int index, AttachPaymentlogInfo value)
{
List.Insert(index, value);
}
/// <summary>
/// Gets the index in the collection of the specified <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see>, if it exists in the collection.
/// </summary>
/// <param name="value">The <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see> to locate in the collection.</param>
/// <returns>The index in the collection of the specified object, if found; otherwise, -1.</returns>
public int IndexOf(AttachPaymentlogInfo value)
{
return this.List.IndexOf(value);
}
public int CreateAttachPaymetLog(AttachPaymentlogInfo attachPaymentLogInfo)
{
DbParameter[] parms = {
DbHelper.MakeInParam("@uid",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Uid),
DbHelper.MakeInParam("@username",(DbType)SqlDbType.NChar, 20, attachPaymentLogInfo.UserName),
DbHelper.MakeInParam("@postdatetime",(DbType)SqlDbType.DateTime, 8, attachPaymentLogInfo.PostDateTime),
DbHelper.MakeInParam("@amount",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Amount),
DbHelper.MakeInParam("@netamount",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.NetAmount),
DbHelper.MakeInParam("@aid",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Aid),
DbHelper.MakeInParam("@authorid",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Authorid)
};
string commandText = string.Format("INSERT INTO [{0}attachpaymentlog] ([uid],[postdatetime],[username],[amount],[netamount],[aid],[authorid]) VALUES (@uid,@postdatetime,@username,@amount,@netamount,@aid,@authorid);SELECT SCOPE_IDENTITY()",
BaseConfigs.GetTablePrefix);
return DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// Gets a value indicating whether the collection contains the specified <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see>.
/// </summary>
/// <param name="value">The <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see> to search for in the collection.</param>
/// <returns><b>true</b> if the collection contains the specified object; otherwise, <b>false</b>.</returns>
public bool Contains(AttachPaymentlogInfo value)
{
return this.List.Contains(value);
}
public int Add(AttachPaymentlogInfo value)
{
return this.List.Add(value);
}
/// <summary>
/// Initializes a new instance of the <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see> class containing the specified array of <see cref="AttachPaymentlogInfo">AttachPaymentlogInfo</see> Components.
/// </summary>
/// <param name="value">An array of <see cref="AttachPaymentlogInfo">AttachPaymentlogInfo</see> Components with which to initialize the collection. </param>
public AttachPaymentlogInfoCollection(AttachPaymentlogInfo[] value)
{
this.AddRange(value);
}
public void Remove(AttachPaymentlogInfo value)
{
List.Remove(value);
}
public void Insert(int index, AttachPaymentlogInfo value)
{
List.Insert(index, value);
}
/// <summary>
/// Copies the collection Components to a one-dimensional <see cref="T:System.Array">Array</see> instance beginning at the specified index.
/// </summary>
/// <param name="array">The one-dimensional <see cref="T:System.Array">Array</see> that is the destination of the values copied from the collection.</param>
/// <param name="index">The index of the array at which to begin inserting.</param>
public void CopyTo(AttachPaymentlogInfo[] array, int index)
{
this.List.CopyTo(array, index);
}
/// <summary>
/// 创建附件交易信息
/// </summary>
/// <param name="attachPaymentLogInfo">要创建的附件交易信息</param>
/// <returns>创建的交易id</returns>
public static int CreateAttachPaymentLog(AttachPaymentlogInfo attachPaymentLogInfo)
{
return Data.AttachPaymentLogs.CreateAttachPaymentLog(attachPaymentLogInfo);
}
/// <summary>
/// Gets the index in the collection of the specified <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see>, if it exists in the collection.
/// </summary>
/// <param name="value">The <see cref="AttachPaymentlogInfoCollection">AttachPaymentlogInfoCollection</see> to locate in the collection.</param>
/// <returns>The index in the collection of the specified object, if found; otherwise, -1.</returns>
public int IndexOf(AttachPaymentlogInfo value)
{
return(this.List.IndexOf(value));
}
public int UpdateAttachPaymetLog(AttachPaymentlogInfo attachPaymentLogInfo)
{
DbParameter[] parms = {
DbHelper.MakeInParam("@id",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Id),
DbHelper.MakeInParam("@uid",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Uid),
DbHelper.MakeInParam("@username",(DbType)SqlDbType.NChar, 20, attachPaymentLogInfo.UserName),
DbHelper.MakeInParam("@postdatetime",(DbType)SqlDbType.DateTime, 8, attachPaymentLogInfo.PostDateTime),
DbHelper.MakeInParam("@amount",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Amount),
DbHelper.MakeInParam("@netamount",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.NetAmount),
DbHelper.MakeInParam("@aid",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Aid),
DbHelper.MakeInParam("@authorid",(DbType)SqlDbType.Int, 4, attachPaymentLogInfo.Authorid)
};
string commandText = string.Format("UPDATE [{0}attachpaymentlog] SET [uid]=@uid,[postdatetime]=@postdatetime,[username]=@username,[amount]=@amount,[netamount]=@netamount,[aid]=@aid,[authorid]=@authorid WHERE [id] = @id",
BaseConfigs.GetTablePrefix);
return DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
public int UpdateAttachPaymetLog(AttachPaymentlogInfo attachPaymentLogInfo)
{
DbParameter[] parms = {
DbHelper.MakeInParam("@id",DbType.Int32, 4, attachPaymentLogInfo.Id),
DbHelper.MakeInParam("@uid",DbType.Int32, 4, attachPaymentLogInfo.Uid),
DbHelper.MakeInParam("@username",DbType.AnsiString, 20, attachPaymentLogInfo.UserName),
DbHelper.MakeInParam("@postdatetime",DbType.DateTime, 8, attachPaymentLogInfo.PostDateTime),
DbHelper.MakeInParam("@amount",DbType.Int32, 4, attachPaymentLogInfo.Amount),
DbHelper.MakeInParam("@netamount",DbType.Int32, 4, attachPaymentLogInfo.NetAmount),
DbHelper.MakeInParam("@aid",DbType.Int32, 4, attachPaymentLogInfo.Aid),
DbHelper.MakeInParam("@authorid",DbType.Int32, 4, attachPaymentLogInfo.Authorid)
};
string sql = "UPDATE [" + BaseConfigs.GetTablePrefix + "attachpaymentlog] SET [uid]=@uid,[postdatetime]=@postdatetime,[username]=@username,[amount]=@amount,[netamount]=@netamount,[aid]=@aid,[authorid]=@authorid WHERE [id] = @id";
return DbHelper.ExecuteNonQuery(CommandType.Text, sql, parms);
}
