/// <summary>
/// 对象实体绑定数据
/// </summary>
public GiftOrderModel ReaderBind(IDataReader dataReader)
{
GiftOrderModel model = new GiftOrderModel();
object ojb;
model.UserId = dataReader["UserId"].ToString();
model.OrderId = dataReader["OrderId"].ToString();
ojb = dataReader["OrderStatus"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderStatus = (OrderStatus)Convert.ToInt16(ojb);
}
ojb = dataReader["ShipMethod"];
if (ojb != null && ojb != DBNull.Value)
{
model.ShipMethod = (ShipMethodType)Convert.ToInt16(ojb);
}
model.RecieverName = dataReader["RecieverName"].ToString();
model.RecieverEmail = dataReader["RecieverEmail"].ToString();
model.RecieverPhone = dataReader["RecieverPhone"].ToString();
model.Postalcode = dataReader["Postalcode"].ToString();
model.RecieverCountry = dataReader["RecieverCountry"].ToString();
model.RecieverCity = dataReader["RecieverCity"].ToString();
model.RecieverProvince = dataReader["RecieverProvince"].ToString();
model.RecieverCounty = dataReader["RecieverCounty"].ToString();
model.AddressDetial = dataReader["AddressDetial"].ToString();
ojb = dataReader["ChangeTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.ChangeTime = (DateTime)ojb;
}
ojb = dataReader["CreateTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateTime = (DateTime)ojb;
}
ojb = dataReader["OrderType"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderType = (OrderType)Convert.ToInt16(ojb);
}
model.ServerIp = dataReader["ServerIp"].ToString();
model.ClientIp = dataReader["ClientIp"].ToString();
model.UserNotes = dataReader["UserNotes"].ToString();
ojb = dataReader["TotalScore"];
if (ojb != null && ojb != DBNull.Value)
{
model.TotalScore = (int)ojb;
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public GiftOrderModel ReaderBind(IDataReader dataReader)
{
GiftOrderModel model = new GiftOrderModel();
object ojb;
model.UserId = dataReader["UserId"].ToString();
model.OrderId = dataReader["OrderId"].ToString();
ojb = dataReader["OrderStatus"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderStatus = (OrderStatus)Convert.ToInt16(ojb);
}
ojb = dataReader["ShipMethod"];
if (ojb != null && ojb != DBNull.Value)
{
model.ShipMethod = (ShipMethodType)Convert.ToInt16(ojb);
}
model.RecieverName = dataReader["RecieverName"].ToString();
model.RecieverEmail = dataReader["RecieverEmail"].ToString();
model.RecieverPhone = dataReader["RecieverPhone"].ToString();
model.Postalcode = dataReader["Postalcode"].ToString();
model.RecieverCountry = dataReader["RecieverCountry"].ToString();
model.RecieverCity = dataReader["RecieverCity"].ToString();
model.RecieverProvince = dataReader["RecieverProvince"].ToString();
model.RecieverCounty = dataReader["RecieverCounty"].ToString();
model.AddressDetial = dataReader["AddressDetial"].ToString();
ojb = dataReader["ChangeTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.ChangeTime = (DateTime)ojb;
}
ojb = dataReader["CreateTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateTime = (DateTime)ojb;
}
ojb = dataReader["OrderType"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderType =(OrderType)Convert.ToInt16(ojb);
}
model.ServerIp = dataReader["ServerIp"].ToString();
model.ClientIp = dataReader["ClientIp"].ToString();
model.UserNotes = dataReader["UserNotes"].ToString();
ojb = dataReader["TotalScore"];
if (ojb != null && ojb != DBNull.Value)
{
model.TotalScore = (int)ojb;
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public GiftOrderModel GetModel(string OrderId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserId,OrderId,OrderStatus,ShipMethod,RecieverName,RecieverEmail,RecieverPhone,Postalcode,RecieverCountry,RecieverCity,RecieverProvince,RecieverCounty,AddressDetial,ChangeTime,CreateTime,OrderType,ServerIp,ClientIp,UserNotes,TotalScore from spGiftOrder ");
strSql.Append(" where OrderId=@OrderId ");
Database db = NoName.NetShop.Common.CommDataAccess.DbReader;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "OrderId", DbType.AnsiString, OrderId);
GiftOrderModel model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 显示允许管理员操作的按钮
/// 支付成功，—— 审核通过，开始备货
/// 支付成功，—— 退还积分给买家，交易失败
/// 开始备货，—— 发货
/// 开始备货 —— 退还积分给买家，交易失败
/// 已发货，—— 物流确认到货，交易完成
/// 已发货，—— 买家拒收，退还积分给买家，交易失败
/// </summary>
/// <param name="order"></param>
private void ShowActions(GiftOrderModel order)
{
btnPrepareGoods.Visible = false;
btnFail.Visible = false;
btnSend.Visible = false;
btnFinish.Visible = false;
txtActionRemark.Visible = false;
//if (order.OrderStatus == OrderStatus.交易完成 || order.OrderStatus == OrderStatus.交易失败)
//{
// txtActionRemark.Visible = false;
//}
if (order.OrderStatus == OrderStatus.已创建)
{
btnFail.Visible = true;
btnPrepareGoods.Visible = true;
txtActionRemark.Visible = true;
}
else if (order.OrderStatus == OrderStatus.备货中)
{
btnFail.Visible = true;
btnSend.Visible = true;
txtActionRemark.Visible = true;
}
else if (order.OrderStatus == OrderStatus.已发货)
{
btnFail.Visible = true;
btnFinish.Visible = true;
txtActionRemark.Visible = true;
}
}
