public JsonResult apidetails(int id)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.api model = Models.ApiDal.Instance.Get(PubConn, id);
if (model == null)
{
return(Json(new { code = -1, msg = "不存在编号为 [" + id + "] 的接口。" }));
}
return(Json(new { code = 1, response = model }));
}
}
public JsonResult edit(Models.DbModels.api model)
{
if (string.IsNullOrEmpty(model.apititle))
{
return(Json(new { code = -1, msg = "请输入接口标题" }));
}
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
try
{
if (model.apiid == 0)
{
if (Models.ApiDal.Instance.Add(PubConn, model))
{
model.apiid = PubConn.GetIdentity();
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "添加失败" }));
}
}
else
{
if (Models.ApiDal.Instance.Edit(PubConn, model))
{
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "修改失败" }));
}
}
}
finally
{
log.opecontent = "修改接口";
Models.CertCenterLogDal.Instance.Add(PubConn, log);
}
}
}
public virtual bool Edit(DbConn PubConn, Models.DbModels.api model)
{
model.apiname = model.apiname ?? "";
model.apititle = model.apititle ?? "";
model.area = model.area ?? "";
model.controller = model.controller ?? "";
model.action = model.action ?? "";
model.para = model.para ?? "";
model.apidesc = model.apidesc ?? "";
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//权限id
new ProcedureParameter("@apiid", model.apiid),
//应用类型
new ProcedureParameter("@apptype", model.apptype),
//应用级别
new ProcedureParameter("@appgradeno", model.appgradeno),
//
new ProcedureParameter("@categoryid", model.categoryid),
//接口名
new ProcedureParameter("@apiname", model.apiname ?? ""),
//接口标题
new ProcedureParameter("@apititle", model.apititle ?? ""),
//area
new ProcedureParameter("@area", model.area ?? ""),
//controller
new ProcedureParameter("@controller", model.controller ?? ""),
//action
new ProcedureParameter("@action", model.action ?? ""),
//para
new ProcedureParameter("@para", model.para ?? ""),
//api说明
new ProcedureParameter("@apidesc", model.apidesc ?? ""),
new ProcedureParameter("@freeze", model.freeze)
};
Par.Add(new ProcedureParameter("@id", model.apiid));
int rev = PubConn.ExecuteSql("update api set apptype=@apptype,appgradeno=@appgradeno,categoryid=@categoryid,apiname=@apiname,apititle=@apititle,area=@area,controller=@controller,action=@action,para=@para,apidesc=@apidesc,freeze=@freeze where apiid=@apiid", Par);
return(rev == 1);
}
public virtual bool Add(DbConn PubConn, Models.DbModels.api model)
{
model.apiname = model.apiname ?? "";
model.apititle = model.apititle ?? "";
model.area = model.area ?? "";
model.controller = model.controller ?? "";
model.action = model.action ?? "";
model.para = model.para ?? "";
model.apidesc = model.apidesc ?? "";
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//应用类型
new ProcedureParameter("@apptype", model.apptype),
//应用级别
new ProcedureParameter("@appgradeno", model.appgradeno),
//
new ProcedureParameter("@categoryid", model.categoryid),
//接口名
new ProcedureParameter("@apiname", model.apiname ?? ""),
//接口标题
new ProcedureParameter("@apititle", model.apititle ?? ""),
//area
new ProcedureParameter("@area", model.area ?? ""),
//controller
new ProcedureParameter("@controller", model.controller ?? ""),
//action
new ProcedureParameter("@action", model.action ?? ""),
//para
new ProcedureParameter("@para", model.para ?? ""),
//api说明
new ProcedureParameter("@apidesc", model.apidesc ?? ""),
new ProcedureParameter("@freeze", model.freeze)
};
int rev = PubConn.ExecuteSql(@"insert into api(apptype,appgradeno,categoryid,apiname,apititle,area,controller,action,para,apidesc,freeze)
values(@apptype,@appgradeno,@categoryid,@apiname,@apititle,@area,@controller,@action,@para,@apidesc,@freeze)" , Par);
return(rev == 1);
}
