public ActionResult Index()
{
var actFanXian = ef.hx_ActivityTable.Where(c => c.ActName == "12月投资立得返现奖励").OrderByDescending(c => c.ActEndtime).FirstOrDefault();
ViewBag.FanXianSTime = actFanXian.ActStarttime;
ViewBag.FanXianETime = actFanXian.ActEndtime;
bool isPingguo = DateTime.Now.Millisecond % 2 == 1;
string close_tanchu = checkStart() ? (isPingguo ? "style='top: 17%;background:url(/images/tan1260_3_close.png) no-repeat;'" : "style='top: 17%;background:url(/images/tan1260_4_close.png) no-repeat;'") : "";
string tanchu = checkStart() ? (isPingguo ? "/Images/tan1260_3.png" : "/Images/tan1260_4.png") : "/Images/tan1260_1.png";
ViewBag.Tanchu = tanchu;
ViewBag.Close_tanchu = close_tanchu;
string firstTimePerDay = Utils.GetCookie("FirstTimePerDay");
ViewBag.FirstTimePerDay = string.IsNullOrWhiteSpace(firstTimePerDay) ? "block" : "none";
if (string.IsNullOrWhiteSpace(firstTimePerDay))
{
var cookie = new HttpCookie("FirstTimePerDay", "That's ok");//加密身份信息，保存至Cookie
cookie.Expires = DateTime.Now.Date.AddDays(1);
Response.Cookies.Add(cookie);
}
int uid = Utils.checkloginsessiontop();
hx_member_table HUsr = new hx_member_table();
if (uid > 0)
{
HUsr = ef.hx_member_table.Where(p => p.registerid == uid).FirstOrDefault();
}
ViewBag.uid = uid;
if (HUsr != null)
{
// ViewBag.amt = HUsr.available_balance== null ? 0.00M : HUsr.available_balance;
ViewBag.amt = HUsr.available_balance;
}
else
{
ViewBag.amt = 0.00;
}
hx_borrowing_target hbt = ef.hx_borrowing_target.Where(p => p.project_type_id == 6 && p.tender_state >= 2 && p.tender_state <= 5).OrderByDescending(p => p.targetid).Take(1).FirstOrDefault();
List <V_borrowing_target_addlist> porlist = ef.V_borrowing_target_addlist.Where(p => p.tender_state >= 2 && p.tender_state <= 5 && p.project_type_id != 6
//&& p.recommend==1
).OrderBy(p => p.tender_state).ThenByDescending(p => p.indexorder).ThenByDescending(p => p.targetid).Take(6).ToList();
ViewBag.hbt = hbt;
GetCacheNesList nes = new GetCacheNesList();
ViewBag.newslist = nes.GetNews(17, 3, 1, 1); //媒体新闻三张列表图片
ViewBag.news1list = nes.GetNews(21, 4, 0, 1); //公告
ViewBag.newslist2 = nes.GetNews(23, 4, 0, 1); //行业新闻
ViewBag.gonggao = nes.GetNews(21, 4, 0, 1); // 公告
return(View(porlist));
}
// GET: Topic/T20170106
public ActionResult Index()
{
int userid = Utils.checkloginsessiontop();
string userUrl = string.Empty;
if (userid > 0)
{
hx_member_table hUser = null;
if (userid == 0)
{
userUrl = "/usercenter/yaoqing";
}
else
{
hUser = ef.hx_member_table.Where(p => p.registerid == userid).FirstOrDefault();
}
ViewBag.UserUrl = userUrl != string.Empty ? userUrl : Utils.GetRe_url("Invitation/" + hUser.invitedcode + ".html");
}
else
{
ViewBag.UserUrl = "/usercenter/yaoqing";
}
string codesql = "select TOP 5 (SELECT mobile from hx_member_table where registerid = Invpeopleid) mobile,count(invcode) invcode from hx_td_Userinvitation where invtime >= '2017/1/6 00:00:00' AND invtime <= '2017/3/31 23:59:59' GROUP BY Invpeopleid ORDER BY invcode desc";//查询累计邀请人数排名
DataTable dtcode = DbHelperSQL.GET_DataTable_List(codesql);
if (dtcode.Rows.Count > 0)
{
ViewBag.RenShu = dtcode;
}
else
{
ViewBag.RenShu = null;
}
string codesql2 = "SELECT TOP 5 (SELECT t.mobile from hx_member_table t where t.registerid=a.registerid) mobile , SUM(Amt)amt FROM hx_UserAct a where RewTypeID = 1 AND Createtime >= '2017/1/6 00:00:00' AND Createtime <= '2017/3/31 23:59:59' AND registerid IN(SELECT distinct Invpeopleid from hx_td_Userinvitation where invtime >= '2017/1/6 00:00:00' AND invtime <= '2017/3/31 23:59:59') GROUP BY registerid ORDER BY amt desc";//查询累计邀请返现排名
DataTable dtcode2 = DbHelperSQL.GET_DataTable_List(codesql2);
if (dtcode2.Rows.Count > 0)
{
ViewBag.JinE = dtcode2;
}
else
{
ViewBag.JinE = null;
}
return(View());
}
/// <summary>
/// 新用户注册活动
/// </summary>
/// <param name="registerid">用户id</param>
/// <param name="ActUser">面向用户 0不限 1首次投资用户 2非首投用户 3每标首投用户 4每标最大投资用户 5所有投资用户</param>
protected internal void SendBonusAfterRegister(int registerid, string targetPlatform, int ActUser = 0)
{
/// <param name="ActTypeId">活动类型id 1新人活动/2短期活动/3常规活动/4邀请活动/5系统赠送 </param>
bool t = true;
B_member_table oy = new B_member_table();
hx_member_table investor = new hx_member_table();
investor = ef.hx_member_table.Where(c => c.registerid == registerid).FirstOrDefault(); //oy.GetModel(Registerid);//被推荐人 也就是投资人
string codesql = "SELECT invcode,Invpeopleid,invpersonid,invtime from hx_td_Userinvitation where invpersonid=" + registerid + " "; //查询本人是否已经被邀请注册过
DataTable dtcode = DbHelperSQL.GET_DataTable_List(codesql);
int uuid = dtcode.Rows.Count > 0 ? int.Parse(dtcode.Rows[0]["Invpeopleid"].ToString()) : 0; //邀请用户id
//用户等级为渠道 不参与活动
if (investor != null && investor.useridentity == 4)
{
t = false;
}
//老渠道机制判断 (推荐人等级为4渠道用户,投资次数大于等于1次 时可参与活动
if (uuid != 0)
{
M_member_table py = new M_member_table();
py = oy.GetModel(uuid);//推荐人
if (py != null && py.useridentity == 4)
{
t = false;
}
}
//新渠道机制判断
using (ChannelAct channelAct = new ChannelAct())
{
//按照渠道类型和投资次数判断是否参与此次活动
if (!channelAct.IsParticipateActivity(investor.channel_invitedcode, 0))
{
t = false;
}
}
if (t == true)
{
//新人注册奖励
List <hx_UserAct> hut = RegisterActBonus(registerid, targetPlatform, ActUser);
BonusRecordOperate(registerid, hut, "新人注册");
}
}
public bool InserXiCaiUser(hx_member_table user, string userid = "0", string display = "pc")
{
XiCaiUser xiCaiUser = new XiCaiUser()
{
Mobile = user.mobile,
XiCaiUserID = int.Parse(userid),
RegisterUserID = user.registerid,
Display = display
};
if (!ef.XiCaiUsers.Any(c => c.Mobile == user.mobile))
{
ef.XiCaiUsers.Add(xiCaiUser);
if (ef.SaveChanges() < 1)
{
LogInfo.WriteLog("注册成功，插入希财数据失败");
return(false); //("操作失败，请重新操作");
}
}
return(true);
}
public static bool AppLoginSite(string userID, string p, string key, loginIn login)
{
if (string.IsNullOrWhiteSpace(userID) || string.IsNullOrWhiteSpace(p) || string.IsNullOrWhiteSpace(key))
{
return(false);
}
//chuangtouEntities ef = new chuangtouEntities();
int uid = int.Parse(userID);
if (uid == 0)
{
FormsAuthentication.SignOut();
return(false);
}
hx_member_table user = ef.hx_member_table.Where(c => c.registerid == uid).FirstOrDefault();
if (user == null)
{
return(false);
}
int appID = p == "android" ? 654321 : (p == "ios" ? 123456 : 0);
var appAuthor = ef.ApplicationAuthorizations.Where(c => c.AppId == appID).FirstOrDefault();
if (appAuthor == null)
{
return(false);
}
string localKey = Utils.MD5(userID + appAuthor.AppSafeCode);
if (key.ToLower() != localKey.ToLower())
{
return(false);
}
string res = login(user.mobile, user.password, "", 1, true).ToString();
registerBackData loginRes = JsonConvert.DeserializeObject <registerBackData>(res);
return(loginRes.rs == "y");
}
/// <summary>
/// 检查手机号是否已经注册
/// </summary>
/// <param name="mobile"></param>
/// <returns></returns>
public string checkmobile(string mobile, int uid = 0)
{
string str = "";
hx_member_table ProPer = (from a in ef.hx_member_table where a.mobile == mobile || a.username == mobile select a).FirstOrDefault();
if (ProPer != null)
{
if (ProPer.registerid == uid && uid > 0)
{
str = "y";
}
else
{
str = "手机号已经被注册";
}
}
else
{
str = "y";
}
return(str);
}
// GET: Topic/T20161018
public ActionResult Index()
{
int userid = Utils.checkloginsessiontop();
if (userid > 0)
{
string userUrl = string.Empty;
hx_member_table hUser = null;
if (userid == 0)
{
userUrl = "/login.html";
}
else
{
hUser = ef.hx_member_table.Where(p => p.registerid == userid).FirstOrDefault();
}
var uid = userid;
var src = userUrl != string.Empty ? userUrl : Utils.GetRe_url("Invitation/" + hUser.invitedcode + ".html");
var url = Server.UrlEncode(src);
var desc = Server.UrlEncode(string.Format("邀请好友来投资，双方都有奖励奖励无上限！送3重豪礼不限量 iPhone7 plus等你拿！复制您的“邀请链接”,通过QQ,微信,微博等方式发给好友,好友通过“邀请链接”注册！{0}", src));
var title = Server.UrlEncode("邀请好友来投资,双方都有奖励奖励无上限！送3重豪礼不限量 iPhone7 plus等你拿！！");
var img = Server.UrlEncode(Utils.GetRe_url("images/logo.jpg"));
var site = Server.UrlEncode("创利投");
var qzone = userUrl != string.Empty ? userUrl : string.Format("http://sns.qzone.qq.com/cgi-bin/qzshare/cgi_qzshare_onekey?url={0}&desc={1}&title={2}&pics={3}&site={4}", url, desc, desc, img, site);
var weibo = userUrl != string.Empty ? userUrl : string.Format("http://v.t.sina.com.cn/share/share.php?appkey=&&source=&content={0}&url={1}&title={2}&pic={3}&site={4}", desc, url, desc, img, site);
var QQ = userUrl != string.Empty ? userUrl : string.Format("http://sns.qzone.qq.com/cgi-bin/qzshare/cgi_qzshare_onekey?to=pengyou&url={0}&desc={1}&title={2}&pics={3}&site={4} title = '分享到朋友社区'", url, desc, desc, img, site);
QQ = userUrl != string.Empty ? userUrl : string.Format("http://connect.qq.com/widget/shareqq/index.html?url={0}&title={1}&summary={2}&site={3}&pics={4}", url, desc, desc, site, img);
var doubai = userUrl != string.Empty ? userUrl : string.Format("http://www.douban.com/recommend/?url={0}&desc={1}&title={2}&pics={3}&site={4}", url, desc, desc, img, site);
var QQweibo = userUrl != string.Empty ? userUrl : string.Format("http://v.t.qq.com/share/share.php?title={0}&url={1}&appkey={2}&site={3}&pic={4}", desc, url, "125522", site, img);
var newWxUrl = string.Empty;
if (Utils.GetAppSetting("DeBug") == "1")
{
newWxUrl = userUrl != string.Empty ? userUrl : Utils.GetAppSetting("MDeBugURL") + "register/index?invitedcode=" + hUser.invitedcode;
}
else
{
newWxUrl = userUrl != string.Empty ? userUrl : Utils.GetAppSetting("MReleaseURL") + "register/index?invitedcode=" + hUser.invitedcode;
}
ViewBag.NewWxUrl = newWxUrl;
ViewBag.QQweibo = QQweibo;
ViewBag.doubai = doubai;
ViewBag.QQ = QQ;
ViewBag.qzone = qzone;
ViewBag.weibo = weibo;
ViewBag.UserUrl = userUrl;
ViewBag.codes = userUrl != string.Empty ? string.Empty : Utils.GetRe_url("Invitation/" + hUser.invitedcode + ".html");
ViewBag.HUsr = hUser;
}
else
{
string userUrl = string.Empty;
var src = userUrl != string.Empty ? userUrl : Utils.GetRe_url("20161110.html");
var url = Server.UrlEncode(src);
var desc = Server.UrlEncode(string.Format("邀请好友来投资，双方都有奖励奖励无上限！送3重豪礼不限量 iPhone7 plus等你拿！复制您的“邀请链接”,通过QQ,微信,微博等方式发给好友,好友通过“邀请链接”注册！{0}", src));
var title = Server.UrlEncode("邀请好友来投资,双方都有奖励奖励无上限！送3重豪礼不限量 iPhone7 plus等你拿！！");
var img = Server.UrlEncode(Utils.GetRe_url("images/logo.jpg"));
var site = Server.UrlEncode("创利投");
var qzone = userUrl != string.Empty ? userUrl : string.Format("http://sns.qzone.qq.com/cgi-bin/qzshare/cgi_qzshare_onekey?url={0}&desc={1}&title={2}&pics={3}&site={4}", url, desc, desc, img, site);
var weibo = userUrl != string.Empty ? userUrl : string.Format("http://v.t.sina.com.cn/share/share.php?appkey=&&source=&content={0}&url={1}&title={2}&pic={3}&site={4}", desc, url, desc, img, site);
var QQ = userUrl != string.Empty ? userUrl : string.Format("http://sns.qzone.qq.com/cgi-bin/qzshare/cgi_qzshare_onekey?to=pengyou&url={0}&desc={1}&title={2}&pics={3}&site={4} title = '分享到朋友社区'", url, desc, desc, img, site);
QQ = userUrl != string.Empty ? userUrl : string.Format("http://connect.qq.com/widget/shareqq/index.html?url={0}&title={1}&summary={2}&site={3}&pics={4}", url, desc, desc, site, img);
var doubai = userUrl != string.Empty ? userUrl : string.Format("http://www.douban.com/recommend/?url={0}&desc={1}&title={2}&pics={3}&site={4}", url, desc, desc, img, site);
var QQweibo = userUrl != string.Empty ? userUrl : string.Format("http://v.t.qq.com/share/share.php?title={0}&url={1}&appkey={2}&site={3}&pic={4}", desc, url, "125522", site, img);
var newWxUrl = string.Empty;
if (Utils.GetAppSetting("DeBug") == "1")
{
newWxUrl = userUrl != string.Empty ? userUrl : Utils.GetAppSetting("MDeBugURL") + "register/index";
}
else
{
newWxUrl = userUrl != string.Empty ? userUrl : Utils.GetAppSetting("MReleaseURL") + "register/index";
}
ViewBag.NewWxUrl = newWxUrl;
ViewBag.QQweibo = QQweibo;
ViewBag.doubai = doubai;
ViewBag.QQ = QQ;
ViewBag.qzone = qzone;
ViewBag.weibo = weibo;
ViewBag.UserUrl = userUrl;
ViewBag.codes = userUrl != string.Empty ? string.Empty : Utils.GetRe_url("");
}
return(View());
}
/// <summary>
/// 上次贷款图片
/// </summary>
/// <returns></returns>
public ActionResult UploadAvatar()
{
string json = "{\"ret\":0,\"msg\":\"上传图片失败！\"}";
int userid = Utils.checkloginsession();
if (userid > 0)
{
HttpFileCollection hfc = System.Web.HttpContext.Current.Request.Files;
string avatarPath = @"/Avatar/";
string imgPath = "";
string PhysicalPath = "";
if (hfc.Count > 0)
{
string suf = "";
if (!isImage(hfc[0].FileName, out suf))
{
json = "{\"ret\":0,\"msg\":\"图片只支持－－－gif|jpg|jpeg|png！\"}";
return(Content(json, "text/json"));
}
string fileName = string.Format("{0}.{1}", sjname(), suf);
var ss = hfc[0].ContentType;
PhysicalPath = Server.MapPath(avatarPath);
if (!System.IO.Directory.Exists(PhysicalPath))
{
System.IO.Directory.CreateDirectory(PhysicalPath);
}
PhysicalPath = PhysicalPath + fileName;
hfc[0].SaveAs(PhysicalPath);
imgPath = avatarPath + fileName;
}
if (Utils.CheckPictureSafe(PhysicalPath))
{
if (!string.IsNullOrEmpty(imgPath))
{
//imgPath = imgPath.Replace("/", "//");
json = "{\"ret\":1,\"path\":\"" + imgPath.Replace("/", "//") + "\"}";
//清理之前的头像文件
hx_member_table user = ef.hx_member_table.Where(p => p.registerid == userid).FirstOrDefault();//.Update(p => new hx_member_table { contactaddress = addr });
if (user != null && user.avatar != null && user.avatar != "0")
{
string oldFile = Server.MapPath("/") + user.avatar;
if (System.IO.File.Exists(oldFile))
{
System.IO.File.Delete(oldFile);
}
}
user.avatar = imgPath;
ef.SaveChanges();
//string sql = "update hx_member_table set avatar = '" + imgPath + "' where registerid =" + userid.ToString();//.Replace("//", "/")
//DBUtility.DbHelperSQL.RunSql(sql);
}
}
else
{ //图片安全提醒，您试除上传非法文件
json = "{\"ret\":0,\"path\":\"图片中含有非法文件\"}";
}
}
else
{
json = "{\"ret\":0,\"msg\":\"你未登录，请登录后再上传头像！\"}";
}
return(Content(json, "text/json"));
}
/// <summary>
/// 常规活动 现金奖励 发放（奖励流水 资金流水 系统消息）
/// </summary>
/// <param name="registerid">用户id</param>
/// <param name="investAmt">投资金额</param>
/// <param name="hat">活动对象</param>
/// <param name="bid_records_id">投标记录id</param>
/// <returns>bool 是否发放成功</returns>
private bool GeneralActCash(int Registerid, decimal InvestAmt, hx_ActivityTable hat, int bid_records_id, int lifeLoan = 0)
{
bool t = false;
//hx_ActivityTable hat = GetActTableInfo(ActTypeId, ActUser, 1);
if (hat != null)
{
B_member_table oy = new B_member_table();
//M_member_table investor = new M_member_table();
hx_member_table investor = new hx_member_table();
investor = ef.hx_member_table.Where(c => c.registerid == Registerid).FirstOrDefault(); //oy.GetModel(Registerid);//被推荐人 也就是投资人
DateTime dte = DateTime.Now;
string codesql = "SELECT invcode,Invpeopleid,invpersonid,invtime from hx_td_Userinvitation where invpersonid=" + Registerid + " ";//查询本人是否已经被邀请注册过
DataTable dtcode = DbHelperSQL.GET_DataTable_List(codesql);
//if (dtcode.Rows.Count > 0 || (investor != null && !string.IsNullOrWhiteSpace(investor.channel_invitedcode)))
//{
int uuid = dtcode.Rows.Count > 0 ? int.Parse(dtcode.Rows[0]["Invpeopleid"].ToString()) : 0; //邀请用户id
//用户等级为渠道 不参与活动
if (investor != null && investor.useridentity == 4)
{
return(t);
}
int investCount = B_usercenter.GetInvestCountByUserid(Registerid);
//老渠道机制判断 (推荐人等级为4渠道用户,投资次数大于等于1次 时可参与活动
if (uuid != 0)
{
M_member_table py = new M_member_table();
py = oy.GetModel(uuid);//推荐人
if ((py != null && py.useridentity == 4) && investCount == 1)
{
return(t);
}
}
//新渠道机制判断
using (ChannelAct channelAct = new ChannelAct())
{
//按照渠道类型和投资次数判断是否参与此次活动
if (!channelAct.IsParticipateActivity(investor.channel_invitedcode, investCount))
{
return(t);
}
}
//if (((py != null && py.useridentity == 4) || !string.IsNullOrWhiteSpace(investor.channel_invitedcode)) && B_usercenter.GetInvestCountByUserid(Registerid) == 1)
//{
// return t;
//}
//if (py.useridentity != 4)//渠道用户不执行 2016-11-8日添加
//{
string ActRule = hat.ActRule;
List <MAmtList> mlist = new List <MAmtList>();
JavaScriptSerializer js = new JavaScriptSerializer();
MActCash mc = new MActCash();
mc = js.Deserialize <MActCash>(ActRule);
//mlist = js.Deserialize<List<MAmtList>>(ActRule);
//获取该活动对应的已经发放奖励的人次
int TopNum = B_usercenter.GetTopNum(hat.ActID);
//获取该活动对应的已经发放奖励的总金额
decimal totalAmt = B_usercenter.GetTopAmtCount(hat.ActID);
if (hat.ActUser == 7)//特殊回款复投奖励类型，根据规则修订奖励基数--投资金额
{
InvestAmt = GetSepcialActAmt(Registerid, bid_records_id, InvestAmt, hat);
}
//根据投资金额计算对应现金奖励金额
decimal actamt = GetActAmt(mc, InvestAmt, TopNum, lifeLoan);
//检查分发奖励是否超过人数顶限或者总金额上限，上限为0表示不限制，如果超过直接跳过
if ((mc.TopAmt > totalAmt || mc.TopAmt == 0) && (mc.TopNum > TopNum || mc.TopNum == 0))
{
//t = true;
if (actamt > 0)//大于 0里写入对应的奖励数据
{
hx_UserAct hua = new hx_UserAct();
hua.ActTypeId = hat.ActTypeId;
hua.registerid = Registerid;
hua.RewTypeID = hat.RewTypeID;
hua.ActID = hat.ActID;
hua.Amt = actamt;
hua.Uselower = 0.00M;
hua.Usehight = 0.00M;
hua.AmtEndtime = DateTime.Parse(hat.ActEndtime.ToString()).AddMonths(1);
hua.AmtUses = 1; //没指定情况下默认为单独使用
hua.UseState = 5; //现金未转账
hua.UseTime = DateTime.Now;
hua.AmtProid = bid_records_id; //未使用默认为0,对于现金奖励该字段存放获得该奖励的投资记录id
hua.ISSmsOne = 0;
hua.IsSmsThree = 0;
hua.isSmsFifteen = 0;
hua.IsSmsSeven = 0;
hua.isSmsSixteen = 0;
hua.OrderID = decimal.Parse(Utils.Createcode());
hua.Createtime = DateTime.Now;
hua.Title = mc.ActName;
hua.UseLifeLoan = "";
ef.hx_UserAct.Add(hua);
int i = ef.SaveChanges();
if (i > 0)
{
//录入成功，后进行转账操作 1.获取用户对象
M_member_table p = new M_member_table();
B_member_table o = new B_member_table();
p = o.GetModel(Registerid);
if (p != null)
{
//2.调用商户向用户转账接口
Transfer tf = new Transfer();
ReTransfer retf = tf.ToUserTransfer(p.UsrCustId, actamt, hua.OrderID.ToString(), hua.ActID.ToString(), "/Thirdparty/ToUserTransfer");
if (retf != null && retf.RespCode == "000")
{
//3.事务处理操作账户及插入流水
#region 验签缓存处理
string cachename = retf.OrdId + "ToUserTransfer" + retf.InCustId;
if (Utils.GeTThirdCache(cachename) == 0)
{
Utils.SetThirdCache(cachename);
B_usercenter BUC = new B_usercenter();
int ic = BUC.UpateActToUserTransfer(retf, bid_records_id); //用户余额更新
if (ic > 0)
{
string sql = "SELECT registerid,username,mobile from hx_member_table where UsrCustId='" + retf.InCustId + "'";
DataTable dt = DbHelperSQL.GET_DataTable_List(sql);
if (dt.Rows.Count > 0)
{
#region 资金流水
B_usercenter ors = new B_usercenter();
decimal di = ors.GetUsridAvailable_balance(int.Parse(dt.Rows[0]["registerid"].ToString()));
// di = di + decimal.Parse(hua.Amt.ToString());
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hx_Capital_account_water(");
strSql.Append("membertable_registerid,income,expenditure,time_of_occurrence,account_balance,types_Finance,createtime,keyid,remarks)");
strSql.Append(" values (");
strSql.Append("" + int.Parse(dt.Rows[0]["registerid"].ToString()) + "," + decimal.Parse(hua.Amt.ToString()) + ",0,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'," + di + "," + (int)Enum.Parse(typeof(EnumTypesFinance), EnumTypesFinance.现金奖励.ToString()) + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',0,'" + "现金奖励" + "')");
DbHelperSQL.RunSql(strSql.ToString());
strSql.Clear();
#endregion
#region MyRegion 记录奖励流水表
string awardDescription = string.Format("{0},已汇入个人账户{1}{2}", hat.ActName, retf.TransAmt, GetBunusDescription(hat.RewTypeID));
AddBonusAccoutWater(int.Parse(hua.UserAct.ToString()), Registerid, decimal.Parse(retf.TransAmt), awardDescription);
#endregion
#region MyRegion 发送系统消息
string MContext = string.Format("尊敬的用户：您好！恭喜您成功参与{0}，获得{1}{2}如有问题可咨询创利投的客服！", hat.ActName, retf.TransAmt, GetBunusDescription(hat.RewTypeID));
AddSytemMessage(Registerid, hat.ActName, MContext);
#endregion
string msg = string.Format("尊敬的客户您好，您已成功投资创利投金服，获得返利{0}元，请登录官网查看。客服热线：010-53732056。", actamt.ToString("0.00"));
SendSMS.Send_SMS(dt.Rows[0]["mobile"].ToString(), msg);
}
}
t = true;
}
#endregion
}
}
}
}
//}
}
//}
}
return(t);
}
/// <summary>
/// 更新用户第三方余额
/// </summary>
/// <param name="usrid"></param>
/// <returns></returns>
public ReQueryBalanceBg Querybalance(int usrid)
{
M_QueryBalanceBg mbg = new M_QueryBalanceBg();
ReQueryBalanceBg retloan = new ReQueryBalanceBg();
hx_member_table mt = ef.hx_member_table.Where(p => p.registerid == usrid).FirstOrDefault();
string UsrCustId = "";
if (mt != null)
{
UsrCustId = mt.UsrCustId;
}
if (UsrCustId != null && UsrCustId != "")
{
if (UsrCustId.Length > 0)
{
mbg.Version = "10";
mbg.CmdId = "QueryBalanceBg";
mbg.MerCustId = Utils.GetMerCustID();
mbg.UsrCustId = UsrCustId;
StringBuilder chkVal = new StringBuilder();
chkVal.Append(mbg.Version);
chkVal.Append(mbg.CmdId);
chkVal.Append(mbg.MerCustId);
chkVal.Append(mbg.UsrCustId);
string chkv = chkVal.ToString();
string log = "更新用户第三方余额";
log += "<br>加签chkv字符:" + chkv;
//私钥文件的位置(这里是放在了站点的根目录下)
string merKeyFile = AppDomain.CurrentDomain.BaseDirectory + Utils.GetMerPr();
//需要指定提交字符串的长度
int len = Encoding.UTF8.GetBytes(chkv).Length;
StringBuilder sbChkValue = new StringBuilder(256);
//加签
int str = DllInterop.SignMsg(Utils.GetMerId(), merKeyFile, chkv, len, sbChkValue);
LogInfo.WriteLog("加签字符:" + str.ToString());
mbg.ChkValue = sbChkValue.ToString();
log += "<br>提交信息：" + FastJSON.toJOSN(mbg);
log += "<br>ChkValue:" + mbg.ChkValue;
using (var client = new WebClient())
{
var values = new NameValueCollection();
values.Add("Version", mbg.Version);
values.Add("CmdId", mbg.CmdId);
values.Add("MerCustId", mbg.MerCustId);
values.Add("UsrCustId", mbg.UsrCustId);
values.Add("ChkValue", mbg.ChkValue);
string url = Utils.GetChinapnrUrl();
//同步发送form表单请求
byte[] result = client.UploadValues(url, "POST", values);
var retStr = Encoding.UTF8.GetString(result);
// Response.Write(retStr);
LogInfo.WriteLog(retStr);
ReQueryBalanceBg reg = new ReQueryBalanceBg();
retloan = (ReQueryBalanceBg)FastJSON.ToObject(retStr, reg);
StringBuilder builder = new StringBuilder();
builder.Append(retloan.CmdId);
builder.Append(retloan.RespCode);
//builder.Append(retloan.RespDesc);
builder.Append(retloan.MerCustId);
builder.Append(retloan.UsrCustId);
builder.Append(retloan.AvlBal);
builder.Append(retloan.AcctBal);
builder.Append(retloan.FrzBal);
// builder.Append(retloan.ChkValue);
var msg = builder.ToString();
log += "<br>返回参数:" + msg;
//验签
string pgPubkFile = AppDomain.CurrentDomain.BaseDirectory + Utils.GetPgPubk();
int ret = DllInterop.VeriSignMsg(pgPubkFile, msg, msg.Length, retloan.ChkValue);
log += "<br>验签ret:" + ret.ToString();
if (ret == 0)
{
if (retloan.RespCode == "000")
{
B_usercenter bu = new B_usercenter();
bu.DataSync(retloan, UsrCustId, 1);
// Response.Write("账户余额: " + retloan.AcctBal + "<br>");
// Response.Write("可用余额: " + retloan.AvlBal + "<br>");
// Response.Write("冻结余额: " + retloan.FrzBal + "<br>");
// AvlBal.Value = retloan.AvlBal;
// FrzBal.Value = retloan.FrzBal;
// string sql = "update hx_member_table set available_balance=" + decimal.Parse(retloan.AvlBal) + " ,frozen_sum=" + decimal.Parse(retloan.FrzBal) + " where UsrCustId='" + UsrCustId + "'";
// DbHelperSQL.RunSql(sql);
}
else
{
// Response.Write(HttpUtility.UrlDecode(retloan.RespDesc));
}
}
}
LogInfo.WriteLog(log);
}
}
return(retloan);
}
