public int Update(Question_Info data)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data));
}
}
public int Update(long QuestionId, Question_Info data, IEnumerable <string> columns)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data, QuestionId, columns));
}
}
public long Insert(Question_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(Question_Info data)
{
long newID = 0;
try
{
newID = new Question_Repo().Insert(data);
}
catch (Exception ex)
{
log.Exception(ex);
}
return(newID);
}
public JsonResult SaveQuestion(Question_Info data)
{
ResultBase result = new ResultBase();
result.setMessage("Done");
if (data.Q_time == DateTime.MinValue)
{
result.setErrorMessage("發布日期格式錯誤，正確格式為YYYY/MM/DD");
}
if (string.IsNullOrEmpty(data.DeptName))
{
result.setErrorMessage("診別不得為空白");
}
if (string.IsNullOrEmpty(data.Q_title))
{
result.setErrorMessage("提問標題不得為空白");
}
if (string.IsNullOrEmpty(data.Q_question))
{
result.setErrorMessage("問題內容不得為空白");
}
if (string.IsNullOrEmpty(data.Q_ans))
{
result.setErrorMessage("回覆內容不得為空白");
}
if (string.IsNullOrEmpty(data.Q_edit))
{
result.setErrorMessage("回覆者不得為空白");
}
if (result.JsonReturnCode > -1)
{
data.LastUpdate = DateTime.Now;
data.LastUpdator = sessionData.trading.LoginId;
var olddata = OQMan.GetBySN(data.QuestionId);
//checkUploadfiles(data, olddata);
if (data.QuestionId > 0)
{
//Keep the existing data.
data.hit = olddata.hit;
QMan.Update(data);
}
else
{
QMan.Insert(data);
}
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
public bool Update(Question_Info data)
{
return(new Question_Repo().Update(data) > 0);
}
public bool Update(long QuestionId, Question_Info data, IEnumerable <string> columns)
{
return(new Question_Repo().Update(QuestionId, data, columns) > 0);
}
