public JsonResult FindByName(string name)
{
var bll = new JMP.BLL.jmp_system();
var mo = bll.GetModelList("s_name='" + name + "'").FirstOrDefault();
return(Json(mo, JsonRequestBehavior.AllowGet));
}
public ActionResult dictionary()
{
var bll = new JMP.BLL.jmp_system();
var model = bll.GetModelList("");
return(View(model));
}
/// <summary>
/// 检查是否允许从数据库加载数据
/// </summary>
private void CheckAllowReadDataFromDatabase()
{
GlobalConfig.AllowReadDataFromDatabase = true;
if (!Properties.Settings.Default.NEED_CHECK_FROM_DATABASE)
{
return;
}
if (string.IsNullOrEmpty(GlobalConfig.CLIENT_ID))
{
GlobalConfig.AllowReadDataFromDatabase = false;
UpdateUi(Level.Error, "此程序的客户端标识未配置");
return;
}
var bll = new JMP.BLL.jmp_system();
var item = bll.GetModelList(string.Format("s_state=1 AND s_name='{0}'", GlobalConfig.CLIENT_ID)).FirstOrDefault();
if (item != null)
{
GlobalConfig.AllowReadDataFromDatabase = item.s_value == "1";
}
if (!GlobalConfig.AllowReadDataFromDatabase)
{
UpdateUi(Level.Error, string.Format("客户端[{0}]的通知功能已被禁用", GlobalConfig.CLIENT_ID));
}
}
/// <summary>
/// 添加或修改系统配置
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public JsonResult InsertOrUpdateSystem(JMP.MDL.jmp_system mode)
{
object retJson = new { success = 0, msg = "操作失败" };
JMP.BLL.jmp_system bll = new JMP.BLL.jmp_system();
JMP.MDL.jmp_system mo = new JMP.MDL.jmp_system();
if (mode.s_id > 0)
{
mo = bll.GetModel(mode.s_id);
mode.s_state = mo.s_state;
if (mo.s_name == "password")
{
//md5加密
mode.s_value = DESEncrypt.Encrypt(mode.s_value);
}
if (bll.Update(mode))
{
#region 日志说明
Logger.ModifyLog("用户" + UserInfo.UserName + "修改系统配置", mo, mode);
#endregion
retJson = new { success = 1, msg = "修改成功" };
}
else
{
retJson = new { success = 0, msg = "修改失败" };
};
}
else
{
#region
mode.s_state = 1;
int cg = bll.Add(mode);
if (cg > 0)
{
Logger.CreateLog("添加系统配置", mode);
retJson = new { success = 1, msg = "操作成功" };
}
else
{
retJson = new { success = 0, msg = "操作失败" };
}
#endregion
}
return(Json(retJson));
}
public JsonResult paysAdd()
{
object result = new { success = 0, msg = "操作失败！" };
JMP.BLL.jmp_user userbll = new JMP.BLL.jmp_user();
JMP.BLL.jmp_system systembll = new JMP.BLL.jmp_system();
//可提现金额
decimal ketiMoney = Convert.ToDecimal(Request["ketiMoney"] ?? "0");
//提现金额
decimal payMoney = Convert.ToDecimal(Request["payMoney"] ?? "0");
//提现银行卡信息
string b_bankid = string.IsNullOrEmpty(Request["b_bankid"]) ? "" : Request["b_bankid"];
//提现选中账单ID
string payid = string.IsNullOrEmpty(Request["payid"]) ? "0" : Request["payid"];
//支付密码
string PayPwd = string.IsNullOrEmpty(Request["PayPwd"]) ? "" : Request["PayPwd"];
//提现类型（1：单卡提现，2：多卡提现）
int WithdrawalsType = string.IsNullOrEmpty(Request["WithdrawalsType"]) ? 0 : int.Parse(Request["WithdrawalsType"]);
//查询开发者信息
JMP.MDL.jmp_user j_user = userbll.GetModel(UserInfo.UserId);
//查询超级密码
JMP.MDL.jmp_system j_sys = systembll.GetModel_name("password");
//提现最小金额
string WithdrawalsMinimum = System.Configuration.ConfigurationManager.AppSettings["WithdrawalsMinimum"].ToString();
//验证提现金额
if (payMoney >= decimal.Parse(WithdrawalsMinimum))
{
if (payMoney > ketiMoney)
{
result = new { success = 0, msg = "提现金额不能超过可提金额！" };
}
else
{
#region 提现金额验证成功，后续处理
//判断是否验证原支付密码
if (!string.IsNullOrEmpty(PayPwd))
{
string temp = DESEncrypt.Encrypt(PayPwd);
if (temp == j_user.u_paypwd || temp == j_sys.s_value)
{
#region 拼装提款表与银行打款对接表sql
if (WithdrawalsType == 1 || WithdrawalsType == 2)
{
List <string> sqllist = new List <string>();
if (WithdrawalsType == 1)
{
sqllist = BankPaySongle(payMoney, b_bankid, payid);
}
else
{
sqllist = BankPay(payMoney, b_bankid, payid);
}
if (sqllist.Count > 0)
{
JMP.BLL.jmp_BankPlaymoney bankBll = new JMP.BLL.jmp_BankPlaymoney();
//执行多条SQL语句，实现数据库事务。
int num = bankBll.SelectBankPayMoney(sqllist);
if (num > 0)
{
string log = "用户：" + UserInfo.UserId + ",申请提现：" + payMoney + ",申请时间：" + DateTime.Now;
Logger.OperateLog("提现申请", log);
result = new { success = 1, msg = "提现申请成功，请等待审核通过！" };
}
else
{
result = new { success = 0, msg = "提现申请失败！" };
}
}
else
{
result = new { success = 0, msg = "提现申请失败！" };
}
}
else
{
Logger.OperateLog("提现申请失败", "提现类型（1：单卡提现，2：多卡提现）:" + WithdrawalsType);
result = new { success = 0, msg = "提现申请失败！" };
}
#endregion
}
else
{
result = new { success = 0, msg = "支付密码输入错误！" };
}
}
else
{
result = new { success = 0, msg = "请输入支付密码！" };
}
#endregion
}
}
else
{
result = new { success = 0, msg = "提现金额不能为空且必须大于等于100！" };
}
return(Json(result));
}
