protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (IsPost) { switch (AjaxAction) { case "InvitePayRecord.Save": SavePayRecord(); break; } } else { int.TryParse(Request.QueryString["rid"], out paymentRequireId); require = PaymentRequire.Get(paymentRequireId); if (require != null) { payMode = PayMode.Get(require.PayModeId).Mode; } } }
private static List<PaymentRequire> List(int uid,short status,Pager pager) { /* INV_PayRequireList @uid int=0, @status smallint=-1, @pageIndex int=1, @pageSize int=20, @sort int=0 */ //[Id],[UserId],[Datetime],[Amount],[PayModeId],[PayRecordId],[Status] List<PaymentRequire> list = new List<PaymentRequire>(); using (SqlDataReader reader = Database.ExecuteReader(CommandType.StoredProcedure, "INV_PayRequireList", new SqlParameter[] { Database.MakeInParam("@uid",SqlDbType.Int,uid), Database.MakeInParam("@status",SqlDbType.SmallInt,status), 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()) { PaymentRequire obj; while (reader.Read()) { obj = new PaymentRequire(); obj.id = reader.GetInt32(0); obj.userId = reader.GetInt32(1); obj.datetime = reader.GetDateTime(2); obj.amount = Convert.ToSingle(reader.GetValue(3)); obj.payModeId = reader.GetInt32(4); obj.payRecordId = reader.GetInt32(5); obj.status = (PaymentRequireStatus)(reader.GetInt16(6)); list.Add(obj); } } } reader.Close(); } return list; }
public static PaymentRequire Get(int id,int uid) { /* INV_PayRequireGet @id int, @uid int=0 */ PaymentRequire pr = new PaymentRequire(); using (SqlDataReader reader = Database.ExecuteReader(CommandType.StoredProcedure, "INV_PayRequireGet", new SqlParameter[]{ Database.MakeInParam("@id",SqlDbType.Int,id), Database.MakeInParam("@uid",SqlDbType.Int,uid) })) { if (reader.Read()) { pr.id = reader.GetInt32(0); pr.userId = reader.GetInt32(1); pr.datetime = reader.GetDateTime(2); pr.amount = Convert.ToSingle(reader.GetValue(3)); pr.payModeId = reader.GetInt32(4); pr.payRecordId = reader.GetInt32(5); pr.status = (PaymentRequireStatus)(reader.GetInt16(6)); } reader.Close(); } return pr; }
/// <summary> /// ���븶�� /// </summary> private void DoRequirePayment() { PaymentRequire pr = new PaymentRequire(UserCookieInfo.Get().Id); int ret = pr.Save(); Html.Append(ret.ToString()); }