/// <summary>
/// �����������Ѽ�¼
/// </summary>
/// <param name="fci">��¼����</param>
/// <returns>��Ӱ������</returns>
public int Insert(FictitiouConsumptionInfo fci)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@U_ID",fci.UserId),
new SqlParameter("@FC_Count",fci.Amount),
new SqlParameter("@FC_Explain",fci.Explain)
};
return XYECOM.Core.Data.SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure,"XYP_InsertFictitiouConsumption", param);
}
/// <summary>
/// ��ȡָ����ŵ��������Ѽ�¼����
/// </summary>
/// <param name="acid">Ҫ��ȡ���������Ѽ�¼����ı��</param>
/// <returns>�ñ���¶�Ӧ���������ݶ���</returns>
public FictitiouConsumptionInfo GetItem(Int64 fcid)
{
FictitiouConsumptionInfo fci = null;
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@strWhere"," where FC_ID ="+fcid.ToString()),
new SqlParameter("@strTableName","u_FictitiouConsumptionInfo"),
new SqlParameter("@strOrder","")
};
using (SqlDataReader dr = XYECOM.Core.Data.SqlHelper.ExecuteReader( CommandType.StoredProcedure, "XYP_SelectByWhere", param))
{
if (dr.Read())
fci = new FictitiouConsumptionInfo(dr.GetInt64(0), dr.GetInt64(1), dr.GetDecimal(2), dr.GetDateTime(3), dr.GetString(4));
}
return fci;
}
