private void DMButton_Search_Click(object sender, RoutedEventArgs e) { runLogBase.RunLogList.Clear(); List <WMS_Log_Model> list = new List <WMS_Log_Model>(); DataTable dt = WMS_Log_Bll.Select_Log(" LogType = 'run' and LogTime like '%" + SearchText_Time.Text + "%' and LogLocation like '%" + SearchText_Location.Text + "%' and LogMessage like '%" + SearchText_Message.Text + "%' and LogLevel like '%" + SearchText_Level.Text + "%'"); for (int i = 0; i < dt.Rows.Count; i++) { WMS_Log_Model wMS_SysLog_Model = new WMS_Log_Model { LogTime = dt.Rows[i]["LogTime"].ToString(), LogType = dt.Rows[i]["LogType"].ToString(), LogLocation = dt.Rows[i]["LogLocation"].ToString(), LogMessage = dt.Rows[i]["LogMessage"].ToString(), LogLevel = int.Parse(dt.Rows[i]["LogLevel"].ToString()) }; list.Add(wMS_SysLog_Model); } foreach (var model in list) { runLogBase.RunLogList.Add(model); } this.RunLogDataGrid.ItemsSource = runLogBase.RunLogList; }
/// <summary> /// 日志更新 /// </summary> /// <param name="wMS_Log_Model"></param> /// <param name="condition"></param> /// <returns></returns> public static int Update_Log(WMS_Log_Model wMS_Log_Model, string condition) { using (var con = GetOpenConnection()) { return(con.Execute(WMS_Log_Dal.Update_Log(wMS_Log_Model, condition))); } }
/// <summary> /// 日志插入 /// </summary> /// <param name="wMS_Log_Model"></param> /// <returns></returns> public static int Inseert_Log(WMS_Log_Model wMS_Log_Model) { using (var con = GetOpenConnection()) { return(con.Execute(WMS_Log_Dal.Inseert_Log(wMS_Log_Model))); } }
/// <summary> /// 日志插入 /// </summary> /// <param name="wMS_Log_Model"></param> /// <returns></returns> public static string Inseert_Log(WMS_Log_Model wMS_Log_Model) { string _insertSql = "INSERT INTO [WMS].[dbo].[WMS_Log]" + "([LogTime],[LogType],[LogLocation],[LogMessage],[LogLevel])" + "VALUES('" + wMS_Log_Model.LogTime + "','" + wMS_Log_Model.LogType + "','" + wMS_Log_Model.LogLocation + "','" + wMS_Log_Model.LogMessage + "'," + wMS_Log_Model.LogLevel + ")"; return(_insertSql); }
/// <summary> /// 日志更新 /// </summary> /// <param name="wMS_Log_Model"></param> /// <param name="condition"></param> /// <returns></returns> public static string Update_Log(WMS_Log_Model wMS_Log_Model, string condition) { string _updateSql = "UPDATE [WMS].[dbo].[WMS_Log]" + "SET[LogTime] = '" + wMS_Log_Model.LogTime + "',[LogType] = '" + wMS_Log_Model.LogType + "',[LogLocation] = '" + wMS_Log_Model.LogLocation + "',[LogMessage] = '" + wMS_Log_Model.LogMessage + "',[LogLevel] = " + wMS_Log_Model.LogLevel + " WHERE " + condition; return(_updateSql); }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static List <WMS_Log_Model> GetErrorLogList() { List <WMS_Log_Model> list = new List <WMS_Log_Model>(); DataTable dt = WMS_Log_Bll.Select_Log(" LogType = 'run' and LogLevel = 2"); for (int i = 0; i < dt.Rows.Count; i++) { WMS_Log_Model wms_Log_Model = new WMS_Log_Model { LogType = dt.Rows[i]["LogType"].ToString(), LogLocation = dt.Rows[i]["LogLocation"].ToString(), LogMessage = dt.Rows[i]["LogMessage"].ToString() }; list.Add(wms_Log_Model); } return(list); }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static List <WMS_Log_Model> GetLoginLogList() { List <WMS_Log_Model> list = new List <WMS_Log_Model>(); DataTable dt = WMS_Log_Bll.Select_Log(" LogType = 'login'"); for (int i = 0; i < dt.Rows.Count; i++) { WMS_Log_Model wms_Log_Model = new WMS_Log_Model { LogTime = dt.Rows[i]["LogTime"].ToString(), LogType = dt.Rows[i]["LogType"].ToString(), LogLocation = dt.Rows[i]["LogLocation"].ToString(), LogMessage = dt.Rows[i]["LogMessage"].ToString(), LogLevel = int.Parse(dt.Rows[i]["LogLevel"].ToString()) }; list.Add(wms_Log_Model); } return(list); }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static List <WMS_Log_Model> GetRunLogList() { List <WMS_Log_Model> list = new List <WMS_Log_Model>(); DataTable totalDt = WMS_Log_Bll.Select_Log(" LogType = 'run'"); totalPages = totalDt.Rows.Count % sizePage == 0 ? (totalDt.Rows.Count / sizePage) : (totalDt.Rows.Count / sizePage) + 1; DataTable dt = PagerHelper.PagerTable(page, sizePage, showColumn, tabName, strCondition, ascColumn, bitOrderType, pkColumn); for (int i = 0; i < dt.Rows.Count; i++) { WMS_Log_Model wms_Log_Model = new WMS_Log_Model { LogID = int.Parse(dt.Rows[i]["LogID"].ToString()), LogTime = dt.Rows[i]["LogTime"].ToString(), LogType = dt.Rows[i]["LogType"].ToString(), LogLocation = dt.Rows[i]["LogLocation"].ToString(), LogMessage = dt.Rows[i]["LogMessage"].ToString(), LogLevel = int.Parse(dt.Rows[i]["LogLevel"].ToString()) }; list.Add(wms_Log_Model); } return(list); }