/// <summary> /// 更新函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID,已存在逻辑主码返回-1</returns> public long UPDATE(Log info) { try { if (SELECT_BY_EVID_MID_DATETIME(info.Tablename, info.Tableid, info.Mid, info.Datetime) == null) { return(-1); } S_log temp = new S_log(); Table <S_log> table = db.GetTable <S_log>(); temp = (from row in db.S_log where row.id == info.Id select row).First(); //temp.id = info.Id; temp.tablename = info.Tablename; temp.tableid = info.Tableid; temp.mid = info.Mid; temp.datetime = info.Datetime; temp.discription = info.Discription; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 插入函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID</returns> public long INSERT(Log info) { try { if (SELECT_BY_EVID_MID_DATETIME(info.Tablename, info.Tableid, info.Mid, info.Datetime) != null) { return(-1); } S_log temp = new S_log(); //temp.id = info.Id; temp.tablename = info.Tablename; temp.tableid = info.Tableid; temp.mid = info.Mid; temp.datetime = info.Datetime; temp.discription = info.Discription; Table <S_log> table = db.GetTable <S_log>(); table.InsertOnSubmit(temp); db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 根据逻辑主码查询 /// </summary> /// <param name="tablename">被操作表名</param> /// <param name="tableid">被操作表数据主码ID</param> /// <param name="mid">操作人ID</param> /// <param name="datetime">操作时间</param> /// <returns>结果</returns> public Log SELECT_BY_EVID_MID_DATETIME(string tablename, long tableid, int mid, DateTime datetime) { try { Log rd = new Log(); S_log temp = (from row in db.S_log where row.tablename == tablename && row.tableid == tableid && row.mid == mid && row.datetime == datetime select row).First(); rd.Id = temp.id; rd.Tablename = temp.tablename; rd.Tableid = temp.tableid; rd.Mid = temp.mid; rd.Datetime = temp.datetime; rd.Discription = temp.discription; return(rd); } catch { return(null); } }
/// <summary> /// 根据物理主码查询 /// </summary> /// <param name="id">id</param> /// <returns>结果</returns> public Log SELECT_BY_ID(long id) { try { Log rd = new Log(); S_log temp = (from row in db.S_log where row.id == id select row).First(); rd.Id = temp.id; rd.Tablename = temp.tablename; rd.Tableid = temp.tableid; rd.Mid = temp.mid; rd.Datetime = temp.datetime; rd.Discription = temp.discription; return(rd); } catch { return(null); } }