public bool Save(FunctionHistory fh)
{
try
{
if (fh ==null) return false;
return _fhDao.Save(fh) >= 0;
}
catch (Exception ex)
{
throw new Exception("FunctionHistory-->Save" + ex.Message,ex);
}
}
public int Save(FunctionHistory fh)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("INSERT INTO function_history (`function_id`,`user_id`,`operate_time`)VALUES({0},{1},'{2}');",fh.Function_Id,fh.User_Id,fh.Operate_Time.ToString("yyyy-MM-dd HH:mm:ss"));
return _dbAccess.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("FunctionHistoryDao-->Save" + ex.Message,ex);
}
}
/// add by wwei0216w 2015/04/03
#region 查詢控件的歷史記錄
public ActionResult QueryHistory()
{
try
{
int total = 0;
int function_id = Convert.ToInt32(Request["function_id"]);
IFunctionHistoryImplMgr _fhMgr = new FunctionHistoryMgr(connectionString);
FunctionHistory fh = new FunctionHistory();
_fhMgr = new FunctionHistoryMgr(connectionString);
int start = int.Parse(Request.Form["start"] ?? "0");
int limit = int.Parse(Request.Form["limit"] ?? "0");
string condition = Request.Form["conditional"];
DateTime startTime = Request.Form["startTime"] == "" ? DateTime.MinValue : Convert.ToDateTime(Request.Form["startTime"]);
DateTime startEnd = Request.Form["endTime"] == "" ? DateTime.MaxValue : Convert.ToDateTime(Request.Form["endTime"]);
var course = _fhMgr.Query(function_id, start, limit, condition, startTime, startEnd, out total);
IsoDateTimeConverter iso = new IsoDateTimeConverter() { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" };
return Content("{success:true,totalCount:" + total + ",item:" + JsonConvert.SerializeObject(course, Formatting.None, iso) + "}");
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
return new EmptyResult();
}
}
