public static SupplierAccount Get(int id,int comId) { /* SupplierAccountGet @id int, @comId int=0 */ //[Id], CompanyId, PaymentMode, Amount, [Datetime], Remark, Operater SupplierAccount sa = null; SqlParameter[] prams ={ Database.MakeInParam("@id",SqlDbType.Int,id), Database.MakeInParam("@comId",SqlDbType.Int,comId) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "SupplierAccountGet", prams); if (reader.Read()) { sa = new SupplierAccount(); sa.id = reader.GetInt32(0); sa.companyId = reader.GetInt32(1); sa.paymentMode = reader.GetString(2); sa.amount = Convert.ToSingle(reader.GetValue(3)); sa.datetime = reader.GetDateTime(4); sa.remark = reader.GetString(5); sa.operater = reader.GetString(6); } reader.Close(); } catch { //throw; } finally { if (reader != null) { reader.Close(); } } return sa; }
private static ArrayList List(string op,int comId, DateTime start, DateTime end, Pager pager) { /*SupplierAccountList @comId int=0, @op varchar(20)='', @start varchar(10)='', @end varchar(10)='', @pageIndex int=1, @pageSize int=20, @sort int=0 */ //[Id], CompanyId, PaymentMode, Amount, [Datetime], Remark, Operater ArrayList list = new ArrayList(); SqlParameter[] prams ={ Database.MakeInParam("@comId",SqlDbType.Int,comId), Database.MakeInParam("@op",SqlDbType.VarChar,20,op), Database.MakeInParam("@start",SqlDbType.VarChar,10,start==DateTime.MinValue?"":start.ToShortDateString()), Database.MakeInParam("@end",SqlDbType.VarChar,10,end==DateTime.MinValue?"":end.ToShortDateString()), Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex), Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize), Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "SupplierAccountList", prams); if (reader.Read()) { pager.RecordCount = reader.GetInt32(0); if (reader.NextResult()) { while (reader.Read()) { SupplierAccount sa = new SupplierAccount(); sa.id = reader.GetInt32(0); sa.companyId = reader.GetInt32(1); sa.paymentMode = reader.GetString(2); sa.amount = Convert.ToSingle(reader.GetValue(3)); sa.datetime = reader.GetDateTime(4); sa.remark = reader.GetString(5); sa.operater = reader.GetString(6); list.Add(sa); } } } reader.Close(); } catch { //throw; } finally { if (reader != null) { reader.Close(); } } return list; }
/// <summary> /// ��ֵ /// </summary> private void AddAccount() { if (Request.Form["supplierId"] != null && Request.Form["payMode"] != null && Request.Form["fee"] != null) { int spId = Convert.ToInt32(Request.Form["supplierId"]); float fee = Convert.ToSingle(Request.Form["fee"]); SupplierAccount spAccount = new SupplierAccount(spId); spAccount.PaymentMode = Request.Form["payMode"].Trim(); spAccount.Amount = fee; spAccount.Remark = "�ʻ���ֵ"; if (spAccount.Save()) { Response.Write(fee); return; } } Response.Write("0"); }