public int Update(Edu_Info data)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data));
}
}
public int Update(long EduId, Edu_Info data, IEnumerable <string> columns)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data, EduId, columns));
}
}
public JsonResult SaveEdu(Edu_Info data)
{
//data.DeptName = getDeptName(sessionData.trading.Dept.Value);
ResultBase result = new ResultBase();
result.setMessage("Done");
if (string.IsNullOrEmpty(data.Title))
{
result.setErrorMessage("衛教標題不得為空白");
}
if (string.IsNullOrEmpty(data.Teacher))
{
result.setErrorMessage("衛教主講者不得為空白");
}
if (string.IsNullOrEmpty(data.Place))
{
result.setErrorMessage("衛教地點不得為空白");
}
if (string.IsNullOrEmpty(data.DateStart))
{
result.setErrorMessage("衛教起始時間不得為空白");
}
if (string.IsNullOrEmpty(data.DateEnd))
{
result.setErrorMessage("衛教結束時間不得為空白");
}
if (data.EduDate == DateTime.MinValue)
{
result.setErrorMessage("衛教日期格式錯誤，格式為 YYYY/MM/DD");
}
string timesample = "2000/01/01 {0}";
DateTime temptime;
if (!DateTime.TryParse(string.Format(timesample, data.DateStart), out temptime))
{
result.setErrorMessage("無效的衛教起始時間");
}
if (!DateTime.TryParse(string.Format(timesample, data.DateEnd), out temptime))
{
result.setErrorMessage("無效的衛教結束時間");
}
if (result.JsonReturnCode > -1)
{
data.LastUpdate = DateTime.Now;
data.LastUpdator = sessionData.trading.LoginId;
if (data.EduId > 0)
{
EduMan.Update(data);
}
else
{
EduMan.Insert(data);
}
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
public long Insert(Edu_Info data)
{
using (var db = new DBExecutor().GetDatabase())
{
long NewID = 0;
var result = db.Insert(data);
if (result != null)
{
long.TryParse(result.ToString(), out NewID);
}
return(NewID);
}
}
public long Insert(Edu_Info data)
{
long newID = 0;
try
{
newID = new Edu_Repo().Insert(data);
}
catch (Exception ex)
{
log.Exception(ex);
}
return(newID);
}
public bool Update(Edu_Info data)
{
return(new Edu_Repo().Update(data) > 0);
}
public bool Update(long EduId, Edu_Info data, IEnumerable <string> columns)
{
return(new Edu_Repo().Update(EduId, data, columns) > 0);
}
