public JsonResult AddNoteResource(Sys_NoteResource model)
{
return(Json(new
{
result = sys_noteresourceBL.AddNoteResource(model) ? "1" : "0"
}, JsonRequestBehavior.AllowGet));
}
public bool AddNoteResource(Sys_NoteResource model)
{
using (IDbConnection conn = OpenConnection())
{
string sql = @"INSERT INTO Sys_NoteResource
(
NoteId,
RealName,
FileName,
CreateDate,
IsDelete
)
VALUES
(
@NoteId,
@RealName,
@FileName,
@CreateDate,
@IsDelete
)
SELECT @@IDENTITY as id";
var param = new
{
NoteId = model.NoteId,
RealName = model.RealName,
FileName = model.FileName,
CreateDate = DateTime.Now,
IsDelete = model.IsDelete
};
decimal id = conn.Query <decimal>(sql, param).FirstOrDefault();
model.Id = decimal.ToInt32(id);
return(model.Id > 0);
}
}
public bool AddNoteResource(Sys_NoteResource model)
{
return(sys_NoteResurceDB.AddNoteResource(model));
}
