public void GetOrders_Successful()
{
// Arrange
MailChimpManager mc = new MailChimpManager(TestGlobal.Test_APIKey);
// Act
OrderListResult result = mc.GetOrders();
// Assert
Assert.IsNotNull(result);
}
public OrderListResult getOrderList(string openid, string shop)
{
OrderListResult orderListResult = new OrderListResult();
string sql = "select l.merchantOrderId,l.tradeTime from t_order_list l "
+ " where l.sendapi = 'XXC' and l.customerCode = '" + openid + "' and l.`status` != '未支付' and l.purchaserId = '" + shop + "' ";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "t_goods_list").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string slt = "";
string pro = "";
string sql1 = "select g.barCode,max(g.skuBillName) goodsname,max(l.slt) slt " +
"from t_order_goods g,t_goods_list l " +
"where l.barcode = g.barCode and g.merchantOrderId = '" + dt.Rows[i]["merchantOrderId"].ToString() + "' " +
"group by g.barCode";
DataTable dt1 = DatabaseOperationWeb.ExecuteSelectDS(sql1, "t_goods_list").Tables[0];
if (dt1.Rows.Count > 0)
{
slt = dt1.Rows[0]["slt"].ToString();
for (int j = 0; j < dt1.Rows.Count; j++)
{
pro += dt1.Rows[0]["goodsname"].ToString() + ",";
}
}
OrderListItem orderListItem = new OrderListItem();
orderListItem.billId = dt.Rows[i]["merchantOrderId"].ToString();
orderListItem.imgUrl = slt;
orderListItem.createTime = dt.Rows[i]["tradeTime"].ToString();
orderListItem.product = pro.Substring(0, pro.Length - 1);
orderListResult.orderList.Add(orderListItem);
}
return(orderListResult);
}
else
{
return(null);
}
}
public ActionResult Index(string dfn, string page)
{
// *** Show a list of orders ***
OrderListModel model = new OrderListModel();
// *** Add patient to model ***
model.Patient = this.CurrentPatient;
// *** Get proper page ***
int pageVal = this.GetPage(page);
// *** Get list ***
OrderListResult result = this.DashboardRepository.Orders.GetList(dfn, pageVal, OrdersPerPage);
// *** Check result ***
if (result.Success)
{
// *** Add orders to model ***
model.Orders = result.OrderList;
// *** Set paging data ***
model.Paging.SetPagingData(OrdersPerPage, pageVal, result.TotalResults);
// *** Set paging base url ***
model.Paging.BaseUrl = Url.Action("Index", new { @dfn = dfn, @page = "" });
}
else
{
this.Error(result.Message);
}
TempData[ReturnUrl] = Url.Action("Index", new { dfn = dfn, page = page });
// *** Return the view ***
return(View(model));
}
public OrderListResult getOrderList(string openid, string shop)
{
string st = "";
if (shop != "")
{
st = " and l.purchaserCode = '" + shop + "' ";
}
OrderListResult orderListResult = new OrderListResult();
string sql = "select l.merchantOrderId,l.tradeTime,l.status,l.tradeAmount,l.payTime from t_order_list l "
+ " where l.sendapi = 'XXC' and l.customerCode = '" + openid + "' and l.`status` != 0 " + st + " order by id desc ";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "t_goods_list").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string slt = "";
string pro = "";
string sql1 = "select barCode,max(skuBillName) goodsname,max(slt) slt " +
"from t_order_goods " +
"where merchantOrderId = '" + dt.Rows[i]["merchantOrderId"].ToString() + "' " +
"group by barCode";
DataTable dt1 = DatabaseOperationWeb.ExecuteSelectDS(sql1, "t_goods_list").Tables[0];
if (dt1.Rows.Count > 0)
{
slt = dt1.Rows[0]["slt"].ToString();
for (int j = 0; j < dt1.Rows.Count; j++)
{
pro += dt1.Rows[j]["goodsname"].ToString() + ",";
}
}
OrderListItem orderListItem = new OrderListItem();
orderListItem.billId = dt.Rows[i]["merchantOrderId"].ToString();
orderListItem.imgUrl = slt;
orderListItem.createTime = dt.Rows[i]["tradeTime"].ToString();
orderListItem.payTime = dt.Rows[i]["payTime"].ToString();
orderListItem.product = pro.Substring(0, pro.Length - 1);
orderListItem.total = dt.Rows[i]["tradeAmount"].ToString();
string status = dt.Rows[i]["status"].ToString();
if (status == "1" || status == "2")
{
status = "等待发货";
}
else if (status == "4" || status == "5")
{
status = "已完成";
}
else if (status == "3")
{
status = "已发货";
}
orderListItem.status = status;
orderListResult.orderList.Add(orderListItem);
}
return(orderListResult);
}
else
{
return(new OrderListResult());
}
}
