public JsonResult Inserkl()
{
object retJson = new { success = 0, msg = "操作失败！" };
string str = string.IsNullOrEmpty(Request["str"]) ? "" : Request["str"];
int appid = string.IsNullOrEmpty(Request["appid"]) ? 0 : Int32.Parse(Request["appid"]);
JMP.BLL.jmp_apprate bll = new jmp_apprate();
if (appid > 0 && !string.IsNullOrEmpty(str))
{
string sql = " delete from jmp_apprate where r_appid=" + appid;
string[] sxf = str.Split('|');
string[] lis = new string[sxf.Length + 1];
lis[0] = sql;
int a = 1;
for (int i = 0; i < sxf.Length; i++)
{
string[] bl = sxf[i].Split(',');
lis[a] = " insert into jmp_apprate(r_appid,r_paymodeid,r_proportion,r_state,r_time,r_name) values(" + appid + "," + bl[0] + "," + bl[1] + ",0,GETDATE(),'" + UserInfo.UserName + "') ";
sql += " insert into jmp_apprate(r_appid,r_paymodeid,r_proportion,r_state,r_time,r_name) values(" + appid + "," + bl[0] + "," + bl[1] + ",0,GETDATE(),'" + UserInfo.UserName + "'); ";
a = a + 1;
}
int cg = bll.InserSxF(lis);
if (cg > 0)
{
retJson = new { success = 1, msg = "设置成功！" };
Logger.OperateLog("通道费率设置扣量比例", "操作数据：" + sql);
}
else
{
retJson = new { success = 0, msg = "设置失败！" };
}
}
return(Json(retJson));
}
public ActionResult AppKl()
{
int appid = string.IsNullOrEmpty(Request["appid"]) ? 0 : Int32.Parse(Request["appid"]);
List <JMP.MDL.jmp_apprate> list = new List <JMP.MDL.jmp_apprate>();
JMP.BLL.jmp_apprate bll = new jmp_apprate();
if (appid > 0)
{
list = bll.SelectListAppid(appid);
}
ViewBag.list = list;
ViewBag.appid = appid;
return(View());
}
/// <summary>
/// 根据应用id和支付类型查询是否设置费率
/// </summary>
/// <param name="appid">应用id</param>
/// <param name="paytype">支付类型</param>
/// <param name="CacheTime">缓存时间</param>
/// <returns></returns>
public bool SelectApprate(int appid, int paytype, int CacheTime)
{
bool ISZero = false;
JMP.BLL.jmp_apprate bll = new JMP.BLL.jmp_apprate();
string CacheName = "CacheName" + appid + paytype;
JMP.MDL.jmp_apprate jmp_Apprate = new jmp_apprate();
if (JMP.TOOL.CacheHelper.IsCache(CacheName))
{
jmp_Apprate = JMP.TOOL.CacheHelper.GetCaChe <JMP.MDL.jmp_apprate>(CacheName);
if (jmp_Apprate != null)
{
if (jmp_Apprate.r_proportion > 0)
{
ISZero = true;
}
else
{
jmp_Apprate = bll.SelectAppidState(appid, paytype);
if (jmp_Apprate != null)
{
if (jmp_Apprate.r_proportion > 0)
{
ISZero = true;
}
JMP.TOOL.CacheHelper.CacheObjectLocak <JMP.MDL.jmp_apprate>(jmp_Apprate, CacheName, CacheTime);//存入缓存
}
}
}
}
else
{
jmp_Apprate = bll.SelectAppidState(appid, paytype);
if (jmp_Apprate != null)
{
if (jmp_Apprate.r_proportion > 0)
{
ISZero = true;
}
JMP.TOOL.CacheHelper.CacheObjectLocak <JMP.MDL.jmp_apprate>(jmp_Apprate, CacheName, CacheTime);//存入缓存
}
}
return(ISZero);
}
