/// <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; }