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