public string GetNowInvestment(int _Page, int _PageSize, int _LoginId)
{
StringBuilder sbStr = new StringBuilder();
string finaIds = new ZhouFu.Bll.TB_ProjectFinancing().GetFieldFormTable("tz_proid", "tz_person=" + _LoginId, "", " group by tz_proid");//获取当前用户投资项目
if (finaIds != "")
{
if (_Page == 0)
{
_Page = 1;
} //当前页
if (_PageSize == 0)
{
_PageSize = 10;
}
; //每页行数
StringBuilder sbSqlWhere = new StringBuilder();
sbSqlWhere.Append("id in (" + finaIds.Trim(',') + ")");
sbSqlWhere.Append("and status=4");
DataTable dt = new DataTable();
DataSet ds = bll.GetList("dbo.TB_Project", "id as pro_Id,pro_number,pro_title,pro_datum_gain,pro_money,hk_month,[status],pro_Stars,pro_endtime,isnull((select COUNT(tz_person) from TB_ProjectFinancing where tz_proid=TB_Project.id ),0) as allps,isnull((select SUM(tz_money) from TB_ProjectFinancing where tz_proid=TB_Project.id),0) as allmoney", "id", _PageSize, _Page, false, true, sbSqlWhere.ToString());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
dt = ds.Tables[0];
sbStr.Append("[{\"msg\":\"获取成功。\",\"data\":" + EasyUIJsonHelper.TableToJson(dt) + ",\"state\":\"0\"}]");
}
else
{
sbStr.Append("[{\"msg\":\"获取成功,无匹配数据。\",\"data\":\"\",\"state\":\"1\"}]");
}
}
else
{
sbStr.Append("[{\"msg\":\"获取成功,无匹配数据。\",\"data\":\"\",\"state\":\"1\"}]");
}
return(sbStr.ToString());
}
public string GetNowBackInterest(int _LoginId, int _Page, int _PageSize, int _State)
{
StringBuilder sbStr = new StringBuilder();
if (_LoginId > 0)
{
if (_Page == 0)
{
_Page = 1;
}
if (_PageSize == 0)
{
_PageSize = 1;
}
int notTop = (_Page - 1) * _PageSize; //sql分页
string strFields = "a.id as fcid,a.tz_money,a.tz_jh_money,a.tz_time,a.tz_yield,b.id as proid,b.pro_number,b.pro_title,b.pro_money,b.hk_month,b.pro_money"; //需要查询的字段
string strOrderBy = " a.tz_time desc"; //按投资时间降序
StringBuilder sbSqlWhere = new StringBuilder(); //查询条件
sbSqlWhere.AppendFormat(" a.tz_person={0}", _LoginId);
sbSqlWhere.AppendFormat(" and b.status={0}", _State);
StringBuilder sbNotSql = new StringBuilder(); //sql分页语句
sbNotSql.AppendFormat("select top {0} a.id from TB_ProjectFinancing as a left join TB_Project as b on a.tz_proid=b.id where {1} order by {2}", notTop, sbSqlWhere.ToString(), strOrderBy);
StringBuilder sbSql = new StringBuilder(); //SQL语句
sbSql.AppendFormat("select top {0} {1} from TB_ProjectFinancing as a left join TB_Project as b on a.tz_proid=b.id where {2} and a.id not in({3}) order by {4}", _PageSize, strFields, sbSqlWhere.ToString(), sbNotSql.ToString(), strOrderBy);
DataSet ds = new ZhouFu.Bll.TB_ProjectFinancing().GetListBySQL(sbSql.ToString());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
sbStr.Append("[{\"msg\":\"查询成功。\",\"data\":[");
for (int i = 0; i < dt.Rows.Count; i++)
{
sbStr.Append("{");
sbStr.Append("\"pro_title\":\"" + dt.Rows[i]["pro_title"] + "\",");
sbStr.Append("\"pro_number\":\"" + dt.Rows[i]["pro_number"] + "\",");
sbStr.Append("\"hk_month\":\"" + dt.Rows[i]["hk_month"] + "\",");
sbStr.Append("\"tz_money\":\"" + dt.Rows[i]["tz_money"] + "\",");
sbStr.Append("\"tz_jh_money\":\"" + dt.Rows[i]["tz_jh_money"] + "\",");
sbStr.Append("\"tz_yield\":\"" + dt.Rows[i]["tz_yield"] + "\",");
sbStr.Append("\"tz_time\":\"" + dt.Rows[i]["tz_time"] + "\",");
sbStr.Append("\"detailedList\":");
sbStr.Append(EasyUIJsonHelper.TableToJson(GetCreateTable(dt.Rows[i]["proid"], Convert.ToInt32(dt.Rows[i]["hk_month"]), dt.Rows[i]["tz_money"], dt.Rows[i]["tz_jh_money"], dt.Rows[i]["tz_yield"])));
sbStr.Append("}");
if (i < dt.Rows.Count - 1)
{
sbStr.Append(",");
}
}
sbStr.Append("],\"state\":\"0\"}]");
}
else
{
sbStr.Append("[{\"msg\":\"查询成功,无匹配数据。\",\"data\":\"\",\"state\":\"1\"}]");
}
}
else
{
sbStr.Append("[{\"msg\":\"获取失败,输入参数错误。\",\"data\":\"\",\"state\":\"2\"}]");
}
return(sbStr.ToString());
}
private string Info(Model.sys_Manager mModel, Model.TB_Project pModel, decimal money, decimal money2)
{
StringBuilder sbStr = new StringBuilder();
int iJF = 0; //积分
decimal tz_yield = Convert.ToDecimal(GetTzYield(pModel, mModel.user_category.ToString())); //获取用户收益率
int firstperson = 0, firstbl = 0, secondperson = 0, secondbl = 0;
if (pModel.pro_type == 0) //普通项目
{
firstperson = Convert.ToInt32(GetFirstPerson(mModel).Split('|')[0]); //一级会员ID
firstbl = Convert.ToInt32(GetFirstPerson(mModel).Split('|')[1]); //一级佣金比例
secondperson = Convert.ToInt32(GetFirstPerson(mModel).Split('|')[2]); //二级会员ID
secondbl = Convert.ToInt32(GetFirstPerson(mModel).Split('|')[3]); //二级佣金比例
}
int projectid = pModel.id;
int personid = mModel.ID;
string ipaddress = DTRequest.GetIP();
DateTime datetime = DateTime.Now;
#region 添加项目融资金额
ZhouFu.Model.TB_ProjectFinancing pfModel = new ZhouFu.Model.TB_ProjectFinancing();
pfModel.tz_proid = projectid;
pfModel.tz_person = personid;
pfModel.tz_money = money;
pfModel.tz_time = datetime;
pfModel.tz_yield = float.Parse(tz_yield.ToString());
#endregion
//#region 修改用户账户
//if (money > 0)
//{
// mModel.AccountBalance = mModel.AccountBalance - Convert.ToDecimal(money);
// iJF = (int)(Convert.ToInt32(money) / Convert.ToInt32(config.Integral) * 1);//获得荣誉积分
// mModel.HonorPoints = mModel.HonorPoints + iJF;
//}
//if (money2 > 0)
//{
// mModel.JLAccountBalance = mModel.JLAccountBalance - Convert.ToDecimal(money2);
//}
//#endregion
#region 发送私信
ZhouFu.Model.TB_UsersLog logModel = new ZhouFu.Model.TB_UsersLog();
logModel.title = "(项目投资)账户扣款通知";
logModel.content = string.Format("尊敬的用户您好，您的投资已成功，账户扣除" + pfModel.tz_money + "，请到个人中心查看明细。</br>感谢您对汇财e家一如既往的支持，希望我们的服务能够带来您财富的增长。", mModel.user_name, pModel.pro_title, pModel.pro_number, pfModel.tz_money, iJF);
logModel.send_userid = 38;
logModel.send_time = DateTime.Now;
logModel.receiv_userid = mModel.ID;
#endregion
#region 记录用户账户明细
ZhouFu.Model.TB_AccountDetails ADetailsModel = new ZhouFu.Model.TB_AccountDetails();
if (money > 0)
{
//ADetailsModel.userid = mModel.ID;
//ADetailsModel.jy_type = 4;
//ADetailsModel.zh_type = 1;
//ADetailsModel.cz_type = 2;
//ADetailsModel.cz_money = pfModel.tz_money;
//ADetailsModel.overmoney = mModel.AccountBalance - money;
//ADetailsModel.remart = string.Format("投资项目【{0}/{1}】支出￥{2}元。", pModel.pro_title, pModel.pro_number, pfModel.tz_money);
}
#endregion
if (1 == 1)
{
sbStr.Append("[{\"msg\":\"投资成功,您本次获得积分:" + iJF + "\",\"data\":\"\",\"state\":\"0\"}]");
object endSumMoney = new ZhouFu.Bll.TB_ProjectFinancing().GetTotalInvestment(" tz_proid=" + pModel.id);//判断项目是否已经融资满额
if (Convert.ToDecimal(endSumMoney) == pModel.pro_money)
{
pModel.status = 5;
new ZhouFu.Bll.TB_Project().Update(pModel);
}
}
else
{
sbStr.Append("[{\"msg\":\"投资失败,服务器处理出错。\",\"data\":\"\",\"state\":\"1\"}]");
}
return(sbStr.ToString());
}
public string InfoSource(int _ProId, int _UserId, string _Money, string _Money2, string _DealPassword)
{
StringBuilder sbStr = new StringBuilder();
decimal money = _Money == "" ? 0 : Convert.ToDecimal(_Money);
decimal money2 = _Money2 == "" ? 0 : Convert.ToDecimal(_Money2);
if (money > 0)
{
ZhouFu.Model.TB_Project pModel = new ZhouFu.Bll.TB_Project().GetModel(_ProId);
ZhouFu.Model.sys_Manager mModel = new ZhouFu.Bll.sys_Manager().GetModel(_UserId);
if (Convert.ToDouble(mModel.AccountBalance) < Convert.ToDouble(money))//判断用户余额
{
sbStr.Append("[{\"msg\":\"您的余额不足。\",\"data\":\"\",\"state\":\"1\"}]");
}
else
{
if (DESEncrypt.GetStringMD5(_DealPassword) == mModel.DealPassword)
{
object objSumMoney = new ZhouFu.Bll.DataHandler().GetSum("TB_ProjectFinancing", "tz_money", "tz_proid=" + pModel.id);
decimal LastMoney = Convert.ToDecimal(pModel.pro_money) - Convert.ToDecimal(objSumMoney);
if (LastMoney > pModel.pro_min_money) //如果还需投资额度大于单笔最小投资额度
{
if (money < pModel.pro_min_money) //判断单笔投资最小额度
{
sbStr.Append("[{\"msg\":\"单比最小投资额度￥:" + pModel.pro_min_money + "元。\",\"data\":\"\",\"state\":\"1\"}]");
}
else
{
if (money > Convert.ToDecimal(pModel.pro_max_money))//判断单笔投资最大额度
{
sbStr.Append("[{\"msg\":\"单比最大投资额度￥:" + pModel.pro_max_money + "元。\",\"data\":\"\",\"state\":\"1\"}]");
}
else
{
int tzCt = new ZhouFu.Bll.TB_ProjectFinancing().GetRecordCount(" tz_person=" + mModel.ID + " and tz_proid=" + pModel.id);
if (tzCt >= pModel.pro_max_count)//如果投资用户所投笔数不在有效范围内
{
sbStr.Append("[{\"msg\":\"此项目个人最多投资" + pModel.pro_max_count + "笔，请您核实是否已投。\",\"data\":\"\",\"state\":\"1\"}]");
}
else
{
sbStr.Append(Info(mModel, pModel, money, money2));
}
}
}
}
else
{ //如果还需投资额度小于单笔最小投资额度
if (LastMoney < money) //如果投资额度大于还需投资额度
{
sbStr.Append("[{\"msg\":\"项目还需融资￥" + LastMoney + "元，请修改投资额度。\",\"data\":\"\",\"state\":\"1\"}]");
}
else
{ //成功投资
sbStr.Append(Info(mModel, pModel, money, money2));
}
}
}
else
{
sbStr.Append("[{\"msg\":\"交易密码不正确。\",\"data\":\"\",\"state\":\"1\"}]");
}
}
}
return(sbStr.ToString());
}
