public JsonResult boardcopy(string boardno)
{
try
{
Models.api_databoard board = boardDbHelper.GetAll(u => u.boardno == boardno, u => u.id).FirstOrDefault();
if (board != null)
{
string newboardno = Guid.NewGuid().ToString("N");
//执行存储过程； 复制;
string sql = "exec pr_app_databoard_copy @boardno,@newboardno,@userid";
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@boardno", board.boardno),
new SqlParameter("@newboardno", newboardno),
new SqlParameter("@userid", ""),
};
DBHelper.ExecuteNonQuery(sql, pars);
return(Json(new { access = true, result = board, msg = newboardno }));
}
else
{
return(Json(new { access = false, msg = "未找到[" + boardno + "]对应的记录", result = board }));
}
// return Json(new { access = true });
}
catch (Exception exp)
{
return(Json(new { access = false, msg = exp.Message }));
}
}
public JsonResult boardSave(Models.api_databoard entity)
{
try
{
if (entity.id <= 0)
{
entity.mod_man = "";
entity.mod_date = DateTime.Now;
entity.cre_date = DateTime.Now;
entity.cre_man = "";
entity.boardno = Guid.NewGuid().ToString();
boardDbHelper.Insert(entity);
boardDbHelper.SaveChanges();
//dbhelper.SaveChanges();
}
else
{
entity.mod_date = DateTime.Now;
boardDbHelper.Update(entity);
boardDbHelper.SaveChanges();
}
return(Json(new { access = true, result = entity }));
}
catch (Exception exp)
{
return(Json(new { access = false, msg = exp.Message }));
}
}
/// <summary>
/// 新增/修改看板定义对像
/// </summary>
/// <param name="api_Databoard"></param>
/// <returns></returns>
public JsonResult DRBAdd(Models.api_databoard api_Databoard)
{
api_Databoard.mod_date = DateTime.Now;
if (api_Databoard.id > 0)
{
boardDbHelper.Update(api_Databoard);
}
else
{
api_Databoard.mod_man = "";
api_Databoard.cre_date = DateTime.Now;
api_Databoard.cre_man = "";
api_Databoard.boardno = Guid.NewGuid().ToString();
boardDbHelper.Insert(api_Databoard);
}
var m = boardDbHelper.SaveChanges();
if (m > 0)
{
return(Json(new
{
success = true,
message = "保存成功",
data = m
}, JsonRequestBehavior.AllowGet));
}
return(Json(new
{
success = false,
message = "保存失败"
}, JsonRequestBehavior.AllowGet));
}
//编辑
public ActionResult Edit(int id)
{
Models.api_databoard item = boardDbHelper.FindById(id);
//Models.Model_ApiItem entity = new Models.Model_ApiItem();
if (item == null)
{
//新增;
item = new Models.api_databoard();
item.boardno = Guid.NewGuid().ToString("N");
ViewBag.entity = item;
}
else
{
//修改
ViewBag.entity = item;
}
return(View());//
}
public JsonResult boardGet(string boardno)
{
try
{
Models.api_databoard board = boardDbHelper.GetAll(u => u.boardno == boardno, u => u.id).FirstOrDefault();
if (board != null)
{
return(Json(new { access = true, msg = "", result = board }));
}
else
{
return(Json(new { access = false, msg = "未找到[" + boardno + "]对应的记录", result = board }));
}
}
catch (Exception exp)
{
return(Json(new { access = false, msg = exp.Message }));
}
}
public JsonResult boardpub(string boardno)
{
try
{
Models.api_databoard board = boardDbHelper.GetAll(u => u.boardno == boardno, u => u.id).FirstOrDefault();
if (board != null)
{
//
if (board.pubno == null || board.pubno == "")
{
//
var pubo = Guid.NewGuid().ToString();;
board.pubno = pubo;
boardDbHelper.Update(board);
boardDbHelper.SaveChanges();
}
//执行存储过程； 发布;
string sql = "exec pr_app_databoard_pub @boardno,@userid";
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@boardno", board.boardno),
new SqlParameter("@userid", ""),
};
DBHelper.ExecuteNonQuery(sql, pars);
return(Json(new { access = true, result = board }));
}
else
{
return(Json(new { access = false, msg = "未找到[" + boardno + "]对应的记录", result = board }));
}
// return Json(new { access = true });
}
catch (Exception exp)
{
return(Json(new { access = false, msg = exp.Message }));
}
}
public JsonResult boardSavconfig(string boardno, string mainoption)
{
try
{
Models.api_databoard board = boardDbHelper.GetAll(u => u.boardno == boardno, u => u.id).FirstOrDefault();
if (board != null)
{
board.mainoption = mainoption;
boardDbHelper.Update(board);
boardDbHelper.SaveChanges();
return(Json(new { access = true, result = board }));
}
else
{
return(Json(new { access = false, msg = "未找到[" + boardno + "]对应的记录", result = board }));
}
}
catch (Exception exp)
{
return(Json(new { access = false, msg = exp.Message }));
}
}
public JsonResult boardDelete(int id)
{
try
{
Models.api_databoard board = boardDbHelper.FindById(id);//.GetAll(u => u.itemno == itemno, u => u.id).FirstOrDefault();
if (board != null)
{
boardDbHelper.Delete(board);
boardDbHelper.SaveChanges();
return(Json(new { access = true, msg = "" }));
}
else
{
return(Json(new { access = false, msg = "未找到[" + id + "]对应的记录", result = board }));
}
// return Json(new { access = true });
}
catch (Exception exp)
{
return(Json(new { access = false, msg = exp.Message }));
}
}