public List <Store> GetStoreList()
{
List <Store> list = new List <Store>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(MallSqls.SELECT_STORE);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
Store store = new Store
{
storeAddr = dr["STORE_ADDR"].ToString(),
storeId = dr["STORE_ID"].ToString(),
storeCardImg = dr["STORE_CARD_IMG"].ToString(),
storeCode = dr["STORE_CODE"].ToString(),
storeDesc = dr["STORE_DESC"].ToString(),
storeImg = dr["STORE_IMG"].ToString(),
storeName = dr["STORE_NAME"].ToString(),
storeTel = dr["STORE_TEL"].ToString(),
storeRate = Convert.ToInt32(dr["STORE_RATE"]),
openReg = Convert.ToInt32(dr["OPEN_REG"]),
};
list.Add(store);
}
}
return(list);
}
public Store GetStoreByMemberId(string memberId)
{
Store store = null;
StringBuilder builder = new StringBuilder();
builder.AppendFormat(OrderSqls.SELECT_STORE_BY_MEMBER_ID, memberId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null && dt.Rows.Count == 1)
{
store = new Store
{
storeAddr = dt.Rows[0]["STORE_ADDR"].ToString(),
storeCode = dt.Rows[0]["STORE_CODE"].ToString(),
storeDesc = dt.Rows[0]["STORE_DESC"].ToString(),
storeId = dt.Rows[0]["STORE_ID"].ToString(),
storeImg = dt.Rows[0]["STORE_IMG"].ToString(),
storeName = dt.Rows[0]["STORE_NAME"].ToString(),
storeRate = Convert.ToInt32(dt.Rows[0]["STORE_RATE"]),
openReg = Convert.ToInt32(dt.Rows[0]["OPEN_REG"]),
};
}
return(store);
}
public Order GetOrderInfo(string orderId)
{
Order order = new Order();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(OrderSqls.SELECT_ORDER_GOODS_LIST_BY_ORDER_ID, orderId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
order.addr = dr["ADDR"].ToString();
order.storeCode = dr["STORE_CODE"].ToString();
order.orderId = orderId;
order.orderCode = dr["ORDER_CODE"].ToString();
order.orderTime = dr["ORDER_TIME"].ToString();
order.state = dr["STATE"].ToString();
order.total = dr["TOTAL"].ToString();
order.expFee = dr["EXP_FEE"].ToString();
order.list.Add(new OrderGoods
{
goodsId = dr["GOODS_ID"].ToString(),
goodsImg = dr["GOODS_IMG"].ToString(),
goodsName = dr["GOODS_NAME"].ToString(),
goodsNum = dr["NUM"].ToString(),
price = dr["PRICE"].ToString(),
});
}
}
return(order);
}
/// <summary>
/// 上传用户信息
/// </summary>
public void updateUserInfo()
{
try
{
TaskJobDao sqlDao = new TaskJobDao();
List <AddMemberInfoParam> paramList = sqlDao.getAddMemberInfoParam();
if (paramList.Count == 0)
{
return;
}
ArrayList list = new ArrayList();
foreach (var param in paramList)
{
string st = getRemoteParam(param, "AddMemberInfo", "5");
string result = HttpHandle.PostHttps(Global.PostUrl, st, "application/json");
ReturnItem ri = JsonConvert.DeserializeObject <ReturnItem>(result);
if (ri.success)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.UPDATE_USER_IF_ADD, param.cardCode);
list.Add(builder.ToString());
}
}
DatabaseOperationWeb.ExecuteDML(list);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public List <CartGoods> GetCartList(string memberId)
{
List <CartGoods> list = new List <CartGoods>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(OrderSqls.SELECT_CART_LIST_BY_MEMBER_ID, memberId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
CartGoods cartGoods = new CartGoods
{
cartChecked = dr["CART_CHECKED"].ToString() == "0" ? false : true,
edit = false,
goodsId = dr["GOODS_ID"].ToString(),
goodsImg = dr["GOODS_IMG"].ToString(),
goodsName = dr["GOODS_NAME"].ToString(),
goodsNum = Convert.ToInt32(dr["GOODS_NUM"]),
goodsPrice = Convert.ToInt32(dr["GOODS_PRICE"]),
cartId = dr["CART_ID"].ToString(),
goodsStock = Convert.ToInt32(dr["GOODS_STOCK"]),
};
list.Add(cartGoods);
}
}
return(list);
}
/// <summary>
/// 订单详情
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public GetOrderDetails GetOrderDetails(string ordercode)
{
GetOrderDetails getOrderDetails = new GetOrderDetails();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(GetOrderDetailsSql.SELECT_ORDER_BY_ORDERCODE, ordercode);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
getOrderDetails.name = dt.Rows[0]["CONSIGNEE_NAME"].ToString();
getOrderDetails.mobille = dt.Rows[0]["CONSIGNEE_MOBILE"].ToString();
getOrderDetails.addr = dt.Rows[0]["CONSIGNEE_ADDR"].ToString();
getOrderDetails.idnumber = dt.Rows[0]["ID_NUMBER"].ToString();
getOrderDetails.express = dt.Rows[0]["EXPRESS"].ToString();
getOrderDetails.waybillno = dt.Rows[0]["WAYBILLNO"].ToString();
getOrderDetails.ordercode = dt.Rows[0]["ORDER_CODE"].ToString();
getOrderDetails.ordertime = dt.Rows[0]["ORDER_TIME"].ToString();
getOrderDetails.paytime = dt.Rows[0]["PAY_TIME"].ToString();
getOrderDetails.ordertype = dt.Rows[0]["ORDER_TYPE"].ToString();
getOrderDetails.ordertotal = dt.Rows[0]["ORDER_TOTAL"].ToString();
foreach (DataRow dr in dt.Rows)
{
GetOrderDetailsList getOrderDetailsList = new GetOrderDetailsList();
getOrderDetailsList.name = dr["GOODSNAME"].ToString();
getOrderDetailsList.img = dr["SLT"].ToString();
getOrderDetailsList.num = dr["QUANTITY"].ToString();
getOrderDetailsList.price = dr["SKUUNITPRICE"].ToString();
getOrderDetails.list.Add(getOrderDetailsList);
}
}
return(getOrderDetails);
}
public List <StockGoods> GetStockGoodsList(string storeId)
{
List <StockGoods> list = new List <StockGoods>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(StoreSqls.SELECT_ORDER_GOODS_LIST_BY_STORE_ID, storeId, "2");
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
StockGoods stockGoods = new StockGoods
{
goodsId = dr["GOODS_ID"].ToString(),
goodsImg = dr["GOODS_IMG"].ToString(),
goodsName = dr["GOODS_NAME"].ToString(),
num = dr["NUMS"].ToString(),
lastUpdateTime = dr["ASN_TIME"].ToString(),
};
list.Add(stockGoods);
}
}
return(list);
}
public List <House> getHouseList()
{
List <House> list = new List <House>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_HOUSELIST);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
House house = new House
{
houseId = dt.Rows[i]["house_id"].ToString(),
houseName = dt.Rows[i]["house_name"].ToString(),
houseImg = dt.Rows[i]["house_img"].ToString(),
peopleNum = dt.Rows[i]["people_num"].ToString(),
hourPrice = dt.Rows[i]["hour_price"].ToString(),
remark = dt.Rows[i]["remark"].ToString(),
};
list.Add(house);
}
}
return(list);
}
public User getUserByPhone(string phone)
{
User user = null;
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_USER_BY_PHONE, phone);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
string userTypeName = "机构";
if (dt.Rows[0]["user_type"].ToString() == "2")
{
userTypeName = "个人";
}
user = new User
{
userId = dt.Rows[0]["user_id"].ToString(),
userName = dt.Rows[0]["user_name"].ToString(),
userPhone = dt.Rows[0]["user_phone"].ToString(),
userType = dt.Rows[0]["user_type"].ToString(),
userTypeName = userTypeName,
openId = dt.Rows[0]["openId"].ToString(),
store = Convert.ToDouble(dt.Rows[0]["store"]),
price = Convert.ToDouble(dt.Rows[0]["price"]),
balance = Convert.ToDouble(dt.Rows[0]["store"]) - Convert.ToDouble(dt.Rows[0]["price"]),
remark = dt.Rows[0]["remark"].ToString(),
status = dt.Rows[0]["status"].ToString(),
};
}
return(user);
}
/// <summary>
/// 修改支付状态
/// </summary>
/// <param name="orderId"></param>
/// <param name="payNo"></param>
public bool updateOrderForPay(string billId, string payNo)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(PaymentSqls.SELECT_PREPAYID_BY_BILLID, billId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
StringBuilder builder1 = new StringBuilder();
builder1.AppendFormat(PaymentSqls.UPDATE_PAYINFO_BY_BILLLIST, payNo, billId);
string sql1 = builder1.ToString();
if (DatabaseOperationWeb.ExecuteDML(sql1))
{
StringBuilder builder2 = new StringBuilder();
builder2.AppendFormat(PaymentSqls.UPDATE_PAYINFO_BY_BILLINFO, billId);
string sql2 = builder2.ToString();
return(DatabaseOperationWeb.ExecuteDML(sql2));
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public List <HomeShop> GetHomeShopList()
{
List <HomeShop> list = new List <HomeShop>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(HomeSqls.SELECT_HOMESHOPLIST);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
HomeShop homeShop = new HomeShop
{
id = dr["id"].ToString(),
shopId = dr["shopId"].ToString(),
title = dr["title"].ToString(),
createTime = dr["createTime"].ToString(),
adress = dr["adress"].ToString(),
tel = dr["tel"].ToString(),
officeHours = dr["officeHours"].ToString(),
shopType = dr["shopType"].ToString(),
imgUrl = dr["imgUrl"].ToString()
};
list.Add(homeShop);
}
}
return(list);
}
public StoreUser GetStoreUser(string openID)
{
StoreUser storeUser = null;
StringBuilder builder = new StringBuilder();
builder.AppendFormat(OpenSqls.SELECT_STORE_USER_BY_OPENID, openID);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null && dt.Rows.Count == 1)
{
storeUser = new StoreUser
{
storeUserId = dt.Rows[0]["STORE_USER_ID"].ToString(),
storeUserImg = dt.Rows[0]["STORE_USER_IMG"].ToString(),
storeUserName = dt.Rows[0]["STORE_USER_NAME"].ToString(),
storeUserPhone = dt.Rows[0]["STORE_USER_PHONE"].ToString(),
storeUserSex = dt.Rows[0]["STORE_USER_SEX"].ToString(),
openid = dt.Rows[0]["OPENID"].ToString(),
storeId = dt.Rows[0]["STORE_ID"].ToString(),
};
}
return(storeUser);
}
public Member GetMember(string openID)
{
Member member = null;
StringBuilder builder = new StringBuilder();
builder.AppendFormat(OpenSqls.SELECT_MEMBER_BY_OPENID, openID);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null && dt.Rows.Count == 1)
{
member = new Member
{
memberId = dt.Rows[0]["MEMBER_ID"].ToString(),
memberImg = dt.Rows[0]["MEMBER_IMG"].ToString(),
memberName = dt.Rows[0]["MEMBER_NAME"].ToString(),
memberPhone = dt.Rows[0]["MEMBER_PHONE"].ToString(),
memberSex = dt.Rows[0]["MEMBER_SEX"].ToString(),
openid = dt.Rows[0]["OPENID"].ToString(),
scanCode = "CHECK_" + dt.Rows[0]["SCAN_CODE"].ToString(),
heart = Convert.ToInt32(dt.Rows[0]["HEART"])
};
}
return(member);
}
public List <HomeList> GetHomeList(string homeId)
{
List <HomeList> list = new List <HomeList>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(MallSqls.SELECT_HOME_LIST_BY_HOME_ID, homeId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
HomeList homeList = new HomeList
{
img = dr["IMG"].ToString(),
title = dr["TITLE"].ToString(),
price = dr["PRICE"].ToString(),
praise = dr["PRAISE"].ToString(),
urlType = dr["URL_TYPE"].ToString(),
urlValue = dr["URL_VALUE"].ToString(),
};
list.Add(homeList);
}
}
return(list);
}
/// <summary>
/// 保存支付日志
/// </summary>
/// <param name="orderId"></param>
/// <param name="payNo"></param>
/// <param name="totalPrice"></param>
/// <param name="openid"></param>
/// <param name="status"></param>
public void insertPayLog(string orderId, string payNo, string totalPrice, string openid, string status)
{
string insql = "insert into t_log_pay(orderId,payType,payNo,totalPrice,openid,createtime,status) " +
"values('" + orderId + "','微信支付','" + payNo + "'," + totalPrice + ",'" + openid + "',now(),'" + status + "')";
DatabaseOperationWeb.ExecuteDML(insql);
}
public List <RechargeLog> getRechargeList(string userPhone)
{
List <RechargeLog> rechargeLogList = new List <RechargeLog>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_RECHARGE_BY_PHONE, userPhone);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
RechargeLog rechargeLog = new RechargeLog
{
id = dt.Rows[i]["id"].ToString(),
createTime = dt.Rows[i]["createTime"].ToString(),
userName = dt.Rows[i]["user_name"].ToString(),
userPhone = dt.Rows[i]["user_phone"].ToString(),
store = dt.Rows[i]["store"].ToString(),
beforeStore = dt.Rows[i]["before_store"].ToString(),
afterStore = dt.Rows[i]["after_store"].ToString(),
beforePrice = dt.Rows[i]["before_price"].ToString(),
afterPrice = dt.Rows[i]["after_price"].ToString(),
inputMember = dt.Rows[i]["inputMember"].ToString(),
};
rechargeLogList.Add(rechargeLog);
}
}
return(rechargeLogList);
}
public DataTable getGoods(string barcode)
{
string sql = "select g.id,g.thumb,g.goodsname,g.price,g.stock from t_goods_list g,t_goods_offer o " +
"where g.barcode = o.barcode and o.usercode='O2O' and o.flag='1' and g.barcode = '" + barcode + "'";
return(DatabaseOperationWeb.ExecuteSelectDS(sql, "t_goods_list").Tables[0]);
}
public TelResult getTel(string posCode)
{
TelResult telResult = new TelResult();
List <TEL> list = new List <TEL>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_TEL_BY_POSCODE, posCode);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
TEL tel = new TEL
{
addr = dr["addr"].ToString(),
phone = dr["phone"].ToString(),
};
list.Add(tel);
}
}
telResult.tellist = list;
return(telResult);
}
/// <summary>
/// 生成订单
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public ConfirmOrdeItem ConfirmOrder(ConfirmOrdeParam confirmOrdeParam)
{
ConfirmOrdeItem confirmOrdeItem = new ConfirmOrdeItem();
StringBuilder builder = new StringBuilder();
string ordercode = "O2O" + confirmOrdeParam.shopId + DateTime.Now.ToString("yyyyMMddHHmmssff");
string ordertime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
builder.AppendFormat(OrderDetailsSql.INSERT_INTO_ORDER_BY_CONFIRMORDERPARAM, confirmOrdeParam.shopId, confirmOrdeParam.userId, ordercode, confirmOrdeParam.ordertype, ordertime, confirmOrdeParam.payable, confirmOrdeParam.price, confirmOrdeParam.derate, confirmOrdeParam.couponcode, confirmOrdeParam.coupon, confirmOrdeParam.freight, confirmOrdeParam.consignee, confirmOrdeParam.phone, confirmOrdeParam.addr, confirmOrdeParam.relname, confirmOrdeParam.idcard);
string sql = builder.ToString();
List <ConfirmOrdeParamList> list = confirmOrdeParam.list;
if (list.Count > 0 && DatabaseOperationWeb.ExecuteDML(sql))
{
for (int i = 0; i < list.Count; i++)
{
StringBuilder builder1 = new StringBuilder();
builder1.AppendFormat(OrderDetailsSql.INSERT_INTO_ORDER_GOODS_BY_CONFIRMORDERPARAM, ordercode, list[i].barcode, list[i].goodsId, list[i].goodsprice, list[i].goodsnum, list[i].goodsname);
string sql1 = builder1.ToString();
DatabaseOperationWeb.ExecuteDML(sql1);
}
confirmOrdeItem.msg = "1";
}
else
{
confirmOrdeItem.msg = "0";
}
return(confirmOrdeItem);
}
public List <Banner> getNotify(string posCode)
{
List <Banner> list = new List <Banner>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_BANNER_BY_POSCODE, posCode, "NOTIFY");
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
Banner banner = new Banner
{
sort = dr["sort"].ToString(),
advname = dr["advname"].ToString(),
advtime = dr["advtime"].ToString(),
advurl = dr["advurl"].ToString(),
imgurl = dr["imgurl"].ToString(),
remark = dr["remark"].ToString()
};
list.Add(banner);
}
}
return(list);
}
public List <StoreAccount> GetStoreAccount(string storeId)
{
List <StoreAccount> list = new List <StoreAccount>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(StoreSqls.SELECT_STORE_ACCOUNT_BY_STORE_ID, storeId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
StoreAccount storeAccount = new StoreAccount
{
heartNum = dr["HEARTS"].ToString(),
paymentDays = dr["ACCOUNT_FROM"].ToString() + " - " + dr["ACCOUNT_TO"].ToString(),
state = dr["STATE"].ToString() == "0" ? "待付款" : "已付款",
};
list.Add(storeAccount);
}
}
return(list);
}
public ShopInfo GetShopInfo(string shopId)
{
ShopInfo shopInfo = new ShopInfo();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShopSqls.SELECT_SHOP_INFO_BY_SHOPID, shopId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ShopGoods shopGoods = new ShopGoods
{
shopgoodsId = dr["SHOP_GOODS_ID"].ToString(),
goodsImg = dr["GOODS_IMG"].ToString(),
goodsName = dr["GOODS_NAME"].ToString(),
goodsPrice = dr["GOODS_PRICE"].ToString(),
};
if (dr["RECOMMEND"].ToString() == "1")
{
shopGoods.sign = "掌柜推荐";
}
else if (dr["HOT"].ToString() == "1")
{
shopGoods.sign = "热销商品";
}
shopInfo.hotGoods.Add(shopGoods);
}
}
return(shopInfo);
}
/// <summary>
/// 上传积分变动信息
/// </summary>
public void updateCommit()
{
try
{
TaskJobDao sqlDao = new TaskJobDao();
ArrayList list = new ArrayList();
//处理玩偶兑换积分
List <UserPointParam> gList = sqlDao.getChange();
foreach (UserPointParam aParam in gList)
{
AddPointRecordParam param = new AddPointRecordParam
{
phone = aParam.phone,
point = aParam.point,
};
string st = getRemoteParam(param, "AddPointRecord", "5");
string result = HttpHandle.PostHttps(Global.PostUrl, st, "application/json");
ReturnItem ri = JsonConvert.DeserializeObject <ReturnItem>(result);
if (ri.success)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.UPDATE_USER_CHANGE_POINT, aParam.cardCode, aParam.totalPoint);
list.Add(builder.ToString());
}
}
DatabaseOperationWeb.ExecuteDML(list);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public ShopGoodsDetails GetShopGoodsDetails(string barcode)
{
ShopGoodsDetails shopGoodsDetails = new ShopGoodsDetails();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShopGoodsDetailsSql.SELECT_SHOPGOODS_BY_GOODSID, barcode);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
shopGoodsDetails.barcode = barcode;
shopGoodsDetails.slt = dt.Rows[0]["GOODS_IMG"].ToString();
shopGoodsDetails.shopId = dt.Rows[0]["SHOP_ID"].ToString();
shopGoodsDetails.goodsId = dt.Rows[0]["GOODS_ID"].ToString();
shopGoodsDetails.goodsName = dt.Rows[0]["GOODS_NAME"].ToString();
shopGoodsDetails.goodsPrice = dt.Rows[0]["GOODS_PRICE"].ToString();
shopGoodsDetails.gw = dt.Rows[0]["GW"].ToString();
shopGoodsDetails.model = dt.Rows[0]["MODEL"].ToString();
shopGoodsDetails.country = dt.Rows[0]["COUNTRY"].ToString();
shopGoodsDetails.num = dt.Rows[0]["GOODS_STOCK"].ToString();
shopGoodsDetails.goodsnum = "1";
}
return(shopGoodsDetails);
}
public List <Goods> GetGoodsByGoodsIds(string[] goodsIds)
{
List <Goods> list = new List <Goods>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(OrderSqls.SELECT_GOODS_LIST_BY_GOODS_IDS, String.Join(",", goodsIds));
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
Goods goods = new Goods
{
goodsDesc = dr["GOODS_DESC"].ToString(),
goodsId = dr["GOODS_ID"].ToString(),
goodsName = dr["GOODS_NAME"].ToString(),
goodsImg = dr["GOODS_IMG"].ToString(),
goodsPrice = Convert.ToInt32(dr["GOODS_PRICE"]),
goodsStock = Convert.ToInt32(dr["GOODS_STOCK"]),
};
list.Add(goods);
}
}
return(list);
}
public ShopMsg GetShopMsg(string shopid)
{
ShopMsg shopMsg = new ShopMsg();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShopMsgSql.SELECT_SHOPMSG_BY_SHOPID, shopid);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
shopMsg.shopid = dt.Rows[0]["SHOP_ID"].ToString();
shopMsg.shopname = dt.Rows[0]["SHOP_NAME"].ToString();
shopMsg.desc = dt.Rows[0]["DESC"].ToString();
shopMsg.tel = dt.Rows[0]["TEL"].ToString();
shopMsg.worktime = dt.Rows[0]["OFFICE_HOURS"].ToString();
shopMsg.img = dt.Rows[0]["IMG"].ToString();
shopMsg.addr = dt.Rows[0]["ADDR"].ToString();
if (dt.Rows[0]["SHOP_TYPE"].ToString() == "0")
{
shopMsg.shoptype = "全部";
}
else if (dt.Rows[0]["SHOP_TYPE"].ToString() == "1")
{
shopMsg.shoptype = "仅支持零售";
}
else
{
shopMsg.shoptype = "仅支持O2O";
}
}
return(shopMsg);
}
public bool InsertOrder(string memberId, string orderCode, PreOrder preOrder, string remark, string addr, int expFee)
{
ArrayList list = new ArrayList();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(OrderSqls.INSERT_ORDER, memberId, orderCode, preOrder.total, preOrder.storeCode, remark, addr, expFee);
string orderSql = builder.ToString();
list.Add(orderSql);
foreach (PreOrderGoods preOrderGoods in preOrder.list)
{
builder.Clear();
builder.AppendFormat(
OrderSqls.INSERT_ORDER_GOODS,
orderCode,
preOrderGoods.goodsId,
preOrderGoods.goodsImg,
preOrderGoods.goodsName,
preOrderGoods.goodsPrice,
preOrderGoods.goodsNum
);
string orderGoodsSql = builder.ToString();
list.Add(orderGoodsSql);
if (preOrderGoods.cartId != null && preOrderGoods.cartId.Length > 0)
{
builder.Clear();
builder.AppendFormat(OrderSqls.DELETE_CART_BY_CART_ID, preOrderGoods.cartId);
string deleteCartSql = builder.ToString();
list.Add(deleteCartSql);
}
}
return(DatabaseOperationWeb.ExecuteDML(list));
}
public List <TaskItem> GetTaskList()
{
List <TaskItem> list = new List <TaskItem>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(SchduleSqls.SELECT_TASK_LIST);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
TaskItem taskItem = new TaskItem
{
taskDb = dr["TASK_DB"].ToString(),
taskKey = dr["TASK_KEY"].ToString(),
taskCode = dr["TASK_CODE"].ToString(),
taskState = dr["TASK_STATE"].ToString(),
taskStateFrom = dr["TASK_STATE_FROM"].ToString(),
taskStateTo = dr["TASK_STATE_TO"].ToString(),
taskTable = dr["TASK_TABLE"].ToString(),
interval = Convert.ToInt32(dr["INTERVAL"]),
remark = dr["REMARK"].ToString(),
taskType = dr["TASK_TYPE"].ToString(),
triggerType = dr["TRIGGER_TYPE"].ToString(),
cronExpression = dr["CRON_EXPRESSION"].ToString(),
};
list.Add(taskItem);
}
}
return(list);
}
public bool PayForOrder(string memberId, Order order, int heart)
{
ArrayList list = new ArrayList();
StringBuilder builder = new StringBuilder();
foreach (OrderGoods orderGoods in order.list)
{
builder.Clear();
builder.AppendFormat(OrderSqls.UPDATE_GOODS_STOCK_BY_GOODS_ID, orderGoods.goodsId, orderGoods.goodsNum);
list.Add(builder.ToString());
}
builder.Clear();
builder.AppendFormat(OrderSqls.UPDATE_ORDER_STATE_BY_ORDER_ID, order.orderId);
list.Add(builder.ToString());
builder.Clear();
builder.AppendFormat(OrderSqls.UPDATE_MEMBER_HEART_BY_MEMBER_ID, memberId, order.total);
list.Add(builder.ToString());
builder.Clear();
builder.AppendFormat(
OrderSqls.INSERT_HEART_CHANGE,
order.total,
order.orderId,
memberId,
heart
);
list.Add(builder.ToString());
return(DatabaseOperationWeb.ExecuteDML(list));
}
public ShowDayGoodsList GetShowDayGoodsList(string showId)
{
ShowDayGoodsList showDayGoodsList = new ShowDayGoodsList();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(MallSqls.SELECT_SHOW_DAY_GOODS_BY_SHOW_ID, showId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
showDayGoodsList.list = new List <ShowDayGoods>();
foreach (DataRow dr in dt.Rows)
{
ShowDayGoods showDayGoods = new ShowDayGoods
{
goodsId = dr["GOODS_ID"].ToString(),
goodsImg = dr["GOODS_IMG"].ToString(),
goodsTitle = dr["GOODS_TITLE"].ToString(),
};
showDayGoodsList.list.Add(showDayGoods);
}
}
return(showDayGoodsList);
}
