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