/// <summary> /// 得到一个实体 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public ShowShop.Model.Order.PaymentMoney GetModelByOrderId(string orderId) { ShowShop.Model.Order.PaymentMoney model = new ShowShop.Model.Order.PaymentMoney(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,orderid,username,gatheringdate,gatheringmoney,presentticket,remark,notedate,notename from yxs_paymentmoney "); strSql.Append(" where [orderid]=@orderid "); SqlParameter parameters = new SqlParameter("@orderid", SqlDbType.VarChar, 50); parameters.Value = orderId; using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.Read()) { model.ID = reader.GetInt32(0); model.OrderId = reader.GetString(1); model.UserName = reader.GetString(2); model.GatheringDate = reader.GetDateTime(3); model.GatheringMoney = Convert.ToDecimal(reader["gatheringmoney"]); model.PresentTicket = Convert.ToDecimal(reader["presentticket"]); model.Remark = reader.GetString(6); model.NoteDate = reader.GetDateTime(7); model.NoteName = reader.GetString(8); } else { model = null; } } return model; }
/// <summary> /// 得到指定条件的所有集合 /// </summary> /// <param name="uid"></param> /// <returns></returns> public List<ShowShop.Model.Order.PaymentMoney> GetAll(string strWhere) { List<ShowShop.Model.Order.PaymentMoney> list = new List<ShowShop.Model.Order.PaymentMoney>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,orderid,username,gatheringdate,gatheringmoney,presentticket,remark,notedate,notename from yxs_paymentmoney "); if (strWhere != null && strWhere != "") { strSql.Append("where " + strWhere + " "); } using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ShowShop.Model.Order.PaymentMoney model = new ShowShop.Model.Order.PaymentMoney(); model.ID = reader.GetInt32(0); model.OrderId = reader.GetString(1); model.UserName = reader.GetString(2); model.GatheringDate = reader.GetDateTime(3); model.GatheringMoney = Convert.ToDecimal(reader["gatheringmoney"]); model.PresentTicket = Convert.ToDecimal(reader["presentticket"]); model.Remark = reader.GetString(6); model.NoteDate = reader.GetDateTime(7); model.NoteName = reader.GetString(8); list.Add(model); } } return list; }