public bool AddOrderDetail(T_OrderDetail model)
{
using (var db = new cakedbEntities())
{
db.Set <T_OrderDetail>().Add(model);
return(db.SaveChanges() > 0);
}
}
private void GetOrder()
{
string ordercode = "";
if (Request["code"] != null)
{
ordercode = Request["code"].ToString();
}
if (ordercode != "")
{
T_Order model = new T_Order();
T_OrderDetail detail = new T_OrderDetail();
OrderBll bll = new OrderBll();
model = bll.GetOrder(ordercode);
detail = bll.GetOrderDetailByCode(ordercode);
if (model != null)
{
//商户订单号，商户网站订单系统中唯一订单号，必填
out_trade_no = model.OrderCode;
//订单名称，必填
subject = detail.ProductName.Trim();
//付款金额，必填
total_fee = model.OrderPrice.ToString();
//收银台页面上，商品展示的超链接，必填
show_url = "http://m.makacake.com/productdetail.aspx?wd=" + detail.ProductId;
//商品描述，可空
body = detail.ProductName;
//把请求参数打包成数组
Config config = new Config();
SortedDictionary <string, string> sParaTemp = new SortedDictionary <string, string>();
sParaTemp.Add("partner", config.partner);
sParaTemp.Add("seller_id", config.seller_id);
sParaTemp.Add("_input_charset", config.input_charset.ToLower());
sParaTemp.Add("service", config.service);
sParaTemp.Add("payment_type", config.payment_type);
sParaTemp.Add("notify_url", config.notify_url);
sParaTemp.Add("return_url", config.return_url);
sParaTemp.Add("out_trade_no", out_trade_no);
sParaTemp.Add("subject", subject);
sParaTemp.Add("total_fee", total_fee);
sParaTemp.Add("show_url", show_url);
sParaTemp.Add("body", body);
//其他业务参数根据在线开发文档，添加参数.文档地址:https://doc.open.alipay.com/doc2/detail.htm?spm=a219a.7629140.0.0.2Z6TSk&treeId=60&articleId=103693&docType=1
//如sParaTemp.Add("参数名","参数值");
//建立请求
string sHtmlText = Submit.BuildRequest(sParaTemp, "get", "确认");
Response.Write(sHtmlText);
}
}
}
// 詳細データ更新
// in : T_OrderDetailデータ
// out : エラーメッセージ
public string PutOrderDetail(T_OrderDetail regOrderDetail)
{
using (var db = new SalesManagement_DevContext())
{
T_OrderDetail orderdetail;
try
{
orderdetail = db.T_OrderDetails.Single(x => x.OrDetailID == regOrderDetail.OrDetailID);
}
catch
{
return(_msc.GetMessage(110));
}
orderdetail.OrDetailID = regOrderDetail.OrDetailID;
orderdetail.OrID = regOrderDetail.OrID;
orderdetail.PrID = regOrderDetail.PrID;
orderdetail.OrQuantity = regOrderDetail.OrQuantity;
orderdetail.OrTotalPrice = regOrderDetail.OrTotalPrice;
db.Entry(orderdetail).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch
{
// throw new Exception(Messages.errorConflict, ex);
// throw new Exception(_cm.GetMessage(100), ex);
return(_msc.GetMessage(100));
}
// ログ出力
var operationLog = new OperationLog()
{
EventRaisingTime = DateTime.Now,
Operator = _logonUser,
Table = "OrderDetail",
Command = "Put",
//Data = ProductLogData(regProduct),
};
//StaticCommon.PostOperationLog(operationLog);
return(string.Empty);
}
}
// データ追加
// in : T_OrderDetailデータ
public string PostT_OrderDetail(T_OrderDetail regOrderDetail)
{
using (var db1 = new SalesManagement_DevContext())
{
db1.T_OrderDetails.Add(regOrderDetail);
db1.Entry(regOrderDetail).State = EntityState.Added;
db1.SaveChanges();
}
//// ログ出力
//var operationLog = new OperationLog()
//{
// EventRaisingTime = DateTime.Now,
// Operator = _logonUser,
// Table = "Order",
// Command = "Post",
// Data = T_OrderLogData(regOrder),
// Comments = string.Empty
//};
//StaticCommon.PostOperationLog(operationLog);
return(string.Empty);
}
public bool AddOrderByUserId(string card, string bastdate, string paytype, string remark, string ordercode)
{
UserBll userbll = new UserBll();
// int csum = Convert.ToInt32(sum);
int userid = 0;
userid = userbll.GetUserIdByToken();
bool orderres = false;
if (userid > 0)
{
T_Order order = new T_Order();
CartBll cartbll = new CartBll();
OrderDal orderdal = new OrderDal();
List <T_Cart> cartlist = new List <T_Cart>();
cartlist = cartbll.GetCartListByUserId(userid);
AddressBll addressbll = new AddressBll();
T_Address address = new T_Address();
// UserBll userbll = new UserBll();
T_User user = new T_User();
user = userbll.GerUserByUserId(userid);
address = addressbll.GetAddressByUserId();
order.OrderCode = ordercode;
order.CreateDate = DateTime.Now;
order.Adress = address.Adress + address.Area + "_" + address.Name;
order.Mobile = address.Mobile;
order.OrderStatus = "待付款";
order.PayType = paytype;
order.bastdate = bastdate;
order.card_birthday = card;
order.Remark = remark;
order.UserId = userid;
string makabi = "";
decimal?sumprice = 0;
int makaprice = 0;
bool res = false;
if (cartlist != null)
{
foreach (T_Cart cart in cartlist)
{
T_OrderDetail orderdetail = new T_OrderDetail();
orderdetail.CreateDate = DateTime.Now;
orderdetail.OrderCode = order.OrderCode;
orderdetail.ProductId = cart.ProductId;
orderdetail.ProductName = cart.ProductName;
orderdetail.ProductNumber = cart.ProductNumber;
orderdetail.ProductPrice = cart.ProductPrice;
orderdetail.Specification = cart.Specification;
res = orderdal.AddOrderDetail(orderdetail);
if (res)
{
cartbll.DelCartById(cart.Id);
}
sumprice = sumprice + cart.ProductPrice;
}
}
if (user != null)
{
makabi = user.MaKaCurrency.ToString();
makaprice = (int)user.MaKaCurrency / 10;
if (makaprice >= sumprice)
{
sumprice = 0;
}
else
{
sumprice = (int)sumprice - makaprice;
}
order.makabi = user.MaKaCurrency;
}
if (sumprice <= 230)
{
sumprice = sumprice + 18;
order.fare = 18;
}
else
{
order.fare = 0;
}
order.OrderPrice = sumprice;
orderres = orderdal.AddOrder(order);
if (orderres)
{
userbll.UpdateUser(userid, (int)user.MaKaCurrency);
}
return(orderres);
}
else
{
return(false);
}
}
