/// <summary>
/// �������
/// </summary>
private void AddAnnual()
{
if (Request.Form["supplierId"] != null &&
Request.Form["fee"] != null &&
Request.Form["annual"] != null)
{
int spId = Convert.ToInt32(Request.Form["supplierId"]);
float fee = Convert.ToSingle(Request.Form["fee"]);
int year = Convert.ToInt32(Request.Form["annual"]);
SupplierAnnualFee spAnnualFee = new SupplierAnnualFee(spId);
spAnnualFee.Annual = year;
spAnnualFee.Fee = fee;
if (spAnnualFee.Save())
{
Response.Write(fee);
return;
}
}
Response.Write("0");
}
public static ArrayList List(int spId,int annual, Pager pager)
{
/*
SupplierAnnualFeeList
@spId int=0,
@year int=0,
@pageIndex int=1,
@pageSize int=20,
@sort int=0
*/
//[Id], SupplierId,SupplierName, Annual, Fee, [Datetime], Operater
ArrayList list = new ArrayList();
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "SupplierAnnualFeeList",
new SqlParameter[] {
Database.MakeInParam("@spId",SqlDbType.Int,spId),
Database.MakeInParam("@year",SqlDbType.Int,annual),
Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex),
Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize),
Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum)
});
if (reader.Read())
{
pager.RecordCount = reader.GetInt32(0);
if (reader.NextResult())
{
while (reader.Read())
{
SupplierAnnualFee f = new SupplierAnnualFee();
f.id = reader.GetInt32(0);
f.supplierId = reader.GetInt32(1);
f.supplierName = reader.IsDBNull(2)?"------":reader.GetString(2);
f.annual = reader.GetInt32(3);
f.fee = Convert.ToSingle(reader.GetValue(4));
f.datetime = reader.GetDateTime(5);
f.operater = reader.GetString(6);
list.Add(f);
}
}
}
reader.Close();
}
catch
{
//throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return list;
}
