/// <summary>
/// ��ȡָ��ID�ĸ����¼��Ϣ
/// </summary>
/// <param name="id">�����¼ID</param>
/// <returns></returns>
public static PayRecord Get(int id)
{
/*INV_PayRecordGet @id int*/
//[Id],[RequireId],[UserId],[Mode],[Doc],[Datetime],[Amount],[Operater],[Status],[PayModeInfo],[Remark]
PayRecord obj=null;
using (SqlDataReader reader = Database.ExecuteReader(CommandType.StoredProcedure, "INV_PayRecordGet",
new SqlParameter[] { Database.MakeInParam("@id", SqlDbType.Int, id) }))
{
if (reader.Read())
{
obj = new PayRecord();
obj.id = reader.GetInt32(0);
obj.requireId = reader.GetInt32(1);
obj.userId = reader.GetInt32(2);
obj.mode = (PaymentModeEnum)(reader.GetInt16(3));
obj.doc = reader.GetString(4);
obj.datetime = reader.GetDateTime(5);
obj.Amount = Convert.ToSingle(reader.GetValue(6));
obj.operater = reader.GetString(7);
obj.status = (PayRecordStatus)(reader.GetInt16(8));
obj.payModeInfo = reader.GetString(9);
obj.remark = reader.GetString(10);
}
reader.Close();
}
return obj;
}
/// <summary>
/// ��ȡ�����¼
/// </summary>
/// <param name="uid">�û�ID</param>
/// <param name="rid">��������ID</param>
/// <param name="mode">���ʽ</param>
/// <param name="status">֧��״̬</param>
/// <param name="doc">����ƾ֤����</param>
/// <param name="keywords">�����˻�ע���ݹؼ���</param>
/// <param name="pager">��ҳ</param>
/// <returns></returns>
private static List<PayRecord> List(int uid,int rid,short mode,short status,string doc,string keywords,Pager pager)
{
/*
INV_PayRecordList
@uid int=0,
@rid int=0,
@mode smallint=-1,
@status smallint=-1,
@doc varchar(50)='',
@keywords varchar(20)='',
@pageIndex int=1,
@pageSize int=20,
@sort int=0
*/
//[Id],[RequireId],[UserId],[Mode],[Doc],[Datetime],[Amount],[Operater],[Status],[PayModeInfo],[Remark]
List<PayRecord> list = new List<PayRecord>();
using (SqlDataReader reader = Database.ExecuteReader(CommandType.StoredProcedure, "INV_PayRecordList",
new SqlParameter[] {
Database.MakeInParam("@uid",SqlDbType.Int,uid),
Database.MakeInParam("@rid",SqlDbType.Int,rid),
Database.MakeInParam("@mode",SqlDbType.SmallInt,mode),
Database.MakeInParam("@status",SqlDbType.SmallInt,status),
Database.MakeInParam("@doc",SqlDbType.VarChar,50,doc),
Database.MakeInParam("@keywords",SqlDbType.VarChar,20,keywords),
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())
{
PayRecord obj;
while (reader.Read())
{
obj = new PayRecord();
obj.id = reader.GetInt32(0);
obj.requireId = reader.GetInt32(1);
obj.userId = reader.GetInt32(2);
obj.mode = (PaymentModeEnum)(reader.GetInt16(3));
obj.doc = reader.GetString(4);
obj.datetime = reader.GetDateTime(5);
obj.Amount = Convert.ToSingle(reader.GetValue(6));
obj.operater = reader.GetString(7);
obj.status=(PayRecordStatus)(reader.GetInt16(8));
obj.payModeInfo = reader.GetString(9);
obj.remark = reader.GetString(10);
list.Add(obj);
}
}
}
reader.Close();
}
return list;
}
private void SavePayRecord()
{
Response.Clear();
int _rid = 0;
DateTime _dt = DateTime.Now;
float amount = 0;
string _doc;
if (Request.Form["payDoc"] == null)
{
return;
}
_doc = Request.Form["payDoc"].Trim();
int.TryParse(Request.Form["requireId"], out _rid);
DateTime.TryParse(Request.Form["payDate"], out _dt);
if (_rid == 0)
{
return;
}
float.TryParse(Request.Form["payAmount"], out amount);
if (amount == 0)
{
return;
}
PayRecord pr = new PayRecord(_rid);
pr.Amount = amount;
pr.Datetime = _dt;
pr.Doc = _doc;
pr.Remark = Request.Form["payRemark"] == null ? "" : Request.Form["payRemark"].Trim();
pr.Operater = SysAdmin.Current.Name;
int newid = pr.Save();
Response.Write(newid.ToString());
Response.End();
}
