/// <summary> /// 得到一个对象实体 /// </summary> public M_borrowing_target GetModel(int targetid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 targetid,borrower_registerid,loan_number,borrowing_title,borrowing_thumbnail,project_type_id,annual_interest_rate,borrowing_balance,life_of_loan,unit_day,release_date,value_date,month_payment_date,repayment_date,minimum,maxmum,companyid,guarantee_way_id,payment_options,start_time,end_time,service_charge,loan_management_fee,investors_management_fee,ordinary_overdue_management_fees,seriously_overdue_management_fees,ordinary_overdue_penalty,seriously_overdue_penalty,transfer_Expenses,fundraising_amount,tender_state,full_scale_loan,flow_return,recommend,sys_time,repaymentperiods,guarantee_fee,consultingAMT,guaranteeAMT,B_Rates,IsUse from hx_borrowing_target "); strSql.Append(" where targetid=@targetid"); SqlParameter[] parameters = { new SqlParameter("@targetid", SqlDbType.Int, 4) }; parameters[0].Value = targetid; M_borrowing_target model = new M_borrowing_target(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 根据期限获取借款标数据 /// </summary> /// <param name="month">借款期限(1,3,6)</param> /// <returns></returns> private M_borrowing_target_ZhuoLu GetPartialTargetModel(int month) { B_borrowing_target bllBorrowingTarget = new B_borrowing_target(); M_borrowing_target_ZhuoLu targetLife; M_borrowing_target target = bllBorrowingTarget.GetModel(Common.ConfigHelper.GetConfigInt("MonthTargetID_" + month)); if (target != null && target.targetid != 0 && target.tender_state == 2 && target.end_time > DateTime.Now && target.fundraising_amount < target.borrowing_balance)//如果指定的标不存在,则使用规则查找符合要求的标 { targetLife = new M_borrowing_target_ZhuoLu { targetid = target.targetid, annual_interest_rate = target.annual_interest_rate, borrowing_balance = target.borrowing_balance, borrowing_title = target.borrowing_title, fundraising_amount = target.fundraising_amount, life_of_loan = target.life_of_loan }; } else { targetLife = bllBorrowingTarget.GetModelByLifeLoan(month); } return(targetLife); }
/// <summary> /// 项目投资利率计算 /// </summary> /// <param name="targetid">标的ID</param> /// <param name="Amount">投资金额</param> ///<param name = "Lixi" > 加息券,默认为0 </ param > /// <returns></returns> public decimal InvCalc(int targetid, decimal Amount = 100.00M, double Lixi = 0) { decimal dec = 0.00M; B_borrowing_target o = new B_borrowing_target(); M_borrowing_target m = new M_borrowing_target(); m = o.GetModel(targetid); InvestmentParameters mp = new InvestmentParameters(); mp.Amount = Amount; mp.Circle = m.life_of_loan; mp.CircleType = m.unit_day; mp.NominalYearRate = double.Parse(m.annual_interest_rate.ToString()) + Lixi; mp.OverheadsRate = 0f; mp.RepaymentMode = m.payment_options; mp.RewardRate = 0f; mp.IsThirtyDayMonth = false; mp.InvestDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); mp.Investmentenddate = DateTime.Parse(m.repayment_date.ToString("yyyy-MM-dd")); mp.Payinterest = m.month_payment_date; mp.InvestObject = 1; dec = Calculationofinterest(mp); return(dec); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(M_borrowing_target model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into hx_borrowing_target("); strSql.Append("borrower_registerid,loan_number,borrowing_title,borrowing_thumbnail,project_type_id,annual_interest_rate,borrowing_balance,life_of_loan,unit_day,release_date,month_payment_date,repayment_date,minimum,maxmum,companyid,guarantee_way_id,payment_options,end_time,service_charge,loan_management_fee,investors_management_fee,ordinary_overdue_management_fees,seriously_overdue_management_fees,ordinary_overdue_penalty,seriously_overdue_penalty,transfer_Expenses,guarantee_fee,B_Rates,recommend,sys_time,IsUse)"); strSql.Append(" values ("); strSql.Append("@borrower_registerid,@loan_number,@borrowing_title,@borrowing_thumbnail,@project_type_id,@annual_interest_rate,@borrowing_balance,@life_of_loan,@unit_day,@release_date,@month_payment_date,@repayment_date,@minimum,@maxmum,@companyid,@guarantee_way_id,@payment_options,@end_time,@service_charge,@loan_management_fee,@investors_management_fee,@ordinary_overdue_management_fees,@seriously_overdue_management_fees,@ordinary_overdue_penalty,@seriously_overdue_penalty,@transfer_Expenses,@guarantee_fee,@B_Rates,@recommend,@sys_time,@IsUse)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@borrower_registerid", SqlDbType.Int, 4), new SqlParameter("@loan_number", SqlDbType.Decimal, 18), new SqlParameter("@borrowing_title", SqlDbType.VarChar, 200), new SqlParameter("@borrowing_thumbnail", SqlDbType.VarChar, 200), new SqlParameter("@project_type_id", SqlDbType.Int, 4), new SqlParameter("@annual_interest_rate", SqlDbType.Decimal, 18), new SqlParameter("@borrowing_balance", SqlDbType.Decimal, 17), new SqlParameter("@life_of_loan", SqlDbType.Int, 4), new SqlParameter("@unit_day", SqlDbType.Int, 4), new SqlParameter("@release_date", SqlDbType.DateTime), new SqlParameter("@month_payment_date", SqlDbType.Int, 4), new SqlParameter("@repayment_date", SqlDbType.DateTime), new SqlParameter("@minimum", SqlDbType.Decimal, 17), new SqlParameter("@maxmum", SqlDbType.Decimal, 17), new SqlParameter("@companyid", SqlDbType.Int, 4), new SqlParameter("@guarantee_way_id", SqlDbType.Int, 4), new SqlParameter("@payment_options", SqlDbType.Int, 4), new SqlParameter("@end_time", SqlDbType.DateTime), new SqlParameter("@service_charge", SqlDbType.Decimal, 18), new SqlParameter("@loan_management_fee", SqlDbType.Decimal, 18), new SqlParameter("@investors_management_fee", SqlDbType.Decimal, 18), new SqlParameter("@ordinary_overdue_management_fees", SqlDbType.Decimal, 18), new SqlParameter("@seriously_overdue_management_fees", SqlDbType.Decimal, 18), new SqlParameter("@ordinary_overdue_penalty", SqlDbType.Decimal, 18), new SqlParameter("@seriously_overdue_penalty", SqlDbType.Decimal, 18), new SqlParameter("@transfer_Expenses", SqlDbType.Decimal, 18), new SqlParameter("@guarantee_fee", SqlDbType.Decimal, 18), new SqlParameter("@B_Rates", SqlDbType.Decimal, 18), new SqlParameter("@recommend", SqlDbType.Int, 4), new SqlParameter("@sys_time", SqlDbType.DateTime), new SqlParameter("@IsUse", SqlDbType.Int, 4) }; parameters[0].Value = model.borrower_registerid; parameters[1].Value = model.loan_number; parameters[2].Value = model.borrowing_title; parameters[3].Value = model.borrowing_thumbnail; parameters[4].Value = model.project_type_id; parameters[5].Value = model.annual_interest_rate; parameters[6].Value = model.borrowing_balance; parameters[7].Value = model.life_of_loan; parameters[8].Value = model.unit_day; parameters[9].Value = model.release_date; parameters[10].Value = model.month_payment_date; parameters[11].Value = model.repayment_date; parameters[12].Value = model.minimum; parameters[13].Value = model.maxmum; parameters[14].Value = model.companyid; parameters[15].Value = model.guarantee_way_id; parameters[16].Value = model.payment_options; parameters[17].Value = model.end_time; parameters[18].Value = model.service_charge; parameters[19].Value = model.loan_management_fee; parameters[20].Value = model.investors_management_fee; parameters[21].Value = model.ordinary_overdue_management_fees; parameters[22].Value = model.seriously_overdue_management_fees; parameters[23].Value = model.ordinary_overdue_penalty; parameters[24].Value = model.seriously_overdue_penalty; parameters[25].Value = model.transfer_Expenses; parameters[26].Value = model.guarantee_fee; parameters[27].Value = model.B_Rates; parameters[28].Value = model.recommend; parameters[29].Value = model.sys_time; parameters[30].Value = model.IsUse; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public M_borrowing_target DataRowToModel(DataRow row) { M_borrowing_target model = new M_borrowing_target(); if (row != null) { if (row["targetid"] != null && row["targetid"].ToString() != "") { model.targetid = int.Parse(row["targetid"].ToString()); } if (row["borrower_registerid"] != null && row["borrower_registerid"].ToString() != "") { model.borrower_registerid = int.Parse(row["borrower_registerid"].ToString()); } if (row["loan_number"] != null && row["loan_number"].ToString() != "") { model.loan_number = decimal.Parse(row["loan_number"].ToString()); } if (row["borrowing_title"] != null) { model.borrowing_title = row["borrowing_title"].ToString(); } if (row["borrowing_thumbnail"] != null) { model.borrowing_thumbnail = row["borrowing_thumbnail"].ToString(); } if (row["project_type_id"] != null && row["project_type_id"].ToString() != "") { model.project_type_id = int.Parse(row["project_type_id"].ToString()); } if (row["annual_interest_rate"] != null && row["annual_interest_rate"].ToString() != "") { model.annual_interest_rate = decimal.Parse(row["annual_interest_rate"].ToString()); } if (row["borrowing_balance"] != null && row["borrowing_balance"].ToString() != "") { model.borrowing_balance = decimal.Parse(row["borrowing_balance"].ToString()); } if (row["life_of_loan"] != null && row["life_of_loan"].ToString() != "") { model.life_of_loan = int.Parse(row["life_of_loan"].ToString()); } if (row["unit_day"] != null && row["unit_day"].ToString() != "") { model.unit_day = int.Parse(row["unit_day"].ToString()); } if (row["release_date"] != null && row["release_date"].ToString() != "") { model.release_date = DateTime.Parse(row["release_date"].ToString()); } if (row["value_date"] != null && row["value_date"].ToString() != "") { model.value_date = DateTime.Parse(row["value_date"].ToString()); } if (row["month_payment_date"] != null && row["month_payment_date"].ToString() != "") { model.month_payment_date = int.Parse(row["month_payment_date"].ToString()); } if (row["repayment_date"] != null && row["repayment_date"].ToString() != "") { model.repayment_date = DateTime.Parse(row["repayment_date"].ToString()); } if (row["minimum"] != null && row["minimum"].ToString() != "") { model.minimum = decimal.Parse(row["minimum"].ToString()); } if (row["maxmum"] != null && row["maxmum"].ToString() != "") { model.maxmum = decimal.Parse(row["maxmum"].ToString()); } if (row["companyid"] != null && row["companyid"].ToString() != "") { model.companyid = int.Parse(row["companyid"].ToString()); } if (row["guarantee_way_id"] != null && row["guarantee_way_id"].ToString() != "") { model.guarantee_way_id = int.Parse(row["guarantee_way_id"].ToString()); } if (row["payment_options"] != null && row["payment_options"].ToString() != "") { model.payment_options = int.Parse(row["payment_options"].ToString()); } if (row["start_time"] != null && row["start_time"].ToString() != "") { model.start_time = DateTime.Parse(row["start_time"].ToString()); } if (row["end_time"] != null && row["end_time"].ToString() != "") { model.end_time = DateTime.Parse(row["end_time"].ToString()); } if (row["service_charge"] != null && row["service_charge"].ToString() != "") { model.service_charge = decimal.Parse(row["service_charge"].ToString()); } if (row["loan_management_fee"] != null && row["loan_management_fee"].ToString() != "") { model.loan_management_fee = decimal.Parse(row["loan_management_fee"].ToString()); } if (row["investors_management_fee"] != null && row["investors_management_fee"].ToString() != "") { model.investors_management_fee = decimal.Parse(row["investors_management_fee"].ToString()); } if (row["ordinary_overdue_management_fees"] != null && row["ordinary_overdue_management_fees"].ToString() != "") { model.ordinary_overdue_management_fees = decimal.Parse(row["ordinary_overdue_management_fees"].ToString()); } if (row["seriously_overdue_management_fees"] != null && row["seriously_overdue_management_fees"].ToString() != "") { model.seriously_overdue_management_fees = decimal.Parse(row["seriously_overdue_management_fees"].ToString()); } if (row["ordinary_overdue_penalty"] != null && row["ordinary_overdue_penalty"].ToString() != "") { model.ordinary_overdue_penalty = decimal.Parse(row["ordinary_overdue_penalty"].ToString()); } if (row["seriously_overdue_penalty"] != null && row["seriously_overdue_penalty"].ToString() != "") { model.seriously_overdue_penalty = decimal.Parse(row["seriously_overdue_penalty"].ToString()); } if (row["transfer_Expenses"] != null && row["transfer_Expenses"].ToString() != "") { model.transfer_Expenses = decimal.Parse(row["transfer_Expenses"].ToString()); } if (row["fundraising_amount"] != null && row["fundraising_amount"].ToString() != "") { model.fundraising_amount = decimal.Parse(row["fundraising_amount"].ToString()); } if (row["tender_state"] != null && row["tender_state"].ToString() != "") { model.tender_state = int.Parse(row["tender_state"].ToString()); } if (row["full_scale_loan"] != null && row["full_scale_loan"].ToString() != "") { model.full_scale_loan = int.Parse(row["full_scale_loan"].ToString()); } if (row["flow_return"] != null && row["flow_return"].ToString() != "") { model.flow_return = int.Parse(row["flow_return"].ToString()); } if (row["recommend"] != null && row["recommend"].ToString() != "") { model.recommend = int.Parse(row["recommend"].ToString()); } if (row["sys_time"] != null && row["sys_time"].ToString() != "") { model.sys_time = DateTime.Parse(row["sys_time"].ToString()); } if (row["repaymentperiods"] != null && row["repaymentperiods"].ToString() != "") { model.repayment_periods = int.Parse(row["repaymentperiods"].ToString()); } if (row["guarantee_fee"] != null && row["guarantee_fee"].ToString() != "") { model.guarantee_fee = decimal.Parse(row["guarantee_fee"].ToString()); } if (row["consultingAMT"] != null && row["consultingAMT"].ToString() != "") { model.consultingAMT = decimal.Parse(row["consultingAMT"].ToString()); } if (row["guaranteeAMT"] != null && row["guaranteeAMT"].ToString() != "") { model.guaranteeAMT = decimal.Parse(row["guaranteeAMT"].ToString()); } if (row["B_Rates"] != null && row["B_Rates"].ToString() != "") { model.B_Rates = decimal.Parse(row["B_Rates"].ToString()); } if (row["sys_time"] != null && row["sys_time"].ToString() != "") { model.sys_time = DateTime.Parse(row["sys_time"].ToString()); } if (row["IsUse"] != null && row["IsUse"].ToString() != "") { model.IsUse = int.Parse(row["IsUse"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(M_borrowing_target model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update hx_borrowing_target set "); strSql.Append("borrower_registerid=@borrower_registerid,"); strSql.Append("loan_number=@loan_number,"); strSql.Append("borrowing_title=@borrowing_title,"); strSql.Append("borrowing_thumbnail=@borrowing_thumbnail,"); strSql.Append("project_type_id=@project_type_id,"); strSql.Append("annual_interest_rate=@annual_interest_rate,"); strSql.Append("borrowing_balance=@borrowing_balance,"); strSql.Append("life_of_loan=@life_of_loan,"); strSql.Append("unit_day=@unit_day,"); strSql.Append("release_date=@release_date,"); strSql.Append("month_payment_date=@month_payment_date,"); strSql.Append("repayment_date=@repayment_date,"); strSql.Append("minimum=@minimum,"); strSql.Append("maxmum=@maxmum,"); strSql.Append("companyid=@companyid,"); strSql.Append("guarantee_way_id=@guarantee_way_id,"); strSql.Append("payment_options=@payment_options,"); strSql.Append("end_time=@end_time,"); strSql.Append("service_charge=@service_charge,"); strSql.Append("loan_management_fee=@loan_management_fee,"); strSql.Append("investors_management_fee=@investors_management_fee,"); strSql.Append("ordinary_overdue_management_fees=@ordinary_overdue_management_fees,"); strSql.Append("seriously_overdue_management_fees=@seriously_overdue_management_fees,"); strSql.Append("ordinary_overdue_penalty=@ordinary_overdue_penalty,"); strSql.Append("seriously_overdue_penalty=@seriously_overdue_penalty,"); strSql.Append("transfer_Expenses=@transfer_Expenses,"); strSql.Append("guarantee_fee=@guarantee_fee,"); strSql.Append("B_Rates=@B_Rates,"); strSql.Append("recommend=@recommend,"); strSql.Append("sys_time=@sys_time, "); strSql.Append("IsUse=@IsUse "); strSql.Append(" where targetid=@targetid"); SqlParameter[] parameters = { new SqlParameter("@borrower_registerid", SqlDbType.Int, 4), new SqlParameter("@loan_number", SqlDbType.Decimal, 18), new SqlParameter("@borrowing_title", SqlDbType.VarChar, 200), new SqlParameter("@borrowing_thumbnail", SqlDbType.VarChar, 200), new SqlParameter("@project_type_id", SqlDbType.Int, 4), new SqlParameter("@annual_interest_rate", SqlDbType.Decimal, 18), new SqlParameter("@borrowing_balance", SqlDbType.Decimal, 17), new SqlParameter("@life_of_loan", SqlDbType.Int, 4), new SqlParameter("@unit_day", SqlDbType.Int, 4), new SqlParameter("@release_date", SqlDbType.DateTime), new SqlParameter("@month_payment_date", SqlDbType.Int, 4), new SqlParameter("@repayment_date", SqlDbType.DateTime), new SqlParameter("@minimum", SqlDbType.Decimal, 17), new SqlParameter("@maxmum", SqlDbType.Decimal, 17), new SqlParameter("@companyid", SqlDbType.Int, 4), new SqlParameter("@guarantee_way_id", SqlDbType.Int, 4), new SqlParameter("@payment_options", SqlDbType.Int, 4), new SqlParameter("@end_time", SqlDbType.DateTime), new SqlParameter("@service_charge", SqlDbType.Decimal, 18), new SqlParameter("@loan_management_fee", SqlDbType.Decimal, 18), new SqlParameter("@investors_management_fee", SqlDbType.Decimal, 18), new SqlParameter("@ordinary_overdue_management_fees", SqlDbType.Decimal, 18), new SqlParameter("@seriously_overdue_management_fees", SqlDbType.Decimal, 18), new SqlParameter("@ordinary_overdue_penalty", SqlDbType.Decimal, 18), new SqlParameter("@seriously_overdue_penalty", SqlDbType.Decimal, 18), new SqlParameter("@transfer_Expenses", SqlDbType.Decimal, 18), new SqlParameter("@guarantee_fee", SqlDbType.Decimal, 18), new SqlParameter("@B_Rates", SqlDbType.Decimal, 18), new SqlParameter("@recommend", SqlDbType.Int, 4), new SqlParameter("@sys_time", SqlDbType.DateTime), new SqlParameter("@IsUse", SqlDbType.Int, 4), new SqlParameter("@targetid", SqlDbType.Int, 4) }; parameters[0].Value = model.borrower_registerid; parameters[1].Value = model.loan_number; parameters[2].Value = model.borrowing_title; parameters[3].Value = model.borrowing_thumbnail; parameters[4].Value = model.project_type_id; parameters[5].Value = model.annual_interest_rate; parameters[6].Value = model.borrowing_balance; parameters[7].Value = model.life_of_loan; parameters[8].Value = model.unit_day; parameters[9].Value = model.release_date; parameters[10].Value = model.month_payment_date; parameters[11].Value = model.repayment_date; parameters[12].Value = model.minimum; parameters[13].Value = model.maxmum; parameters[14].Value = model.companyid; parameters[15].Value = model.guarantee_way_id; parameters[16].Value = model.payment_options; parameters[17].Value = model.end_time; parameters[18].Value = model.service_charge; parameters[19].Value = model.loan_management_fee; parameters[20].Value = model.investors_management_fee; parameters[21].Value = model.ordinary_overdue_management_fees; parameters[22].Value = model.seriously_overdue_management_fees; parameters[23].Value = model.ordinary_overdue_penalty; parameters[24].Value = model.seriously_overdue_penalty; parameters[25].Value = model.transfer_Expenses; parameters[26].Value = model.guarantee_fee; parameters[27].Value = model.B_Rates; parameters[28].Value = model.recommend; parameters[29].Value = model.sys_time; parameters[30].Value = model.IsUse; parameters[31].Value = model.targetid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(M_borrowing_target model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(M_borrowing_target model) { return(dal.Add(model)); }
/// <summary> /// 邀请奖历 投资成功奖励 /// </summary> /// <param name="dt"></param> protected internal void SendBonusForInviteAfterInvest(DataTable dt, string targetPlatform) //(int registerid, string invcode, int invcount, decimal investAmt, string userName, string borrowing_title, decimal bonusAmt) { if (dt.Rows.Count <= 0) { return; } //投资金额 decimal investAmt = decimal.Parse(dt.Rows[0]["investment_amount"].ToString()); int registerid = int.Parse(dt.Rows[0]["investor_registerid"].ToString()); //投资人ID int bid_records_id = int.Parse(dt.Rows[0]["bid_records_id"].ToString()); int life_of_loan = int.Parse(dt.Rows[0]["life_of_loan"].ToString()); int unit_day = int.Parse(dt.Rows[0]["unit_day"].ToString()); if (unit_day != 1) { life_of_loan = 0; } string borrowing_title = dt.Rows[0]["borrowing_title"].ToString(); string userName = dt.Rows[0]["username"].ToString(); string invcode = dt.Rows[0]["invitationcode"].ToString(); int targetid = int.Parse(dt.Rows[0]["targetid"].ToString());//标的ID //本次投标使用的奖励金额 decimal bonusAmt = decimal.Parse(dt.Rows[0]["bonusAmt"].ToString()); B_bonus_account_water bbaw = new B_bonus_account_water(); int invcount = B_usercenter.GetInvestCountByUserid(registerid);//投资次数 string uid = registerid.ToString(); LogInfo.WriteLog("投资人ID:" + registerid + "; /*邀请码*/:" + invcode); #region MyRegion 邀请奖历 投资成功奖励 暂不启用false 待重新梳理帐号fangjianmin if (invcode != null && invcode != "")// && false { DateTime dte = DateTime.Now; string codesql = "SELECT invcode,Invpeopleid,invpersonid,invtime from hx_td_Userinvitation where invcode='" + invcode + "' and invpersonid=" + uid + " ";//查询本人是否已经被邀请注册过 LogInfo.WriteLog("投资人ID:" + registerid + ";查询本人是否已经被邀请注册过:" + codesql); DataTable dtcode = DbHelperSQL.GET_DataTable_List(codesql); if (dtcode.Rows.Count > 0) { int uuid = int.Parse(dtcode.Rows[0]["Invpeopleid"].ToString()); //邀请用户id B_member_table oy = new B_member_table(); M_member_table py = new M_member_table(); //获取 邀请用户身份渠道用户不执行 py = oy.GetModel(uuid); if (py.useridentity != 4) { DateTime invtime = Convert.ToDateTime(dtcode.Rows[0]["invtime"].ToString()); //邀请时间 DateTime nowdate = DateTime.Now; DateTime startdate = new DateTime(2017, 1, 6, 0, 00, 00); DateTime enddate = new DateTime(2017, 3, 31, 23, 59, 59); if ((nowdate > startdate && nowdate < enddate) && (invtime > startdate && invtime < enddate)) { #region 1月6日活动,奖励邀请人首投满2000返现10元 if (!string.IsNullOrWhiteSpace(py.UsrCustId)) { B_borrowing_target bbt = new B_borrowing_target(); M_borrowing_target mbt = new M_borrowing_target(); mbt = bbt.GetModel(targetid); if (mbt.project_type_id != 6)//排除新手标 { string log = "用户" + registerid + "活动奖励邀请人首投满2000返现10元: "; decimal amtc = 0; DataTable dtstAmt = B_usercenter.GetInvestCountByUseridNew(registerid); if (dtstAmt.Rows.Count > 0) { log += "<br> 投资次数" + dtstAmt.Rows.Count + "次"; if (dtstAmt.Rows.Count == 1) { amtc = decimal.Parse(dtstAmt.Rows[0]["InvCount_Amt"].ToString()); log += "<br>投资金额" + amtc; if (amtc >= 2000) { hx_UserAct huact = InviteActCashNew(uuid, targetPlatform, amtc, 4, 1, 10, 5)[0]; if (huact != null && huact.ActID != null) { log += "<br>奖励发放成功"; #region MyRegion 奖励流水 string awardDescription = string.Format("邀请好友首投满2000成功,获得{0}{1}", Convert.ToDouble(huact.Amt.ToString()), GetBunusDescription(huact.RewTypeID)); AddBonusAccoutWater(huact.UserAct, uuid, decimal.Parse(huact.Amt.ToString()), awardDescription, registerid); //registerid 被邀请人 uuid邀请人 #endregion MyRegion 奖励流水 #region MyRegion 系统消息 string MContext = string.Format("尊敬的用户:邀请好友{0}首投{1}金额为{2},获得{3}{4}如有问题可咨询创利投的客服!", userName, borrowing_title, investAmt, decimal.Parse(huact.Amt.ToString()), GetBunusDescription(huact.RewTypeID)); AddSytemMessage(uuid, "邀请好友首投满2000成功奖励", MContext); #endregion #region 现金流水信息 if (huact.RewTypeID == 1) { B_usercenter o = new B_usercenter(); decimal di = o.GetUsridAvailable_balance(uuid); //di = di + decimal.Parse(huact.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("" + uuid + "," + decimal.Parse(huact.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,'" + awardDescription + "')"); DbHelperSQL.RunSql(strSql.ToString()); strSql.Clear(); } #endregion } } } } LogInfo.WriteLog(log); } } #endregion #region 受邀好友首次成功投资给予活动奖励 常规邀请 //获取标的期限 life_of_loan = int.Parse(dt.Rows[0]["life_of_loan"].ToString()); unit_day = int.Parse(dt.Rows[0]["unit_day"].ToString()); int lol = 0; if (unit_day == 1) { lol = life_of_loan; } #region 邀请好友投资成功返现(奖励邀请人) if (!string.IsNullOrWhiteSpace(py.UsrCustId)) { hx_UserAct hut = InviteActBonus(uuid, targetPlatform, int.Parse(dtcode.Rows[0]["invpersonid"].ToString()), investAmt, 1, 4, 1, 0, 5, lol, "邀请好友投资成功返现")[0];// if (hut != null && hut.ActID != null) { #region MyRegion 奖励流水 string awardDescription = string.Format("邀请好友投资成功,获得{0}{1}", Convert.ToDouble(hut.Amt.ToString()), GetBunusDescription(hut.RewTypeID)); AddBonusAccoutWater(hut.UserAct, uuid, decimal.Parse(hut.Amt.ToString()), awardDescription, registerid); //registerid 被邀请人 uuid邀请人 #endregion MyRegion 奖励流水 #region MyRegion 系统消息 string MContext = string.Format("尊敬的用户:邀请好友{0}投资{1}金额为{2},获得{3}{4}如有问题可咨询创利投的客服!", userName, borrowing_title, investAmt, hut.Amt.ToString(), GetBunusDescription(hut.RewTypeID)); AddSytemMessage(uuid, "邀请好友投资成功奖励", MContext); #endregion #region 现金流水信息 if (hut.RewTypeID == 1) { B_usercenter o = new B_usercenter(); decimal di = o.GetUsridAvailable_balance(uuid); //di = di + decimal.Parse(hut.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("" + uuid + "," + decimal.Parse(hut.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,'" + awardDescription + "')"); DbHelperSQL.RunSql(strSql.ToString()); strSql.Clear(); } #endregion } } #endregion #region 被邀请投资成功返现(奖励被邀请人) int byquuid = int.Parse(dtcode.Rows[0]["invpersonid"].ToString()); hx_UserAct byhut = InviteActBonus(byquuid, targetPlatform, 0, investAmt, 1, 4, 1, 0, 5, lol, "被邀请投资返现")[0];// if (byhut != null && byhut.ActID != null) { #region MyRegion 奖励流水 string awardDescription = string.Format("被邀请投资成功,获得{0}{1}", Convert.ToDouble(byhut.Amt.ToString()), GetBunusDescription(byhut.RewTypeID)); AddBonusAccoutWater(byhut.UserAct, byquuid, decimal.Parse(byhut.Amt.ToString()), awardDescription, registerid); //registerid 被邀请人 uuid邀请人 #endregion MyRegion 奖励流水 #region MyRegion 系统消息 string MContext = string.Format("尊敬的用户:被邀请投资{0}金额为{1},获得{2}{3}如有问题可咨询创利投的客服!", borrowing_title, investAmt, byhut.Amt.ToString(), GetBunusDescription(byhut.RewTypeID)); AddSytemMessage(byquuid, "被邀请投资成功奖励", MContext); #endregion #region 现金流水信息 if (byhut.RewTypeID == 1) { B_usercenter o = new B_usercenter(); decimal di = o.GetUsridAvailable_balance(byquuid); //di = di + decimal.Parse(byhut.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("" + byquuid + "," + decimal.Parse(byhut.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,'" + awardDescription + "')"); DbHelperSQL.RunSql(strSql.ToString()); strSql.Clear(); } #endregion } #endregion #endregion } #region 这里现金返现 ??? 投资金额为-1 作了单独处理。注册?? RewTypeID-1 ??? //hx_UserAct ua = InviteActBonus(uuid, int.Parse(dtcode.Rows[0]["invpersonid"].ToString()), -1M, 1, 4, 1, 0, 5)[0];//??? #endregion //} //else if (invcount > 1) //{ // #region 受邀用户续投奖励 邀请活动正常续投 // int biyaoUsrid = int.Parse(dtcode.Rows[0]["invpersonid"].ToString()); // decimal totAmt = B_usercenter.GetInviUserTotalAmt(uuid, biyaoUsrid);//????这里需要取出受邀用户奖总数 // // hx_UserAct hut = aci.InviteActCash(uuid, biyaoUsrid, decimal.Parse(p.TransAmt), 4, 2, 1, totAmt, 5); // hx_UserAct hut = InviteActBonus(uuid, int.Parse(dtcode.Rows[0]["invpersonid"].ToString()), investAmt - bonusAmt, 1, 4, 1, totAmt, 5)[0];//???? // if (hut != null && hut.ActID != null) // { // #region MyRegion 奖励流水 // string awardDescription = string.Format("邀请好友续投成功获得{0}{1}", hut.Amt.ToString(), GetBunusDescription(hut.RewTypeID)); // AddBonusAccoutWater(hut.UserAct, uuid, decimal.Parse(hut.Amt.ToString()), awardDescription, registerid); //registerid 被邀请人 uuid邀请人 // #endregion MyRegion 奖励流水 // #region MyRegion 系统消息 // string MContext = string.Format("尊敬的用户:邀请好友续投{1}金额为{2},获得{3}{4}如有问题可咨询创利投的客服!", userName, borrowing_title, investAmt, hut.Amt.ToString(), GetBunusDescription(hut.RewTypeID)); // AddSytemMessage(uuid, "邀请好友续投奖励", MContext); // #endregion // #region 现金奖励 资金流水信息 // if (hut.RewTypeID == 1) // { // B_usercenter o = new B_usercenter(); // decimal di = o.GetUsridAvailable_balance(uuid); // // di = di + decimal.Parse(hut.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("" + uuid + "," + decimal.Parse(hut.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,'" + awardDescription + "')"); // LogInfo.WriteLog("续投奖励流水语句:" + strSql.ToString()); // DbHelperSQL.RunSql(strSql.ToString()); // strSql.Clear(); // } // #endregion // } // #endregion //} /* * DbHelperSQL.RunSql(" update hx_td_Userinvitation set InvitesStates=1 where invcode='" + invcode + "' and invpersonid=" + uid + " and InvitesStates=2 "); * LogInfo.WriteLog(" 后台更新数据邀请状态 update hx_td_Userinvitation set InvitesStates=1 where invcode='" + invcode + "' and invpersonid=" + uid + " and InvitesStates=2 "); */ } } } #endregion }