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());
}
