/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.jmp_apptype model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into jmp_apptype(");
strSql.Append("t_name,t_sort,t_topid,t_state");
strSql.Append(") values (");
strSql.Append("@t_name,@t_sort,@t_topid,@t_state");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@t_name", SqlDbType.NVarChar, -1),
new SqlParameter("@t_sort", SqlDbType.NVarChar, -1),
new SqlParameter("@t_topid", SqlDbType.Int, 4),
new SqlParameter("@t_state", SqlDbType.Int, 4)
};
parameters[0].Value = model.t_name;
parameters[1].Value = model.t_sort;
parameters[2].Value = model.t_topid;
parameters[3].Value = model.t_state;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加或修改应用类型
/// </summary>
/// <returns></returns>
public JsonResult InsertOrUpdateAddType(JMP.MDL.jmp_apptype mode)
{
object retJson = new { success = 0, msg = "操作失败" };
JMP.BLL.jmp_apptype bll = new JMP.BLL.jmp_apptype();
if (mode.t_id > 0)
{
#region 修改应用类型
JMP.MDL.jmp_apptype mo = new JMP.MDL.jmp_apptype();
mo = bll.GetModel(mode.t_id);
var mocole = mo.Clone();
mo.t_name = mode.t_name;
mo.t_sort = mode.t_sort;
mo.t_topid = mode.t_topid;
mo.t_namecj = mode.t_namecj;
//mode.t_state = mo.t_state;
//string xgzfc = "";
if (bll.Update(mo))
{
Logger.ModifyLog("修改应用类型", mocole, mode);
retJson = new { success = 1, msg = "修改成功" };
}
else
{
retJson = new { success = 0, msg = "修改失败" };
}
#endregion
}
else
{
#region 添加应用类型
mode.t_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));
}
/// <summary>
/// 添加或修改应用类型界面
/// </summary>
/// <returns></returns>
public ActionResult AppTypeAdd()
{
JMP.BLL.jmp_apptype bll = new JMP.BLL.jmp_apptype();
List <JMP.MDL.jmp_apptype> list = new List <JMP.MDL.jmp_apptype>();
int t_id = string.IsNullOrEmpty(Request["t_id"]) ? 0 : Int32.Parse(Request["t_id"]);
JMP.MDL.jmp_apptype model = new JMP.MDL.jmp_apptype();
if (t_id > 0)
{
model = bll.GetModel(t_id);
}
ViewBag.model = model;
DataTable dt = bll.GetList(" 1=1 and t_topid='0' ").Tables[0];
list = JMP.TOOL.MdlList.ToList <JMP.MDL.jmp_apptype>(dt);
ViewBag.list = list;
return(View());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.jmp_apptype GetModel(int t_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select t_id, t_name, t_sort, t_topid, t_state ");
strSql.Append(" from jmp_apptype ");
strSql.Append(" where t_id=@t_id");
SqlParameter[] parameters =
{
new SqlParameter("@t_id", SqlDbType.Int, 4)
};
parameters[0].Value = t_id;
JMP.MDL.jmp_apptype model = new JMP.MDL.jmp_apptype();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["t_id"].ToString() != "")
{
model.t_id = int.Parse(ds.Tables[0].Rows[0]["t_id"].ToString());
}
model.t_name = ds.Tables[0].Rows[0]["t_name"].ToString();
model.t_sort = ds.Tables[0].Rows[0]["t_sort"].ToString();
if (ds.Tables[0].Rows[0]["t_topid"].ToString() != "")
{
model.t_topid = int.Parse(ds.Tables[0].Rows[0]["t_topid"].ToString());
}
if (ds.Tables[0].Rows[0]["t_state"].ToString() != "")
{
model.t_state = int.Parse(ds.Tables[0].Rows[0]["t_state"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.jmp_apptype model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jmp_apptype set ");
strSql.Append(" t_name = @t_name , ");
strSql.Append(" t_sort = @t_sort , ");
strSql.Append(" t_topid = @t_topid , ");
strSql.Append(" t_state = @t_state ");
strSql.Append(" where t_id=@t_id ");
SqlParameter[] parameters =
{
new SqlParameter("@t_id", SqlDbType.Int, 4),
new SqlParameter("@t_name", SqlDbType.NVarChar, -1),
new SqlParameter("@t_sort", SqlDbType.NVarChar, -1),
new SqlParameter("@t_topid", SqlDbType.Int, 4),
new SqlParameter("@t_state", SqlDbType.Int, 4)
};
parameters[0].Value = model.t_id;
parameters[1].Value = model.t_name;
parameters[2].Value = model.t_sort;
parameters[3].Value = model.t_topid;
parameters[4].Value = model.t_state;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改应用
/// </summary>
/// <returns></returns>
public ActionResult UpdateAPP(int a_id)
{
JMP.BLL.jmp_app bll = new JMP.BLL.jmp_app();
JMP.MDL.jmp_app model = new JMP.MDL.jmp_app();
string glpt = "";
string zf = "";
string szmrdj = "";
string yy = "";
if (a_id > 0)
{
model = bll.SelectId(a_id);
#region =========获取应用平台在用信息=========
JMP.BLL.jmp_platform bllpl = new JMP.BLL.jmp_platform();
DataTable dt = bllpl.GetList(" 1=1 and p_state='1' ").Tables[0];//获取应用平台在用信息
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Int32.Parse(dt.Rows[i]["p_id"].ToString()) == model.a_platform_id)
{
glpt += "<option value=\"" + dt.Rows[i]["p_id"] + "\" selected=\"selected\" >" + dt.Rows[i]["p_name"] + "</option>";
}
else
{
glpt += "<option value=\"" + dt.Rows[i]["p_id"] + "\">" + dt.Rows[i]["p_name"] + "</option>";
}
}
#endregion
#region =====获取支付类型在用信息======
JMP.BLL.jmp_paymode zfbll = new JMP.BLL.jmp_paymode();
DataTable zfdt = zfbll.GetList(" 1=1 and p_state='1' ").Tables[0];//获取支付类型在用信息
string[] a_paymode = model.a_paymode_id.Split(',');
for (int k = 0; k < zfdt.Rows.Count; k++)
{
bool check = true;
for (int i = 0; i < a_paymode.Length; i++)
{
if (zfdt.Rows[k]["p_id"].ToString() == a_paymode[i])
{
zf += " <input type=\"checkbox\" name=\"zflx\" class=\"inputChck\" id=paytype_" + zfdt.Rows[k]["p_id"] + " data-stat=" + zfdt.Rows[k]["p_islocked"] + " value=" + zfdt.Rows[k]["p_id"] + " checked=\"checked\" /> " + zfdt.Rows[k]["p_name"];
check = false;
break;
}
}
if (check)
{
zf += " <input type=\"checkbox\" name=\"zflx\" class=\"inputChck\" id=paytype_" + zfdt.Rows[k]["p_id"] + " data-stat=" + zfdt.Rows[k]["p_islocked"] + " value=" + zfdt.Rows[k]["p_id"] + " /> " + zfdt.Rows[k]["p_name"];
}
}
#endregion
#region ========获取应用类型在用信息======
JMP.BLL.jmp_apptype yybll = new JMP.BLL.jmp_apptype();
string where = " t_id in (select DISTINCT(t_topid) from jmp_apptype where t_topid in( select t_id from jmp_apptype where t_topid='0' )) and t_state='1' order by t_sort desc";
DataTable yydt = yybll.GetList(where).Tables[0];//获取应用类型在用信息
JMP.MDL.jmp_apptype models = new JMP.MDL.jmp_apptype();
int t_topid = 0;
if (model.a_apptype_id > 0)
{
models = yybll.GetModel(model.a_apptype_id);//查询单条信息
t_topid = models.t_topid;
}
string yyid = "";
for (int j = 0; j < yydt.Rows.Count; j++)
{
yyid = "yy" + yydt.Rows[j]["t_id"].ToString();
if (t_topid > 0)
{
if (Int32.Parse(yydt.Rows[j]["t_id"].ToString()) == models.t_topid)
{
szmrdj = yyid;
yy += "<input type=\"button\" id='" + yyid + "' name=\"yyname\" onclick=\"xzyylx(this.id,0)\" class=\"xzinput\" value=" + yydt.Rows[j]["t_name"] + " />";
}
else
{
yy += "<input type=\"button\" id='" + yyid + "' name=\"yyname\" onclick=\"xzyylx(this.id,0)\" class=\"inpuwxz\" value=" + yydt.Rows[j]["t_name"] + " />";
}
}
else
{
yy += "<input type=\"button\" id='" + yyid + "' name=\"yyname\" onclick=\"xzyylx(this.id,0)\" class=\"inpuwxz\" value=" + yydt.Rows[j]["t_name"] + " />";
}
}
#endregion
#region 根据应用子类型获取风险等级
JMP.BLL.jmp_risklevelallocation ribll = new JMP.BLL.jmp_risklevelallocation();
List <JMP.MDL.jmp_risklevelallocation> rilist = new List <JMP.MDL.jmp_risklevelallocation>();
rilist = ribll.SelectAppType(model.a_apptype_id);
ViewBag.rilist = rilist;
#endregion
}
ViewBag.model = model;
ViewBag.glpt = glpt;
ViewBag.zf = zf;
ViewBag.yy = yy;
ViewBag.szmrdj = szmrdj;
return(View());
}
public ActionResult UpdateApp()
{
#region 获取用户实名认证状态信息
JMP.BLL.jmp_user sm_bll = new JMP.BLL.jmp_user();
JMP.MDL.jmp_user sm_model = new JMP.MDL.jmp_user();
int u_ids = UserInfo.Uid;
//查询登录信息
sm_model = sm_bll.GetModel(u_ids);
ViewBag.auditstate = sm_model.u_auditstate;
ViewBag.linkEmail = sm_model.u_email;
#endregion
int appid = string.IsNullOrEmpty(Request["appid"]) ? 0 : Int32.Parse(Request["appid"]);
JMP.BLL.jmp_app appbll = new JMP.BLL.jmp_app();
JMP.MDL.jmp_app model = new JMP.MDL.jmp_app();
string yy = "";
if (appid > 0)
{
model = appbll.SelectId(appid);
#region =========获取应用平台在用信息=========
JMP.BLL.jmp_platform bll = new JMP.BLL.jmp_platform();
DataTable dt = bll.GetList(" 1=1 and p_state='1' ").Tables[0];//获取应用平台在用信息
List <JMP.MDL.jmp_platform> yypt = JMP.TOOL.MdlList.ToList <JMP.MDL.jmp_platform>(dt);
ViewBag.glptdt = yypt;
#endregion
#region ========获取应用类型在用信息======
JMP.BLL.jmp_apptype yybll = new JMP.BLL.jmp_apptype();
string where = " t_id in (select DISTINCT(t_topid) from jmp_apptype where t_topid in( select t_id from jmp_apptype where t_topid='0' )) and t_state='1' order by t_sort desc";
DataTable yydt = yybll.GetList(where).Tables[0];//获取应用类型在用信息
JMP.MDL.jmp_apptype models = new JMP.MDL.jmp_apptype();
int t_topid = 0;
if (model.a_apptype_id > 0)
{
models = yybll.GetModel(model.a_apptype_id);//查询单条信息
t_topid = models.t_topid;
}
string yyid = "";
if (model.a_auditstate == 1)
{
yy += "<select id='xzyylx' disabled ='disabled' > ";
}
else
{
yy += "<select id='xzyylx' onclick='xzyylx()'> ";
}
for (int j = 0; j < yydt.Rows.Count; j++)
{
yyid = yydt.Rows[j]["t_id"].ToString();
if (t_topid > 0)
{
if (Int32.Parse(yydt.Rows[j]["t_id"].ToString()) == models.t_topid)
{
yy += "<option value='" + yyid + "' selected=selected >" + yydt.Rows[j]["t_name"] + "</option>";
}
else
{
yy += "<option value='" + yyid + "' >" + yydt.Rows[j]["t_name"] + "</option>";
}
}
else
{
yy += "<option value='" + yyid + "' >" + yydt.Rows[j]["t_name"] + "</option>";
}
}
yy += "</select>";
#endregion
}
#region 获取所有支付方式
JMP.BLL.jmp_paymode zfbll = new JMP.BLL.jmp_paymode();
DataTable zfdt = new DataTable();
List <JMP.MDL.jmp_paymode> zflist = new List <JMP.MDL.jmp_paymode>();
zfdt = zfbll.GetList(" 1=1 and p_state='1' ").Tables[0];//获取支付类型在用信息
zflist = JMP.TOOL.MdlList.ToList <JMP.MDL.jmp_paymode>(zfdt);
ViewBag.appid = appid;
ViewBag.list = zflist;
#endregion
ViewBag.yy = yy;
ViewBag.model = model;
//支付方式
string[] zffs = model.a_paymode_id.Split(',');
ViewBag.zffs = zffs;
return(View());
}
