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 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 void GetChargeStatus(int resourceId)
{
chargebitEntities db = new chargebitEntities();
try
{
List <Charge_Order> orders = (from o in db.Charge_Order where o.Status == 1 select o).ToList <Charge_Order>();
if (orders.Count <= 0)
{
Logger.Info("No orders need to sync status of resourceId:" + resourceId);
return;
}
Logger.Info(string.Format("{0} orders need to sync status", orders.Count));
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.APIURL);
List <WebRequestParameters> parmeters = new List <WebRequestParameters>();
parmeters.Add(new WebRequestParameters("V", version, false));
parmeters.Add(new WebRequestParameters("Action", "getReports", false));
SortedDictionary <string, string> paras = new SortedDictionary <string, string>();
paras["Account"] = rInterface.Username;
paras["Count"] = statusCount.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));
}
bool succeed = false;
SendRequest(parmeters, false, out succeed);
if (succeed && !string.IsNullOrEmpty(Response))
{
JObject jsonRes = JObject.Parse(Response);
string code = jsonRes["Code"] != null ? jsonRes["Code"].ToString() : "";
string message = jsonRes["Message"] != null ? jsonRes["Message"].ToString() : "";
Logger.Info(string.Format("Code:{0}, Message:{1}", code, message));
if (!string.IsNullOrEmpty(code) && code == "0" && !string.IsNullOrEmpty(message) && message == "OK")
{
JArray charges = (JArray)jsonRes["Reports"];
if (charges != null)
{
Logger.Info(string.Format("Get {0} reports from resource", charges.Count));
for (int i = 0; i < charges.Count; i++)
{
JObject report = (JObject)charges[i];
string taskId = report["TaskID"] != null? report["TaskID"].ToString():"";
string phone = report["Mobile"] != null? report["Mobile"].ToString():"";
string status = report["Status"] != null? report["Status"].ToString():"";
string time = report["ReportTime"] != null?report["ReportTime"].ToString():"";
string rptCode = report["ReportCode"] != null? report["ReportCode"].ToString():"";
Logger.Info(string.Format("TaskId:{0}, MobilePhone:{1}, Status:{2}, Time:{3}", taskId, phone, status, time));
Charge_Order order = (from o in orders where o.Out_Order_Id == taskId && o.Phone_number == phone select o).FirstOrDefault <Charge_Order>();
if (order != null && !string.IsNullOrEmpty(taskId) && !string.IsNullOrEmpty(phone) && !string.IsNullOrEmpty(status))
{
DateTime cTime = DateTime.MinValue;
DateTime.TryParse(time, out cTime);
if (cTime != DateTime.MinValue)
{
order.Completed_Time = DateTimeUtil.ConvertDateTimeToInt(cTime);
}
if (status == "4")
{
order.Status = 2;
order.Message = "充值成功:" + rptCode;
RemoveQRCode(order);
}
else if (status == "5")
{
order.Status = 3;
order.Message = "充值失败:" + rptCode;
if (order.Agent_Id > 0)
{
if (order.MarketOrderId <= 0)
{
Users agency = (from u in db.Users where u.Id == order.Agent_Id select u).FirstOrDefault <Users>();
if (agency != null)
{
agency.Remaining_amount += order.Purchase_price;
order.Refound = true;
}
}
else
{
order.Message = string.Format("充值失败:{0},二维码可以重复扫码使用直到充值成功", rptCode);
order.Refound = false;
Marketing_Orders mOrder = (from mo in db.Marketing_Orders where mo.Id == order.MarketOrderId select mo).FirstOrDefault <Marketing_Orders>();
if (mOrder != null)
{
mOrder.Used = false;
}
}
db.SaveChanges();
}
}
}
//send back status to agent api calling
if (!string.IsNullOrEmpty(order.CallBackUrl))
{
this.SendStatusBackToAgentCallback(order);
}
}
if (charges != null && charges.Count > 0)
{
db.SaveChanges();
}
}
}
}
}
catch (KMBitException kex)
{
Logger.Warn(kex);
}catch (Exception ex)
{
Logger.Fatal(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);
}