public string GetSlidePicture(string _StrJson)
{
StringBuilder sbStr = new StringBuilder();
sbStr.Append("[{\"msg\":\"获取失败，无匹配数据。\",\"data\":\"\",\"state\":\"1\"}]");
CommonJsonModel model = new CommonJsonModel(Regex.Replace(_StrJson, @"\r\n", ""));
List <CommonJsonModel> lst = model.GetCollection();
foreach (CommonJsonModel item in lst)
{
string tempPage = item.GetValue("_Page");
string tempPageSize = item.GetValue("_PageSize");
int _Page = (tempPage != "" && Convert.ToInt32(tempPage) > 0)? Convert.ToInt32(item.GetValue("_Page")) : 1;
int _PageSize = (tempPageSize != "" && Convert.ToInt32(tempPageSize) > 0) ? Convert.ToInt32(item.GetValue("_PageSize")) : 100;
DataTable dt = new DataTable();
DataSet ds = new ZhouFu.Bll.DataHandler().GetList("dbo.TB_SlidePicture", "ID,FilePath,Url", "sort", _PageSize, _Page, false, false, "");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
dt = ds.Tables[0];
sbStr.Clear();
sbStr.Append(EasyUIJsonHelper.TableToJson(dt));
}
}
return(sbStr.ToString());
}
public DataTable GetCreateTable(object proid, int month, object money, object jlmoney, object yield)//项目ID、返款期数、投资金额、激活奖励金、投资收益率
{
#region 获取项目返息时间表
StringBuilder sbSqlWhere = new StringBuilder();
sbSqlWhere.AppendFormat(" proid=" + proid);
DataSet ds = new ZhouFu.Bll.DataHandler().GetList("dbo.TB_ProjectBackDetails", "backcount,backtime,backstatus,status, DATEDIFF(day,getdate(),backtime) as nowday ", "id", 100, 1, false, false, sbSqlWhere.ToString());
#endregion
DataTable edt = new DataTable();
edt.Columns.Add("qs", Type.GetType("System.String")); //返息期数
edt.Columns.Add("yfbj", Type.GetType("System.String")); //应还本金
edt.Columns.Add("yflx", Type.GetType("System.String")); //应还利息
edt.Columns.Add("fxsj", Type.GetType("System.String")); //返息时间
edt.Columns.Add("jlts", Type.GetType("System.String")); //距离天数
edt.Columns.Add("zt", Type.GetType("System.String")); //返息状态
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
int qs = Convert.ToInt32(dt.Rows[i]["backcount"]);
string bj = GetBenJin(month, qs, money, jlmoney);
string lx = GetLiXi(month, money, jlmoney, yield);
string fxsj = dt.Rows[i]["backtime"].ToString();
string jlts = dt.Rows[i]["nowday"].ToString();
string zt = dt.Rows[i]["status"].ToString() == "5" ? "已返" : "未返";
edt.Rows.Add(qs, bj, lx, fxsj, jlts, zt);
}
}
return(edt);
}
public string GetApplyForProList(string _StrJson)
{
StringBuilder sbStr = new StringBuilder();
sbStr.Append("[{\"msg\":\"获取失败，内部处理错误。\",\"data\":\"\",\"state\":\"2\"}]");
try {
StringBuilder SqlWhere = new StringBuilder();
string Fields = "id,title,pro_money,hk_type,hk_month,hope_rate,status";
CommonJsonModel model = new CommonJsonModel(Regex.Replace(_StrJson, @"\r\n", ""));
List <CommonJsonModel> lst = model.GetCollection();
Model.TB_Project proModel = new Model.TB_Project();
foreach (CommonJsonModel item in lst)
{
int Page = Convert.ToInt32(item.GetValue("_Page"));
int PageSize = Convert.ToInt32(item.GetValue("_PageSize"));
string LoginId = item.GetValue("_LoginId");
SqlWhere.AppendFormat("status<=4 and pub_user={0}", LoginId);
DataTable dt = new DataTable();
DataSet ds = new ZhouFu.Bll.DataHandler().GetList("TB_Project", Fields, "id", PageSize, Page, false, true, SqlWhere.ToString());
if (ds != null && ds.Tables.Count > 0)
{
sbStr.Append("[{\"msg\":\"获取数据成功。\",\"data\":" + EasyUIJsonHelper.TableToJson(ds.Tables[0]) + ",\"state\":\"0\"}]");
}
else
{
sbStr.Append("[{\"msg\":\"获取数据成功,无匹配数据。\",\"data\":\"\",\"state\":\"1\"}]");
}
}
}
catch { }
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());
}
