/// <summary>
/// 得到一个实体
/// </summary>
/// <param name="orderId"></param>
/// <returns></returns>
public ShowShop.Model.Order.RemittanceInfo GetModelByOrderId(string orderId)
{
ShowShop.Model.Order.RemittanceInfo model = new ShowShop.Model.Order.RemittanceInfo();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,orderid,username,remittancedate,remittancemoney,remintancebank,presentticket,remark,informmode,notedate,notename from yxs_remittanceinfo ");
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.RemittanceDate = reader.GetDateTime(3);
model.RemittanceMoney = Convert.ToDecimal(reader["remittancemoney"]);
model.RemintanceBank = reader.GetInt32(5);
model.PresentTicket = Convert.ToDecimal(reader["presentticket"]);
model.Remark = reader.GetString(7);
model.InformMode = reader.GetString(8);
model.NoteDate = reader.GetDateTime(9);
model.NoteName = reader.GetString(10);
}
else
{
model = null;
}
}
return model;
}
/// <summary>
/// 得到指定条件的所有短消息
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public List<ShowShop.Model.Order.RemittanceInfo> GetAll(string strWhere)
{
List<ShowShop.Model.Order.RemittanceInfo> list = new List<ShowShop.Model.Order.RemittanceInfo>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,orderid,username,remittancedate,remittancemoney,remintancebank,presentticket,remark,informmode,notedate,notename from yxs_remittanceinfo ");
if (strWhere != null && strWhere != "")
{
strSql.Append("where " + strWhere + " ");
}
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
{
while (reader.Read())
{
ShowShop.Model.Order.RemittanceInfo model = new ShowShop.Model.Order.RemittanceInfo();
model.ID = reader.GetInt32(0);
model.OrderId = reader.GetString(1);
model.UserName = reader.GetString(2);
model.RemittanceDate = reader.GetDateTime(3);
model.RemittanceMoney = Convert.ToDecimal(reader["remittancemoney"]);
model.RemintanceBank = reader.GetInt32(5);
model.PresentTicket = Convert.ToDecimal(reader["presentticket"]);
model.Remark = reader.GetString(7);
model.InformMode = reader.GetString(8);
model.NoteDate = reader.GetDateTime(9);
model.NoteName = reader.GetString(10);
list.Add(model);
}
}
return list;
}
