public ActionResult AddUserInfo(tb_userinfo model)
{
try
{
if (db.tb_userinfos.Any(s => s.UserID == model.UserID))
{
return(Json(Comm.ToJsonResult("Error", "用户已存在"), JsonRequestBehavior.AllowGet));
}
else
{
model.Balance = 0;
model.FirstCharge = Enums.Enums.YesOrNo.No;
model.RewardMoney = 0;
model.Integral = 0;
model.UserGrade = UserGrade.Primary;
model.ParentID = 0;
model.Siteid = AliPayConfig.MediaID;
model.Memberid = AliPayConfig.Memberid;
model.ThisMonthSettlementMoney = 0;
model.ThisMonthEstimateIncome = 0;
model.LastMonthEstimateIncome = 0;
model.LastMonthSettlementMoney = 0;
model.AliAccount = string.Empty;
model.AliUserName = string.Empty;
db.tb_userinfos.Add(model);
int row = db.SaveChanges();
if (row > 0)
{
string tempazoneid = "";
tb_TKInfo tk = db.tb_TKInfo.FirstOrDefault(s => s.PIDState == YesOrNo.No);
if (tk != null)
{
tempazoneid = tk.Adzoneid;
}
tk.PIDState = YesOrNo.Yes;
tk.UID = model.ID;
string uscode = Comm.GetCreateUserCode(model.Phone, model.ID);
var usmodel = db.tb_userinfos.Find(model.ID);
usmodel.UserCode = uscode;
usmodel.Adzoneid = tempazoneid;
usmodel.PID = "mm_" + AliPayConfig.Memberid + "_" + AliPayConfig.MediaID + "_" + tempazoneid;
db.SaveChanges();
}
return(Json(Comm.ToJsonResult("Success", "成功"), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(Comm.ToJsonResult("Error", ex.Message), JsonRequestBehavior.AllowGet));
}
}
public void getinfo(string cmd, string data)
{
try
{
bool isload = false;
//创建广告位
if (cmd.Equals("adzone_add") && !isload)
{
isload = true;
Newtonsoft.Json.Linq.JObject datas = JsonHelper.DeserializeObject(data);
string memberID = datas.SelectToken("memberID").ToString();
string mediaID = datas.SelectToken("mediaID").ToString();
string adzoneID = datas.SelectToken("adzoneID").ToString();
string temppid = "mm_" + memberID + "_" + mediaID + "_" + adzoneID;
tb_TKInfo model = new tb_TKInfo();
model.Adzoneid = adzoneID;
model.Memberid = memberID;
model.PID = temppid;
model.PIDState = YesOrNo.No;
model.Siteid = mediaID;
db.tb_TKInfo.Add(model);
db.SaveChanges();
isload = false;
}
//付款订单
else if (cmd.Equals("payorderorder") && !isload)
{
isload = true;
var datas = Newtonsoft.Json.JsonConvert.DeserializeObject(data) as JContainer;//转json格式 JsonHelper.DeserializeObject(data);
string ss2 = datas.ToString();
JsonSerializer serializer1 = new JsonSerializer();
StringReader sr1 = new StringReader(ss2);
object o1 = serializer1.Deserialize(new JsonTextReader(sr1), typeof(List <OrderModel>));
List <OrderModel> list = o1 as List <OrderModel>;
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
string tempgoodsid = list[i].商品ID.ToString(); // datas.SelectToken("商品ID").ToString();
string ordercode = list[i].订单编号.ToString(); //datas.SelectToken("订单编号").ToString();
string ggid = list[i].广告位ID.ToString(); //datas.SelectToken("广告位ID").ToString();
string goodimg = "";
decimal ygsr = decimal.Round(decimal.Parse(list[i].预估收入.ToString() == "" ? "0" : list[i].预估收入.ToString()), 2);
decimal jsje = decimal.Round(decimal.Parse(list[i].结算金额.ToString() == "" ? "0" : list[i].结算金额.ToString()), 2);
decimal xgyg = decimal.Round(decimal.Parse(list[i].效果预估.ToString()), 2);
string ordertime = list[i].创建时间.ToString();
string ratestr = list[i].收入比率.ToString();
string[] tempstr = ratestr.Split('%');
//var tborder = db.Tborder.FirstOrDefault(s => s.OrderCode == ordercode);
//如果还没同步过订单则进行数据保存
if (!db.Tborder.Any(s => s.OrderCode == ordercode))
{
//根据商品id获取商品图片
//ITopClient client = new DefaultTopClient(AliPayConfig.tkapp_url, AliPayConfig.tkapp_key, AliPayConfig.tkapp_secret, "json");
//TbkItemInfoGetRequest req = new TbkItemInfoGetRequest();
//req.NumIids = tempgoodsid;
//req.Platform = 2L;
////req.Ip = "11.22.33.43";
//TbkItemInfoGetResponse rsp = client.Execute(req);
//var jsondataformain = Newtonsoft.Json.JsonConvert.DeserializeObject(rsp.Body) as JContainer;//转json格式
//string s = jsondataformain.SelectToken("tbk_item_info_get_response").ToString();
//var js = Newtonsoft.Json.JsonConvert.DeserializeObject(s) as JContainer;
//string s1 = js.SelectToken("results").ToString();
//var js1 = Newtonsoft.Json.JsonConvert.DeserializeObject(s1) as JContainer;
//string s2 = js1.SelectToken("n_tbk_item").ToString();
//JsonSerializer serializer = new JsonSerializer();
//StringReader sr = new StringReader(s2);
//object o = serializer.Deserialize(new JsonTextReader(sr), typeof(stroemodel));
//List<stroemodel> modellist = o as List<stroemodel>;
//if (modellist.Count > 0)
//{
// goodimg = modellist[0].pict_url;
//}
Tborder m = new Tborder();
m.AdsenseID = ggid;
m.EffectIncome = xgyg;
m.EstimateIncome = xgyg;
m.GoodsID = tempgoodsid;
m.GoodsImage = goodimg;
m.GoodsName = list[i].商品信息.ToString(); //datas.SelectToken("商品信息").ToString();
m.GoodsPrice = decimal.Round(decimal.Parse(list[i].商品单价.ToString()), 2);
m.IncomeRate = decimal.Round(decimal.Parse(tempstr[0]), 2);
m.OrderCode = ordercode;
m.OrderPrice = decimal.Round(decimal.Parse(list[i].付款金额.ToString()), 2);
m.OrderState = TbOrderState.NoBalance;
m.OrderTime = Convert.ToDateTime(ordertime);
m.OrderType = list[i].订单类型.ToString();//datas.SelectToken("订单类型").ToString();
m.SettlementMoney = jsje;
m.SettlementTime = Convert.ToDateTime("1990-01-01");
m.StoreName = list[i].所属店铺.ToString(); //datas.SelectToken("所属店铺").ToString();
db.Tborder.Add(m);
int row = db.SaveChanges();
if (row > 0)
{
//计算用户结算佣金
OrderCommon oc = new OrderCommon();
oc.SetUserGradeRate(ggid, xgyg, "pay", ordertime, ordercode, "1990-01-01");
isload = false;
}
}
}
}
}
//结算订单
else if (cmd.Equals("Settlementorder") && !isload)
{
var datas = Newtonsoft.Json.JsonConvert.DeserializeObject(data) as JContainer;//转json格式 JsonHelper.DeserializeObject(data);
string ss2 = datas.ToString();
JsonSerializer serializer1 = new JsonSerializer();
StringReader sr1 = new StringReader(ss2);
object o1 = serializer1.Deserialize(new JsonTextReader(sr1), typeof(List <OrderModel>));
List <OrderModel> list = o1 as List <OrderModel>;
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
string tempgoodsid = list[i].商品ID.ToString();
string ordercode = list[i].订单编号.ToString();
string ggid = list[i].广告位ID.ToString();
string goodimg = "";
decimal ygsr = decimal.Round(decimal.Parse(list[i].预估收入.ToString() == "" ? "0" : list[i].预估收入.ToString()), 2);
decimal jsje = decimal.Round(decimal.Parse(list[i].结算金额.ToString() == "" ? "0" : list[i].结算金额.ToString()), 2);
string ordertime = list[i].创建时间.ToString();
string jstime = list[i].结算时间.ToString();
string ratestr = list[i].收入比率.ToString();
string[] tempstr = ratestr.Split('%');
//如果还没同步过订单则进行数据保存
if (!db.Tborder.Any(s => s.OrderCode == ordercode))
{
//根据商品id获取商品图片
//ITopClient client = new DefaultTopClient(AliPayConfig.tkapp_url, AliPayConfig.tkapp_key, AliPayConfig.tkapp_secret, "json");
//TbkItemInfoGetRequest req = new TbkItemInfoGetRequest();
//req.NumIids = tempgoodsid;
//req.Platform = 2L;
////req.Ip = "11.22.33.43";
//TbkItemInfoGetResponse rsp = client.Execute(req);
//var jsondataformain = Newtonsoft.Json.JsonConvert.DeserializeObject(rsp.Body) as JContainer;//转json格式
//string s = jsondataformain.SelectToken("tbk_item_info_get_response").ToString();
//var js = Newtonsoft.Json.JsonConvert.DeserializeObject(s) as JContainer;
//string s1 = js.SelectToken("results").ToString();
//var js1 = Newtonsoft.Json.JsonConvert.DeserializeObject(s1) as JContainer;
//string s2 = js1.SelectToken("n_tbk_item").ToString();
//JsonSerializer serializer = new JsonSerializer();
//StringReader sr = new StringReader(s2);
//object o = serializer.Deserialize(new JsonTextReader(sr), typeof(stroemodel));
//List<stroemodel> modellist = o as List<stroemodel>;
//if (modellist.Count > 0)
//{
// goodimg = modellist[0].pict_url;
//}
//[{"创建时间":"2019-03-21 09:25:25","点击时间":"2019-03-21 09:24:14","商品信息":"4条装日系内裤女纯棉高腰大码女士三角裤全棉质面料少女蕾丝短裤",
//"商品ID":"541009215405","掌柜旺旺":"wisdomfeng","所属店铺":"美多拉内衣","商品数":"1","商品单价":"76.00","订单状态":"订单付款","订单类型":"淘宝","收入比率":"9.00 %",
//"分成比率":"100.00 %","付款金额":"37.80","效果预估":"3.40","结算金额":"0.00","预估收入":"0.00","结算时间":"","佣金比率":"9.00 %","佣金金额":"0.00","技术服务费比率":"",
//"补贴比率":"0.00 %","补贴金额":"0.00","补贴类型":"-","成交平台":"无线","第三方服务来源":"--","订单编号":"384487585332201957","类目名称":"内衣/家居服","来源媒体ID":"283700162","来源媒体名称":"rp云购",
//"广告位ID":"96815000311","广告位名称":"001"}]
Tborder m = new Tborder();
m.AdsenseID = ggid;
m.EffectIncome = decimal.Round(decimal.Parse(list[i].效果预估.ToString()), 2);
m.EstimateIncome = ygsr;
m.GoodsID = tempgoodsid;
m.GoodsImage = goodimg;
m.GoodsName = list[i].商品信息.ToString();//datas.SelectToken("商品信息").ToString();
m.GoodsPrice = decimal.Round(decimal.Parse(list[i].商品单价.ToString()), 2);
m.IncomeRate = decimal.Round(decimal.Parse(tempstr[0]), 2);
m.OrderCode = list[i].订单编号.ToString();//datas.SelectToken("订单编号").ToString();
m.OrderPrice = decimal.Round(decimal.Parse(list[i].付款金额.ToString()), 2);
m.OrderState = TbOrderState.IsBalance;
m.OrderTime = Convert.ToDateTime(list[i].创建时间.ToString());
m.OrderType = list[i].订单类型.ToString();
m.SettlementMoney = jsje;
m.SettlementTime = Convert.ToDateTime(jstime);
m.StoreName = list[i].所属店铺.ToString();// datas.SelectToken("所属店铺").ToString();
db.Tborder.Add(m);
int row = db.SaveChanges();
if (row > 0)
{
//计算用户结算佣金
OrderCommon oc = new OrderCommon();
oc.SetUserGradeRate(ggid, ygsr, "Settlement", ordertime, ordercode, jstime);
isload = true;
}
}
else
{
var tborder = db.Tborder.FirstOrDefault(s => s.OrderCode == ordercode);
tborder.SettlementMoney = jsje;
tborder.EstimateIncome = ygsr;
tborder.OrderState = TbOrderState.IsBalance;
tborder.SettlementTime = Convert.ToDateTime(jstime);
int row = db.SaveChanges();
//if (row > 0)
//{
//计算用户结算佣金
OrderCommon oc = new OrderCommon();
oc.SetUserGradeRate(ggid, ygsr, "Settlement", ordertime, ordercode, jstime);
isload = true;
//}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
