/// <summary> /// Save data modification details to the update table /// </summary> /// <param name="id">Represents references</param> /// <param name="table">Represents the reference table</param> /// <param name="actionType">Reference the table modification type</param> public static void Update(string id, string table, ActionType actionType) { SalonDbEntities db = new SalonDbEntities(); tbllog update = new tbllog { ref_table = table, ref_id = id, updated_date_time = DateTime.Now, action_type = System.Enum.GetName(typeof(ActionType), actionType) }; db.tbllogs.Add(update); db.SaveChanges(); }
public async Task <object> setLogData([FromBody] tbllog data) { object resdata = null; try { resdata = DataAccess.saveData(data); } catch (Exception ex) { ex.ToString(); } return(resdata); }
/// <summary> /// 记录日志 /// </summary> /// <param name="type"> 1.登录 2.注册 3.报名 4.支付 5.比赛</param> /// <param name="userid"></param> /// <param name="ip"></param> /// <param name="note"></param> /// <returns></returns> public int OptLog(int type, string userid, string ip, string note) { tbllog log = new tbllog(); log.createtime = System.DateTime.Now; log.IP = ip; log.opttype = type; log.remark = note; log.tid = System.Guid.NewGuid().ToString(); log.userid = userid; log.source = 1; //来源 1.web 2.app using (var db = new BFdbContext()) { return(db.Insert <tbllog>(log)); } }
public static int saveData(tbllog data) { int result = 0; try { sql = Staticinfos.qruryInsert; if (con != null && con.State == ConnectionState.Closed) { con.Open(); } using (var cmd = new NpgsqlCommand()) { cmd.CommandText = sql; cmd.CommandType = CommandType.Text; cmd.Connection = con; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("logdetails", data.logdetails); cmd.Parameters.AddWithValue("logdate", DateTime.Now); IDataReader dr = cmd.ExecuteReader(); result = dr.RecordsAffected; } } catch (Exception ex) { ex.ToString(); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(result); }