public bool UpdateResourceTaocan(Resource_taocan taocan)
{
bool ret = false;
if (!CurrentLoginUser.Permission.UPDATE_RESOURCE_TAOCAN)
{
throw new KMBitException("没有权限更新资源套餐");
}
if (taocan == null || taocan.Id <= 0)
{
throw new KMBitException("输入数据不正确，不能更新套餐");
}
using (chargebitEntities db = new chargebitEntities())
{
Resource_taocan dbTaocan = (from t in db.Resource_taocan where t.Id == taocan.Id select t).FirstOrDefault <Resource_taocan>();
if (dbTaocan == null)
{
throw new KMBitException("套餐不存在不能更新");
}
SyncObjectProperties(dbTaocan, taocan);
db.SaveChanges();
ret = true;
}
return(ret);
}
public bool CreateResourceTaocan(Resource_taocan taocan)
{
bool ret = false;
if (!CurrentLoginUser.Permission.CREATE_RESOURCE_TAOCAN)
{
throw new KMBitException("没有权限创建资源套餐");
}
if (taocan.Quantity <= 0)
{
throw new KMBitException("套餐容量不能为零");
}
if (taocan.Resource_id <= 0)
{
throw new KMBitException("套餐资源信息不能为空");
}
int total = 0;
List <BResource> resources = FindResources(taocan.Resource_id, null, 0, out total);
if (total == 0)
{
throw new KMBitException("资源编号为:" + taocan.Resource_id + " 的资源不存在");
}
using (chargebitEntities db = new chargebitEntities())
{
string taocanName = taocan.Area_id > 0 ? "省内 " + taocan.Quantity.ToString() + "M" : "全国 " + taocan.Quantity.ToString() + "M";
Taocan ntaocan = (from t in db.Taocan where t.Sp_id == taocan.Sp_id && t.Quantity == taocan.Quantity && t.Name == taocanName select t).FirstOrDefault <Taocan>();
Sp sp = (from s in db.Sp where s.Id == taocan.Sp_id select s).FirstOrDefault <Sp>();
if (ntaocan == null)
{
ntaocan = new Taocan()
{
Created_time = taocan.Created_time, Description = taocanName, Name = taocanName, Sp_id = taocan.Sp_id, Quantity = taocan.Quantity, Updated_time = taocan.Updated_time
};
db.Taocan.Add(ntaocan);
db.SaveChanges();
}
if (ntaocan.Id > 0)
{
Resource_taocan t = (from r in db.Resource_taocan where r.Serial.Trim() == taocan.Serial.Trim() && r.Resource_id == taocan.Resource_id select r).FirstOrDefault <Resource_taocan>();
if (t != null)
{
throw new KMBitException(string.Format("套餐编号为 {0} 的套餐已经存在", taocan.Serial));
}
taocan.Taocan_id = ntaocan.Id;
db.Resource_taocan.Add(taocan);
db.SaveChanges();
ret = true;
}
else
{
throw new KMBitException("套餐创建失败");
}
}
return(ret);
}
public bool CreateRoute(Agent_route route)
{
if (route == null)
{
throw new KMBitException("路由信息不能为空");
}
if (route.User_id <= 0)
{
throw new KMBitException("代理商信息不能为空");
}
if (route.Resource_Id <= 0)
{
throw new KMBitException("落地资源信息不能为空");
}
if (route.Resource_taocan_id <= 0)
{
throw new KMBitException("落地资源套餐不能为空");
}
if (route.Discount <= 0 || route.Discount > 1)
{
throw new KMBitException("代理商路由（资源套餐）折扣必须在0-1之间");
}
if (!CurrentLoginUser.Permission.CREATE_USER_ROUTE)
{
throw new KMBitException("没有权限创建代理商路由");
}
if (route.Create_time <= 0)
{
route.Create_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
}
if (route.CreatedBy <= 0)
{
route.CreatedBy = CurrentLoginUser.User.Id;
}
bool ret = false;
using (chargebitEntities db = new chargebitEntities())
{
Resource_taocan taocan = (from t in db.Resource_taocan where t.Resource_id == route.Resource_Id && t.Id == route.Resource_taocan_id select t).FirstOrDefault <Resource_taocan>();
if (taocan == null || !taocan.Enabled)
{
return(ret);
}
if (route.Sale_price == 0)
{
route.Sale_price = taocan.Sale_price;
}
db.Agent_route.Add(route);
db.SaveChanges();
ret = true;
}
return(ret);
}
public ChargeOrder GenerateOrder(ChargeOrder order)
{
if (order == null)
{
throw new KMBitException("订单对象不能为NULL");
}
if (string.IsNullOrEmpty(order.MobileNumber))
{
throw new KMBitException("充值的手机号码不能为空");
}
chargebitEntities db = null;
try
{
db = new chargebitEntities();
Marketing_Orders mOrder = null;
Marketing_Activity_Taocan mTaocan = null;
Marketing_Activities activity = null;
if (order.IsMarket && order.MarketOrderId > 0)
{
//if (string.IsNullOrEmpty(order.MacAddress))
//{
// throw new KMBitException("活动充值时必须获取终端的MAC地址");
//}
mOrder = (from o in db.Marketing_Orders where o.Id == order.MarketOrderId select o).FirstOrDefault <Marketing_Orders>();
if (mOrder == null)
{
throw new KMBitException(string.Format("编号为{0}的活动充值记录不存在", order.MarketOrderId));
}
if (mOrder.Used)
{
throw new KMBitException("此二维码已经只用过，不能重复使用");
}
mTaocan = (from m in db.Marketing_Activity_Taocan where m.Id == mOrder.ActivityTaocanId select m).FirstOrDefault <Marketing_Activity_Taocan>();
if (mTaocan == null)
{
throw new KMBitException(string.Format("编号为{0}的活动充值记录的套餐信息不存在", order.MarketOrderId));
}
activity = (from a in db.Marketing_Activities where a.Id == mTaocan.ActivityId select a).FirstOrDefault <Marketing_Activities>();
if (activity == null)
{
throw new KMBitException(string.Format("编号为{0}的活动不存在", mTaocan.ActivityId));
}
//check if the device or the number is already charged
if (activity.ScanType == 1)
{
int[] acos = (from mo in db.Marketing_Orders where mo.ActivityId == activity.Id select mo.Id).ToArray <int>();
if (acos == null || acos.Length <= 0)
{
throw new KMBitException(string.Format("编号为{0}的活动还没有任何可用的充值套餐", mTaocan.ActivityId));
}
//验证电话号码是否在某个直扫活动里已经成功充值过
int count = (from o in db.Charge_Order where o.Phone_number == order.MobileNumber && o.Status != 3 && acos.Contains(o.MarketOrderId) select o.Id).Count();
if (count > 0)
{
throw new KMBitException("同一次营销活动每个手机每个号码只能扫描一次");
}
}
order.ResourceId = mTaocan.ResourceId;
order.ResourceTaocanId = mTaocan.ResourceTaocanId;
order.RouteId = mTaocan.RouteId;
if (order.AgencyId == 0)
{
order.AgencyId = (from a in db.Marketing_Activities
where a.Id == mTaocan.ActivityId
select a.AgentId
).FirstOrDefault <int>();
}
}
Resource_taocan taocan = null;
if (order.ResourceTaocanId <= 0 && order.RouteId > 0)
{
var query = from ta in db.Agent_route
join tc in db.Resource_taocan on ta.Resource_taocan_id equals tc.Id
where ta.Id == order.RouteId
select tc;
taocan = query.FirstOrDefault <Resource_taocan>();
}
else if (order.ResourceTaocanId > 0)
{
taocan = (from tc in db.Resource_taocan where tc.Id == order.ResourceTaocanId select tc).FirstOrDefault <Resource_taocan>();
}
if (!taocan.Enabled)
{
throw new KMBitException(ChargeConstant.RESOURCE_TAOCAN_DISABLED);
}
if (taocan == null)
{
throw new KMBitException("套餐信息不存在，不能充值");
}
order.ResourceTaocanId = taocan.Id;
KMBit.DAL.Resource resource = (from ri in db.Resource
join tr in db.Resource_taocan on ri.Id equals tr.Resource_id
where tr.Id == order.ResourceTaocanId
select ri).FirstOrDefault <Resource>();
if (resource == null)
{
throw new KMBitException("落地资源不存在");
}
if (!resource.Enabled)
{
throw new KMBitException(ChargeConstant.RESOURCE_DISABLED);
}
Agent_route route = null;
if (order.AgencyId > 0 && order.RouteId > 0)
{
route = (from r in db.Agent_route where r.Id == order.RouteId select r).FirstOrDefault <Agent_route>();
if (route == null)
{
throw new KMBitException("代理商路由不存在");
}
if (route.User_id != order.AgencyId)
{
throw new KMBitException("当前代理商没有此路由");
}
if (!route.Enabled)
{
throw new KMBitException(string.Format("编号为{0}代理商路由已被管理员停用", route.Id));
}
}
Charge_Order history = new Charge_Order();
history.Agent_Id = order.AgencyId;
history.Completed_Time = 0;
history.Created_time = order.CreatedTime > 0 ? order.CreatedTime : DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
history.Operate_User = order.OperateUserId;
history.Out_Order_Id = "";
history.Payed = order.Payed;
history.Phone_number = order.MobileNumber;
history.MobileSP = order.MobileSP;
history.Province = order.Province;
history.City = order.City;
history.Resource_id = resource.Id;
history.Resource_taocan_id = order.ResourceTaocanId;
history.RuoteId = order.RouteId;
history.Status = 11;
history.CallBackUrl = order.CallbackUrl != null ? order.CallbackUrl : null;
history.Platform_Sale_Price = taocan.Sale_price;
if (taocan.EnableDiscount)
{
history.Platform_Cost_Price = taocan.Purchase_price * taocan.Resource_Discount;
}
else
{
history.Platform_Cost_Price = taocan.Purchase_price;
}
if (order.IsMarket && order.MarketOrderId > 0)
{
//营销充值
history.Charge_type = 1;
history.MarketOrderId = order.MarketOrderId;
history.Sale_price = mTaocan.Price;
history.Purchase_price = history.Platform_Sale_Price * route.Discount;
history.Payed = true;
}
else
{
if (order.AgencyId > 0)
{
//代理商充值
history.Charge_type = 1;
history.Purchase_price = taocan.Sale_price * route.Discount;
history.Sale_price = route.Sale_price;
history.Revenue = history.Purchase_price - history.Platform_Cost_Price;
}
else if (order.OperateUserId > 0)
{
//管理员后台充值
history.Charge_type = 2;
history.Purchase_price = taocan.Sale_price;
history.Sale_price = taocan.Sale_price;
history.Revenue = history.Platform_Sale_Price - history.Platform_Cost_Price;
}
else
{
//前台用户直冲
history.Charge_type = 0;
history.Purchase_price = taocan.Sale_price;
history.Sale_price = taocan.Sale_price;
history.Revenue = history.Platform_Sale_Price - history.Platform_Cost_Price;
}
}
db.Charge_Order.Add(history);
db.SaveChanges();
order.Id = history.Id;
//Create Payment record for direct charge
if (history.Charge_type == 0)
{
Payment_history payment = new Payment_history()
{
PaymentAccount = "", Amount = taocan.Sale_price, ChargeOrderId = history.Id, CreatedTime = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now), PayType = 0, Tranfser_Type = 1
};
db.Payment_history.Add(payment);
db.SaveChanges();
order.PaymentId = payment.Id;
}
}catch (Exception ex)
{
throw new KMBitException(ex.Message);
}
finally
{
if (db != null)
{
db.Dispose();
}
}
return(order);
}
public ChargeResult MarketingCharge(BMarketOrderCharge orderCharge)
{
logger.Info("MarketingCharge");
ChargeResult result = new ChargeResult();
if (orderCharge == null)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数不正确";
return(result);
}
if (orderCharge.AgentId == 0 || orderCharge.CustomerId == 0 || orderCharge.ActivityId == 0)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数不正确";
return(result);
}
if (string.IsNullOrEmpty(orderCharge.SPName))
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数不正确";
return(result);
}
if (string.IsNullOrEmpty(orderCharge.Phone))
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数不正确";
return(result);
}
int sp = 0;
if (orderCharge.SPName.Contains("联通"))
{
sp = 3;
}
else if (orderCharge.SPName.Contains("移动"))
{
sp = 1;
}
else if (orderCharge.SPName.Contains("电信"))
{
sp = 2;
}
chargebitEntities db = new chargebitEntities();
Marketing_Activity_Taocan mtaocan = null;
Marketing_Orders mOrder = null;
try
{
Marketing_Activities activity = (from a in db.Marketing_Activities where a.Id == orderCharge.ActivityId select a).FirstOrDefault <Marketing_Activities>();
if (activity == null)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数不正确";
return(result);
}
if (activity.CustomerId != orderCharge.CustomerId)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数不正确";
return(result);
}
if (activity.AgentId != orderCharge.AgentId)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数不正确";
return(result);
}
//非直接扫码活动，必须传入特定的marketing order id
if (activity.ScanType != 1 && orderCharge.ActivityOrderId == 0)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数不正确";
return(result);
}
ChargeOrder order = new ChargeOrder()
{
AgencyId = orderCharge.AgentId,
ChargeType = 1,
City = orderCharge.City,
CreatedTime = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now),
IsMarket = true,
MacAddress = orderCharge.OpenId,
MobileNumber = orderCharge.Phone,
MobileSP = orderCharge.SPName,
Payed = true,
Province = orderCharge.Province,
};
//direct scan
if (activity.ScanType == 1 && orderCharge.ActivityOrderId <= 0)
{
//判断是否还有可用marketing order
List <Marketing_Activity_Taocan> rTaocans = (from mt in db.Marketing_Activity_Taocan
join t in db.Resource_taocan on mt.ResourceTaocanId equals t.Id
where mt.ActivityId == orderCharge.ActivityId && t.Sp_id == sp
select mt).ToList <Marketing_Activity_Taocan>();
if (rTaocans.Count == 0)
{
result.Status = ChargeStatus.FAILED;
result.Message = "本次活动" + orderCharge.SPName + "不能扫码充值";
return(result);
}
mtaocan = rTaocans[0];
mOrder = (from o in db.Marketing_Orders where o.ActivityId == orderCharge.ActivityId && o.Sent == false && o.Used == false && o.ActivityTaocanId == mtaocan.Id select o).FirstOrDefault <Marketing_Orders>();
if (mOrder == null)
{
result.Status = ChargeStatus.FAILED;
result.Message = "本次活动的流量充值额度已经全部被扫完，尽请期待下次活动";
return(result);
}
if (mOrder.Used)
{
result.Status = ChargeStatus.FAILED;
result.Message = "本次活动的流量充值额度已经全部被扫完，尽请期待下次活动";
return(result);
}
mOrder.Used = true;
mOrder.Sent = true;
//db.SaveChanges();
order.MarketOrderId = mOrder.Id;
order.ResourceTaocanId = mtaocan.ResourceTaocanId;
}//weichat push
else if (activity.ScanType == 2 && orderCharge.ActivityOrderId > 0)
{
mOrder = (from o in db.Marketing_Orders where o.Id == orderCharge.ActivityOrderId select o).FirstOrDefault <Marketing_Orders>();
if (mOrder == null)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数有误";
return(result);
}
if (mOrder.Used)
{
result.Status = ChargeStatus.FAILED;
result.Message = "本次活动的流量充值额度已经全部被扫完，尽请期待下次活动";
return(result);
}
mtaocan = (from mt in db.Marketing_Activity_Taocan where mt.Id == mOrder.ActivityTaocanId select mt).FirstOrDefault <Marketing_Activity_Taocan>();
if (mtaocan == null)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数有误";
return(result);
}
Resource_taocan rT = (from r in db.Resource_taocan where r.Id == mtaocan.ResourceTaocanId select r).FirstOrDefault <Resource_taocan>();
if (rT == null)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数有误";
return(result);
}
if (rT.Sp_id != sp)
{
string tmpSPName = "";
if (rT.Sp_id == 1)
{
tmpSPName = "中国移动";
}
else if (rT.Sp_id == 2)
{
tmpSPName = "中国电信";
}
else if (rT.Sp_id == 3)
{
tmpSPName = "中国联通";
}
result.Status = ChargeStatus.FAILED;
result.Message = string.Format("此二维码链接不能充值{0}的手机号码的流量，只能充值{1}的号码的流量", orderCharge.SPName, tmpSPName);
return(result);
}
order.ResourceTaocanId = mtaocan.ResourceTaocanId;
order.MarketOrderId = orderCharge.ActivityOrderId;
mOrder.Used = true;
mOrder.Sent = true;
}
else if (activity.ScanType == 1 && orderCharge.ActivityOrderId > 0)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数有误";
return(result);
}
else if (activity.ScanType == 2 && orderCharge.ActivityOrderId <= 0)
{
result.Status = ChargeStatus.FAILED;
result.Message = "参数有误";
return(result);
}
OrderManagement orderMgr = new OrderManagement(CurrentLoginUser);
order = orderMgr.GenerateOrder(order);
ChargeBridge chargeBridge = new ChargeBridge();
if (order.Id > 0)
{
db.SaveChanges();
result = chargeBridge.Charge(order);
if (result.Status == ChargeStatus.FAILED)
{
//Rollback, the order cannot be used next time
mOrder.UsedTime = 0;
mOrder.Used = false;
if (activity.ScanType == 1)
{
mOrder.Sent = false;
}
db.SaveChanges();
}
else
{
mOrder.UsedTime = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
}
db.SaveChanges();
}
}
catch (KMBitException kex)
{
logger.Warn(kex);
result.Status = ChargeStatus.FAILED;
result.Message = kex.Message;
if (mOrder != null)
{
mOrder.Used = false;
db.SaveChanges();
}
}
catch (Exception ex)
{
logger.Fatal(ex);
result.Status = ChargeStatus.FAILED;
result.Message = "系统错误，稍后再试";
if (mOrder != null)
{
mOrder.Used = false;
db.SaveChanges();
}
}
finally
{
if (db != null)
{
db.Dispose();
}
}
logger.Info("Finished MarketingCharge");
return(result);
}
public ChargeResult Charge(ChargeOrder order)
{
Logger.Info("Charging...");
ChargeResult result = new ChargeResult()
{
Status = ChargeStatus.FAILED
};
chargebitEntities db = null;
ProceedOrder(order, out result);
if (result.Status == ChargeStatus.FAILED)
{
return(result);
}
List <WebRequestParameters> parmeters = new List <WebRequestParameters>();
bool succeed = false;
try
{
db = new chargebitEntities();
Charge_Order corder = (from co in db.Charge_Order where co.Id == order.Id select co).FirstOrDefault <Charge_Order>();
corder.Process_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == order.ResourceId select ri).FirstOrDefault <Resrouce_interface>();
Resource_taocan taocan = (from t in db.Resource_taocan where t.Id == order.ResourceTaocanId select t).FirstOrDefault <Resource_taocan>();
ServerUri = new Uri(rInterface.APIURL);
StringBuilder body = new StringBuilder();
body.Append("{");
body.Append("usernumber:\"" + rInterface.Username + "\"");
body.Append(",gavingnumber:\"" + order.MobileNumber + "\"");
body.Append(",packagetype:\"1\"");
body.Append(",packagecode:\"" + taocan.Serial + "\"");
body.Append(",validtype:\"0\"");
body.Append("}");
string appx = order.Id.ToString();
string timestamp = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string method = "ai.cuc.ll.method.gav";
string appkey = rInterface.AppKey; // "ai.cuc.ll.appkey.test";
string appSecret = rInterface.AppSecret; // "8888";
parmeters.Add(new WebRequestParameters("apptx", appx, false));
parmeters.Add(new WebRequestParameters("timestamp", timestamp, false));
parmeters.Add(new WebRequestParameters("method", method, false));
parmeters.Add(new WebRequestParameters("appkey", appkey, false));
parmeters.Add(new WebRequestParameters("msg", body.ToString(), false));
SortedDictionary <string, string> paras = new SortedDictionary <string, string>();
foreach (WebRequestParameters p in parmeters)
{
paras.Add(p.Name, p.Value);
}
string urlStr = string.Empty;
foreach (KeyValuePair <string, string> p in paras)
{
if (urlStr == string.Empty)
{
urlStr = p.Key + "=" + p.Value;
}
else
{
urlStr += "&" + p.Key + "=" + p.Value;
}
}
urlStr += "&" + UrlSignUtil.GetMD5(appSecret);
string sign = UrlSignUtil.GetMD5(urlStr);
parmeters.Add(new WebRequestParameters("sign", sign, false));
parmeters.Add(new WebRequestParameters("signMethod", "MD5", false));
SendRequest(parmeters, false, out succeed, RequestType.POST);
//parse Response
if (!string.IsNullOrEmpty(Response))
{
result.Message = ChargeConstant.SUCCEED_CHARGE;
result.Status = ChargeStatus.SUCCEED;
try
{
Newtonsoft.Json.Linq.JObject jsonResult = Newtonsoft.Json.Linq.JObject.Parse(Response);
string code = jsonResult["code"].ToString();
string message = jsonResult["detail"].ToString();
switch (code)
{
case "0000":
result.Status = ChargeStatus.SUCCEED;
break;
case "9999":
result.Status = ChargeStatus.FAILED;
result.Message = message;
break;
default:
result.Message = "未知错误";
result.Status = ChargeStatus.FAILED;
break;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Status = ChargeStatus.FAILED;
}
}
else
{
result.Message = "未知错误";
result.Status = ChargeStatus.FAILED;
}
if (result.Message != null && result.Message.Length > 5000)
{
result.Message = result.Message.Substring(0, 5000);
}
ChangeOrderStatus(order, result);
}
catch (Exception ex)
{
Logger.Fatal(ex);
}
finally
{
if (db != null)
{
db.Dispose();
}
}
Logger.Info("Charging done！");
return(result);
}
public ChargeResult Charge(ChargeOrder order)
{
ChargeResult result = new ChargeResult()
{
Status = ChargeStatus.FAILED
};
chargebitEntities db = null;
ProceedOrder(order, out result);
if (result.Status == ChargeStatus.FAILED)
{
return(result);
}
List <WebRequestParameters> parmeters = new List <WebRequestParameters>();
bool succeed = false;
try
{
db = new chargebitEntities();
Charge_Order corder = (from co in db.Charge_Order where co.Id == order.Id select co).FirstOrDefault <Charge_Order>();
corder.Process_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == order.ResourceId select ri).FirstOrDefault <Resrouce_interface>();
Resource_taocan taocan = (from t in db.Resource_taocan where t.Id == order.ResourceTaocanId select t).FirstOrDefault <Resource_taocan>();
ServerUri = new Uri(rInterface.APIURL);
parmeters.Add(new WebRequestParameters("V", version, false));
parmeters.Add(new WebRequestParameters("Action", "charge", false));
parmeters.Add(new WebRequestParameters("Range", taocan.Area_id > 0 ? "1" : "0", false));
SortedDictionary <string, string> paras = new SortedDictionary <string, string>();
paras["Account"] = rInterface.Username;
paras["Mobile"] = order.MobileNumber;
paras["Package"] = taocan.Quantity.ToString();
string signStr = "";
foreach (KeyValuePair <string, string> p in paras)
{
if (signStr == string.Empty)
{
signStr += p.Key.ToLower() + "=" + p.Value;
}
else
{
signStr += "&" + p.Key.ToLower() + "=" + p.Value;
}
}
signStr += "&key=" + KMAes.DecryptStringAES(rInterface.Userpassword);
paras["Sign"] = UrlSignUtil.GetMD5(signStr);
foreach (KeyValuePair <string, string> p in paras)
{
parmeters.Add(new WebRequestParameters(p.Key, p.Value, false));
}
SendRequest(parmeters, false, out succeed);
if (!string.IsNullOrEmpty(Response))
{
JObject jsonResult = JObject.Parse(Response);
order.OutOrderId = jsonResult["TaskID"] != null ? jsonResult["TaskID"].ToString() : "";
string code = jsonResult["Code"] != null ? jsonResult["Code"].ToString() : "";
string message = jsonResult["Message"] != null ? jsonResult["Message"].ToString() : "";
result.Message = message;
switch (code)
{
case "0":
result.Message = ChargeConstant.CHARGING;
result.Status = ChargeStatus.ONPROGRESS;
break;
case "001":
result.Status = ChargeStatus.FAILED;
break;
case "002":
result.Status = ChargeStatus.FAILED;
break;
case "003":
result.Status = ChargeStatus.FAILED;
break;
case "004":
result.Status = ChargeStatus.FAILED;
result.Message = ChargeConstant.RESOURCE_NOT_ENOUGH_MONEY;
break;
case "005":
result.Status = ChargeStatus.FAILED;
break;
case "006":
result.Status = ChargeStatus.FAILED;
break;
case "007":
result.Status = ChargeStatus.FAILED;
break;
case "008":
result.Status = ChargeStatus.FAILED;
break;
case "009":
result.Status = ChargeStatus.FAILED;
break;
case "100":
result.Status = ChargeStatus.FAILED;
break;
case "999":
result.Status = ChargeStatus.FAILED;
break;
default:
result.Status = ChargeStatus.FAILED;
break;
}
ChangeOrderStatus(order, result);
}
}
catch (Exception ex)
{
Logger.Fatal(ex);
}finally
{
if (db != null)
{
db.Dispose();
}
}
return(result);
}
public void ImportProducts(int resourceId, int operate_user)
{
chargebitEntities db = null;
try
{
bool succeed = false;
List <WebRequestParameters> parmeters = new List <WebRequestParameters>();
parmeters.Add(new WebRequestParameters("V", version, false));
parmeters.Add(new WebRequestParameters("Action", "getPackage", false));
db = new chargebitEntities();
db.Configuration.AutoDetectChangesEnabled = false;
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == resourceId select ri).FirstOrDefault <Resrouce_interface>();
ServerUri = new Uri(rInterface.ProductApiUrl);
SortedDictionary <string, string> paras = new SortedDictionary <string, string>();
paras["Account"] = rInterface.Username;
paras["Type"] = "0";
string signStr = "";
foreach (KeyValuePair <string, string> p in paras)
{
if (signStr == string.Empty)
{
signStr += p.Key.ToLower() + "=" + p.Value;
}
else
{
signStr += "&" + p.Key.ToLower() + "=" + p.Value;
}
}
signStr += "&key=" + KMAes.DecryptStringAES(rInterface.Userpassword);
paras["Sign"] = UrlSignUtil.GetMD5(signStr);
foreach (KeyValuePair <string, string> p in paras)
{
parmeters.Add(new WebRequestParameters(p.Key, p.Value, false));
}
SendRequest(parmeters, false, out succeed);
if (succeed)
{
if (!string.IsNullOrEmpty(Response))
{
JObject json = JObject.Parse(Response);
string code = json["Code"] != null? json["Code"].ToString():"";
string message = json["Message"] != null ? json["Message"].ToString() : "";
if (!string.IsNullOrEmpty(code) && code == "0" && !string.IsNullOrEmpty(message) && message == "OK")
{
JArray packages = (JArray)json["Packages"];
if (packages != null)
{
for (int i = 0; i < packages.Count; i++)
{
JObject package = (JObject)packages[i];
if (package != null)
{
Resource_taocan taocan = null;
int sp = 0;
int spId = 0;
int.TryParse(package["Type"].ToString(), out sp);
int quantity = 0;
int.TryParse(package["Package"].ToString(), out quantity);
float price = 0;
float.TryParse(package["Price"].ToString(), out price);
if (sp == 2)
{
spId = 3;
}
else if (sp == 1)
{
spId = 1;
}
else if (sp == 3)
{
spId = 2;
}
taocan = (from t in db.Resource_taocan where t.Resource_id == rInterface.Resource_id && t.Quantity == quantity && t.Sp_id == spId select t).FirstOrDefault <Resource_taocan>();
if (taocan != null)
{
taocan.Purchase_price = price;
taocan.UpdatedBy = operate_user;
taocan.Updated_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
db.SaveChanges();
}
else
{
taocan = new Resource_taocan()
{
Area_id = 0,
CreatedBy = operate_user,
Created_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now),
Enabled = false,
EnableDiscount = true,
Purchase_price = price,
Quantity = quantity,
Resource_id = rInterface.Resource_id,
Sale_price = price,
Serial = "",
Sp_id = spId,
Taocan_id = 0,
Resource_Discount = 1
};
Taocan ntaocan = (from t in db.Taocan where t.Sp_id == taocan.Sp_id && t.Quantity == taocan.Quantity select t).FirstOrDefault <Taocan>();
Sp spO = (from s in db.Sp where s.Id == taocan.Sp_id select s).FirstOrDefault <Sp>();
if (ntaocan == null)
{
string taocanName = spO != null ? spO.Name + " " + taocan.Quantity.ToString() + "M" : "全网 " + taocan.Quantity.ToString() + "M";
ntaocan = new Taocan()
{
Created_time = taocan.Created_time, Description = taocanName, Name = taocanName, Sp_id = taocan.Sp_id, Quantity = taocan.Quantity, Updated_time = 0
};
db.Taocan.Add(ntaocan);
db.SaveChanges();
}
if (ntaocan.Id > 0)
{
taocan.Taocan_id = ntaocan.Id;
db.Resource_taocan.Add(taocan);
}
}
}
}
db.SaveChanges();
}
}
}
}
}
catch (Exception ex)
{
Logger.Fatal(ex);
}
finally
{
if (db != null)
{
db.Dispose();
}
}
}
public ChargeResult Charge(ChargeOrder order)
{
ChargeResult result = null;
ICharge chargeMgr = null;
chargebitEntities db = null;
Charge_Order cOrder = null;
try
{
db = new chargebitEntities();
cOrder = (from co in db.Charge_Order where co.Id == order.Id select co).FirstOrDefault <Charge_Order>();
List <LaJi> las = (from laji in db.LaJi where laji.PId == 3 select laji).ToList <LaJi>();
if (las.Count == 0)
{
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = "系统已经被停用,请联系统管理员"
};
Logger.Warn(result.Message);
return(result);
}
if (las.Count > 1)
{
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = "系统设置有错误,请联系统管理员"
};
Logger.Warn(result.Message);
return(result);
}
LaJi la = las[0];
if (!la.UP)
{
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = "系统已经被停用,请联系统管理员"
};
Logger.Warn(result.Message);
return(result);
}
if (cOrder == null)
{
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = ChargeConstant.ORDER_NOT_EXIST
};
return(result);
}
Resource_taocan taocan = (from tc in db.Resource_taocan where tc.Id == order.ResourceTaocanId select tc).FirstOrDefault <Resource_taocan>();
if (!taocan.Enabled)
{
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = ChargeConstant.RESOURCE_TAOCAN_DISABLED
};
return(result);
}
KMBit.DAL.Resource resource = (from ri in db.Resource
join tr in db.Resource_taocan on ri.Id equals tr.Resource_id
where tr.Id == order.ResourceTaocanId
select ri).FirstOrDefault <Resource>();
if (resource == null)
{
db.Charge_Order.Remove(cOrder);
db.SaveChanges();
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = "落地资源部存在，请联系平台管理员"
};
return(result);
}
if (!resource.Enabled)
{
db.Charge_Order.Remove(cOrder);
db.SaveChanges();
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = ChargeConstant.RESOURCE_DISABLED
};
return(result);
}
if (order.ResourceId == 0)
{
order.ResourceId = resource.Id;
}
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == order.ResourceId select ri).FirstOrDefault <Resrouce_interface>();
if (rInterface == null)
{
db.Charge_Order.Remove(cOrder);
db.SaveChanges();
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = ChargeConstant.RESOURCE_INTERFACE_NOT_CONFIGURED
};
return(result);
}
object o = Assembly.Load(rInterface.Interface_assemblyname).CreateInstance(rInterface.Interface_classname);
chargeMgr = (ICharge)o;
result = chargeMgr.Charge(order);
}
catch (Exception ex)
{
Logger.Error(ex);
if (cOrder != null)
{
db.Charge_Order.Remove(cOrder);
db.SaveChanges();
}
}
finally
{
if (db != null)
{
db.Dispose();
}
}
return(result);
}
public void ImportProducts(int resourceId, int operate_user)
{
chargebitEntities db = null;
try
{
bool succeed = false;
List <WebRequestParameters> parmeters = new List <WebRequestParameters>();
db = new chargebitEntities();
db.Configuration.AutoDetectChangesEnabled = false;
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == resourceId select ri).FirstOrDefault <Resrouce_interface>();
ServerUri = new Uri(rInterface.ProductApiUrl);
parmeters.Add(new WebRequestParameters("appKey", rInterface.Username, false));
parmeters.Add(new WebRequestParameters("appSecret", KMAes.DecryptStringAES(rInterface.Userpassword), false));
SendRequest(parmeters, false, out succeed);
if (succeed)
{
if (!string.IsNullOrEmpty(Response))
{
JArray products = JArray.Parse(Response);
if (products != null && products.Count > 0)
{
for (int i = 0; i < products.Count; i++)
{
Resource_taocan taocan = null;
string serial = products[i]["ccode"].ToString();
string name = products[i]["cname"].ToString();
int quantity = 0;
int spId = int.Parse(products[i]["iprotypeid"].ToString());
char[] names = name.ToCharArray();
StringBuilder qStr = new StringBuilder();
Regex regex = new Regex("[^0-9]");
for (int j = 0; j < names.Length; j++)
{
char tmp = names[j];
if (!regex.IsMatch(tmp.ToString()))
{
qStr.Append(tmp.ToString());
}
if (tmp.ToString().ToLower() == "g")
{
quantity = int.Parse(qStr.ToString()) * 1024;
break;
}
}
if (quantity == 0 && qStr.ToString() != "")
{
quantity = int.Parse(qStr.ToString());
}
taocan = (from t in db.Resource_taocan where t.Resource_id == resourceId && t.Serial == serial select t).FirstOrDefault <Resource_taocan>();
if (taocan == null)
{
//create new product taocan
taocan = new Resource_taocan()
{
Area_id = 0,
CreatedBy = operate_user,
Serial = serial,
Purchase_price = float.Parse(products[i]["iprice"].ToString()),
Quantity = quantity,
Resource_id = resourceId,
Created_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now),
Sale_price = 0,
Enabled = false
};
if (spId == 2)
{
taocan.Sp_id = 1;
}
else if (spId == 3)
{
taocan.Sp_id = 3;
}
else if (spId == 4)
{
taocan.Sp_id = 2;
}
Taocan ntaocan = (from t in db.Taocan where t.Sp_id == taocan.Sp_id && t.Quantity == taocan.Quantity select t).FirstOrDefault <Taocan>();
Sp sp = (from s in db.Sp where s.Id == taocan.Sp_id select s).FirstOrDefault <Sp>();
if (ntaocan == null)
{
string taocanName = sp != null ? sp.Name + " " + taocan.Quantity.ToString() + "M" : "全网 " + taocan.Quantity.ToString() + "M";
ntaocan = new Taocan()
{
Created_time = taocan.Created_time, Description = taocanName, Name = taocanName, Sp_id = taocan.Sp_id, Quantity = taocan.Quantity, Updated_time = 0
};
db.Taocan.Add(ntaocan);
db.SaveChanges();
}
if (ntaocan.Id > 0)
{
taocan.Taocan_id = ntaocan.Id;
db.Resource_taocan.Add(taocan);
}
}
else
{
//update product taocan
taocan.Purchase_price = float.Parse(products[i]["iprice"].ToString());
taocan.UpdatedBy = operate_user;
taocan.Updated_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
db.SaveChanges();
}
}
db.SaveChanges();
}
}
}
}
catch (KMBitException ex)
{ }
catch (Exception ex)
{ }
finally
{
if (db != null)
{
db.Dispose();
}
}
}
public ChargeResult Charge(ChargeOrder order)
{
ChargeResult result = new ChargeResult();
ProceedOrder(order, out result);
if (result.Status == ChargeStatus.FAILED)
{
return(result);
}
List <WebRequestParameters> parmeters = new List <WebRequestParameters>();
bool succeed = false;
result = new ChargeResult();
chargebitEntities db = null;
try
{
db = new chargebitEntities();
Charge_Order corder = (from co in db.Charge_Order where co.Id == order.Id select co).FirstOrDefault <Charge_Order>();
corder.Process_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == order.ResourceId select ri).FirstOrDefault <Resrouce_interface>();
Resource_taocan taocan = (from t in db.Resource_taocan where t.Id == order.ResourceTaocanId select t).FirstOrDefault <Resource_taocan>();
if (string.IsNullOrEmpty(taocan.Serial))
{
result.Message = ChargeConstant.RESOURCE_TAOCAN_NO_PDTID;
result.Status = ChargeStatus.ONPROGRESS;
return(result);
}
ServerUri = new Uri(rInterface.APIURL);
parmeters.Add(new WebRequestParameters("appKey", rInterface.Username, false));
parmeters.Add(new WebRequestParameters("appSecret", KMAes.DecryptStringAES(rInterface.Userpassword), false));
parmeters.Add(new WebRequestParameters("phoneNo", order.MobileNumber, false));
parmeters.Add(new WebRequestParameters("prodCode", taocan.Serial, false));
parmeters.Add(new WebRequestParameters("backUrl", rInterface.CallBackUrl, false));
parmeters.Add(new WebRequestParameters("transNo", order.Id.ToString(), false));
SendRequest(parmeters, false, out succeed);
if (!string.IsNullOrEmpty(Response))
{
JObject jsonResult = JObject.Parse(Response);
order.OutId = jsonResult["orderId"] != null? jsonResult["orderId"].ToString():"";
string res = jsonResult["respCode"] != null?jsonResult["respCode"].ToString():"";
string resMsg = jsonResult["respMsg"] != null?jsonResult["respMsg"].ToString():"";
switch (res.ToLower())
{
case "jx0000":
result.Message = ChargeConstant.CHARGING;
result.Status = ChargeStatus.ONPROGRESS;
break;
case "0000":
case "00000":
case "000000":
result.Message = ChargeConstant.SUCCEED_CHARGE;
result.Status = ChargeStatus.SUCCEED;
break;
case "jx0001":
result.Message = ChargeConstant.AGENT_WRONG_PASSWORD;
result.Status = ChargeStatus.FAILED;
break;
case "jx0002":
result.Message = ChargeConstant.AGENT_NOT_BIND_IP;
result.Status = ChargeStatus.FAILED;
break;
case "jx0003":
result.Message = ChargeConstant.AGENT_IP_NOT_MATCH;
result.Status = ChargeStatus.FAILED;
break;
case "jx0004":
result.Message = ChargeConstant.RESOURCE_PRODUCT_NOT_EXIST;
result.Status = ChargeStatus.FAILED;
break;
case "jx0005":
result.Message = ChargeConstant.RESOURCE_NOT_ENOUGH_MONEY;
result.Status = ChargeStatus.FAILED;
break;
default:
result.Message = resMsg;
result.Status = ChargeStatus.FAILED;
break;
}
ChangeOrderStatus(order, result);
}
}
catch (Exception ex)
{
}finally
{
if (db != null)
{
db.Dispose();
}
}
return(result);
}
public virtual void ProceedOrder(ChargeOrder order, out ChargeResult result, bool isSOAPAPI = false)
{
lock (o)
{
Logger.Info("Processing order...");
Logger.Info("OrderId:" + order.Id);
result = new ChargeResult();
using (chargebitEntities db = new chargebitEntities())
{
if (!isSOAPAPI)
{
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == order.ResourceId select ri).FirstOrDefault <Resrouce_interface>();
if (rInterface == null)
{
result.Status = ChargeStatus.FAILED;
result.Message = ChargeConstant.RESOURCE_INTERFACE_NOT_CONFIGURED;
return;
}
if (string.IsNullOrEmpty(rInterface.APIURL))
{
result.Status = ChargeStatus.FAILED;
result.Message = ChargeConstant.RESOURCE_INTERFACE_APIURL_EMPTY;
return;
}
}
Charge_Order cOrder = (from o in db.Charge_Order where o.Id == order.Id select o).FirstOrDefault <Charge_Order>();
if (cOrder == null)
{
result.Status = ChargeStatus.FAILED;
result.Message = ChargeConstant.ORDER_NOT_EXIST;
return;
}
cOrder.Process_time = KMBit.Util.DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
Resource_taocan taocan = (from t in db.Resource_taocan where t.Id == order.ResourceTaocanId select t).FirstOrDefault <Resource_taocan>();
if (order.AgencyId == 0)
{
cOrder.Payed = order.Payed;
//cOrder.Sale_price = taocan.Sale_price;
//cOrder.Purchase_price = taocan.Sale_price;
//cOrder.Platform_Cost_Price = taocan.Purchase_price;
//cOrder.Platform_Sale_Price = taocan.Sale_price;
//cOrder.Revenue = taocan.Sale_price- taocan.Purchase_price;
cOrder.Status = 10;//等待充值
result.Status = ChargeStatus.SUCCEED;
db.SaveChanges();
return;
}
Users agency = (from u in db.Users where u.Id == order.AgencyId select u).FirstOrDefault <Users>();
Agent_route ruote = (from au in db.Agent_route where au.Id == order.RouteId select au).FirstOrDefault <Agent_route>();
if (ruote != null)
{
//no need to verify agent remaining amount or credit amount if the charge is marketing order
if (cOrder.MarketOrderId <= 0)
{
float price = taocan.Sale_price * ruote.Discount;
if (agency.Pay_type == 1)
{
if (agency.Remaining_amount < price)
{
result.Message = ChargeConstant.AGENT_NOT_ENOUGH_MONEY;
result.Status = ChargeStatus.FAILED;
cOrder.Status = 3;//failed
cOrder.Message = result.Message;
cOrder.Completed_Time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
//db.Charge_Order.Remove(cOrder);
db.SaveChanges();
return;
}
else
{
agency.Remaining_amount = agency.Remaining_amount - price;
result.Status = ChargeStatus.SUCCEED;
cOrder.Payed = true;
Logger.Info("Payment:" + price);
Logger.Info("Payment has been executed on agent remaining amount.");
db.SaveChanges();
}
}
else if (agency.Pay_type == 2)
{
if (agency.Remaining_amount < price)
{
if (agency.Remaining_amount + agency.Credit_amount < price)
{
result.Message = ChargeConstant.AGENT_NOT_ENOUGH_CREDIT;
result.Status = ChargeStatus.FAILED;
cOrder.Status = 3;//failed
cOrder.Message = result.Message;
cOrder.Completed_Time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
//db.Charge_Order.Remove(cOrder);
db.SaveChanges();
return;
}
else
{
cOrder.Payed = true;
agency.Remaining_amount = agency.Remaining_amount - price;
agency.Credit_amount = agency.Credit_amount - (price - agency.Remaining_amount);
Logger.Info("Payment:" + price);
Logger.Info("Payment has been executed on agent Credit_amount amount.");
db.SaveChanges();
result.Status = ChargeStatus.SUCCEED;
}
}
else
{
agency.Remaining_amount = agency.Remaining_amount - price;
result.Status = ChargeStatus.SUCCEED;
Logger.Info("Payment:" + price);
Logger.Info("Payment has been executed on agent remaining amount.");
db.SaveChanges();
cOrder.Payed = true;
}
}
}
cOrder.Status = 10;
//cOrder.Sale_price = ruote.Sale_price;
//cOrder.Purchase_price = price;
//cOrder.Platform_Cost_Price = taocan.Purchase_price;
//cOrder.Platform_Sale_Price = taocan.Sale_price;
//cOrder.Revenue = price - taocan.Purchase_price;
db.SaveChanges();
}
if (result.Status == ChargeStatus.FAILED)
{
//db.Charge_Order.Remove(cOrder);
}
else
{
if (cOrder.MarketOrderId > 0)
{
Marketing_Orders mOrder = (from mo in db.Marketing_Orders where mo.Id == cOrder.MarketOrderId select mo).FirstOrDefault <Marketing_Orders>();
if (mOrder != null)
{
mOrder.Used = true;
mOrder.Sent = true;
mOrder.UsedTime = KMBit.Util.DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
mOrder.PhoneNumber = cOrder.Phone_number;
mOrder.OpenId = cOrder.DeviceMacAddress;
}
}
}
db.SaveChanges();
}
Logger.Info("ProceedOrder Done！");
}
}
public ChargeResult Charge(ChargeOrder order)
{
ChargeResult result = null;
ICharge chargeMgr = null;
chargebitEntities db = null;
Charge_Order cOrder = null;
try
{
db = new chargebitEntities();
cOrder = (from co in db.Charge_Order where co.Id == order.Id select co).FirstOrDefault <Charge_Order>();
if (cOrder == null)
{
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = ChargeConstant.ORDER_NOT_EXIST
};
return(result);
}
Resource_taocan taocan = (from tc in db.Resource_taocan where tc.Id == order.ResourceTaocanId select tc).FirstOrDefault <Resource_taocan>();
if (!taocan.Enabled)
{
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = ChargeConstant.RESOURCE_TAOCAN_DISABLED
};
return(result);
}
KMBit.DAL.Resource resource = (from ri in db.Resource
join tr in db.Resource_taocan on ri.Id equals tr.Resource_id
where tr.Id == order.ResourceTaocanId
select ri).FirstOrDefault <Resource>();
if (resource == null)
{
db.Charge_Order.Remove(cOrder);
db.SaveChanges();
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = "落地资源部存在，请联系平台管理员"
};
return(result);
}
if (!resource.Enabled)
{
db.Charge_Order.Remove(cOrder);
db.SaveChanges();
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = ChargeConstant.RESOURCE_DISABLED
};
return(result);
}
if (order.ResourceId == 0)
{
order.ResourceId = resource.Id;
}
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == order.ResourceId select ri).FirstOrDefault <Resrouce_interface>();
if (rInterface == null)
{
db.Charge_Order.Remove(cOrder);
db.SaveChanges();
result = new ChargeResult()
{
Status = ChargeStatus.FAILED, Message = ChargeConstant.RESOURCE_INTERFACE_NOT_CONFIGURED
};
return(result);
}
object o = null;
Assembly assembly = System.Reflection.Assembly.GetExecutingAssembly();
Type type = assembly.GetType(rInterface.Interface_classname);
o = Activator.CreateInstance(type);
chargeMgr = (ICharge)o;
result = chargeMgr.Charge(order);
}
catch (Exception ex)
{
if (cOrder != null)
{
db.Charge_Order.Remove(cOrder);
db.SaveChanges();
}
}
finally
{
if (db != null)
{
db.Dispose();
}
}
return(result);
}
public ChargeResult Charge(ChargeOrder order)
{
Logger.Info("Charging...");
ChargeResult result = new ChargeResult()
{
Status = ChargeStatus.FAILED
};
chargebitEntities db = null;
ProceedOrder(order, out result);
if (result.Status == ChargeStatus.FAILED)
{
return(result);
}
List <WebRequestParameters> parmeters = new List <WebRequestParameters>();
bool succeed = false;
try
{
db = new chargebitEntities();
Charge_Order corder = (from co in db.Charge_Order where co.Id == order.Id select co).FirstOrDefault <Charge_Order>();
corder.Process_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
KMBit.DAL.Resrouce_interface rInterface = (from ri in db.Resrouce_interface where ri.Resource_id == order.ResourceId select ri).FirstOrDefault <Resrouce_interface>();
Resource_taocan taocan = (from t in db.Resource_taocan where t.Id == order.ResourceTaocanId select t).FirstOrDefault <Resource_taocan>();
if (string.IsNullOrEmpty(rInterface.APIURL))
{
result.Status = ChargeStatus.FAILED;
result.Message = "资源充值API URL没有配置";
Logger.Error("Cannot get token.");
ChangeOrderStatus(order, result);
return(result);
}
ServerUri = new Uri(rInterface.APIURL);
if (string.IsNullOrEmpty(token))
{
Logger.Info("Token doesn't exist, try to request one.");
GetToken(rInterface);
}
else
{
Logger.Info("Token is already existed.");
}
if (DateTimeUtil.ConvertDateTimeToInt(DateTime.Now) > expiredTime)
{
Logger.Info("Existing token is already expired, try to request a new one.");
GetToken(rInterface);
}
if (string.IsNullOrEmpty(token))
{
result.Status = ChargeStatus.FAILED;
result.Message = "获取令牌失败";
Logger.Error("Failed to request token, please contact gatway administrator. The charge order will be marked as fail, refound the currency to agent.");
ChangeOrderStatus(order, result);
return(result);
}
StringBuilder jsonParam = new StringBuilder();
corder.Out_Order_Id = rInterface.Username + DateTimeUtil.ConvertDateTimeToInt(DateTime.Now).ToString("0");
order.OutOrderId = corder.Out_Order_Id;
db.SaveChanges();
jsonParam.Append("[");
jsonParam.Append("{");
jsonParam.Append("\"orderId\":");
jsonParam.Append("\"" + corder.Out_Order_Id.Trim() + "\",");
jsonParam.Append("\"accNumber\":");
jsonParam.Append("\"" + corder.Phone_number.Trim() + "\",");
jsonParam.Append("\"pricePlanCd\":");
jsonParam.Append("\"" + taocan.Serial.Trim() + "\",");
jsonParam.Append("\"orderType\":");
jsonParam.Append("\"0\"");
jsonParam.Append("}");
jsonParam.Append("]");
parmeters.Add(new WebRequestParameters()
{
Name = "para", Value = jsonParam.ToString()
});
parmeters.Add(new WebRequestParameters()
{
Name = "token", Value = token
});
parmeters.Add(new WebRequestParameters()
{
Name = "id", Value = rInterface.Username.Trim()
});
SendRequest(parmeters, false, out succeed, RequestType.POST);
if (!string.IsNullOrEmpty(Response))
{
try
{
Newtonsoft.Json.Linq.JObject jsonResult = Newtonsoft.Json.Linq.JObject.Parse(Response);
string ret = jsonResult["result"].ToString();
string message = jsonResult["resultMsg"].ToString();
if (!string.IsNullOrEmpty(ret) && ret.Trim() == "0")
{
result.Status = ChargeStatus.ONPROGRESS;
}
else
{
result.Status = ChargeStatus.FAILED;
}
result.Message = message;
}
catch (Exception ex)
{
Logger.Fatal(ex);
result.Status = ChargeStatus.FAILED;
result.Message = "系统错误，请联系管理员";
}
if (result.Message != null && result.Message.Length > 5000)
{
result.Message = result.Message.Substring(0, 5000);
}
ChangeOrderStatus(order, result);
}
}
catch (Exception ex)
{
Logger.Fatal(ex);
}
finally
{
if (db != null)
{
db.Dispose();
}
}
Logger.Info("Charging done!");
return(result);
}
public APIChargeResult Charge(int agentId, int routeId, string mobile, string spname, string province, string city, string callBackUrl, string client_order_id)
{
if (string.IsNullOrEmpty(mobile))
{
throw new KMBitException("手机号码不能为空");
}
if (string.IsNullOrEmpty(spname))
{
throw new KMBitException("手机号归属运行商不能为空");
}
if (string.IsNullOrEmpty(province))
{
throw new KMBitException("手机号归属省份不能为空");
}
//if (string.IsNullOrEmpty(city))
//{
// throw new KMBitException("手机号归属城市不能为空");
//}
ChargeResult result = null;
ChargeBridge cb = new ChargeBridge();
ChargeOrder order = new ChargeOrder()
{
ClientOrderId = client_order_id,
Payed = false,
OperateUserId = 0,
AgencyId = agentId,
Id = 0,
Province = province,
City = city != null? city:"",
MobileNumber = mobile,
MobileSP = spname,
OutOrderId = "",
ResourceId = 0,
ResourceTaocanId = 0,
RouteId = routeId,
CreatedTime = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now),
CallbackUrl = callBackUrl
};
chargebitEntities db = null;
OrderManagement orderMgt = new OrderManagement();
try
{
db = new chargebitEntities();
Users agent = (from u in db.Users where u.Id == agentId select u).FirstOrDefault <Users>();
if (agent == null)
{
throw new KMBitException(string.Format("编号为{0}的代理商不存在", agentId));
}
if (!agent.Enabled)
{
throw new KMBitException(string.Format("代理商{0}已经被关闭禁用", agent.Name));
}
//verify mobile sp
Agent_route route = (from r in db.Agent_route where r.Id == routeId && r.User_id == agentId select r).FirstOrDefault <Agent_route>();
if (route == null)
{
throw new KMBitException(string.Format("代理商 {1} 编号为{0}的路由不存在", routeId, agent.Name));
}
if (!route.Enabled)
{
throw new KMBitException(string.Format("代理商 {1} 编号为{0}的路由已经被关闭", routeId, agent.Name));
}
Resource_taocan taocan = (from t in db.Resource_taocan where t.Id == route.Resource_taocan_id select t).FirstOrDefault <Resource_taocan>();
int spId = (from sp in db.Sp where sp.Name.Contains(spname.Trim()) select sp.Id).FirstOrDefault <int>();
if (spId == 0)
{
throw new KMBitException("手机运营商的值必须是-中国移动，中国联通或者中国电信");
}
int provinceId = (from area in db.Area where area.Name.Contains(province) select area.Id).FirstOrDefault <int>();
if (provinceId == 0)
{
throw new KMBitException("手机号码归属省份值不正确，例如 河南，海南，江苏，请以此种格式传入");
}
if (taocan.NumberProvinceId > 0 && provinceId > 0)
{
if (provinceId != taocan.NumberProvinceId)
{
throw new KMBitException(string.Format("当前路由不能充{0}-{1}的手机号码", spname, province));
}
}
order = orderMgt.GenerateOrder(order);
//result = cb.Charge(order);
if (order.Id > 0)
{
result = new ChargeResult();
result.Status = ChargeStatus.SUCCEED;
result.Message = "充值信息已提交到充值系统";
}
}
catch (KMBitException kex)
{
throw kex;
}
catch (Exception ex)
{
logger.Error(ex);
result = new ChargeResult();
result.Status = ChargeStatus.FAILED;
result.Message = "未知错误，请联系平台管理员";
}
APIChargeResult apiResult = new APIChargeResult();
//apiResult.Message = result.Message;
apiResult.OrderId = order.Id;
switch (result.Status)
{
case ChargeStatus.SUCCEED:
apiResult.Status = ChargeStatus.SUCCEED.ToString();
apiResult.Message = result.Message;
break;
case ChargeStatus.FAILED:
apiResult.Status = ChargeStatus.FAILED.ToString();
break;
case ChargeStatus.ONPROGRESS:
apiResult.Status = ChargeStatus.SUCCEED.ToString();
break;
case ChargeStatus.PENDIND:
apiResult.Status = ChargeStatus.SUCCEED.ToString();
break;
}
return(apiResult);
}
